PostgreSQL Database Administrator

Summary

We are seeking an experienced  PostgreSQL Database Administrator  with a strong track record in  PostgreSQL ,  Oracle ,  Oracle-to-PostgreSQL migration projects . The ideal candidate will have deep expertise in PostgreSQL administration, performance tuning, high availability, and backup / recovery strategies, as well as hands-on experience converting large-scale, mission-critical Oracle databases to PostgreSQL in both on-prem and cloud environments.

Your role in our mission

• Lead the migration of enterprise Oracle databases to PostgreSQL, including schema conversion, data migration, and application integration.
• Perform detailed assessment of Oracle schemas, PL / SQL code, and database features to plan equivalent PostgreSQL implementations.
• Configure, administer, and maintain PostgreSQL databases for performance, availability, and security.
• Implement high availability (HA) and disaster recovery (DR) solutions for PostgreSQL (e.g., streaming replication, Patroni, pgpool-II).
• Develop and execute performance tuning strategies, including query optimization, indexing, and configuration adjustments.
• Manage database backup and recovery processes, ensuring RTO / RPO objectives are met.
• Collaborate with application teams to rewrite PL / SQL code into PostgreSQL-compatible functions and procedures (PL / pgSQL).
• Monitor database health, capacity, and growth; troubleshoot and resolve incidents promptly.
• Document migration plans, configuration standards, and operational procedures.
• Stay current on PostgreSQL features, tools, and migration best practices.

What we're looking for

What you should expect in this role

#LI-GD1

#LI-REMOTE

The pay range for this position is $71,100.00 - $101,600.00 per year, however, the base pay offered may vary depending on geographic region, internal equity, job-related knowledge, skills, and experience among other factors. Put your passion to work at Gainwell. You’ll have the opportunity to grow your career in a company that values work flexibility, learning, and career development. All salaried, full-time candidates are eligible for our generous, flexible vacation policy, a , and educational assistance. We also have a variety of leadership and technical development academies to help build your skills and capabilities.