MySQL DBA

$100,000 - $100,000/Yr

Wise Equation Solutions - Cedar Park, TX

Full-time - Mid Level

Cedar Park, TX

Professional, Scientific, and Technical Services

About the position

As a MySQL Database Administrator (DBA) at Wise Equation Solutions, you will play a critical role in supporting and maintaining MySQL databases across both production and non-production environments. Your responsibilities will include installing, configuring, monitoring, upgrading, and ensuring the overall health of the database systems. You will be part of an on-call rotation that provides 24/7 support, ensuring that any issues are addressed promptly to maintain system availability and performance. In this position, you will be involved in backup and restore tasks, responding to requests for data recovery, and rebuilding servers using shell scripts in the event of data loss. You will also work on setting up replication and clustering based on application tier levels, providing technical expertise and hands-on support during consolidation and migration processes. Your role will require you to implement router installations for InnoDB cluster setups and manage bi-directional setups as needed. You will support failover processes both locally and across data centers, depending on the application environments. Additionally, you will implement DBA tools to enhance task effectiveness, focusing on performance tuning and recovery strategies. Modifying database structures based on input from application developers will also be part of your responsibilities. Daily tasks will include user and schema creation, query tuning, addressing deadlock issues, and monitoring file system alerts. You will manage tickets, change requests, and daily ITDR activities, collaborating with infrastructure engineering, business operations, and technical operations teams to deliver database services that meet established SLAs and targets. Your expertise will be crucial in resolving replication, cluster, router, and lock issues at the application tier level.

Responsibilities

• Support database technology installation, configuration, monitoring, upgrading, and maintenance of MySQL databases in production and non-production environments.
• Participate in on-call rotation providing 24/7 support to systems.
• Perform backup and restore tasks upon request and rebuild servers using shell scripts in case of data loss.
• Work on replication setups and cluster setups based on application tier levels, providing technical expertise and hands-on support for consolidation and migrations.
• Implement router installations for InnoDB cluster setups and bi-directional setups.
• Support local and across data center failover based on application environments.
• Implement DBA tools to improve task effectiveness, including performance tuning and recovery.
• Modify database structures as necessary based on information from application developers.
• Manage tickets, change requests, daily ticket queues, ITDR activities, and application releases.
• Collaborate with infrastructure engineering, business operations, and technical operations to deliver database services within SLAs and targets.
• Handle day-to-day tasks such as user creation, schema creation, query tuning, and addressing deadlock issues and file system alerts.
• Resolve replication issues, cluster issues, router issues, and lock issues at the application tier level.

Requirements

• Bachelor's degree in computer science, computer information systems, information technology, relevant engineering (computer engineering, software engineering, electronic engineering, or related), or a combination of education and experience equating to the U.S. equivalent of a Bachelor's degree in one of the aforementioned subjects.

Benefits

• Competitive salary starting at $100,000+
• Full-time position with potential for career growth
• Opportunity to work in a dynamic and supportive environment