Sr. MySQL DBA
Job Responsibilities:
- Established as Product SME and/or established as specialist.
- Installation and configuration of database software and related products.
- Plan and implement Database backup and recovery and disaster recovery configurations.
- Adherence to well-defined change control and configuration management policies.
- Capacity planning & system-level architecture.
- OS/Storage/DB configuration and optimization.
- Database security checks and audits, including compliance-related reporting & controls.
- General database health checks.
- Working with DBMS vendor support (Oracle MySQL support, Percona etc.).
- Defining and maintaining quantitative SLAs and helping enhance current service levels.
- Physical data model/architecture, DML, DDL generation and maintenance.
- Responsible for recommending Architectural/Structural changes Database creation and configuration
- Maintenance (proactive, reactive and automated); both scheduled and unscheduled. Improve processes and procedures
- Complex application troubleshooting and repairs
- Reporting on state of databases
- Database tuning (proactive and reactive)
- Maintaining specialized environments such as log shipping, replication, cluster-based instances, etc.
- SOP (Std. Operating Procedure) definition & automation
- Responsible for setup and maintaining standards and best practices
- Documentation related to all Application DBA areas
- Development & utilization of detailed triage processes
- Detailed workload analysis
- Infrastructure advise and planning
- Disaster recovery/failover services
- Working with developers and third-party application owners to introduce managed changes into the production environment
- Design appropriate data architecture to enable access to and availability of structured data
- Managing database users and security/access control
- Contributes significant, new and innovative ideas to the DBA knowledge base
- Architect complex database solutions
- Configure and execute Percona toolkit utilities
- SQL Statement performance tuning/index recommendations. Able to write and tune complex SQL queries and assist the development team as required.
· Application tuning and load testing.
· Support Partition maintenance and replication processing
· Participate in application upgrade deployments.
· Participate in an On-call Rota
Required Skills:
· 5+ years’ experience with a bachelor’s degree
· Experience working within an IT Operations environment
· Experience of the full application life cycle
· Expert relational database knowledge, primarily in MySQL/MariaDB Server Administration and Performance Tuning
· In depth knowledge of Logical/Physical Database Design
· Ability to develop Unix Shell scripts and database SQL scripts. Familiarity with writing database DDL & DML statements
· Strong database administration
· Hands-on experience with Database performance tuning and familiar with database performance and diagnostic related features and tools
· Experience in Linux/Unix/ VMWare/Cloud/Apache/JBoss/PHP and Java
· Ability to use a wide variety of open source technologies and scripting languages
· Excellent written and verbal communication skills
· Ability to work independently
· Experience working in a fast-paced environment with ability to learn quickly
· Experience of working with application developers to create optimized queries
· Willingness to collaborate closely with the client and report details to the Operational System DBA team
- Rigorous attention to detail and thorough application of standards, set guidelines and best practices
Desired Skills:
· Experience troubleshooting enterprise infrastructure environments across Open Systems environments hosting critical client databases and applications.
· An understanding of Infrastructure technologies like Storage Area Networks and Networking.
· Additional preferred knowledge: VMware ESX, VSphere, Exchange, Cisco experience, Scripting, Public Cloud
· Amazon RDS, Aurora, Azure MySQL
· NoSQL
· Familiar with Percona Monitoring and Management tool
· Understanding and awareness of technology and an ability to learn and acquire new technologies as needed
· Knowledge of ITIL and process models
· Bachelor's degree and a minimum of 7 years of related experience; or equivalent work experience