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

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 setting 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

Disclaimer : This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

📌 ORACLE DBA Professional (Mumbai)
🏢 Swathi Business Solutions
📍 Mumbai