Senior Postgres Database Engineer

$108,900 - $189,700/Yr

Signify Health - Dallas, TX

Full-time - Senior

Dallas, TX

5,001-10,000 employees

Insurance Carriers and Related Activities

About the position

As a Senior Database Reliability Engineer specializing in PostgreSQL at Signify Health, you will be responsible for designing, managing, and optimizing the cloud-based PostgreSQL database infrastructure. Your role is crucial in ensuring the reliability, availability, and performance of database systems while fostering a collaborative and innovative environment. This position requires deep operational expertise in PostgreSQL and experience with Azure, along with a strategic mindset to drive database solutions that align with the company's commitment to reliability and sustainability.

Responsibilities

• Design, implement, and maintain PostgreSQL database systems in cloud environments (Azure) to ensure high availability, performance, and reliability.
• Conduct performance tuning and optimization of database queries, indexes, and configurations to enhance efficiency.
• Develop and manage robust backup and recovery strategies, ensuring data integrity and availability in case of failures.
• Implement and maintain monitoring solutions using tools such as Redgate, pganalyze, and New Relic to proactively identify and resolve database issues.
• Implement and maintain database security measures, including user management, encryption, data masking, and access controls.
• 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.
• Participate in on-call rotations to enhance the reliability and performance of database systems.

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.
• 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.
• Proficiency in automation tools such as Terraform, Ansible, and Flyway.
• Strong understanding of security practices and compliance frameworks.

Nice-to-haves

• Experience with GCP is a plus but not required.
• Excellent written and verbal communication skills with the ability to convey complex technical concepts to both technical and non-technical stakeholders.
• Strategic thinker with the ability to drive long-term database solutions aligned with business goals.
• Collaborative and team-oriented, contributes ideas, suggestions, and effort to the group.

Benefits

• Medical, dental, and vision 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