PostgreSQL Database Developer

$106,773 - $144,907/Yr

Contact Government Services - Los Angeles, CA

Full-time - Mid Level

Los Angeles, CA

Professional, Scientific, and Technical Services

About the position

CGS is seeking a PostgreSQL Database Developer to support a rapidly growing Data Analytics and Business Intelligence platform focused on providing data solutions for federal customers. The role involves migrating from an Oracle database to a PostgreSQL database and managing database environments proactively to ensure scalability and performance.

Responsibilities

• Drive efforts to migrate from the current Oracle database to the new Microsoft Azure Postgres database.
• Create and maintain technical documentation using defined templates and gain 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 the databases, allocating sufficient resources for high resilience and speed.
• Perform and assist developers in performance tuning of the databases.
• Proactively monitor database systems to ensure secure services with minimum downtime and improve maintenance, including rollouts, patching, and upgrades.

Requirements

• Bachelor's degree
• Must be US Citizenship
• 7 years of experience with administrating 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.

Nice-to-haves

• Experience implementing and maintaining data warehouses
• 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.

Benefits

• Health, Dental, and Vision Insurance
• Life Insurance
• 401k
• Flexible Spending Account (Health, Dependent Care, and Commuter)
• Paid Time Off and Observance of State/Federal Holidays