MYSQL DBA

Skills

Description

Designs and maintains SQL queries and routines.
Collaborates with team members and business partners in defining, designing, developing and implementing technology solutions to improve business functions.
Analyzes user requirements and translates into database requirements and implements in database code.

Responsibilities

• Database Management: Install, configure, and maintain MySQL databases. Ensure high availability and performance of databases in production and development environments.
• Backup & Recovery: Utilize MySQL tools for regular database backups and restoration. Implement and manage backup schedules and procedures, ensuring the integrity of backup data.
• Query Optimization: Write complex MySQL queries, stored procedures, and functions for efficient data retrieval. Analyze and optimize queries to improve performance and minimize resource consumption.
• Database Security: Implement and manage database security policies, including user access control, encryption, and auditing.
• Performance Tuning: Continuously monitor database performance, optimize queries, indexes, and overall database configuration to enhance system performance.
• Troubleshooting: Proactively identify, diagnose, and resolve database issues, ensuring minimal downtime and service disruptions.
• Replication & Clustering: Set up and maintain MySQL replication and clustering configurations to ensure high availability and fault tolerance.
• Upgrade & Patching: Plan and execute MySQL database version upgrades, patches, and maintenance to ensure systems are up-to-date and secure.
• Documentation: Maintain detailed documentation for database environments, backup procedures, and troubleshooting steps.
• MySQL Query Expertise: Strong ability to write complex SQL queries, optimize query performance, and create stored procedures, triggers, and views to handle business logic and reporting requirements.
• MySQL Administration: In-depth knowledge of MySQL database architecture, tools, and techniques. Experience with tools such as mysqldump, MySQL Enterprise Backup, Percona XtraBackup, etc., for database backup and restore operations.
• Backup & Restore Techniques: Extensive experience with database backup and recovery strategies, including point-in-time recovery and high availability setups.
• Database Performance Tuning: Knowledge of indexing, query optimization, and techniques for ensuring optimal database performance and resource management.
• Replication & Clustering: Experience in configuring and managing MySQL replication (master-slave, master-master) and clustering solutions (such as MySQL NDB or Galera Cluster).
• Operating System Knowledge: Strong experience working with Linux/Unix environments and familiarity with shell scripting.
• Security Practices: Knowledge of MySQL security best practices including user authentication, roles, and privileges management.