About the job Senior Database Administrator
-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.
-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
Active data guard configuration, troubleshooting, tuning.
Constantly monitoring and tuning multiple Database environment using Oracle enterprise manager 13c.
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