Lead MY SQL DBA

In this role, you will be instrumental in maintaining and optimizing our database systems and Linux environments to ensure operational excellence and high performance. You will be responsible for database management, troubleshooting, and resolving issues that may arise in our SQL environments, as well as managing and configuring our Linux servers. The ideal candidate will have a solid understanding of SQL Server and Linux administration, along with a proven track record of managing databases in a production environment. You will work closely with developers and other IT staff to provide support for database-related requests and ensure seamless operation across our platforms. This position requires someone who is proactive and detail-oriented, as maintaining data integrity and security will be a top priority. You will also have the opportunity to implement automation and optimization strategies to improve performance and reduce downtime, making your role key to our overall IT strategy. If you are passionate about technology and eager to take on new challenges, we encourage you to apply and contribute to our mission of delivering outstanding services to our clients.

MySQL Database Administration:

Deploy, configure, and manage MySQL database servers in high availability environments, ensuring optimal performance and reliability.

Implement database schema, indexing strategies, and partitioning to optimize query performance and enhance scalability.

Develop and maintain database backup and recovery procedures, including regular backups, point-in-time recovery, and disaster recovery planning.

Perform database performance tuning and optimization, including query optimization, resource utilization analysis, and database cache management.

Monitor database health and performance metrics, identify bottlenecks, and implement corrective actions to ensure optimal database performance.

Implement and manage database security measures, including user access controls, authentication mechanisms, and data encryption.

Collaborate with application developers to troubleshoot database-related issues and optimize database queries for improved application performance.

Provide expert support for Applications databases in the development and test environments.

Work with Application developers and their logical data models, create physical Application database designs which conform to industry standards (e.g., data normalization), optimize performance, and efficiently utilize disk space, size tables, and indexes for production implementation based on projected row counts provided by Applications.

Create complex new databases and Application database objects (e.g., tables, indexes, procedures), and as requirements change, update data structures/objects in existing databases.

Coordinate production database deployment including tasks to promote database objects between environments (e.g., test to production) in support of Application requirements.

Provide technical leadership to Application developers in database capabilities and features, build efficient queries, database design, Application database Problem Resolution, and the use of database utilities.

Determine and implement appropriate Application database backup and recovery strategies, including decisions regarding frequency of backup and procedures for recovering Application database changes.

Perform production database recovery when necessary.

Qualifications:

- Bachelor's degree in computer science, Information Technology, or a related field.

 10+ years of hands-on experience in SQL/MySQL database administration.

- Strong analytical and problem-solving skills, with the ability to think critically and strategically.

- Excellent communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams and stakeholders.