Senior Database Administrator

Overview: We are seeking a highly skilled and proactive Database Administrator with a strong focus on PostgreSQL and MySQL, complemented by experience with infrastructure-as-code (IaC) using Terraform and configuration management with Ansible. The ideal candidate will be responsible for managing, optimizing, and ensuring the high availability and security of our database environments. Experience with and implementing auto or manual failover, DNS management, load balancing solutions is crucial for this role. Additionally, experience with databases like ClickHouse/Redshift/Microsoft SQL server/MongoDB is a significant plus. You will play a key part in building and maintaining a robust and scalable data infrastructure that may encompass both relational and non-relational database systems. Responsibilities: Database Administration (Primary Focus: PostgreSQL and MySQL): Install, configure, and maintain PostgreSQL or MySQL database systems (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.