Senior PostgreSQL Database Engineer / Cloud Database Engineer
Job Title: Senior PostgreSQL Database Engineer / Cloud Database EngineerLocation: Plano, TXExpected Duration: 5 Months ContractWork Model: Hybrid ModelSeeking 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.ResponsibilitiesDesign, develop, and maintain PostgreSQL databases, schemas, tables, views, indexes, stored procedures, functions, and triggersPlan and execute database migrations from legacy relational database platforms to PostgreSQLAssess source and target database environments and identify migration risks, dependencies, and compatibility issuesConvert and optimize database objects, queries, and data models during migration effortsPerform data transformation, validation, reconciliation, and post-migration testingTune PostgreSQL performance through indexing, query optimization, execution plan analysis, and database configurationSupport backup, restore, replication, and high availability strategiesTroubleshoot database performance issues, migration defects, and production incidentsCollaborate with application developers, DevOps, infrastructure, and security teams to support platform modernizationBuild and support cloud-based database and application workloadsImplement and support infrastructure as code, CI/CD pipelines, and deployment automationWork with cloud networking, monitoring, access control, and security best practicesSupport production systems and participate in incident resolution and root cause analysisDocument technical designs, migration plans, operating procedures, and support processesRequirementsStrong hands-on experience with PostgreSQL development and administrationProven experience leading or supporting database migration projectsProficiency in SQL, database design, normalization, and relational data modelingExperience with stored procedures, functions, views, triggers, and indexesStrong understanding of query optimization, performance tuning, and execution plansExperience with ETL, data transformation, and data validationKnowledge of backup, restore, replication, and high availability conceptsFamiliarity with transactions, locking, isolation levels, and concurrency controlCloud engineering experience supporting workloads in AWSExperience with infrastructure as code, CI/CD, and deployment automationKnowledge of cloud security, networking, monitoring, and scaling practicesAbility to troubleshoot complex technical issues in database and cloud environmentsStrong communication, documentation, and problem-solving skillsPreferred QualificationsExperience migrating from Oracle, SQL Server, MySQL, or other RDBMS platforms to PostgreSQLExperience with PostgreSQL extensions and advanced featuresExperience with large-scale, business-critical, or enterprise migration projectsExperience supporting cloud-native architectures and modern DevOps practices