Optum is a global organization that delivers care aided by technology to help millions of people live healthier lives. They are seeking a Data Engineer (PostgreSQL DBA) responsible for installing, configuring, upgrading, and maintaining PostgreSQL databases, while ensuring database availability and performance. The role includes monitoring database security, managing user access, and providing guidance on database usage.
Responsibilities:
- Install, configure,upgrade and maintain PostgreSQL databases in production and non‑production environments
- Manage database availability, high availability configurations, and failover processes
- Leverage enterprise-approved AI tools to enhance productivity and innovation by streamlining workflows and automating repetitive tasks. Evaluate emerging trends to drive continuous improvement and strategic innovation
- Monitor database health and performance; proactively identify and resolve performance bottlenecks
- Perform query and system-level performance tuning
- Perform regular recovery testing and execute disaster recovery procedures as required
- Ensure data integrity and recoverability at all times
- Monitor database security and prevent unauthorized access
- Manage user access, roles, and permissions in alignment with security standards and compliance requirements
- Schedule and execute routine database maintenance activities
- Troubleshoot and resolve production database issues, including data-related incidents
- Provide best-practice guidance to development and application teams on database usage
- Develop and enhance automation to streamline database operations and data loading processes
- Utilize PostgreSQL utilities and tools and monitoring/management solutions to maintain the environment
- Manage user access and permissions by adding and removing users as required
- Maintain the database using different utilities. This includes using pg_ctl and psql
Requirements:
- High School Diploma/GED
- 3+ years of experience as a PostgreSQL Infrastructure DBA supporting Postgres in a large‑scale enterprise environment, including managing databases of 10+ TB
- 2+ years of experience working with public cloud environment
- Healthcare experience
- Experience with MySQL or additional relational database platforms
- Working knowledge of implementing AI-driven tools used in database operations, monitoring, and support environments