MySQL Database Administrator (01 Position at Head Office) Full-time Job
5 years ago - Banking / Financial Service / Insurance - Phnom Penh - 1,009 viewsRoles & Responsibilities:
We are looking for an experienced MySQL Database Manager who will be responsible for ensuring the performance, availability, and security of clusters of MySQL instances. You will also be responsible for orchestrating upgrades, backups, monitoring, and provisioning of database instances. You will also work with the other teams, preparing documentations and specifications as required. The basic roles and responsibilities of MySQL Database Administrator are included:
- Ensure performance, security, and availability of databases.
- Handle common database procedures, such as upgrade, backup, recovery, monitoring, migration and replication.
- Profile server resource usage, optimize and tweak as necessary.
- Provision MySQL instances, both in clustered and non-clustered configurations.
- Prepare documentations and specifications.
- Collaborate with other team members and stakeholders.
- Run daily check all logs to make sure DB is healthy and provide report to line manager.
- Involve in database design with web developer and suggest high performance of database structure and indexing correctly.
- Set up instance notification via email or SMS if any incident occur.
Job Requirements:
- Strong proficiency in MySQL database management.
- Able to configure the real-time monitoring of traffic at network entry level.
- Strong proficiency in SQL injection, brute force attacks and other types of database attacks.
- 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.
- Knowledge of de-factor standards and best practices in MySQL.
- Proficient in writing and optimizing SQL statements.
- 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 Git / SVN.
- Proactively on any incident issue may happen.
- Take ownership on assigned task and having high responsibility.
- Used to manage big data of application and be able to set up load balancing traffic.
- Required Linux commands.
How to Apply:
Interested and qualified applicants should submit only your updated covering letter and CV stating the position you apply for with current photo (4x6) through our E-mail: [email protected]
Note: For more vacancies please visit our website: www.ababank.com if the above job advertisement doesn’t meet your career goal.