Performance Tuning Expert (Mariadb-Mysql)

Position: Nutanix RE (Database) / Performance Tuning Expert

We are looking a candidate who has expertise in MySQL or Maria DB

• Total Experience: 4 to 8 Years
• Duration: 6 Months + extendable
• Work Location: Jakarta, Indonesia

Key Considerations

Perform assessment and consultative approach for the whole stack solution provided by the ISV, starting from infrastructure, databases up to the application layer.

 The candidate should have good understanding in application framework and app architecture as well.

 The candidate should have good understanding in database operations and infrastructure.

Job Responsibilities

Evaluate the provisioned instances of MariaDB instances, both in clustered and non-clustered configurations and check if optimal MariaDB instances have been created.

 Perform Database Performance Tuning for MariaDB using Several9s tool

 Should be well versed with activities like – setting up disk I/O scheduler, concepts of open file limits, Linux swap limits, filesystem optimizations for MariaDB etc.

 Ensure performance, security, and availability of databases

 Perform database administration tasks, including automation, performance monitoring and tuning, and query optimization.

 Prepare documentations and specifications

 Should be aware of common database procedures, such as upgrade, backup, recovery, migration, etc.

 Collaborate with other team members and stakeholders Proficiency Required Strong proficiency in MariaDB/ MySQL database management with recent versions

 Experience with replication configuration (Master slave, Master-Master).

 Create and Manage users with proper permissions.

 Drive performance tuning, Query Tuning and monitoring the performance using tools.

 Tuning servers configurations as per the workload.

 Demonstrated ability to implement High Availability, Work Load Management and Fail Over, Disaster recovery using Nutanix.

 Ability to plan resource requirements from high level specifications.

 Knowledge of limitations in MariaDB/MySQL and their workarounds in contrast to other popular relational databases.

 Hands-on experience in working in Linux Environment