Database Environment Management:
- Plan, implement, test, and maintain in-house database environments.
- Setup and configure database engines for development, testing, and production environments.
- Provide 24x7 support for day-to-day 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 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.