Signify Health is hiring a
Senior Postgres Database Engineer

Summary

Join our team as a Senior Database Reliability Engineer specializing in PostgreSQL, where you will design, manage, and optimize cloud-based PostgreSQL database infrastructure. This role requires deep operational expertise in PostgreSQL, experience with Azure, and a strategic mindset to drive database solutions.

Requirements

• Minimum of 10 years of operational experience at scale in database management with at least 6 years focused on PostgreSQL
• Extensive experience managing PostgreSQL databases in cloud environments, particularly Azure. Experience with GCP is a plus but not required
• Hands-on experience with Continuous Integration/Continuous Deployment pipelines, Database/Schema as Code tools, and Git workflows
• Expert level experience analyzing and tuning queries to improve application performance
• Experience with database recovery, including point-in-time recovery and transaction wraparound process remediation
• Experience with management of Postgres Vacuuming process, able to design and implement processes and standards to prevent production impacting Vacuuming events
• Experience with PostgreSQL upgrade processes
• Advanced knowledge of PostgreSQL architecture, performance tuning, and query optimization experience with Azure Query Performance Insight is a plus
• Advanced knowledge of operating databases at large scale in cloud-managed environments including optimizing for cpu, memory,IO usage and cost management
• Proficiency in automation tools such as Terraform, Ansible, and Flyway
• Strong understanding of security practices and compliance frameworks
• Extensive knowledge of PostgreSQL internals, index design, statistics and wait types

Responsibilities

• Design, implement, and maintain PostgreSQL database systems
• Conduct performance tuning and optimization of database queries, indexes, and configurations
• Develop and manage robust backup and recovery strategies
• Implement and maintain monitoring solutions using tools such as Redgate, pganalyze, and New Relic
• Implement and maintain database security measures
• Work closely with cross functional teams to support application development and deployment processes
• Maintain comprehensive documentation of database configurations, procedures, scripts and best practices
• Provide guidance in the creation and modification of standards and procedures including scripts for automation and reporting for adherence to standards
• Participate in on-call rotations as an opportunity to enhance the reliability and performance of our database systems

Benefits

• 401(k) retirement savings plan
• Employee Stock Purchase Plan
• Education assistance
• Free development courses
• Paid time off programs
• Paid holidays
• CVS store discount
• Discount programs with participating partners