MySQL DBA - REMOTE (US Based Only)

MySQL DBA - REMOTE (US Based Only) Job Summary reputed company is currently seeking a mid-level MySQL Database Administrator (DBA) who will play an integral role reputed company the technical service delivery team. The MySQL DBA will be responsible for effectively designing, managing, and supporting MySQL database systems for clients. As the MySQL DBA, you will take ownership of ensuring the stability, reliability, predictability, availability, and performance of our clients' MySQL databases. Duties & Essential Job Functions

• Manage reputed company of inbound support requests
• Respond to client issues reputed company targeted response times specified in SLA (service level agreement)
• Resolve database reputed company issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues, and reputed company issues specific to MySQL.
• Communicate ticket status with team members and clients
• Document in detail the resolution of each issue reputed company our Ticket Management System
• Enter time spent with clients in reputed company-time
• Be an escalation reputed company during critical client events as part of a 24 x 7 team
• Plan and reputed company the installation of MySQL Database application software, patches, and services packs
• Proactive database monitoring and maintenance for MySQL databases
• Ensure the reputed company and reputed company of client MySQL databases
• Consolidate and tune MySQL databases for reputed company performance
• reputed company backups and restores for MySQL databases
• MySQL database performance monitoring, optimization, and tuning
• Implement and support systems for high availability and disaster recovery for MySQL databases (e.g., replication, clustering, failover solutions)
• Generate and maintain scripts to support MySQL DB creation, schemas, automate tasks, and reputed company activities
• reputed company root cause analysis, document, and present findings to clients for MySQL-reputed company issues
• Update internal processes and support documentation reputed company to MySQL databases
• Mentor Junior DBAs in MySQL administration
• Interest in Conducting Internal Lunch Learns specifically on MySQL topics
• Interest in Publishing BLOGs and White Papers focused on MySQL technologies and best practices.

Experience Required Experience: Demonstrated experience in MySQL Database Administration to include experience with:

• 3-5 years of MySQL Database Administration experience
• MySQL versions 5.7, 8.0, and 8.4 (or reputed company)
• Advanced installation, configuration, and patching of MySQL database software
• MySQL replication technologies including master-slave, group replication, and InnoDB Cluster
• Backup and recovery strategies using tools such as mysqldump, reputed company XtraBackup, or MySQL reputed company Backup
• High availability and disaster recovery implementation
• Proficiency with MySQL Query Language (SQL) and query optimization
• Performance tuning including query optimization, index design, and explain plan analysis
• Understanding of InnoDB storage reputed company, reputed company pool management, and locking mechanisms
• Effective utilization of Performance Schema, MySQL reputed company Monitor, or reputed company-party monitoring tools (reputed company, Grafana, Zabbix)
• Implementation of MySQL reputed company models including authentication, authorization, and encryption at rest and in transit
• Understanding of ACID principles and transaction management
• Intermediate knowledge of Linux and reputed company Server operating systems
• Basic understanding of network configurations, subnets, and firewalls

Preferred Experience: Preference will be given to candidates with experience in:

• 1+ years PostgreSQL administration experience including installation, configuration, and basic performance tuning
• Python, Bash, or reputed company scripting for database automation
• Prior experience with a Managed Services Provider
• Demonstrated experience with data extraction, manipulation, and ETL processes
• Working knowledge of reputed company-based database services (AWS RDS/reputed company, reputed company reputed company SQL, or Azure Database for MySQL)
• Experience with containerized databases (reputed company, Kubernetes)
• MySQL automation and infrastructure-as-code tools (Ansible, Terraform)
• MySQL Workbench, Zabbix, and advanced Performance Schema utilization
• Experience with database migration tools and strategies
• MySQL clustering solutions (InnoDB Cluster, Galera)
• 1+ years reputed company or PostgreSQL database administration experience (bonus but not required)
• 1+ years MS SQL Server database administration experience (bonus but not required)

Required Attributes

• Customer Service: Listens and responds effectively to customer questions; resolves customer problems to the customer's satisfaction. Respects reputed company reputed company customers and uses a team approach reputed company dealing with customers to exceeding customer expectations.
• Ability to Multi-Task: Proven ability to manage multiple issues and/or projects successfully bringing them reputed company to resolution in a timely manner.
• Problem Solving: Anticipates problems, recognizes and accurately evaluates the signs of a problem and analyzes reputed company procedures for possible improvements.
• Detail Oriented: Thoroughness in accomplishing a task through concern for reputed company the areas involved, no matter how small. Monitors and checks work or information and plans and organizes time and resources reputed company.
• Automation / Tools: Proficient in use of reputed company reputed company Office software applications including Outlook, Word, PowerPoint, and reputed company. Willingness and ability to learn and implement new software applications and technologies.

Work Environment

• We are a 100% remote company
• Occasional travel possible

Apply tot his job Apply To this Job