Senior Database Administrator (PostgreSQL, Ansible, Terraform)

Responsibilities

• Database Administration (Primary Focus: PostgreSQL and MySQL):
• Provision, configure, and maintain PostgreSQL or MySQL database systems (AWS cloud and on-premises)
• Perform database performance monitoring, alerting, and optimization.
• Implement and manage database backups, restores, and recovery strategies.
• Ensure database security through access controls, encryption, and regular audits.
• Troubleshoot database issues and provide timely resolutions.
• Plan and execute complicated database upgrades and migrations.
• Infrastructure as Code (IaC) with Terraform:
• Design, implement, and manage database infrastructure using Terraform.
• Automate the provisioning and management of database servers, storage, and related resources.
• Maintain Terraform configurations and ensure infrastructure consistency.
• Configuration Management with Ansible:
• Utilize Ansible playbooks to automate database deployments, configurations, and patching.
• Ensure consistent database configurations across all environments.
• Develop and maintain Ansible roles for database administration tasks.
• Linux System Administration:
• Manage and maintain the underlying Linux operating systems hosting the databases.
• Perform system monitoring, security hardening, and performance tuning.
• Troubleshoot Linux-related issues affecting database performance and availability.
• Auto Failover Implementation:
• Design, implement, and test automated failover solutions for database systems to ensure business continuity.
• Implement and manage load balancing solutions for database traffic to ensure high availability and performance
• Understand and manage DNS configurations related to database accessibility and failover mechanisms.
• Work with network teams to ensure proper DNS resolution for database services.
• Collaboration and Documentation:
• Develop and maintain comprehensive documentation for database configurations, procedures, and disaster recovery plans for all managed database systems.
• Participate in on-call rotation for critical database issues across all database technologies.
• Collaborate with development, operations, and data science teams on database-related projects and initiatives.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Excellent troubleshooting and problem-solving abilities.
• Ability to work independently and manage multiple tasks effectively.
• Strong communication and collaboration skills.
• Significant experience as a Database Administrator, with a strong focus on PostgreSQL and MySQL.
• Familiarity with CI/CD pipelines and routine automations.
• Proven experience with configuration management tools, preferably Ansible.
• Strong scripting skills (e.g., Bash, Python).
• Hands-on experience with Infrastructure as Code (IaC) using Terraform.
• Experience with database monitoring tools (e.g., Prometheus, Grafana).
• Solid understanding of Linux operating systems.
• Experience implementing and managing load balancing and auto-failover solutions for database systems.

Preferred Qualifications

• Experience with cloud-based database services (e.g., AWS RDS, Google Cloud SQL).
• Knowledge of containerization technologies (e.g., Docker, Kubernetes) and their interaction with databases.
• Knowledge of financial audit processes would be a plus.
• Production ClickHouse or MongoDB experience.