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, managing database environments, and ensuring system scalability.

Responsibilities

• Create and maintain technical documentation and gain an in-depth knowledge of business data to propose and implement effective solutions.
• Collaborate with internal and external parties to transform high-level technical objectives into comprehensive technical requirements.
• Ensure the availability and performance of databases supporting systems, allocating sufficient resources for high resilience and speed.
• Perform and assist developers in performance tuning.
• Proactively monitor database systems to ensure secure services with minimal downtime and maintain databases through rollouts, patching, and upgrades.
• Create and maintain technical documentation using defined templates and gain an in-depth knowledge of business data to propose and implement effective solutions.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field.
• US Citizenship required.
• 7+ years of experience administering 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.
• Prior federal consulting experience is preferred.

Benefits

Our benefits package includes health, dental, and vision insurance, life insurance, a 401(k) plan, flexible spending accounts, paid time off, and observance of state/federal holidays. We also offer a comprehensive benefits package including health, dental, and vision insurance, life insurance, a 401(k) plan, flexible spending accounts, paid time off, and observance of state/federal holidays.