- Minimum 9+ Yrs. relevant experience on Oracle 12c/18c/19c Database Administration
- Candidate should be able to quickly understand and resolve issues, mitigate risks and dependencies and the ability to drive projects and resources to completion
- Excellent verbal and written communication, presentation and documentation skills.
- Should possess certification in Oracle database administration like Oracle 12c / 18c / 19c.
- Willing to work in 24x7 environment with Rotational Shifts.
- Actively participate in service improvement plans.
- Should be able to drive the critical issues and effectively communicate over the calls.
- Implementing short / long term plan.
- Monitoring overall functioning of process and identify improvement areas.
- Should be ready to work as On-call as per the requirement.
- Strong analysis and problem solving skills.
- should have worked extensively on Production systems
- Should have basic knowledge of Solaris / Linux / Veritas Cluster etc.
- Identify and Drive Automation Areas and service improvement efforts.
- Should be having good scripting knowledge.
- Should be able to drive the critical issues and effectively communicate over the calls.
Required Technical Skills – Primary
- Extensive experience with Database Migration, Installation, Upgrades and Patching.
- Storage Management Techniques
- Configuring and Administering the Oracle 12c, 18c and 19c.
- Oracle database Installation Pre-requisites
- Should have good knowledge on Oracle Kernel Parameters tuning
- Excellent hands on experience on performance analysis and tuning.
- Managing the Database Performance using (AWR, ADDM).
- Hands on experience on Database Cloning
- Automatic Storage Management
- Initialization of Parameters
- Should have experience on Backup and Recovery Strategies planning using RMAN
- Extensive experience on Database patching.
- Upgrade of Oracle Databases from 11g/12c to 18c/19c.
- Flash Recovery Features & Flash back query
- Managing Alerts and Notifications
- Database Black-out Administration
- Cross platform transportable Tablespaces.
- Excellent Knowledge of implementation, configuration and Data Guard / RAC (Real Application Clusters) which includes Implementation, configuration, Administration and troubleshooting issues.
- Knowledge of Data warehousing
- Knowledge on Oracle Exadata / Golden gate / OEM
- Extensive working knowledge of utilities like Data Pump, Export / Import.
- Managing high severity critical incident issues and calls
- Working on Root Cause Analysis and problem tickets both pro-active and re-active.
Technical Skills - Secondary
- Prior experience of working in a DevOps / Agile environment will be an advantage.
- Working knowledge on ITSM tool – JIRA
- Knowledge on Cloud technologies like - Azure or AWS