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.
