Gainwell Technologies LLC-posted 2 months ago
$71,100 - $101,600/Yr
Full-time • Mid Level
OH
5,001-10,000 employees

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.

  • 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.
  • 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.
  • Generous, flexible vacation policy
  • 401(k) employer match
  • Comprehensive health benefits
  • Educational assistance
  • Leadership and technical development academies
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service