Oracle Database Administrator (DBA)
Job Scope:
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.