Design, architect, and build databases from determining business requirements to planning and deploying test and production systems.
Administration of PostgreSQL databases throughout the development and production lifecycles in an AWS environment.
Design and develop logical and physical database designs from customer requirements.
Analyze/Develop business description of user needs, program functions, and steps required to develop or modify systems, including Business Requirements Documents and supporting documents, diagrams, data and database specification.
Assist the project/application manager with release, configuration, and change management activities.
Provide advice and support to development resources.
Liaise with business customers and business analysts to support the design of intuitive end user reporting.
Provide guidance in the creation and modification of standards and procedures.
Provide mentorship to group members and will be expected to help develop and support mid and junior level staff.
Scheduled for after hours on-call support and will be required to apply production packages during non-peak hours.
Bachelor’s degree and 4 years of relative experience, Master's degree and 2 years of relative experience, in an IT field in lieu of a degree.
At least 5 years hands-on experience in database infrastructure tasks on Linux/Unix operating systems with demonstrated experience in each of the following:
Installing databases preferably on premise and Cloud PostgreSQL
Designing/developing/maintaining database schemas
Converting database schemas from on premise DB2 or Oracle databases to PostgreSQL database structures.
Writing data conversion scripts from on premise DB2 or Oracle databases to PostgreSQL database structures.
Developing, writing, and testing of Linux or Bash scripts for start-up, shutdown, backups, database scripts, and other scripting as required
At least 3 years of experience in database administration tasks such as DB analysis, maintenance, development, and reporting
Must be able to obtain and maintain a US Public Trust clearance
Preferred Qualifications: Candidates with these skills will be given preferential consideration.
Experience with deployment of AWS Cloud Infrastructure
Experience working in a cloud environment like AWS/Google cloud
Experience setting up and managing PostgreSQL on AWS RDS and AWS EC2 Virtual Server.
Knowledge of PostgreSQL Architecture Python Development and Ansible Deployment.
Experience with data architecture, logical and physical design, reporting and analysis.