91 677
8 881
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. 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. 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. Design, implement, and manage database infrastructure using Terraform. Automate the provisioning and management of database servers, storage, and related resources. 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. 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. 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. Bachelors degree in Computer Science, Information Technology, or a related field. Significant experience as a Database Administrator, with a strong focus on PostgreSQL and MySQL. Bash, Python). Experience with database monitoring tools (e.g., Solid understanding of Linux operating systems. Experience implementing and managing load balancing and auto-failover solutions for database systems. Experience with cloud-based database services (e.g., AWS RDS, Google Cloud SQL). Docker, Kubernetes) and their interaction with databases.