Job Description
Employment Type : Permanent
Benefits : AWS & VB
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 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.
