Senior Postgres Database Engineer
How will this role have an impact?
As a Senior Database Reliability Engineer specializing in PostgreSQL, you will play a critical role in designing, managing, and optimizing our cloud based PostgreSQL database infrastructure. You will ensure the reliability, availability, and performance of our database systems while fostering a collaborative and innovative environment. This position requires deep operational expertise in PostgreSQL, experience with Azure, and a strategic mindset to drive database solutions that align with our commitment to reliability and sustainability.
Key Responsibilities:
- Database Management: Design, implement, and maintain PostgreSQL database systems, primarily managed instances in cloud environments (Azure), to ensure high availability, performance, and reliability.
- Performance Tuning: Conduct performance tuning and optimization of database queries, indexes, and configurations to enhance efficiency.
- Backup and Recovery: Develop and manage robust backup and recovery strategies, ensuring data integrity and availability in case of failures.
- Monitoring and Troubleshooting: Implement and maintain monitoring solutions using tools such as Redgate, pganalyze, and New Relic to proactively identify and resolve database issues, ensuring minimal downtime and optimal performance.
- Security: Implement and maintain database security measures, including user management, encryption, data masking and access controls, to ensure compliance with healthcare regulations.
- Collaboration: Work closely with cross functional teams to support application development and deployment processes.
- Documentation: Maintain comprehensive documentation of database configurations, procedures, scripts and best practices.
- Standards and Procedures: Provide guidance in the creation and modification of standards and procedures including scripts for automation and reporting for adherence to standards.
- On-call Support: Participate in on-call rotations as an opportunity to enhance the reliability and performance of our database systems, ensuring minimal disruptions and optimal performance without frequent interruptions.
What You’ll Need (Required Qualifications):
- Experience:
- 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.
- Technical Skills:
- 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.
- Soft Skills:
- 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.
- Ability to work effectively in a collaborative team environment or independently.
The base salary hiring range for this position is $108,900 to $189,700. Compensation offered will be determined by factors such as location, level, job-related knowledge, skills, and experience. Certain roles may be eligible for incentive compensation, equity, and benefits.
In addition to your compensation, enjoy the rewards of an organization that puts our heart into caring for our colleagues and our communities. Eligible employees may enroll in a full range of medical, dental, and vision benefits, 401(k) retirement savings plan, and an Employee Stock Purchase Plan. We also offer education assistance, free development courses, paid time off programs, paid holidays, a CVS store discount, and discount programs with participating partners.
About Us:
Signify Health is helping build the healthcare system we all want to experience by transforming the home into the healthcare hub. We coordinate care holistically across individuals’ clinical, social, and behavioral needs so they can enjoy more healthy days at home. By building strong connections to primary care providers and community resources, we’re able to close critical care and social gaps, as well as manage risk for individuals who need help the most. This leads to better outcomes and a better experience for everyone involved.
Our high-performance networks are powered by more than 9,000 mobile doctors and nurses covering every county in the U.S., 3,500 healthcare providers and facilities in value-based arrangements, and hundreds of community-based organizations. Signify’s intelligent technology and decision-support services enable these resources to radically simplify care coordination for more than 1.5 million individuals each year while helping payers and providers more effectively implement value-based care programs.
To learn more about how we’re driving outcomes and making healthcare work better, please visit us at www.signifyhealth.com
Diversity and Inclusion are core values at Signify Health, and fostering a workplace culture reflective of that is critical to our continued success as an organization.
We are committed to equal employment opportunities for employees and job applicants in compliance with applicable law and to an environment where employees are valued for their differences.
Apply for this job
*
indicates a required field