Senior Database Administrator (PostgreSQL, Ansible, Terraform)

Tasks

• Administer Linux systems hosting databases
• Automate database deployments configurations and patching with Ansible
• Automate provisioning and management of database servers and storage
• Collaborate with development operations and data science on database projects
• Design implement and test automated database failover
• Design implement manage database infrastructure with Terraform
• Develop and maintain Ansible roles for database administration
• Develop and maintain documentation for configurations procedures disaster recovery plans
• Ensure consistent database configurations across environments
• Ensure database security access controls encryption audits
• Implement manage database backups restores recovery
• Implement manage load balancing for database traffic
• Maintain Terraform configurations and ensure consistency
• Manage DNS configurations for database accessibility and failover
• Participate in on call rotation for critical database issues
• Perform database performance monitoring alerting optimization
• Perform system monitoring security hardening performance tuning
• Plan execute database upgrades and migrations
• Provision configure maintain PostgreSQL and MySQL databases
• Troubleshoot database issues and resolve incidents

Perks/Benefits

• Employee referral program
• Generous time off
• Health benefits
• Hybrid work model
• Pension benefits
• Volunteer days
• Workation remote days

Skills/Tech-stack

AWS | AWS RDS | Access Control | Ansible | Backup and Recovery | Bash | DNS | Database Backup | Database Migration | Database backup and recovery | Encryption | Failover | Grafana | Infrastructure as Code | Linux | Load Balancing | Monitoring | MySQL | Performance Tuning | PostgreSQL | Prometheus | Python | Scripting | Terraform | “as-code”