PostgreSQL Database Administrator

Gainwell Technologies LLC • OH

118d • $71,100 - $101,600

About The Position

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.

Requirements

• 5+ years of experience as a Database Administrator, including 3+ 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.

Responsibilities

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

Benefits

• Generous, flexible vacation policy
• 401(k) employer match
• Comprehensive health benefits
• Educational assistance
• Leadership and technical development academies

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 5,001-10,000 employees