Oracle-to-Postgres Migration & Performance Engineer

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

Benefits offered by this job

Health, Dental, and Vision

Life Insurance

401k

Flexible Spending Account

Paid Time Off

Job summary

A federal services company in Detroit is seeking a PostgreSQL Database Developer to support the migration from Oracle to Postgres. The role involves creating technical documentation and collaborating on technical requirements. Ideal candidates have 7+ years of PostgreSQL database administration experience and a Bachelor's degree. Benefits include health insurance and a 401k plan, providing a supportive work environment for professional growth.

Qualifications

• 7 years of experience with administrating PostgreSQL Databases in Linux environments.
• Experience with setting up, monitoring, and maintaining PostgreSQL instances.
• Experience migrating Oracle schema, packages, views, triggers to Postgres using Ora2Pg tool.

Responsibilities

• Drive efforts to migrate from Oracle database to Microsoft Azure Postgres database.
• Collaborate with internal and external parties for technical requirements.
• Ensure availability and performance of the databases supporting systems.

Skills

PostgreSQL administration

Database migration

Performance tuning

Technical documentation

Education

Bachelor's degree

Tools

Ora2Pg

AWS RDS for PostgreSQL

Job description

A federal services company in Detroit is seeking a PostgreSQL Database Developer to support the migration from Oracle to Postgres. The role involves creating technical documentation and collaborating on technical requirements. Ideal candidates have 7+ years of PostgreSQL database administration experience and a Bachelor's degree. Benefits include health insurance and a 401k plan, providing a supportive work environment for professional growth.