About the role
**Job Role: MySQL DBA** **Location: Englewood Cliffs, NJ (Onsite)** **Duration: Contract for 06+ Months** **Interview Mode: Face to Face or In-Person Interview** **Job Description:** - The MySQL Database Administrator will be responsible for installing| configuring| and maintaining MySQL environments. - They will handle schema management| indexing| and optimizing database performance. - The role includes managing MySQL replication and high-availability setups. - Additionally| the DBA will perform recovery operations and ensure data integrity. - Participation in on-call rotation for production incidents is also required. **Essential Skills:** - Experience with AWS cloud services is preferred but not mandatory. - Familiarity with monitoring tools like Grafana or CloudWatch is beneficial. - Exposure to DevOps tools such as Jenkins or GitLab CI can enhance a candidates profile. - Knowledge of NoSQL databases like MongoDB or Redis is a plus. - Understanding containerization technologies like Docker or Kubernetes is also advantageous. - Candidates must have strong hands-on experience with MySQL databases| including installation| configuration| and maintenance. - Proficiency in Linux administration is essential for troubleshooting and server management. - Experience with performance tuning and backup/recovery processes is critical. - Familiarity with MySQL internals and storage engines is required. **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. **Skills:** - Digital : Amazon Web Service(AWS) Cloud Computing~Unix Administration~MySQL~Java EE Performance Optimization & Tuning - Experience Required: 6-8 Years