Senior Site Reliability Engineer (database focused)

Responsibilities - Architect, implement, and rigorously test robust highly available and fault tolerant solutions on bare-metal platforms - Design, implement, and validate comprehensive disaster recovery strategies for production databases - Automate reliable backup strategies while guaranteeing data integrity, adequacy, and real-time restorability - Develop and maintain infrastructure as code solutions to fully automate the provisioning, configuration, hardening, patching, and scaling of database instances - Implement and enforce reliable, predictable, reviewable, and testable database infrastructure deployments, ensuring strict consistency across environments - Integrate database provisioning, configuration, and schema migrations into existing CI/CD pipelines to facilitate automated and fault-tolerant database changes - Provide expert administration, maintenance, and support for all production and non-production database systems - Execute database upgrades, patching, and migrations with minimal disruption - Manage database users, permissions, and access controls for secure access - Deeply profile and optimize database server resource usage, schemas, and complex SQL queries, leveraging profound understanding of underlying database engines - Design and implement comprehensive, granular monitoring for all database performance and health, integrating with existing observability platform - Configure and refine alerting mechanisms within observability platforms to predict and prevent performance degradation, security anomalies, and availability risks - Configure, sanitize, and refine observability metrics and logging with existing observability and logging platforms - Proactively identify and mitigate potential vulnerabilities - Develop and implement data lifecycle management strategies - Deliver expert troubleshooting and resolution for critical production database issues -Collaborate closely with engineering, product, and IT operations teams to design, implement, and optimize scalable database solutions - Continuously stay aware of established trends and developments in database administration, focusing on solutions that prioritize stability and reliability - Partner closely with junior to mid-level engineers on database operations, maintenance, and observability, providing guidance and a cornerstone for all things database