KeySkills:

ORACLE DATABASE ADMINISTRATION, BACKUP & RECOVERY, ORACLE RAC ADMINISTRATION, ORACLE DATA GUARD (DC-DR), ORACLE GOLDENGATE, PERFORMANCE TUNING, MONITORING, PATCH MANAGEMENT, EXPORT & IMPORT, SECURITY & COMPLIANCE, INCIDENT & PROBLEM MANAGEMENT, ORACLE SUPPORT, SQL SKILLS, PARTITIONING, DOCUMENTATION, REPORTING, CHANGE MANAGEMENT, OPERATING SYSTEM SKILLS

Job Description:

• Monitoring : Status of database instances, Status of database listeners, Alert log of each DB, File system utilization, Disk group utilization, Listener log of each DB, Cluster status, Tablespace utilization & DC-DR sync status

• DC - DR sync evidence provisioning to auditors

• DB refresh of environment whenever required.

• Creation of incidents in SM on behalf of Bank for all the tasks performed

• Export - Import activity of various databases as per request.

• Support, log, categorize, prioritize, track and route : Incidents reported by users, Continuous monitoring of devices under scope, Alarms raised by monitoring tools. Raise ticket and investigate if utilization cross threshold values.), Escalate as per SLA, Follow documented escalation process approved by the Bank.

• Database creation as per requirement

• Creation and Implementation of various changes (Patching / SCD / Adhoc requests) over weekends.

• SCD implementation of all the DBs

• VAPT compliance of all the dBs

• Yearly Table Partitioning Activity.

• Day to day troubleshooting of various errors coming in operations & DR automation issues

• DB sync (DC - DR ) sync in case DB goes out of sync due to some issues

• quarterly user review

• Export - Import activity of various databases as per request

• Database upgraded/downgrade as per requirement

• RAC Database / Single Instance / One off bugs database patching

• Goldengate setup creation and troubleshooting.

• Periodical performance tuning of Database

• Manage incidents

• Coordination with internal and OEM partners for incident resolution

• Patch management

• Documentation of Changes and upkeep architecture documents to latest versions.

• Continuous improvement / Reduction of incidents

• Resolution & Provisioning of RCA in case of any issues

• Periodical user review of various DB as and when Bank demands.

• Sharing of SQL output for various requirements as and when demanded by the Bank.

• Attending daily operation review meeting for regular updates to Bank management

• Raising SR with OEM (Oracle) for issues that are complex in nature

• Working with OEM (via SR) for complex issue resolution

• Golden Gate setup creation and troubleshooting.

• Pro-active problem identification and Continuous service improvement

• Problem management and Root cause analysis

• Review of Change implementation and rollback, migration, SOPs and architecture documents.

• MIS reporting with Bank’s management (Weekly / Monthly/ Quarterly) as and when required by the bank

Note:

(i) Our client is looking for immediate & early joiners.

(ii) Having LinkedIn Profile is a must.

(iii) Being an immediate & high priority requirement interested candidates can share their Resumes with Photograph in word doc. format and the details are enclosed as below: