Senior PostgreSQL Database Engineer / Cloud Database Engineer

Job Title: Senior PostgreSQL Database Engineer / Cloud Database Engineer

Location: Plano, TX

Expected Duration: 5 Months Contract

Work Model: Hybrid Model

Visa Status: US Citizen or GC’s Only!

ID Proof is mandatory at the time of submission

Seeking an experienced PostgreSQL Developer / Cloud Engineer to support database development, migration, optimization, and cloud-based platform engineering initiatives. The ideal candidate will have strong PostgreSQL expertise, hands-on experience with database migrations, and solid cloud engineering experience across modern infrastructure and deployment environments.

Responsibilities

Design, develop, and maintain PostgreSQL databases, schemas, tables, views, indexes, stored procedures, functions, and triggers

Plan and execute database migrations from legacy relational database platforms to PostgreSQL

Assess source and target database environments and identify migration risks, dependencies, and compatibility issues

Convert and optimize database objects, queries, and data models during migration efforts

Perform data transformation, validation, reconciliation, and post-migration testing

Tune PostgreSQL performance through indexing, query optimization, execution plan analysis, and database configuration

Support backup, restore, replication, and high availability strategies

Troubleshoot database performance issues, migration defects, and production incidents

Collaborate with application developers, DevOps, infrastructure, and security teams to support platform modernization

Build and support cloud-based database and application workloads

Implement and support infrastructure as code, CI/CD pipelines, and deployment automation

Work with cloud networking, monitoring, access control, and security best practices

Support production systems and participate in incident resolution and root cause analysis

Document technical designs, migration plans, operating procedures, and support processes

Requirements

Strong hands-on experience with PostgreSQL development and administration

Proven experience leading or supporting database migration projects

Proficiency in SQL, database design, normalization, and relational data modeling

Experience with stored procedures, functions, views, triggers, and indexes

Strong understanding of query optimization, performance tuning, and execution plans

Experience with ETL, data transformation, and data validation

Knowledge of backup, restore, replication, and high availability concepts

Familiarity with transactions, locking, isolation levels, and concurrency control

Cloud engineering experience supporting workloads in AWS

Experience with infrastructure as code, CI/CD, and deployment automation

Knowledge of cloud security, networking, monitoring, and scaling practices

Ability to troubleshoot complex technical issues in database and cloud environments

Strong communication, documentation, and problem-solving skills

Preferred Qualifications

Experience migrating from Oracle, SQL Server, MySQL, or other RDBMS platforms to PostgreSQL

Experience with PostgreSQL extensions and advanced features

Experience with large-scale, business-critical, or enterprise migration projects

Experience supporting cloud-native architectures and modern DevOps practices