Senior Database Site Reliability Engineer (SRE)

Department:

Employment Type:

Location:

Reporting To:

Description

What you will do:

• Administer and maintain Amazon Aurora PostgreSQL clusters in production and development environments.
• Monitor database performance, implement tuning solutions, and optimize queries for speed and efficiency.
• Automate backups, scaling, failover, and patching using AWS-native tools and best practices.
• Collaborate with DevOps and Engineering teams to design database solutions that are scalable, reliable, and secure.
• Perform data migrations, upgrades, and schema changes with minimal downtime.
• Develop and maintain disaster recovery strategies, including automated failover and snapshot recovery.
• Automate database operations using Terraform, Ansible, AWS Lambda, and AWS CLI. Manage Aurora’s read replicas, auto-scaling, and failover mechanisms.
• Ensure high availability and redundancy across multi-AZ Aurora PostgreSQL clusters.
• Implement role-based access control and monitor database security in compliance with company policies.
• Create and maintain documentation for database architecture, standards, and procedures.
• Embrace SRE principles such as Chaos Engineering, Reliability, Reducing Toil, etc.,

What We're Looking For:

•  With over 8 years of total experience, including 4+ years of hands-on expertise in managing relational databases (Oracle, and PostgreSQL) in both cloud and on-prem environments, including SRE tasks like backup/restore, Performance issues and replication (primary skill required for this role)
• 3+ years of experience hosting enterprise applications in AWS (EC2, EBS, ECS/EKS, Elastic Beanstalk, RDS, CloudWatch).
• Familiarity with tools like pgAdmin, psql, or other database management utilities. Automate routine database maintenance tasks (e.g., vacuuming, reindexing, patching). Knowledge of backup and recovery strategies (e.g., pg_dump, PITR).
• Automate routine database maintenance tasks (e.g., vacuuming, reindexing, patching).
• Proven hands-on experience as an SRE for critical, client-facing applications, with the ability to dive deep into daily SRE tasks, manage incidents, and oversee operational tools.
• Automation experience with Infrastructure as Code (Terraform, CloudFormation, Python, Jenkins, GitHub/Actions). Knowledge of multi-region Aurora Global Databases for disaster recovery.
• Scripting experience in Python, Bash, Java, JavaScript, Node.js.
• Excellent written/verbal communication, critical thinking. Willingness to work in shifts and assist your team to resolve issues efficiently.

Join Us at Vitech!