SUMMARY

• Six(6) years experience with ORACLE DATABASE ADMINISTRATION (10g, 11g).
• Six(6) years of PERFORMANCE TUNNING experience (Database, Memory and SQL Tuning using the AWR, ASH, ADDM, EXPLAIN PLAN).
• Six(6) years of experience configuring and administering DATA GUARD for disaster recovery. Configured both physical and logical standby databases. Configured dataguard BROKER to ease the role transition.
• Six(6) years using RMAN - (backups, recovery and cloning).
• Six(6) years of experience with MIGRATING from similar to different operating system such as Linux Red Hat, AIX, Solaris, Windows using DATAPUMP, GOLDENGATE, TRANSPORTABLE TABLESPACE, CREATE TABLE AS, and many other strategies.
• Six(6) years working in OLTP and OLAP Environments
• Six(6) years of experience MONITORING THE DATABASE WITH TOOLS ( TOAD, SQL Developer, OEM 12c, …).
• Five(5) Years of experience implementing SECURITY (Auditing, TDE, Network Encryption,…).
• Six(6) years of experience UPGRADING & PATCHING (CPU and PSU).
• Six(6) years of experience managing Oracle GOLDENGATE (both 11g and 12c). me did both unidirectional and bidirectional configuration.
• Six(6) years of experience managing and administering 2 and 3 NODE RAC (11g and 12c) using ASM, ACFS and OCFS storage
• Three(3) years of experience writing UNIX SHELL SCRIPTING & PL SQL PACKAGE.
• Six(6) years of experience using unix command to create, view and edit files
• 3 years of experience with ORACLE version (12C R1 AND 12C R2)

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000, UNIX

RDBMS: Oracle 10g, 11g and 12c

Languages: SQL, PL/SQL

Tools: TKPROF, EXPLAIN PLAN, AWR, and ADDM.Toad, Putty, NX client, Winscp, Remote Desktop Connection, VNC, Team Viewer, LogMeIn and Cisco VPN Client

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Oracle Database Administrator

Responsibilities:

• DBA supporting major projects from Development to Production via Test and UAT environments. Duties involve daily administration, maintenance and tuning.Databaseranging from 100GB to 10TB.Monitoring on OEM.
• Database, Table and schema refreshes using Data pump, expdp and impdp and transportable tablespaces.
• Experienced in cloning the databases using online and offline backups and using RMAN duplicate backup to migrate data from 11g to 11.2.o.3
• Configured deployed and administered 2 and 3 node RAC clusters on Solaris 10 and Redhat Enterprise Linux 5.9.
• Extensively involved in performance tuning of applications, SQL queries and databases using Explain Plan, ASH, ADDM, SQL TRACE, TKPROF and AWR reports.
• Installation, configuration and administration ofOracleGolden Gate
• Created a standbydatabaseusing RMAN Duplicate in order to reduce the down time for the PROD databaseduring the migration process.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups on crontab and OEM, taking Logical Backups (with Export/Import Data pump utilities).
• implementeddatabasesecurity management, by using the principle of least privilege, and Provided technical support for all applicationadministratorsand users.
• Applied critical patches toOracledatabases and application servers.
• used Grid control (OEM Grid) to administer and manage large number of databases and enterprise wide targets.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics. And PL/SQL Tuning.
• Responsible for setup and implementation of 2 Node RAC on Linux in 11g and 12c.
• Implemented Data guard, creating both logical and physical standby databases in 10g and 11g RAC environment for productiondatabase.
• Experience in PeopleSoft/Oracle Database installation, upgrade, patching and migration
• Experience in Exadata cloud installation, upgrade, patching and migration from oracle 12c to Exadata cloud.
• Involved in Exadata implementation, monitoring, upgrade, patching and migration.
• Configure and manage PeopleSoft running applications such as Finance, HR, SCM. CRM.
• . Involve in upgrade and patching of Peoplesoft application.
• Experience in configuring and managing E - Business suite which integrates business CRM, ERP, AND SCM with applications such as HR, FINANCE, PROJECT PORTFOLIO AND PRECUREMENT

Confidential - Greensboro, NC

Oracle DBA

Responsibilities:

• Successfully installed and configuredOracle11.1.0.7,Oracle12.1.0.2 databases on Linux platforms.
• Monitored different databases and application servers usingOracleEnterprise Manager (OEM) 12c Cloud Control.
• Loading data from flat files todatabaseusing SQL*Loader, External Tables.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Implementing Data pump, export/import utility ofOracle11g, 10g for re - organizing Databases/Schemas/Tables to improve the performance, cloned using RMAN.
• Trouble shooting and performance tuning golden gate replications, monitoring scripts for Golden gate in Unix scripting
• Involved in Performance Planning and Tuning, using baselines and proactive monitoring, bottleneck elimination and the wait event interface to identify issues and generated weekly reports
• Implemented Flashback technology of theOracle11g, 10g for a faster recovery of databases anddatabase objects.
• Performed full & incremental backup (cumulative and differential), incremental updated using RMAN
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases., as well as performingdatabaseupgrade.
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts CreatedatabaseObjects, Table spaces, Schemas as needed.
• Exposure to AWS migration and implementation
• Experience in installation, migration, monitoring, patching and upgrade Exadata.
• Exposure to sql server databases. Installation, upgrade migration monitoring performance and supporting users.
• Hands on experience in E-business suite application monitoring, configuring and instalations.