PostgreSQL Developer/Cloud Engineer - Database Platforms

Orangepeople • Plano, TX

13h

About The Position

We are seeking an experienced PostgreSQL Developer/Cloud Engineer to support database development, migration, optimization, and cloud-based platform engineering initiatives. The role involves designing and maintaining PostgreSQL databases, migrating data and database objects from legacy platforms, tuning performance, supporting production environments, and building cloud-based workloads. The engineer will collaborate with application development, DevOps, infrastructure, and security teams on platform modernization and will document technical designs, migration plans, operating procedures, and support processes.

The position also includes participation in monthly team meetings, team-building efforts, technical discussions and peer reviews, contributing to the OP-Wiki/Knowledge Base, and providing status reports to OP Account Management when requested.

Requirements

• 10+ years of professional experience in PostgreSQL development, database engineering, or related roles.
• Strong hands-on experience with PostgreSQL development and administration.
• 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 and Azure.
• 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.

Nice To Haves

• 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.

Responsibilities

• Design, develop, and maintain PostgreSQL databases and objects, including schemas, tables, views, indexes, stored procedures, functions, and triggers.
• Plan and execute 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 migrations.
• Perform data transformation, validation, reconciliation, and post-migration testing.
• Tune PostgreSQL performance using 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 practices.
• Support production systems and participate in incident resolution and root-cause analysis.
• Document technical designs, migration plans, operating procedures, and support processes.
• Participate in OP monthly team meetings and team-building efforts.
• Contribute to OP technical discussions and peer reviews.
• Contribute content and collaborate via the OP-Wiki/Knowledge Base.
• Provide status reports to OP Account Management as requested.

Benefits

• 401(k)
• Dental insurance
• Health insurance
• Vision insurance

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed