DEBIPRASAD MAHATO

Oracle Database Administrator

408-***-**** ad23wn@r.postjobfree.com

linkedin.com/in/debiprasadmahato San Francisco,CA

SUMMARY

Oracle Certified Database Administrator having 13+ years of experience as an Oracle Database, Application, Cloud Administrator and Project Management with reputed organizations. I have led database migration, upgrade, single sign on implementation, automation, Performance tuning for various customers with different domains like Finance, Telecom, manufacturing.

PROFESSIONAL EXPERIENCE

Oracle Database Administrator 11/2019 - Present

Client: Yahoo! Inc. San Jose, CA

Upgraded Oracle ERP and non-ERP databases from 12c (12.1.0.2) to 19c (19.16.0.0.0). Completed End to End Implementation for 12c Multitenant Database. Migrated the on-premises oracle database to AWS environment(AWS RDS/EC2). Automated the database and application daily refresh script. Migrated large databases of Oracle Database to different datacenter. Worked as a team member for RHEL6 to RHEL7 operating system upgrade. In-depth knowledge on performance troubleshoots and tuning on Application and Database side.

Setting up and maintaining Standby Database / Oracle DataGuard to protect against failures.

Actively involved on month end, quarter end and yearend related activity. Assisted in implementing Disaster Recovery and High Availability strategies. Upgraded the SAP database from the version 11.2.0 .4 to 12.1.0 .2 on latest operating system.

Automated the database and WebLogic patching through Ansible. Periodically performed database and application failover testing. Quarterly involved on application and database password Change activity. Oracle Database Administrator 01/2019 - 11/2019

Client: Charter Communications St Louis, MO

Successfully integrated Oracle Storage Inventory Management (SIM) with Oracle Database.

Worked as SME for Operation support for various critical database and application. Periodically refreshed database through RMAN and Data pump. Migrated large on premises Oracle Database to Aws Cloud. Periodically performed database switchover testing. Performance monitoring of database and application through OEM and Identify the issues. Interact with the users through bridge, troubleshoot and identify the issues and provide appropriate recommendation.

Worked on Oracle Goldengate and it’s component like extract, manager, replicat, trail files. Implemented reliable backup strategies and recovery procedures for small and large databases using RMAN and Data pump methodology.

Oracle Database Administrator 06/2017 - 01/2019

Client: Yahoo! Inc. Sunnyvale, CA

Upgraded Oracle EBS from 11.5.10 to 12.2.6 with database upgrade from 11.2.0.4 to 12.1.0.2

Given expertise support on application and database performance related issues. Integrated WebLogic application (WebCenter) with OKTA Single sign on. Successfully Migrated SAP and PeopleSoft databases and application from one datacenter to another.

Worked on setting up S3 bucket while migrating databases to different datacenter. Data-Guard setup Build and Testing Switchover and Failover Scenario Periodically. Developed data loading scripts through SQL Loader designed the database structures for the custom module.

Performed the maintenance of database and production support. Expert in applying application patch through ADOP, ADPATCH and database patch through OPATCH.

Hands-on experience on Load Balancer and Printer Setup and troubleshoot. SKILLS

R12 (12.1.x, R12.2.x)

Oracle, MySQL, PostgreSQL, AWS RDS

OPatch, Data Pump, Golden gate, RMAN

Red Hat Linux, Solaris, AIX, Windows

PL/SQL, Shell Script, Python3

Splunk, OEM, Yamas, Cronjob

Jira, Service Now, Confluence

CERTIFICATION

Oracle Cloud Infrastructure

Certified DevOps Professional

Valid:Sep 2025

Oracle Cloud Infrastructure

Certified Architect Associate

Valid:Aug 2025

Oracle Cloud Database Migration

and Integration Professional

Valid:July 2025

ITIL V3 Foundations Certified

Associate

Valid:Apr 2027

ATTAINMENTS

Appreciated for successfully upgrade of

revenue generating A1 Application.

Got customer recognition for integrating

OKTA SSO with Oracle WebLogic

Application.

Appreciated by customer to performance

troubleshooting automated scripts.

Got appreciation for automate patching

activity through OEM and through

automated script.

E

q

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

PROFESSIONAL EXPERIENCE

Oracle Database Administrator 10/2013 - 06/2017

Client: Cisco System Inc. San Jose, CA

Successfully upgraded critical applications from database version 11.2.0.4 to 12.1.0.2 and application version from 12.1.0.3 to 12.2.0.5.

Worked as an SME for patching team. Automated patching through OEM and through shell script.

Automate Regular Oracle/MySQL administration, DB Deployment, Monitoring and Support jobs using Ansible, shell script and Python. Implemented Oracle Identity management as a single sign on with failover option. Identified and resolved critical application issues including those relating to performance, Workflow, forms, reports, and concurrent processes. Integrate Ping access as a single sign on option with several Oracle Application like EBS, WebLogic.

Worked on zero downtime database upgrade from 11g to 12c using Oracle Goldengate. Oracle Database Administrator 08/2010 - 10/2013

Client: Michelin Bangalore, KA

Successfully Implemented Real Application Testing (RAT) through load tool like Swing bench.

Applied Oracle CPU and PSU Patch quarterly and cloned the production database to test database.

Involved with installation and maintenance of ORACLE 11g RAC/oracle 12C RAC and standby database for high Availability and Disaster Recovery purpose. Installed grid software, created database, and converted it to multi node (RAC). Setup Standby database, troubleshoot and recover standby database in case of high archive lag.

Troubleshoot the databases using AWR, ADDM, INDEXES, EXPLAINPLAN, SQLTRACE and TKPROF.

Schemas refresh using data pump from prod to test, creating tablespaces re-organizing the data files, tables, indexes.

settings privileges and user logins for prod/dev/test databases. EDUCATION

Master Of Computer Application 2003 - 2006

Regional College Of Management Bhubaneswer, India

Bachelor of Science (Mathematics) 2000 - 2003

University of Calcutta Calcutta,India

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

Contact this candidate