Job Title: Mysql DBA Analyst
Location: New Jersey (Local only)
Skills: Digital: Amazon Web Service (AWS) Cloud Computing~MySQL
Experience Required: 10 & Above
Note: Please note that candidate should be ok for f2f CE.
Role Descriptions:
- Install| configure| upgrade| and maintain MySQL| Redis| 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. Good with Shell Scripting or Python. Good with linux administration.