Associate engineer (MySQL admin) at NielsenIQ

NielsenIQ

Chennai, TN, in·1w ago

SeniorFull-timeMySQL

Salary Range

$26,520 - $35,880 /year

Estimated

This salary is estimated based on similar roles. The actual salary may vary.

About the Role

We are looking for a skilled MySQL Database Administrator to support mission-critical systems in a 24/7 environment. This role involves maintaining performance, availability, and security of MySQL environments across development, QA, and production.

Key Responsibilities

→Provision, configure, and maintain MySQL database instances in clustered and non-clustered environments.
→Ensure high levels of performance, security, and availability across all MySQL databases.
→Perform routine DBA tasks such as upgrades, backups, restorations, migrations, and recovery.
→Monitor database systems for performance bottlenecks, slow queries, locking issues, and implement optimizations.
→Support and manage MySQL databases for Production, QA, and Development environments.
→Conduct performance tuning, query optimization, and index refinement.
→Manage MySQL Replication setups including Master-Slave and Master-Master configurations.
→Implement and maintain MySQL Enterprise tools including Audit, Backup, and Monitoring.
→Work with INNODB and NDB cluster technologies as needed.
→Ensure proactive monitoring of MySQL database systems with minimal downtime.
→Cross-Functional Collaboration
→Work closely with development and infrastructure teams to troubleshoot and fine-tune performance issues.
→Assist developers with query tuning, schema design refinements, and review of database-related changes.
→Operations & Automation
→Analyze, troubleshoot, and quickly resolve real-time production issues ensuring system stability.
→Automate recurring tasks and enhance processes to improve operational efficiency.
→Maintain versioned documentation of configuration changes, workflows, and database procedures.
→MSSQL (Basic Administration)
→Perform basic MSSQL DBA tasks such as monitoring SQL Server health, managing backups and restores, supporting schema updates and query execution, and troubleshooting common issues.
→Provide foundational support for MSSQL instances alongside MySQL activities.