PostgreSQL Database Developer with Security Clearance

About the role

CGS is seeking a PostgreSQL Database Developer to support a Data Analytics and Business Intelligence platform. The role involves migrating from Oracle to Microsoft Azure Postgres database, managing database environments, and ensuring system scalability.

Responsibilities

• Drive efforts to migrate from Oracle to Postgres database
• Create and maintain technical documentation
• Collaborate with internal and external parties to transform technical objectives into technical requirements
• Ensure the availability and performance of databases supporting systems
• Perform and assist developers in performance tuning
• Proactively monitor database systems for security and minimal downtime
• Improve maintenance of databases including rollouts, patching, and upgrades
• Create and maintain technical documentation using defined templates
• Work within a structured and Agile development approach

Qualifications

• Bachelor's degree
• US Citizenship
• 7 years of experience with PostgreSQL Databases in Linux environments
• Experience with setting up, monitoring, and maintaining PostgreSQL instances
• Experience with implementing and maintaining PostgreSQL backup and disaster recovery processes
• Experience migrating Oracle schema, packages, views, triggers to Postgres using Ora2Pg tool
• Experience with AWS RDS for PostgreSQL
• Experience with Oracle databases
• Experience leveraging the Ora2Pg tool
• Experience with working in cloud environments such as Azure and/or AWS
• Prior federal consulting experience