PostgreSQL Database Developer

$106,773 - $144,907/Yr

Contact Government Services - Santa Ana, CA

Full-time - Mid Level

Santa Ana, CA

Professional, Scientific, and Technical Services

About the position

The PostgreSQL Database Developer will support the migration from an Oracle database to a PostgreSQL database within a rapidly growing Data Analytics and Business Intelligence platform. This role involves managing database environments proactively to ensure scalability and performance, while collaborating with various stakeholders to implement effective data solutions for federal customers.

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.
• 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.
• Improve maintenance of the databases, 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