Role Description
This role is responsible to provide support in migrating, upgrading, configuring, troubleshooting and administering the Database Platforms in non-Production and Production environments. The incumbent also needs to ensure the platform adherence to IT compliance requirements.
Job Responsibilities
• Create new DB creations, database network configuration, determine/adhere to guidelines for database structures and file layout, review and enhance scripts and procedures, proper management of transaction and redo/archive logs
• Maintain regular database maintenance schedules
• Monitor backups, recovery and replication for successful completion
• Perform Disaster Recovery (DR) for all the critical systems and ensure successful rebuilt of Production or DR servers, if necessary
• Analyze and tune database performance, including SQL query optimization, indexing, and partitioning.
• Document daily checks and status update
• Report monthly on database size and DB Uptime and Performance
• Review, improve and document the database administration and operational guide on new or revised processes and procedures regularly
• Any other ad-hoc duties as required or assigned
Job Requirements
• Degree/diploma in Computer Science, Computing, Electrical Engineering or IT or equivalent
• Experience in system administration in enterprise Oracle database versions (e.g., Oracle 11g, 12c, 19c).
• Knowledge in Oracle Linux, database intrusion technologies are advantageous
• Strong understanding of SQL and PL/SQL programming.
• Familiarity with IT compliance standards such as CIS in a variety of technical environments, including Windows, Linux etc
• Strong analytical and problem-solving skills, combined with ability to provide quick resolution to problems.
• Effective verbal and written communication skills
Advantageous Experience/Skills/Certificates:
· Familiarity in shell scripting.
· Oracle Certified Professional (OCP) or Oracle Certified Master (OCM) in Oracle Database.
· Other relevant certifications in database management and administration.
