Senior Database Reliability Engineer (PostgreSQL, Terraform, AWS)

Own the provisioning, configuration, and ongoing maintenance of PostgreSQL and MySQL instances across AWS RDS and on-premises, ensuring they meet uptime and performance targets.

Design and implement automated failover solutions, load balancing configurations, and DNS management strategies to keep databases accessible under failure conditions.

Write and maintain Terraform code to provision and manage database infrastructure - clusters, instances, storage, parameter groups, security groups - with consistency across environments.

Build and manage Ansible playbooks and roles for database deployments, configuration changes, and patching cycles.

Monitor, alert, and tune - using Prometheus and Grafana - to catch performance degradation before it becomes an incident.

Plan and execute database upgrades and migrations, including cross-version and cross-engine work (PostgreSQL, MySQL, Redshift, ClickHouse, DynamoDB), with minimal impact to production.

Manage backup, restore, and recovery processes; test them regularly so they work when it matters.

Harden database security through access controls, encryption at rest and in transit, and periodic audits.

Maintain and improve underlying Linux systems hosting the databases, including security hardening and performance tuning.

Document configurations, runbooks, and disaster recovery plans; participate in on-call rotation.