Fortified Data ยท 6 days ago
MySQL DBA - REMOTE (US Based Only)
United States
Full-time
Remote
Mid Level
3+ years expFortified Data is a fast-growing, fully remote database services company helping organizations worldwide optimize their most critical data environments. The MySQL DBA will be responsible for effectively designing, managing, and supporting MySQL database systems for clients, ensuring their stability, reliability, and performance.
Information Technology & Services
Responsibilities
Manage priority of inbound support requests
Respond to client issues within targeted response times specified in SLA (service level agreement)
Resolve database integrity issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues, and security issues specific to MySQL
Communicate ticket status with team members and clients
Document in detail the resolution of each issue within our Ticket Management System
Enter time spent with clients in real-time
Be an escalation point during critical client events as part of a 24 x 7 team
Plan and perform the installation of MySQL Database application software, patches, and services packs
Proactive database monitoring and maintenance for MySQL databases
Ensure the integrity and security of client MySQL databases
Consolidate and tune MySQL databases for optimal performance
Perform 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 related activities
Perform root cause analysis, document, and present findings to clients for MySQL-related issues
Update internal processes and support documentation related 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
Qualification
Required
3-5 years of MySQL Database Administration experience
MySQL versions 5.7, 8.0, and 8.4 (or later)
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, Percona XtraBackup, or MySQL Enterprise 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 engine, buffer pool management, and locking mechanisms
Effective utilization of Performance Schema, MySQL Enterprise Monitor, or third-party monitoring tools (Prometheus, Grafana, Zabbix)
Implementation of MySQL security models including authentication, authorization, and encryption at rest and in transit
Understanding of ACID principles and transaction management
Intermediate knowledge of Linux and Windows Server operating systems
Basic understanding of network configurations, subnets, and firewalls
Customer Service: Listens and responds effectively to customer questions; resolves customer problems to the customer's satisfaction
Ability to Multi-Task: Proven ability to manage multiple issues and/or projects successfully bringing them all to resolution in a timely manner
Problem Solving: Anticipates problems, recognizes and accurately evaluates the signs of a problem and analyzes current procedures for possible improvements
Detail Oriented: Thoroughness in accomplishing a task through concern for all the areas involved, no matter how small
Automation / Tools: Proficient in use of all Microsoft Office software applications including Outlook, Word, PowerPoint, and Excel
Preferred
1+ years PostgreSQL administration experience including installation, configuration, and basic performance tuning
Python, Bash, or Shell scripting for database automation
Prior experience with a Managed Services Provider
Demonstrated experience with data extraction, manipulation, and ETL processes
Working knowledge of cloud-based database services (AWS RDS/Aurora, Google Cloud SQL, or Azure Database for MySQL)
Experience with containerized databases (Docker, 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 Oracle or PostgreSQL database administration experience (bonus but not required)
1+ years MS SQL Server database administration experience (bonus but not required)
Company
Fortified Data
For over a decade, Fortified Data has provided superior managed services and database maintenance to clients and partners all around the world.
11-50 employees
Funding
Current Stage
Early StageLeadership Team
Mark Abrahm
Chief Financial Officer
Chad Timms
Chief Operating Officer
Company data provided by crunchbase