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.