Sr. Database Administrator

Job Description

Responsibilities • Hands-on maintenance of PostgreSQL databases, ensuring uptime, reliability, and performance. • Design and implement procedures for backup, failover, and recovery to deliver data integrity and business continuity. • Provide hands-on database expertise to development teams, advising on schema design, indexing, and query optimization. • Proactively monitor database health and performance; identify and resolve issues before they impact production. • Collaborate with internal teams and service providers (AWS, Enterprise DB etc.) in the resolution of issues • Work closely with DevOps and Engineering to integrate safe database change processes into delivery pipelines • Establish and document database standards, policies, and best practices. • Contribute to the broader data architecture strategy as the organization scales and evolves. • Recommend and implement best practices for data security, compliance, and scalability. • Define, agree and maintain improvement roadmap for the database estate. Knowledge, Skills and Experience Required Proven experience required • 6+ years of hands-on experience working with PostgreSQL in complex, production environments. • Demonstrable expertise in hands-on operations, managing the ongoing hygiene of a postgreSQL estate including backup, point-in-time recovery, replication and failover – ideally with Barman and a PG load balancer. • Deep technical knowledge of PostgreSQL internals with experience in query optimization, indexing strategies, and performance tuning of DB instance and host parameters. • Experience working with cloud-based and/or containerized infrastructure • Proficient in scripting (e.g., Bash, Python) to automate database operations and maintenance tasks. • Solid understanding of Linux system administration as it relates to database performance and configuration. • Demonstrates the drive and ability to independently identify required work, negotiate priorities and efficiently deliver on agreed objectives. • Strong communication skills, with the ability to explain database concepts and trade-offs to both technical and nontechnical stakeholders. Desirable: • Exposure to other database technologies (e.g., MySQL, MongoDB, Redis). • Experience with observability and monitoring tools (e.g., Prometheus, Grafana, pg_stat_statements). • Experience with infrastructure-as-code techniques (e.g. Terraform, Ansilble) Show more Show less