Responsibilities and Requirements
- Strong proficiency in MariaDB or MySQL database management
- Minimum 4 years of experience in MariaDB or MySQL database administration
- Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM
- Experience setting up Master-Slave replication, Multi-Master replication, backup, point in time recovery, high available configurations and disaster recovery in a complex and dynamic production environment
- Provision MariaDB or MySQL instances
- Ensure performance, security, and availability of databases
- Prepare documentations and specifications
- Collaborate with other team members and stakeholders
- Knowledge of de-facto standards and best practices in MySQL or MariaDB
- Proficient in writing and optimizing SQL statements Proficient writing Linux shell scripts for maintenance and automation purposes
- Strong communication skills and ability to add recommendations on architecture/design decisions that will ensure optimal application performance with MySQL/MariaDB
- Position requires the ability to work various work schedules that support a 24x7 coverage may include nights, weekends and holidays Familiarity with other databases such as PostgreSQL/EDB, MS SQL will be an added advantage
- Knowledge of limitations in MySQL/MariaDB and their workarounds in contrast to other popular relational databases
- Highly coachable and willingness to learn
- Basic knowledge of Linux operating system (RedHat) and basic commands
- Should be a good team player
- Maintaining production, UAT and dev databases without outage