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 v

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