PostgreSQL Database Administrator

Gainwell Technologies

  • Tennessee
  • $90,900-129,900 per year
  • Permanent
  • Full-time
  • 23 days ago
Be part of a team that unleashes the power of leading-edge technologies to help improve the health and well-being of those most vulnerable in our country and communities. Working at Gainwell carries its rewards. You'll have an incredible opportunity to grow your career in a company that values work flexibility, learning, and career development. You'll add to your technical credentials and certifications while enjoying a generous, flexible vacation policy and educational assistance. We also have comprehensive leadership and technical development academies to help build your skills and capabilities.SummaryWe 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
  • 8+ years of experience as a Database Administrator, including 5+ years in PostgreSQL.
  • Proven, hands-on experience in end-to-end Oracle-to-PostgreSQL migration for large, complex systems.
  • Expertise in migration tools such as Ora2Pg, AWS SCT/DMS, EDB Migration Toolkit, or equivalent.
  • Proficiency in PostgreSQL architecture, configuration, administration and SQL and procedural languages (PL/pgSQL, PL/SQL).
  • Solid experience with backup/recovery tools (pgBackRest, Barman) and HA solutions.
  • Experience with Linux/Unix environments and shell scripting.
What you should expect in this role
  • Fully Remote Opportunity - Work from anywhere in the U.S.
  • Minimal Travel Required - Occasional travel opportunities (0-10%).
  • Video cameras must be used during all interviews, as well as during the initial week of orientation
The deadline to submit applications for this posting is September 1, 2025.The pay range for this position is $90,900.00 - $129,900.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.We believe nothing is impossible when you bring together people who care deeply about making healthcare work better for everyone. Build your career with Gainwell, an industry leader. You'll be joining a company where collaboration, innovation, and inclusion fuel our growth. Learn more about Gainwell at our and visit our for all available job role openings.Gainwell Technologies is an Equal Opportunity Employer, where all qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical condition), age, sexual orientation, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.

Gainwell Technologies