Job Description
• Provide Ms. SQL server and Oracle database services to users like Start/Stop and monitor database services for 24/7 service running in DC and replication or active for database recovery at DR site, Restore and Backup data for user request environments;
• Support IT Operation for problem troubleshooting the root cause when thing goes wrong during daytime and Core Banking System Close of Business (COB) process by database service;
• Ensuring of no unauthorized user access to databases by Creating, Deleting, Granting and Revoking of database user privilege, Regular Maintain and review user matrix of databases with sign-off;
• Data consistency check, test and deploy the updated security patches;
• Performance analysis including system resource management, indexing, configurations, and tuning-up;
• Request support from vendors to get solution, recommendation for the best performance and stabilization CBS and other databases running;
• Regular archive history data, resize database, monitoring database services, log files, storage size, and other routine works of Oracle and Ms. SQL Server;
• Trace and report the statistic increase of Oracle database, storage capacity planning to support data growth in 3 to 5 years, and provide storage hardware sizing for budgeting;
• Daily review backup and restore database and allocate to the defined places;
• Mastering on the database upgrade and data migration projects;
• Involving in the application projects to support the database setup, configurations, user creations;
• Be able to setup Ms. SQL Server and Oracle 12c clustering and disaster recovery active - active or active standby as preferable;
• Develop, document and implement T24 backup, restoration and recovery procedures and processes, ensuring proper scheduling, verification, cycles, media, retention, log, copies and storage have been applied.
Job Requirement
• Degree in Information Technology or Computer Science or related fields;
• Minimum 2 years’ experiences in database design, scripting programming and administrator supporting sophisticated critical environments;
• Experience in T24 database system administration, enterprise consoles, scheduling tools, JBASE;
• Knowledgeable in Microsoft SQL Server 2008 R2, Oracle Database 11c or later version;
• Good verbal and written communication in both Khmer and English.