MySQL DBA

Volto Consulting; Englewood Cliffs (NJ); On-site; USD 100,000 - 150,000; Full time

Job summary

VOLTO Consulting is seeking a MySQL Database Administrator in New Jersey. The role focuses on installing, configuring, and maintaining MySQL environments, optimizing performance, and ensuring data integrity.

The candidate will manage replication, high availability, and backups across on-premises and AWS. The position requires strong Linux administration skills, experience with AWS services, and familiarity with monitoring tools.

Qualifications

• 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.
• Familiarity with MySQL internals and storage engines.

Responsibilities

• Install, configure, and maintain MySQL environments.
• Handle schema management, indexing, and optimize database performance.
• Manage MySQL replication and high-availability setups.
• Perform recovery operations and ensure data integrity.
• Participation in on-call rotation for production incidents.
• 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 requirements for HA.
• Administer and optimize AWS managed services (RDS, Aurora, ElastiCache, DynamoDB, S3, EC2).
• Automate routine tasks using Ansible and AWS CloudFormation.
• Design monitoring and alerting with CloudWatch, PMM, Datadog, MonYog.
• Daily maintenance, health checks, capacity planning across environments.
• Collaborate with developers to design efficient schemas and optimize queries.
• Work with DevSecOps to apply security patches.
• Develop robust backup and disaster recovery strategies.
• Generate ad-hoc reports for internal teams.
• Shell scripting or Python proficiency.
• Linux administration proficient.

Skills

AWS Cloud Computing

Unix Administration

MySQL

Java EE Performance Tuning

Tools

Grafana

CloudWatch

Jenkins

GitLab CI

Docker

Kubernetes

Job description

Mysql DBA

Please Note: The candidate should be comfortable attending a face-to-face (F2F) client interview (CE). However, the team is open to considering genuine profiles of candidates who are willing to relocate from Day 1 and can attend an F2F interview at the nearest TCS office.

Experience Required

6-8 Years

Skills

• Amazon Web Service(AWS) Cloud Computing
• Unix Administration
• MySQL
• Java EE Performance Optimization & Tuning

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.

Requirements

• 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.
• Candidates should also be comfortable working onsite in New Jersey.

Role Descriptions

• 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.
• 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.
• 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.