MySQL DBA

Tekgence Inc; Englewood (NJ); On-site; USD 140,000 - 190,000; Full time

Job summary

Tekgence Inc. seeks an experienced database administrator to install, configure, and optimize MySQL, PostgreSQL, and Redis across on-premises and AWS environments. You will design schemas, optimize queries, implement high availability, and automate tasks with Ansible and Python.

Expect collaboration with DevSecOps and development teams, on-call duties, and a focus on reliability and performance. The role requires local candidates to NY/NJ for in-person interviews and onsite work in New Jersey.

Qualifications

• 12+ years of database experience in enterprise environments.
• Expertise with MySQL, PostgreSQL, and Redis.
• Experience with on-premises and AWS cloud deployments.
• Strong SQL optimization and schema design skills.
• Ability to automate DBA tasks with Ansible and Python.
• On-call rotation and incident response experience.
• Ability to work with DevSecOps and infrastructure teams.

Responsibilities

• Install, configure, upgrade, patch, and maintain MySQL, PostgreSQL, and Redis databases across on-premises and AWS environments.
• Manage and optimize MySQL database performance, including query optimization and indexing strategies.
• Develop and maintain MySQL replication and high-availability solutions.
• Automate routine database administration tasks using Ansible and AWS CloudFormation.
• Collaborate with application developers to design efficient database schemas and improve interaction.
• Monitor and troubleshoot database health, performance, and availability across environments.

Skills

MySQL tuning

Query optimization

Linux administration

Incident management

DevOps coordination

Performance monitoring

Tools

Ansible

AWS CloudFormation

Datadog

MONyog

PMM

Python

Job description

Job Duration: 12+ Months

Experience: 12+ Years

Interview: F2F (In-person)

Note: We need only Local candidate to NY/NJ who can attend the FtoF interview

Role Overview

• Install, configure, upgrade, patch, and maintain MySQL, PostgreSQL, and Redis databases across on-premises and AWS environments.
• Perform database schema management, including schema design, table structures, indexing, partitioning, and optimization.
• Manage and optimize MySQL database performance, including query optimization, indexing strategies, execution plans, and database configuration.
• Develop and maintain MySQL replication solutions based on application requirements to provide high availability and disaster recovery.
• Configure and manage database high-availability solutions and ensure database services meet availability and reliability requirements.
• Administer AWS database and infrastructure services including Amazon RDS, Aurora, ElastiCache, DynamoDB, S3, and EC2.
• Monitor database health, performance, availability, capacity, and resource utilization across development, test, and production environments.
• Implement monitoring and alerting using AWS CloudWatch, PMM, Datadog, and MONyog.
• Proactively identify database performance bottlenecks and implement appropriate optimization and remediation strategies.
• Perform daily database maintenance, health checks, housekeeping, capacity planning, and database health assessments.
• Troubleshoot database, operating system, connectivity, replication, performance, and availability issues.
• Work closely with application developers to design efficient database schemas and improve application/database interaction.
• Analyze and optimize complex SQL queries to improve database performance and application response times.
• Apply database performance-tuning techniques based on workload, resource utilization, query behavior, and MySQL configuration.
• Demonstrate strong understanding of MySQL internals and storage engines.
• Develop and maintain comprehensive backup and recovery strategies for critical databases.
• Perform database recovery operations and restoration activities while ensuring data integrity and minimizing data loss.
• Develop and maintain disaster recovery (DR) procedures and participate in DR testing and validation.
• Ensure appropriate Recovery Point Objective (RPO) and Recovery Time Objective (RTO) requirements are supported.
• Automate routine database administration and infrastructure tasks using Ansible and AWS CloudFormation.
• Develop shell scripts and/or Python scripts to automate database monitoring, maintenance, deployment, backup, and operational activities.
• Work closely with DevSecOps teams to ensure timely application of database security patches, upgrades, and configuration changes.
• Follow database security best practices and maintain secure database configurations across environments.
• Perform database version upgrades, patching, migration, and maintenance activities with minimal production impact.
• Support database environments running in both on-premises data centers and AWS cloud environments.
• Work with Linux administrators and infrastructure teams to troubleshoot database server and operating-system-level issues.
• Perform Linux administration and troubleshooting, including resource utilization, processes, file systems, networking, permissions, and system performance.
• Participate in production incident management and provide L2/L3 database support.
• Participate in an on-call rotation to support critical production database incidents and service interruptions.
• Investigate production incidents, perform root-cause analysis, and implement permanent corrective actions.
• Generate ad-hoc database reports and provide data-related insights to internal teams and stakeholders.
• Collaborate with application, infrastructure, DevOps, DevSecOps, and engineering teams to resolve database-related issues.
• Maintain technical documentation covering database configurations, operational procedures, recovery processes, replication, monitoring, and troubleshooting.
• Ensure database environments are reliable, scalable, highly available, secure, and optimized for application workloads.
• Work onsite in New Jersey and collaborate effectively with technical and business teams.