Responsibilities
Designing, planning and implementation of new Database Servers, including Oracle, MS SQL Server.
Develop and maintain automation scripts for daily operations, including database level backup and restore.
Implement monitoring solutions for databases.
Operate databases ensuring that systems are running optimally ensuring availability, efficiency, and recoverability.
Work with the oversea DBA team to ensure the security and privacy policy and daily DB operations follows best practices for all applications database managed.
Troubleshoot database related issues, support incidents and changes.
Perform Root Cause Analysis for incidents & provide remediation plan to functional teams.
Perform database migrations to new systems and new software releases, and from IDC to Cloud environment.
Work with multiple database servers and complex database environments, including MySQL, PostgreSQL
Acts as an expert technical resource to development team in all phases of the development and implementation process.
Requirements
Understanding of database design, installation and configuration, database monitoring tools and disaster recovery solutions
Expertise in managing Oracle 12c,19c on Unix platforms and MS SQL Server on Windows
Familiar with Oracle management tools like SQL Developer, or OEM, or Toad etc.
Familiar with SQL Server tools like Configuration Manager
Expertise in Database backup and restore utilities like RMAN.
Experience in Restoration of high severity incidents
Should be able to automate programs using Shell scripting, PL/SQL
Should be able to troubleshoot using basic Unix commands.
Expertise in database performance management, tuning, mirroring, and replication
Expertise in Database Security
Be able to identify route cause for incidents & provide remediation plan to functional teams.
Be able to identify improvement opportunities in the env & handover to the functional teams.
Have experience in Ali Cloud and Azure Database Management MySQL, PostgreSQL is a plus.
Have experience in Data Platform related project is a plus.
Fluent Chinese and English Communication
Soft Skills Required
Attention to Detail
Possess a keen interest within database technologies by understanding new current/forthcoming versions, including Oracle, MS SQL, MySQL, Cloud PAAS DB including MySQL, PostgreSQL
Skill in using analytics, logic and reasoning to troubleshoot issues and find the best solutions to overcome challenges.
Must have a passion for providing excellent support to all types of users as well as impeccable verbal and written communication skills.
Must possess organizational proficiencies to multitask and work in a fast-paced environment with minimum supervision.
Must be a team player and have the ability to interact with multiple levels of personnel within the organization.
Qualifications
Bachelor's degree in computer science, information system or equivalent experience
Certification in OCM, OCP, MCTS, MCITP, PostgreSQL would be an advantage.
ITIL certified will be added advantage.