SUMMARY

• Over 19 years of IT experience, mainly Oracle Database Administration experience including Oracle Exadata, Oracle Enterprise Manager Cloud Control 12c & 13c Release 2 (12.1.0.2), 11gR2 RAC on LINUX and Sun Solaris, Installation, Upgrading, Patching, sizing, creating Oracle Databases, and Oracle database Objects, data migrations, Troubleshooting, Performance & Tuning, Backup & Recovery, and Database integrity and Security.
• Extensively involved in developing scripts, logical/physical designing of databases in OLTP and Data Warehouse environments.
• Experienced in coding SQL, PL/SQL, and UNIX shell scripting to automate the jobs.
• Expert in using commvault,netbackup, Avamar & Data Domain Boost,Export/Import, Data Pump, RMAN, GoldenGate 12C and SQL *LOADER, Using Oracle Cloud Services to setup RAC databases.
• Experienced in handling multiple tasks, multiple projects and monitoring multiple database and servers.
• Monitor and Tune an Oracle Databases with ADDM/ASH/AWR/STATSPACK Diagnostic Tools.
• Oracle11g/12C/13C Grid Control implementation & Configuration.
• Strong work ethics, Oracle DBA skills, team player with excellent communication and interpersonal skills.
• Exadata Smart Scan, Exadata Smart Flash Cache, Exadata Smart Flash Logging, and Exadata Hybrid Columnar Compression.
• Oracle13C Grid Control implementation & Configuration.
• Experience in TDE(Transparent Data Encryption) in both 11g wallet and 12C Keystore.

TECHNICAL SKILLS

DB Software: Oracle 7.3.4.0/8.1.7/9 i/10g/11g/12c/18C, Erwin, Data Modeling SQL, PL/SQL, ODI, External tables, SQL*LOADER, Oracle OS Watcher and Exadata

Operating Systems: UNIX (Solaris, HP - UX, IBM-AIX), Linux (Suse, Redhat, OEL), and MS Windows

Hardware: Solaris 8, 10, HP-Unix 11, AIX,Win-NT 4.0, Win 2003 Server, Win 2008 Server, Win 2000 Professional, Sun Sparc/Ultra/Enterprise, Linux Red Hat & Oracle Enterprise Linux,, AIX, HPUX.

Applications & Tools: SOA, Manhattan, SCI, Jde, Provia, Si, Gis, Webfocus, Vertex, Ifs, Red Prairie, Tms, and Wms, VB5.0, HTML,, PVCS Tracker v7.0, Visual SourceSafe, JDE, Provia, webfocus, GIS, Evavi,McKesson (Performance Manager,Care Manager,Lab,Meds Manager,Physician Portal,Care Record, Horizon Outreach, SAP, INET, ISOTRAIN, EDI, ODI, GPRT,T RACKWISE,LIMS,EMPOWER, 'Model-N, BODS, and Chemstore

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

Sr. Oracle Database Administrator/App DBA

Responsibilities:

• Support many databases running Oracle12.2.0.1 Exadata environment, running on X6s with the use of Cloud Control 12C & 13C in monitoring.
• Also support many databases running Oracle12.2.0.1 on exadata Super Cluster M7 Cloud.
• Provide senior level DBA support for applications, including developing data migration scripts, data validation queries, and a maintenance plan for the various development versions of these applications.
• Provide documentation and support for all aspects of maintenance and development.
• Work with application development team staff to develop & test database architecture and approve all production schema changes.
• Manage movement of data between Test. UAT and Production.
• Tune database instances and applications and recommend changes to improve database performance.
• Migration of data from sql-server to Oracle12C.
• Installation and configuration of Oracle 12C.
• Mange RAC databases, instances, ASM and the clusters with the use of ASMCMD, SRVCTL and CRSCTL
• Handle all the aspects ncluding new projects, manage existing databases, performance and tuning, contact for vendors, and internal/external customers.
• Maintain backups.
• Support databases that interface with ODI.
• Upgraded of Exadata from X2 &X3 to X6s
• Implemented Oracle Advanced Security Transparent Data Encryption(TDE) for both 11g Wallet and 12C Keystore for tablespaces, tablespaces & columns
• Upgraded Exadata RAC cluster from Oracle11g (11.2.0.4) to Oracle12c (12.2.0.1)
• Applied Opatch 27626925 to fix optimizer adaptive issues after upgrade to 12C
• Installed and configured Grid Control 13C
• Applied Opatch 27626925 to fix optimizer adaptive issues after upgrade to 12C

Confidential

Sr. Oracle Database Administrator

Responsibilities:

• Supported many databases on 9i, 10g, 11g & 12c on AiX and Linux environments with the use of Cloud Control 12C in monitoring.
• Implemented Dataguard for RAC databases .
• Applied DB PSU + GI PSU using auto patching, including Rolling patches.
• Provided senior level DBA support for applications, including developing data migration scripts, data validation queries, and a maintenance plan for the various development versions of these applications.
• Provided documentation and support for all aspects of maintenance and development.
• Worked with application development team staff to develop & test database architecture and approve all production schema changes.
• Managed movement of data between Devs, Staging and Production.
• Tuned database instances and applications and recommend changes to improve database performance.
• Constantly worked with the clients on issues regarding data element changes, including eliminating unwanted data.
• Data guard & data guard broker setup
• Installation and configuration of Oracle 12C.
• Upgraded of databases from 8i,9i, 10g and 11g to 12C
• Manged RAC databases, instances, ASM and the clusters through SRVCTL and CRSCTL
• Handled all the aspects ncluding new projects, manage existing databases, performance and tuning, contact for vendors, and internal/external customers.
• Maintained backups.
• Used Precise and Oswatcher to monitor and tune databases

Confidential, Chicago, IL

Sr. Oracle Database Administrator

Responsibilities:

• Supported more than 300 databases on 8i, 9i, 10g,11g Exadata & 12C on Linux,Solaris and Window environments.
• Supported databases for applications, such as SAP,EDI,VISIPRISE, MODLAND,AUTOSYS,MATRIX, Pilgrim Smart CAPA, Trackwise, GEMS environments.
• Provided senior level DBA support for applications, including developing data migration scripts, data validation queries, and a maintenance plan for the various development versions of these applications.
• Provided documentation and support for all aspects of maintenance and development.
• Worked with application development team staff to develop & test database architecture and approve all production schema changes.
• Qualified all changes to database design/structure.
• Used Goldengate 11g and 12c to duplicate data for backup and Offshore testing
• Managed movement of complex schema changes into test and production.
• Helped tune database instances and applications and recommend changes to improve database performance.
• Work closely with various teams to identify the improvement opportunities, improve efficiency, quality and reduce risk,
• Suggest process improvements, propose solutions and work on their implementation,
• Provide support to SAP users - problem solving, training and random audits
• Worked with the clients on issues regarding data element changes, including eliminating unwanted data.
• Setup Data guard & data guard broker .
• Responsible for the creation of and upkeep of the Database Configuration Management document for application systems.
• Worked closely with test and application Development team providing optimal database solutions.
• Worked with the backup team to maintain backups and recovery procedures.
• Installed and Configured Oracle11.2 RAC on Linux
• Worked with Oracle Support to manage Oracle Exadata databases, including instances, ASM and the clusters through SRVCTL and CRSCTL
• Used Automatic Database Diagnostic Monitor (ADDM) in RAC, Collect Oracle Cluster ware diagnostics.
• Migrated of data between different database and oracle versions.
• Provided montly reporting on Capacity Management showing the existing trends od resource usage.
• Helped lead all aspects ncluding new projects, manage existing databases, performance and tuning, contact for vendors, and internal/external customers.
• Worked with Offshore DBAs to support Global customs

Confidential

Sr. Oracle Database Administrator

Responsibilities:

• Supported over many databases on 9i, 10g & 11g on Linux & Solaris environments.
• Supported databases for Warehouse Management applications, such as Provia, JD Edwards, RedPrairie, Webfocus, GIS, SI, IFS and Evavi environments.
• Provided senior level DBA support for applications, including developing data migration scripts, data validation queries, and a maintenance plan for the various development versions of these applications.
• Provided documentation and support for all aspects of maintenance and development.
• Worked with application development team staff to develop & test database architecture and approve all production schema changes.
• Approved & implement all changes to database design/structure.
• Managed movement of complex schema changes into test and production.
• Tuned database instances and applications and recommend changes to improve database performance.
• Constantly worked with the clients on issues regarding data element changes, including eliminating unwanted data.
• Data guard & data guard broker setup and configuration ( Creation,management,control, and monitoring).
• Acted as the final link before changes are implemented into production.
• Responsible for the creation of and upkeep of the Database Configuration Management document for application systems.
• Worked closely with test and application Development team providing optimal database solutions.
• Maintained backup and recovery procedures.
• Installed and Configured Oracle11.2 RAC on Linux
• Installed and configured Oracle 11 R2 Grid Control for monitoring.
• Also installed and tested Oracle 12c Grid Control - still under testing and evaluation.
• Manged RAC databases, instances, ASM and the clusters through SRVCTL and CRSCTL
• Used Automatic Database Diagnostic Monitor (ADDM) in RAC, Collect Oracle Cluster ware diagnostics.
• Migrated of data between different database and oracle versions.
• Provided montly reporting on Capacity Management showing the existing trends od resource usage.
• Handled all the aspects ncluding new projects, manage existing databases, performance and tuning, contact for vendors, and internal/external customers.
• Acted as a Laison for Security and Compliance team for database audits.
• Provided 24 X 7 support on rotational basis for customers located in Europe, South America, Australia, Middle East, and USA.

Confidential, Bloomington, IN

Remote Oracle Database Administrator

Responsibilities:

• Supported databases ranging from 8i to 10.2.0.3 running McKesson (Performance Manager,Care Manager,Lab,Meds Manager,Physician Portal,Care Record & Horizon Outreach)
• Worked with the Nurses & Doctors on issues regarding data element changes, especially eliminating unwanted data.
• Duties included Oracle software installation, database design, implementation, management and development.
• Migrated data from Oracle9i to 10g on Linux & Solaris.
• Provided remote senior DBA-level support for applications, including developing data migration scripts, data validation queries, and a maintenance plan for the various development versions of these applications.
• Provided documentation and CR (Change Request) support for all aspects of maintenance and development.
• Work with production support team to develop & test database architecture and approve all production schema changes.
• Coordinated QA meetings for design and implementation of changes to databases.
• Helped in the movement of schema changes into test and production.
• Helped to tune database instances and applications and recommended changes to improve database performance.
• Assigned and coordinated tasks on production problems to team members/QA.
• Put in placed data archiving process from production databases.

Confidential, Louisville, KY

Oracle Apps Database Administrator

Responsibilities:

• Duties included Oracle software installation, database design, implementation, management and development.
• Migrated data from Oracle9i to 10g on Solaris 10 & HP environments.
• Provided senior DBA-level support for applications, including developing data migration scripts, data validation queries, and a maintenance plan for the various development versions of these applications.
• Provided documentation and CR (Change Request) support for all aspects of maintenance and development.
• Work with production support team to develop & test database architecture and approve all production schema changes.
• Coordinated QA meetings for design and implementation of changes to databases.
• Managed movement of complex schema changes into test and production.
• Tuned database instances and applications and recommend changes to improve database performance.
• Assigned and coordinated tasks on production problems to team members/QA.
• Worked with the clients on issues regarding data element changes, especially eliminating unwanted data.
• Implemented data archiving process from production databases.
• Instrumental in providing support to the migration of major portions of data in a data warehouse.