Role Overview:This role is for a MySQL DBA Analyst responsible for the installation, configuration, upgrade, and maintenance of MySQL, Redis, and PostgreSQL databases across on-premises and AWS environments. The analyst will manage replication solutions, optimize AWS managed database services, and automate routine tasks to ensure high availability and performance.
Key Responsibilities:- Install, configure, upgrade, and maintain MySQL, Redis, and PostgreSQL databases in both on-premises and AWS environments.
- Manage replication solutions for each Database based on application requirement for proper High Availability.
- Administer and Optimize AWS Managed database services (RDS, AURORA, ElastiCache, DynamoDB, S3, EC2).
- Automate routine tasks and infrastructure setup using tools like Ansible and AWS CloudFormation.
- Design and implement comprehensive monitoring and alerting systems (CloudWatch, PMM, Datadog, MonYog) to proactively identify performance bottlenecks and apply necessary optimizations or fixes.
- Perform daily maintenance, health checks, and capacity planning to ensure database reliability across all environments.
- Collaborate with application developers to design efficient schemas, optimize complex queries, and enhance database performance.
- Work closely with DevSecOps to ensure timely application of security patches and upgrades.
- Develop and manage robust backup and disaster recovery strategies ensuring minimal data loss and downtime.
- Generate ad-hoc reports and provide insights as requested by internal teams or stakeholders.
Required Skills:- MySQL Database Administration
- Redis Database Administration
- PostgreSQL Database Administration
- Amazon Web Services (AWS) Cloud Computing
- AWS Managed Database Services (RDS, AURORA, ElastiCache, DynamoDB, S3, EC2)
- Automation tools: Ansible, AWS CloudFormation
- Monitoring and Alerting systems: CloudWatch, PMM, Datadog, MonYog
- Shell Scripting or Python
- Linux Administration
Qualifications:- 10+ years of experience in database administration.
