Logo
Omni Inclusive

MySQL DBA

Omni Inclusive, Austin, Texas, us, 78716

Save Job

MySQL DBA profiles with 7+ years of Experience, to manage, optimize, and ensure the reliability of MySQL database systems. Responsible for database design, implementation, monitoring, and maintenance, ensuring high performance, availability, and security

Skills Requirements: • Proven experience as a MySQL DBA in production environments. • Expertise in SQL performance tuning, Query optimization and code/script optimization and other optimization tools and techniques. • Proficient in designing and creating database objects, such as data table structures, stored procedures, views, triggers reports, database administration, configuration, maintenance and support. • Hands-on experience with MySQL replication (Master-Slave, Master-Master, GTID, etc.). • Familiarity with backup and recovery tools (mysqldump, Percona XtraBackup, etc.). • Experience with cloud-based database solutions (AWS RDS, Azure Database for MySQL, Google Cloud SQL). • Knowledge of monitoring tools such as Prometheus, Grafana, Percona Monitoring and Management (PMM), or Nagios. • Familiarity with Linux operating systems and command-line tools. • Excellent analytical, problem-solving, and communication skills. • Understanding of database security best practices.

Key Responsibilities: • Install, configure, and manage MySQL databases on-premises and in cloud environments. • Monitor database performance, identify bottlenecks, and optimize queries, indexing, and storage engines. • Implement security best practices, manage access controls, and ensure compliance with data protection regulations. • Design and implement backup and disaster recovery strategies to ensure data integrity and availability. • Configure replication, clustering, and failover mechanisms for high availability and scalability. • Diagnose and resolve database-related issues, ensuring minimal downtime. • Develop scripts for automation of routine database tasks using SQL, Python, or Shell scripting. • Monitor database growth and plan for scalability and future storage needs. • Work closely with developers, system administrators, and DevOps teams to optimize database integration and performance. • Collaborate with developers to design and implement database structures. • Maintain documentation of database configurations, schemas and procedures. • Plan and execute database migrations and upgrades. • Ensure maximum uptime according to the SLA. • Implementing new technologies and design changes. • Improves and maintains customer and employee satisfaction.