Job Scope:
Database Environment Management:
- Plan implement test and maintain inhouse database environments.
- Setup and configure database engines for development testing and production environments.
- Provide 24x7 support for daytoday database activities ensuring speedy resolution or escalation of
- operational incidents/problems.
Monitoring and Optimization:
- Conduct proactive monitoring activities to prevent incidents and maximize database availability.
- Perform regular performance tuning of the database including table structure and index optimization.
- Develop and implement scripts for database task scheduling monitoring and maintenance.
Reporting and Analysis:
- Generate weekly reports on database status for analysis and forecasting usage including tablespace
- disk space and table rows.
- Utilize Oracle Enterprise Manager (OEM) 12c cloud for comprehensive monitoring and management.
Backup and Recovery:
- Manage database backup and restore operations to ensure data integrity and availability.
Requirements
Technical Skills:
- Proficiency in administrating Unix OS.
- Strong knowledge of Unix shell scripting.
- Experience with PL/SQL development.
- Familiarity with Oraclerelated tools and technologies.
- Experience using Oracle Data Guard with or without broker.
Certifications:
- Preferably hold OCA / OCP Certification (Oracle Certified Associate / Oracle Certified Professional) or equivalent.
Technical Skills: Proficiency in administrating Unix OS. Strong knowledge of Unix shell scripting. Experience with PL/SQL development. Familiarity with Oracle-related tools and technologies. Experience using Oracle Data Guard, with or without broker. Certifications: Preferably hold OCA / OCP Certification (Oracle Certified Associate / Oracle Certified Professional) or equivalent.
Education
Preferably hold OCA / OCP Certification (Oracle Certified Associate / Oracle Certified Professional) or equivalent.