The MySQL DBA will manage and optimize MySQL databases, ensuring performance, security, and availability. Responsibilities include installation, monitoring, backups, disaster recovery, and collaboration with developers for query optimization.
SUMMARY:
The MySQL DBA will be responsible for ensuring the performance, integrity, and security of our MySQL databases. This role involves planning and developing databases as well as troubleshooting any issues on behalf of the users. Your primary objective is to maintain the availability and consistent performance of our databases.
We are looking for candidates who are as excited about pushing their own development and working on a geographically distributed team where most of the communication is happening online.
WHAT WILL YOU BE DOING:
- Installing, configuring, and upgrading MySQL server software and related products.
- Monitoring database performance, implementing changes, and applying new patches and versions when required.
- Ensuring the security and integrity of databases, including creating and managing users, roles, and permissions.
- Performing regular backups and recovery operations.
- Developing and maintaining database standards, documentation, and procedures.
- Conducting database tuning and performance monitoring.
- Designing and implementing disaster recovery plans.
- Providing 24/7 support for critical production systems.
- Collaborating with developers to design and optimise SQL queries.
- Troubleshooting database-related issues and providing timely solutions.
- Implementing and managing database replication and clustering.
- Conducting data migrations and ETL processes.
WHAT WE ARE LOOKING FOR:
- 6+ years as a MySQL DBA or in a similar role.
- Bachelor's degree in Computer Science or a related field.
- In-depth knowledge of MySQL database management.
- Proficiency in database design, backup/restore, performance tuning, and replication.
- Strong SQL and database scripting skills.
- Familiarity with Linux/Unix operating systems.
- Understanding of database security management and data protection principles.
- Experience with both On-Premise and Cloud database solutions (e.g., Oracle Cloud Infrastructure, AWS RDS, Google Cloud SQL).
- Ability to work in high-demand and high-availability system environments.
- Familiarity with database replication and clustering using Galera Cluster.
- Experience with MariaDB.
- Knowledge of ProxySQL and/or other load-balancing technologies
- Knowledge of MySQL High availability setup and management
- Hands-on with database monitoring tools such as Percona, PRTG, MySQL Enterprise Monitor, etc.
- Excellent problem-solving and analytical abilities.
- Ability to work independently and as part of a team.
- Proficient in English communication, both written and verbal.
AWESOME BUT NOT REQUIRED:
- Certifications such as Oracle MySQL Database Administrator, MySQL Developer, or equivalent.
- Knowledge of other database systems (e.g., PostgreSQL, MongoDB) is a plus.
WHAT’S IN IT FOR YOU?
- Be part of our collegial environment where responsibility and authority are shared equally amongst colleagues and help create our company culture
- A culture in which we don’t criticise failure but ensure we learn from our mistakes
- An Agile environment where your ideas are welcome
- The possibility to grow and experience different projects
- Ongoing Training & Mentoring
- The possibility of travel
- ATTENTION! THIS POSITION IS FOR PORTUGAL OR BRAZIL BASED ONLY
Top Skills
MySQL
SQL
Similar Jobs
As a Database Administrator - MySQL Specialist, you will manage and enhance the existing and new database infrastructure, monitor and adjust database capacity, automate deployments, and facilitate database setups for new regions while documenting processes and responsibilities.
Be an Early Applicant
As a Database Administrator for this remote role, you will manage and take ownership of the database infrastructure, monitor queries, automate deployments using Terraform, develop dashboards, and facilitate database management for expansions into new regions, all within a dynamic online gaming environment.
Be an Early Applicant
Lead the development and delivery of end-to-end data and analytics solutions for insurance business functions, focusing on claims, customer engagement, and risk management. Collaborate with business and tech teams to create scalable AI solutions, manage the product life cycle, and mentor team members.
What you need to know about the Kolkata Tech Scene
When considering the industries shaping India's tech scene, gaming might not immediately come to mind. However, in the last decade, increased internet usage and greater access to mobile devices have catapulted the industry to new heights, with Kolkata-based companies like Virtualinfocom, Red Apple Technologies and Digitoonz, at the forefront, driving the design and animation of new gaming titles for players.
