MYSQL Database Administrator Infrastructure

Role: MYSQL Database Administrator Infrastructure

Locations: Berkeley Heights NJ (5 Days Onsite)

Duration: Long term

Employment Type: Contract W2

Job 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 Responsibilities

• 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

Mandatory Technical Skills & Competencies

• 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 GCP) 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 GCP 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

About Next Gen Software Solutions LLC:

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.

Equal Employment Opportunity Statement:

Next Gen Software Solutions LLC is an Equal Opportunity Employer. We are committed to fostering an inclusive and diverse workplace where all employees and applicants are treated respect and dignity. We do not discriminate based on race colour religion sex (including pregnancy sexual orientation or gender identity) national origin age genetic information veteran status or any other legally protected characteristic under applicable federal state or local laws.