Database Administrator (MySQL)
Job title: MySQL Database Administrator
Location: Indore(Onsite)
Experience: 5+ years
About the role:
India’s leading Educational ERP Software company, a Deloitte Fast 50 Company and ET Growth Champion Serosoft is looking for an experienced database analyst for our dynamic. The ideal candidate will have 5-10 years of relevant experience as a MySQL DBA who will be responsible for ensuring the Performance, Database Tuning, Database Clean-up, Database Migration, Database Availability, and Security of Clusters of MySQL Instances. The candidate will also be responsible for Orchestrating Upgrades, Backups, and Provisioning of Database Instances. The candidate will also work in tandem with the other teams, documentation, and specifications as required.
Responsibilities:
- Provision MySQL instances, both in Clustered and Non-Clustered Configurations.
- Ensuring the Performance, Database Tuning, Database Availability, and Security of Clusters of MySQL Instances.
- Development of Database Schema.
- Development of ERD.
- Find the Root Cause of Database related issues & Database Clean-up.
- Migrating Data from Customer Database to Serosoft Product Database.
- Prepare Documentation and Specifications.
- Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
- Profile server resource usage, optimize and tweak as necessary.
- Collaborate with other team members and stakeholders.
Skills and Qualifications:
- Strong proficiency in MySQL database management.
- Decent experience with recent versions of MySQL.
- Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM.
- Experience with replication configuration in MySQL.
- Proficient in Database Clean-up and Migrations.
- Knowledge of De-Facto Standards and Best Practices in MySQL.
- Proficient in Writing and Optimizing SQL statements.
- Proficient in Table Scan, Row Scan, Query Execution Plan, SQL Profiler, etc.
- Should be able to decide when to create Views (Standard Views, Indexed views, and Partitioned views).
- Knowledge of MySQL features, such as its Event Scheduler.
- Ability to plan Resource requirements from High-Level Specifications.
- Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, etc.
- Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases.
- Proficient understanding of code versioning tools such as SVN / Git.
- DBA Certification would be an added advantage.