SUMMARY:

• Over 8+ years of hands - on experience as an Oracle Database Administrator with experience on 24x7 production and mission critical database support, including RAC, ASM and Data Guard. I possess strong analytical and problem-solving skills, self-motivated, results-driven, team player with excellent verbal and writing communication skills. I have worked on Oracle 12c, 11g, 10g, 9i versions involving database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, cloning, Golden gate, OLTP, OLAP, space management and security.
• Certified Oracle Database administrator with over 7 years of hands-on technical experience.
• Comfortable in Full SDLC including Production, Application & Project Support.
• Experienced in Oracle 9i, 10g, 11g, 12c, RAC, DG, ASM, PL/SQL, Shell Scripting, RMAN, TOAD & OEM GC on various platforms including AIX, UNIX, LINUX & Windows Servers.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Database Administrator

• Monitored and tuned database performance using difference oracle tools.
• Provided troubleshooting support to developers at ACF
• Perform database migration, cloning and quarterly patching of the oracle software
• Installed Oracle software, created databases on Linux and Window servers
• Designed database architecture and application schema.
• Participated in all phases of the system development life cycle from requirements analysis through system implementation.
• Collaborated with development team to tackle database/application issues.
• Designed and implemented Oracle database backup/recovery scheme and setup security and storage management strategies.
• Preforming data pump export and refresh schema and its objects including materialize views.

Environment: Oracle 11g&12c, RMAN, AWR, ADDM, SQL*Loader, DATA PUMP, Linux/Unix/Windows, Share Point site, WEBLOGIC application, PUTTY, WinSCP, SSI system, LADP OID, OVD for authentications methods, SSH Keys, OEM Grid Control, SHELL Scripts, Crontab, WebEx.

Confidential

Database Administrator/System Analyst

• Design, develop and implement database objects for Linux/Unix/Windows, procedures in development, test and production environments.
• Provided project & production support for 10g, 11g, & 12c, RAC & Data Guard environments utilizing ASM on AIX, UNIX & Linux platforms. Experience in Exadata and Golden gate.
• Ensures that only authorized users have access to the databases and fortifying it against any external, unauthorized access.
• Update and maintain data models and data dictionaries using Erwin.
• Develop and maintain scripts for data extract/transformation/loads, archival, data scrubbing as needed. Maintain nightly batch processes/Java programs/Unix Scripts.
• Performed Database upgrade from Oracle 9i (9.2.0.7) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.
• Maintain software source code versions.
• Provide customer with the database support required for data updates, periodic and ad-hoc reporting, and data analysis
• Web development experience using JSP desired
• Experience with Java development with RAD desired
• Data extraction, Modification & Movement throughout the environment Dev/Test/Prod
• Tuned performance with AWR, ADDM, ASH, SQL tuning advisors, indexes, partitions, etc.
• Reports preparations.

Environment: Oracle 9i, 10g,11g&12c, RMAN, AWR, ADDM, SQL*Loader, IBM DB2, Linux/Unix/Windows, BMC Remedy, Erwin, JSP, IBM Data Studio, IBM WebSphere, Citrix, Delph Application, IBM AIX V6 & Red Hat Linux, RHEL 5.2, PUTTY, Wincp.

Confidential - Memphis, TN

Oracle Database Administrator

• Provided project & production support for 10g, 11g, & 12c, RAC & Data Guard environments utilizing ASM on AIX, UNIX & Linux platforms. Experience in Exadata and Golden gate.
• Performed Platform migrations from AIX to Linux & Windows servers using Data Pump.
• Installed Database upgrades from 9i to 10g, 11g & 12c & configured both PSU & CPU patches.
• Implemented Change Requests using BMC Remedy system.
• Heavily utilized OEM Grid Control & TOAD for administrative, monitoring, & diagnostic tasks.
• Tuned performance with AWR, ADDM, ASH, SQL tuning advisors, indexes, partitions, etc.
• Created Data models & Ad-hoc reports in OLTP & Data Warehouse environments.
• Performed Database upgrade from Oracle 9i (9.2.0.7) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, UNIX & LINUX, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.

Confidential - Chicago, IL

Oracle Production Support Database Administrator

• Performed Installations and configurations of Oracle Software 9i, 10g, & 11g on UNIX and Windows Servers.
• Supported Developers & Engineers with PL/SQL query Designs/Optimization, data migration, version control, patch implementation & deployments of new databases & application servers.
• Extensive Backup/Recovery & Refreshes using RMAN, Cloning, Data Pump, Data Guard, Export/Import, OEM, Crontab, & shell scripting.
• Conducted daily administrative functions such as health checks, monitoring of logs & resources (CPU, Memory, I/O, Disk capacity/usage) on production & application servers.
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.
• Involved in converting a single instance database to Oracle 11g, 10g RAC databases.

Environment: Oracle 11.1.0.4, 10.2.0.3, 9i, IBM AIX V6.1, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.

Confidential

Oracle Database Administration

• Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on Red Hat Linux platforms.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
• Loading data from flat files to database using SQL*Loader, External Tables.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databases and Data pump import/export to move data between 9i and 10g/11g environments.
• Involved in construction of DR sites for all the Production environments.

Environment: Oracle 10g/11g/11g RAC/9i, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.