Oracle DBA L3

Required Skill Set: –
● Minimum Experience of minimum 5+ years in oracle Production DBA. Experience in the banking domain is preferable.
● Oracle Production database administration with knowledge of Oracle 10g, 11g databases, SQL loader, RMAN, Physical Standby Databases, Data guard, ASM, RAC databases.
● Should have knowledge of Oracle Database Performance Tuning.
● Backup and Recovery methodology using Hot backups and RMAN backups.
● Working knowledge to work with oracle support.
● Should have working knowledge of logical backups and restore using data pump utility & normal EXP / IMP utility.
● Shell Scripting knowledge on Unix platforms specially on Solaris.
● Should be ready to provide 24x7support. Should be ready to work in shifts.
● Basic knowledge of Oracle Applications Server 11i .

Key Responsibilities: –
● Implementing and maintaining database security (create and maintain users, roles and assign privileges)
● Maintaining standby databases, in both local and remote locations
● Advanced Backup and Recovery using Oracle’s RMAN software; using offline/online for recovery in a production environment.
● Performing daily routine activities i.e. database backups, export, Imports
● Recovery manager (RMAN) Configuration on Oracle 10g
● Designed and created Standby Database in Oracle 9i and Oracle 10g.
● Oracle 9i and 10g, 11g Server Installation on UNIX, Solaris and Windows platforms.
● Archive log shipping to the Standby site for production databases.
● Resolving User related queries in Production and Test Databases.
● Communicating with other teams and client for their queries and issues.
● Performance analysis and Diagnosis of Databases.
● Internally escalating problems as well as externally wherever necessary in order to meet SLAs.
● Good analytical and problem-solving skills are required.
● Ability to successfully handle multiple tasks while under pressure.

Certification: Oracle OCA / OCP (Preferably Oracle11g Database)
Must be ready to work in shifts, late nights, extra hours
Willing to work late night, Saturdays and must be available (24X7)