Senior Database Administrator

Role Purpose:
-The Oracle Database Administrator (DBA) is accountable for availability, performance, costs, and risks related to all Oracle database services.

-The Database Administrator will provide enterprise-wide Oracle Database infrastructure support for complex system and interconnected technologies that require day-today support and administration in order to maintain optimum performance and utilization. Provide support in the following areas: Oracle Database 12c & 19c on Oracle Solaris 10, 11 and Linux platform.

Key Responsibilities:
-Acceptable level of performance of all DBs across organization
-Proactively support systems, analyze existing/potential issues happened with deep dive into rdbms and/or related sw (GI, ASM, os)
-Understand the layer b/w rdbms/asm and storage/os in order to be able to identify layer of performance glitches or small degradation
-Automation of BAU DBA tasks with sh/bash scripting
-Understanding core concepts of oracle optimizer, statistics, tracing related to performance
-PL SQL coding ability for admin purpose, able to read/understand the code written by others
-Mw (oracle forms and reports) knowledge above basic
-Understand oracle net / OCI / JBDC relates issues troubleshooting

Used domains
RDBMS oracle
Active data guard configuration, troubleshooting, tuning.
OEM
Constantly monitoring and tuning multiple Database environment using Oracle enterprise manager 13c.

Responsibilities:
Systems availability
Ensure that availability of services exceed the defined service levels.
Maintain Database environment during business hours and off-hours
Install, configure and maintain highly optimized Database environment with Oracle RAC/CDB