Azure PostgreSQL Migration Specialist

CGS Federal (Contact Government Services); City of Albany (NY); On-site; USD 120,000 - 150,000; Full time

Benefits offered by this job

Health, Dental, and Vision

401k

Flexible Spending Account

Job summary

CGS Federal is seeking a PostgreSQL Database Developer to join our Information Technology team for a data analytics platform serving federal customers. You will help migrate from Oracle to PostgreSQL and manage scalable database environments in Azure and AWS.

You will document architectures, tune performance, and collaborate with stakeholders to translate requirements into robust database solutions. This full-time role is based in Albany, NY.

Qualifications

• 7 years of experience administering PostgreSQL databases in Linux environments.
• Experience setting up, monitoring, and maintaining PostgreSQL instances.
• Experience implementing and maintaining PostgreSQL backup and disaster recovery processes.
• Experience migrating Oracle schema, packages, views, triggers to Postgres using Ora2Pg tool.

Responsibilities

• Migrate from Oracle to the new Microsoft Azure Postgres database.
• Create and maintain technical documentation using templates and deep knowledge of business data.
• Collaborate with internal and external parties to translate objectives into technical requirements.
• Ensure database availability and performance with adequate resources for high resilience and speed.
• Perform and assist developers in performance tuning and optimization.

Skills

PostgreSQL

Linux

Performance tuning

Migration planning

Agile

Documentation

Education

Bachelor's degree

Tools

Ora2Pg

AWS RDS

Azure

Oracle

Job description

CGS Federal is seeking a PostgreSQL Database Developer to join our Information Technology team for a data analytics platform serving federal customers. You will help migrate from Oracle to PostgreSQL and manage scalable database environments in Azure and AWS.

You will document architectures, tune performance, and collaborate with stakeholders to translate requirements into robust database solutions. This full-time role is based in Albany, NY.