MYSQL Database Administrator Infrastructure

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., * Infrastructure 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 service
• Security & 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 downtime

• Deep 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 required
• OS Knowledge: Strong experience managing MySQL on Linux/Unix environments, including kernel tuning for database workloads
• Networking: 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 awareness
• Caching 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 strategies
• Experience 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 sharing

Soft Skills

• Strong problem-solving and analytical skills
• Clear communication with technical and non-technical stakeholders
• Ownership mindset and production-grade engineering discipline
• Ability to work independently and within cross-functional teams

Next Gen Software Solutions is a trusted provider of IT Staffing and consulting services dedicated to empowering businesses with cutting-edge technology solutions and exceptional talent. We specialize in delivering tailored IT consulting services, innovative software solutions, and connecting businesses with highly skilled IT professionals. Founded and led by a dedicated U.S. Army solider, Next Gen Software Solutions is deeply rooted in the core values of integrity, discipline, commitment, and experience-principles that guide every aspect of our operations., Next Gen Software Solutions is a trusted provider of IT staffing and consulting services dedicated to empowering businesses with cutting-edge technology solutions and exceptional talent. We specialize in delivering tailored IT consulting services, innovative software solutions, and connecting businesses with highly skilled IT professionals. Founded and led by a dedicated U.S. Army soldier, Next Gen Software Solutions is deeply rooted in the core values of integrity, discipline, commitment, and excellence-principles that guide every aspect of our operations.