Oracle DBA L3
About The Company
- Top 5 IT Firms
- Belapur (Navi Mumbai)
Experience
4 Years+
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)