Oracle Database Administrator (DBA)

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.

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.

See also