Oracle-to-Postgres Migration & Performance Engineer

CGS Federal (Contact Government Services); United States; On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

401k

Paid Time Off

Job summary

A government services provider is seeking a PostgreSQL Database Developer to assist in migrating an Oracle database to Postgres, ensuring system scalability and availability. The ideal candidate has a Bachelor's degree and extensive PostgreSQL experience, particularly in Linux environments. Responsibilities include maintaining database performance and creating technical documentation. We offer comprehensive benefits including health, dental, and retirement plans, as well as opportunities for professional growth.

Qualifications

• 7 years of experience with administrating PostgreSQL Databases in Linux environments.
• Experience with implementing and maintaining PostgreSQL backup and disaster recovery processes.
• Experience migrating Oracle schema, packages, views, triggers to Postgres using Ora2Pg tool.

Responsibilities

• Drive migration from Oracle database to Microsoft Azure Postgres.
• Create and maintain technical documentation.
• Ensure availability and performance of databases.

Skills

PostgreSQL administration

Performance tuning

Linux environments

Migration expertise

AWS RDS for PostgreSQL

Education

Bachelor's degree

Tools

Ora2Pg

Microsoft Azure

Job description

A government services provider is seeking a PostgreSQL Database Developer to assist in migrating an Oracle database to Postgres, ensuring system scalability and availability. The ideal candidate has a Bachelor's degree and extensive PostgreSQL experience, particularly in Linux environments. Responsibilities include maintaining database performance and creating technical documentation. We offer comprehensive benefits including health, dental, and retirement plans, as well as opportunities for professional growth.