PostgreSQL Developer / Cloud Engineer

PostgreSQL Developer / Cloud Engineer

Duration: Immediate March 31, 2027
Type: Contract
Location: [Add location / Remote if applicable]

Job Summary
We are seeking an experienced PostgreSQL Developer / Cloud Engineer with strong expertise in PostgreSQL development, database migration, performance optimization, and AWS cloud engineering. The ideal candidate will have hands-on experience migrating databases from legacy RDBMS platforms to PostgreSQL and supporting cloud-based production environments.

Key Responsibilities

• Design and maintain PostgreSQL databases, schemas, tables, views, indexes, functions, procedures, and triggers.
• Plan and execute migrations from Oracle, SQL Server, MySQL, or other RDBMS platforms to PostgreSQL.
• Analyze source and target environments, migration risks, dependencies, and compatibility issues.
• Perform database conversion, data transformation, validation, reconciliation, and post-migration testing.
• Optimize SQL queries, indexes, execution plans, and PostgreSQL configurations.
• Support backup, restore, replication, high availability, and disaster recovery.
• Troubleshoot database performance issues and production incidents.
• Collaborate with application, DevOps, infrastructure, and security teams.
• Support AWS-based database and application workloads.
• Implement infrastructure as code, CI/CD pipelines, and deployment automation.
• Support cloud networking, monitoring, access control, security, and scaling.
• Participate in incident management, root-cause analysis, and production support.
• Create technical documentation, migration plans, and operational procedures.

Required Skills

• Strong hands-on PostgreSQL development and administration
• Strong SQL, database design, normalization, and relational data modeling
• Database migration experience
• Stored procedures, functions, views, triggers, and indexes
• PostgreSQL query optimization and performance tuning
• Execution plan analysis
• ETL, data transformation, and data validation
• Backup, restore, replication, and high availability
• Transactions, locking, isolation levels, and concurrency
• AWS cloud engineering
• Infrastructure as Code and CI/CD
• Cloud networking, monitoring, security, and scaling
• Production troubleshooting and incident resolution

Preferred

• Oracle PostgreSQL migration
• SQL Server PostgreSQL migration
• MySQL PostgreSQL migration
• PostgreSQL extensions and advanced features
• Large-scale enterprise database migrations
• Cloud-native architecture
• Modern DevOps practices