Senior Database Administrator

We are seeking a highly skilled and proactive Database Administrator with a strong focus on PostgreSQL and MySQL to manage, optimize, and ensure the high availability and security of our database environments.

Requirements

• 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.
• Maintain Terraform configurations and ensure infrastructure consistency.
• 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.
• 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

Benefits

• Auto failover implementation
• Implementation of load balancing solutions
• Infrastructure as Code with Terraform
• Configuration management with Ansible