Oracle DBA Resume

SUMMARY:

A result oriented professional with rich experience of more than 15 years of IT industry.
Expertise in Oracle Database Administration (DBA) with 15+ years of experience working in International and MNCs with Oracle OCP s.
Experienced in data modeling, logical/physical Database design, Normalization, Installations on Cloud/ Linux/ Unix/ Windows environments.
Extensive experience of Development, System Test and Production databases implement & support.
Actively involved in Data Centre Migration & Database Migration & Upgrade.
Experience supporting large size Production & Data warehouse databases in 24X7 complex environments.
Expertise in Cloud - AWS (VPC, EC2, S3, EBS, DMS & SCT, RDS), Oracle Database administration (RAC), Backup & Recovery and Performance Tuning. 24x7 Production support experience in most critical environments.

SKILLS:

RDBMS: Oracle 12c, Oracle 11g (RAC), Oracle 10g, Oracle 9i, Oracle 8i/8 Oracle 7 vesions with OLTP & Data Warehouse

OS /Env: AWS Cloud, Unix, Linux, AIX, Sun Solaris, Windows

Tools: AWS Console, AWS DMS & SCT, Oracle GoldenGate, Oracle OEM, SwingbenchER-Studio, Erwin, ITIL (Service Now)

EMPLOYMENT HISTORY:

Confidential

Oracle DBA

Responsibilities:

Databases migration support during Data Centre migration from USA to India
Oracle Databases upgraded from 9i/11g to 12c (Solaris/Linux to Windows)
Split database and setup done at Mexico plant for legacy Applications
Implement Data sync strategies between India & Mexico databases to address latency issues
Plan & Implement Backup & Recovery strategies
Support Application Development & enhancement

Confidential

Performance DBA

Responsibilities:

Monitor Databases Performance and provide pro - active support
Analyze Application Performance issues & implement permanent solutions
Optimize Apps code (Package/Procedure/Query) for better performance
Optimize Database & Query tuning for improved performance
Support Application testing with Dev/QA prior to Production cut-over
Performance DBA for 400+ Databases (11g, 12c RAC, On-premise, AWS EC2 & RDS)

Confidential

ICAM Project DBA

Responsibilities:

Participate & provide DB solutions for Application releases (monthly/quarterly)
Support QA/Performance testing
Suggest solutions for performance improvements
Support Apps code - push & production cut-over
Major issues have been resolved & streamlined Database services

Confidential

Production support DBA

Responsibilities:

24x7 on call production support
Monitor & Support DBA activities
Build new databases (Dev/QA/Prod)
QA/DEV DB refresh with Production data
Schema refresh & code push
Setup & Monitor standby DB databases
Automate schema refresh
Resolve standby MRP / archive log gap issues

Confidential

Production support DBA

Responsibilities:

Monitor 2-node 12c RAC databases hosted on Exadata rack
Monitor & improve performance of Database Applications
Resolved major performance issues & provided 24x7 on-call DBA support

Confidential

DBA Support

Responsibilities:

Data center migration project
Migrated databases from Atlanta to remote location
Migrated 150+ databases with NO issues

Confidential

Production support DBA

Responsibilities:

Upgrade Databases from 11g to 12c RAC (one - node & 3-node with ASM)
Implement RMAN backup & recovery plans for 12c RAC databases
Database migration from SYBASE to Oracle 12c
Have taken ownership for P1/P2 issues, identified & implemented solutions
Resolve day-to-day 12c RAC listener & DB issues
Setup Physical Standby (Dataguard) databases
Implement Active Dataguard.

Confidential

DBA Architect

Responsibilities:

Participate in new Application design & discussions
Participate in Data modelling. Design physical & logical schema entity diagrams
Extensively used ER tools like, ER - Studio and ER-Win
Generate SQL DDL/DML statements from schema diagrams
Reverse engineer database schemas for Application modifications/enhancements.
Recommend PK, FK and indexes based entity relations (1-1 & 1-n)
Part of architect schema approval team
Capacity planning

Confidential

Data warehouse DBA

Responsibilities:

Design & Create Data warehouse databases
Support bulk loads & monitor databases activities during loads
Support DB & ETL services
Monitor & create necessary indexes for performance improvement.
Implement Table Partitions for better performance

Confidential

Production support DBA

Responsibilities:

Production support for 9i/10g Databases.
Upgrade databases from 9i to 10g.
24x7 & on - call support
Regular DBA support like, monitor alerts, attend space issues & listener issues
Co-ordinate with change control team for schedule & implement DB changes
DB User administration & setup object privileges

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship