PostgreSQL Database Engineer

  • Nashville, TN
  • Posted 6 days ago | Updated 6 days ago

Overview

On Site
Depends on Experience
Accepts corp to corp applications
Contract - W2

Skills

PostgreSQL Database Engineer
Migration (Oracle to PostgreSQL)
GCP
Azure
Terraform
PL/Sql
Oracle
shell scripting
data migration
Validation

Job Details

Job Summary:
We are seeking an experienced and detail-oriented PostgreSQL Database Engineer with a strong background in Oracle to PostgreSQL migrations. The ideal candidate will lead and support large-scale database migration projects, ensuring seamless data transformation, performance optimization, and post-migration support.

Key Responsibilities:
Lead end-to-end migration from Oracle to PostgreSQL, including schema conversion, data migration, and validation

Analyze existing Oracle database architecture, objects, stored procedures, packages, and performance configurations

Design and implement equivalent PostgreSQL solutions following industry best practices

Convert PL/SQL code (procedures, triggers, functions) to PL/pgSQL or appropriate PostgreSQL constructs

Optimize PostgreSQL performance through indexing, query tuning, partitioning, and caching strategies

Support testing teams during UAT and post-migration validation phases

Develop migration strategy, risk assessments, and rollback plans

Provide documentation, deployment scripts, and technical support throughout the migration lifecycle

Collaborate with development and DevOps teams to ensure seamless database integration

Participate in database upgrades, patching, and maintenance

Monitor and troubleshoot PostgreSQL databases in production and staging environments

Required Skills & Experience:
5+ years of hands-on experience with PostgreSQL database administration and development

Strong experience in Oracle to PostgreSQL migrations (manual and using tools like AWS DMS, Ora2Pg, etc.)

In-depth knowledge of PL/SQL and PL/pgSQL

Experience in schema design, data modeling, and performance tuning

Proficient in writing complex SQL queries, stored procedures, and functions

Experience with Linux-based systems and shell scripting for automation

Familiarity with high availability (HA), replication, and backup strategies for PostgreSQL

Strong debugging and analytical skills

Excellent verbal and written communication skills

Preferred Qualifications:
Experience with cloud platforms like AWS (RDS/Aurora PostgreSQL), Google Cloud Platform, or Azure PostgreSQL

Exposure to CI/CD tools, version control (Git), and infrastructure automation (Terraform, Ansible)

Knowledge of database security and compliance best practices

Familiarity with containerization (Docker/Kubernetes)

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.