1. Setting up, testing new database server and handling systems on premise and cloud as AWS, RDS, Oracle Cloud
- Provide database environment for Test/Dev/Production and hardening
- Implement database change follow CR process and security policy.
- Implement and manage database platform on Cloud system.
- Handover new database system
- Consolidate database systems into Database farm.
2. Execute DBA operation checklist and resolve database requests
- Resolve requests/issues within a timely manner against SLA/OLA requirements
- Implement backup procedure.
3. Responsible for the database performance, housekeeping tasks, integrity, and security of database. Work closely with the System Analysts and DevOps Teams, AM/PM to assist in database related duties
- Database is stable and has good performance
- Inform Services Owner (SO) Top Module/Poor SQL query impacted to database performance.
- Fix security vulnerabilities following security procedure
- Provide technical advice, support to DevOps Teams and Projects.
4. Participate in written/update database procedure documents
- Database operation document updated.
5. Proposing cost-effective solutions, optimization, and stability
- Database services performance improvement
- Saving cost (storage, outsource…)
6. Review database changes/ all related documents for DevOps applications in charge
- Make sure Database align IT strategy, architecture, and security policy
- Reduce risk, occur happen by Change request.
- Handover database system.
Educational Qualifications
- A bachelor's degree in information technology or computer science or related field of study: or equivalent education, training by Oracle/Microsoft/MongoDB & experiences
Relevant Knowledge/ Expertise
- Experience with Oracle, MSSQL And/Or MySQL Database And/Or XML/Mongo/NoSQL technology
- Extensive experience in BigData, Oracle Golden Gate, DataGuard, Database design.
- Extensive experience in Oracle database on cloud
- Knowledge of OS as Windows Server, Linux, AIX
- Experience with T24/Way4/Core Banking applications
- Experience with migrations and upgrades
- SQL tuning and database performance assessments
- Source code control (Git, SVN, etc)
Relevant Experience
- 5+ years of database experience (Oracle/MSSQL and/or MySQL, NoSQL Redis/MongoDB, PostgreSQL), in addition to educational requirements
- Have experience in Cloud platform, NoSQL system management (Redis, Elastisearch, MongoDB/noSQL system)
- Good at 'relational database management systems' (RDBMS), 'object oriented database management systems' (OODBMS) and XML/NoSQL database management systems
- Database Performance Tuning/Troubleshooting
- Ensuring availability as HA, DC/DR (Active-Active, Active/Passive)
- Backups and Disaster Recovery