MYSQL Database Administrator Infrastructure

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Applied Thought Auditors & Consultants Inc., is seeking the following. Apply via Dice today!Title: MYSQL Database Administrator InfrastructureLocation: Berkeley Heights, NJ (5 Days Onsite)Contract - W2Job Description:We are seeking a MYSQL Database Administrator Infrastructure Resource having 8+ years of professional experience in responsible for the design, implementation, and maintenance of scalable database systems. The candidate must have deep hands‑on experience with MYSQL, along with the ability to design scalable, secure, and resilient cloud solutions.This role requires close collaboration with cross‑functional teams, adherence to DevOps and Agile practices, and ownership of service quality and delivery.Key ResponsibilitiesInfrastructure Design: Develop and maintain database reference architecture and design documents. This includes building Cloud-based database solutions and physical storage structures.High Availability & Disaster Recovery: Design and manage replication strategies (e.g., Master-Slave, GTID), multi-AZ configurations, and failover mechanisms to ensure 24x7 mission-critical availability.Performance Engineering: Identify database bottlenecks, conduct query optimization, and perform regular performance tuning. Perform capacity planning to predict future storage and resource needs. Profiling server resource usage (CPU, RAM, I/O) and tweaking system variables to optimize the underlying storage engine performance, specifically for InnoDB.Disaster Recovery: Implementing automated backup, restoration, and point-in-time recovery (PITR) procedures to guarantee business continuity.Automation & Patching: Using tools (like Ansible or custom scripts) to orchestrate version upgrades, security patches, and routine health checks with minimal downtime.Capacity Planning: Monitoring growth trends to anticipate future storage and hardware needs before they impact serviceSecurity & Compliance: Establish security standards, manage role-based user access, and implement encryption for data at rest and in transit.Automation & DevOps: Integrate database systems into automated deployment pipelines and use tools like Ansible, Chef, or shell scripting to automate routine tasks.Lifecycle Management: Orchestrate database upgrades, patching, and migrations to new platforms with minimal downtimeMandatory Technical Skills & CompetenciesDeep knowledge of MySQL engines (e.g., (InnoDB/MyISAM)), sharding, native replication, memory management, and file systems. Strong Scripting knowledge: Competence in Bash, Python, or Perl for automating repetitive administrative tasks and monitoring.Familiarity with cloud platforms (AWS, Azure, Google Cloud Platform) and containerization (Docker, Kubernetes) is often requiredOS Knowledge: Strong experience managing MySQL on Linux/Unix environments, including kernel tuning for database workloadsNetworking: Understanding of connectivity issues, deadlocks, and blocking in distributed database systems.Proficiency in SQL and OS-level scripting (Python, Bash) for automation.Infrastructure: Hands-on experience with Docker and Kubernetes (K8s), Containerized application deployment concepts, Configuration, scaling, and environment management awarenessCaching Technologies: Experience managing data storage/caching with Redis or Memcached. Tooling: Familiarity with Git, Maven/Gradle, and CI/CD tools like (ArgoCD, Jenkins, Artifactory, DevSecOps), Source control, branching strategies, merge requests, CI/CD pipeline configuration and automated deployments, Environment-based deployments and rollback strategiesExperience with AWS, Azure, or Google Cloud Platform services.Understanding of distributed tracing, audit and logging. Agile and Collaboration Tools: Sprint planning, work item tracking, and agile delivery, Technical documentation and knowledge sharingSoft SkillsStrong problem-solving and analytical skillsClear communication with technical and non‑technical stakeholdersOwnership mindset and production‑grade engineering disciplineAbility to work independently and within cross‑functional teams