Oracle Database Administrator Resume

SUMMARY

An accomplished IT Professional with 6+ years of proven experience as Oracle database administrator on diverse platform like Linux, Sun Solaris, and Unix.
Experience includes working with Oracle 10g, 11g, 12c, 18c and 19c database versions, Installation and Configuration, Database Upgrades, Patching, User and profile Management, Database Migration, Backup and Recovery, Database Design and Data Modeling, Performance Monitoring/Tuning, Database Cloning, Golden Gate, Real Application Clusters (RAC), Data Guard and Supporting Application.

TECHNICAL SKILLS

Oracle 10g, 11g, 12c, 18c and 19c
RMAN,
SQL Loader,
Exp/Imp/Data Pump,
Log miner,
Statspack/AWR, ADDM,ASH
DBCA,
DBUA,
Oracle Migration Workbench,
Remedy
Toad, OEM Grid
Golden Gate
Data Guard
RAC
Oracle SQL Developer
ServiceNow
AWS Cloud
Oracle Cloud
Database Migration to Cloud

PROFESSIONAL EXPERIENCE

Oracle Database Administrator

Confidential

Responsibilities:

Performed SQL query tuning using reports generated by tools like StatsPack, TKPROF and SQL*Trace and Explain Plan.
Refreshed databases using DATAPUMP from DEV database to PROD environment. configured oracle golden gate for data replication and zero downtime,upgrade using trail local and remote trail files, extract andreplicate process, manager process and supplemented withdatapump for logical transfer of data from source to target.
Rebuilt Indexes and gather statistics on tables on different databases on a regular basis togain database performance using DBMS STATS package
Upgraded the databases from 11g to non - CDB 12c.
Migrated 12c Non CDB databases to pluggable databases.
Setup 4 nodes Primary RAC with 3 nodes physical standby for a new application Utilized Enterprise manager to monitor alerts, schedule jobs, monitor SQL loads,generate AWR reports.
Configured Oracle Data Guard to ensure disaster recovery, high availability, and dataprotection.
Database monitoring and performance tuning using OEM, AWR and ADDM, ASH, SQLTRACE, SQL Access Advisor.
Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multipledatabase and notification of database alerts, and configured EM agents on multipledatabase servers.
Implemented Datapump, conventional export/import utility of Oracle 11g, 10g for re organized Databases/Schemas/Tables to improve the performance.
Used import/export utilities for cloning/migration of small-sized databases andDatapump import/export to move data between 10g and 11g/12c environments. • Implemented switchovers on primary and standby databases as a part of plannedmaintenance activities.
Partitioned tables by determining the suitable methodology to improve performance andmanageability.
Applied upgrade patch, maintenance and interim (Opatch) patches on all the databases. • Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for HighAvailability, Scalability, and Performance by determining the best Cluster architecture,choosing the best hardware configuration for Oracle RAC.
Successful in installation/maintenance of Physical Standby database using Oracle DataGuard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.
Database monitoring/maintenance, replication process, and performance tuning are doneusing OEM (Oracle Enterprise Manager).

Junior Oracle Database Administrator

Confidential

Responsibilities:

Maintained and supported existing production and non-production Oracle databases.
Performed and scheduled backups and recovery of some production databases
Performance optimization of SQL statements and some oracle databases
Database refreshes using DATAPUMP from PROD database to DEV environment.
Supported database needs for new project deployments.
Assisted in all facets of infrastructure lifecycle management activities.
Installed, upgraded, and patched 11g and 12c Oracle databases in Linux and Windowsenvironments.
Automated database administration tasks using PL/SQL and shell scripts.
Performed basic and advanced tuning at the database and database/server level.
Used Enterprise Manager and other tools for availability and performance monitoring.
Worked directly with clients to plan and execute database outages and migrations Responsible for setting and managing USER MANAGEMENT, SPACEMANAGEMENT Granting required privileges to users. installed/maintained Physical Standby database using Oracle Data Guard for Oracle11.2.0.3 and Oracle 10.2.0.5 RAC databases.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship