SUMMARY:

• 17+ years of IT experience as Oracle DBA of progressively responsible positions in diversified and very large production and development environments with database and Application implementations in various platforms of Unix flavors and Windows with a proven track record as a Senior Oracle DBA.
• Extensive experience in production DBA activities including installations, patching, cloning, High Availability (SuperCluster (Exadata on Solaris), RAC, Dataguard, RMAN, OEM Cloud Control & Grid Control).
• Expertise in Oracle RAC, ASM, Data Guard, installation, migration, patching, designing, scripting, performance tuning, database security and auditing, Oracle Internals, Oracle databases(8.x, 8i.x, 9i.x, 10g.x, 11g.x and 12c.x), Oracle Cloud Control(12c) & Oracle Grid Control 10g.x & 11g.x).
• Oracle Certified Professional (9i DBA). Microsoft Certified Professional (NT Server).
• Installation of Oracle 12c (with multitenant architecture i.e. CDB and PDB) database on Oracle Linux.
• Extensively upgraded 11gR2 to 12cR1 database, 10gR2 to 11gR2 & 9iR2 to 10gR2.
• Deep understanding about Exadata specific features such as Smart Scan, Flash Cache, Flash logs, etc.
• Used Exachk and Sundiag to run Exadata health checks.
• Performed object analysis to set storage clause to KEEP to - use Smart Flash Cache Intelligent Caching.
• Tuned free buffer waits on Exadata using WriteBack feature.
• Broad knowledge and success in planning / implementing database projects.
• Recommended hardware and OS platform for database systems. Conform to industry standard practices for implementing tools and components.
• Extensive experience in managing, leading and mentoring junior DBAs.
• Solid experience in system analysis and design, development, documentation, code review, code analysis, process improvement and participating in customer presentations.
• Cross-Platform Migration of "Oracle Database" from Windows to SUSE Linux Platform and upgrade of it from 9i and 10R2 to 11g R2.
• CPU /PSU patch analysis and application.
• Foolproof Database Upgrade from 11gR2 to 12cR1 using Real Application Testing (RAT).
• Strategize and implement Oracle database RMAN backups and logical backups using export/import utility.
• Configured RMAN Backups using TDPO & TSM.
• Experienced in administration and design of OLAP and OLTP databases.
• Analyzing AWR, ADDM and ASH reports to tune Oracle Databases.
• Oracle RDBMS design and developing stored procedures, packages, triggers, cursors & functions using SQL and PL/SQL.
• Expertise in tuning procedures, packages and SQL statements.
• Proficient in error handling and debugging coding issues and troubleshoot production problems.
• Possess excellent problem solving skills, very strong written and verbal communication skills.
• Able to direct multiple tasks efficiently and master innovative software and tools.
• Illustrated performance in identifying problems in initial stages, executing quick resolutions, and communicating technical issues to non-technical personnel.

DATABASE KNOWLEDGE:

• Install and upgrade 12c, 11g, 10g, 9i, 8i Oracle database servers.
• Plan, Setup and Support SuperCluster (Exadata).
• Install and upgrade tools and applications (ERP Apps).
• Monitor, tune, size, disaster recovery, analyze, and defrag.
• Design and implement database security and user management.
• SQL and PL/SQL scripts, triggers, procedures, packages, and automation projects.
• Write shell scripts providing instance- and machine-level monitoring.
• Author shell scripts to perform and monitor backups and housekeeping.

TECHNICAL SKILLS:

Relational Databases: Oracle (12c, 11g, 10g, 9i, 8i, 8, 7).

ERP Applications: Oracle ERP Apps (10.7, 11.0, 11i).

Oracle Tools/Utilities: RMAN, ASM, OEM Grid/Cloud Control 11g/12c/13c, Active Dataguard, Snapshot Standby Database, SQL Developer, SQLPlus, TOAD, SQLLoader, TKPROF, IMP-EXP, Expdp-Impdp, SQLT, STATSPACK, AWR, ADDM, ASH, ORAChk, OSWatcher. DBV, Shell Scripting, Top, SAR, VMSTAT & IOSTAT.

Operating Systems: UNIX (SUSE Linux, OEL, HP UX, Sun OS, IBM AIX), Windows (2012, 2008).

Programming: UNIX shell, SQL, PL/SQL, Awk, MQL and ThinkScript.

Internet: HTML, CGI and Perl.

Other: SuperCluster, Oracle Enterprise Manager (OEM 13c & 12c), Oracle Data Guard, MS Access, MS-Office, Putty, Winscp, VNC Viewer.

PROFESSIONAL EXPERIENCE:

Confidential, Livonia, MI

Senior Oracle DBA

Responsibilities:

• Provide hands-on database administration in support of production and lower environments.
• Lead and primary DBA for Cerner PathNet. Helped in technology planning, database project implementation and db environment design.
• Performed database refreshes using manual and RMAN duplicate process.
• Performed upgrade of 11g GI to 12c.
• Support the maintenance for RAC-one and RAC nodes during SP5 upgrades.
• Designed backup strategy for daily and weekly backups using RMAN from Standby rather than Primary.
• Upgraded 11.2.0.4 databases to 12.1 CDB.
• Used SQL Baselines and SQL Profiles to optimize query performance and monitoring sql plan changes as proactive approach.
• Lead a project to identify required stats on mission critical applications where the DATA volatility is more than 10% and scheduled an automatic stats gathering job in non-peak hours as proactive measurement to avoid issues pertaining to table statistics.
• Participate in on-call duties on a rotational basis.
• Took action to support LUN failure. Performed switchover. Recovered the original RAC database.
• Fixed excessive incarnations in RMAN catalog.
• Configured Snapshot standby for 724 Downtime Viewer database.
• Eliminated space errors by implementing proactive space monitoring and effective space allocation.
• Perform other duties as assigned.

Environment: Oracle 12c, 11g, AIX, Red Hat Linux, ASM, CRS, RAC, RAC one, ACFS.

Confidential, Dearborn, MI

Senior Oracle DBA

Responsibilities:

• Administer and support the continuous operations of Oracle enterprise server databases running on UNIX and Windows environments (size from 300G to 10T).
• Part of core group to document and implement DBA standards (installation, database naming/creation, Backups, Disaster Recovery, Oracle ERP environments, automatic startup/shutdown scripts, on-call support), Standard Operating Procedures (SOP’s).
• Installing Oracle RDBMS and GRID Binaries 11.2.0.4 & 12.1.0.2 in Silent and GUI Mode for Oracle Restart and RAC environments.
• Deep understanding about Exadata specific features such as Smart Scan, Flash Cache, Flash logs, etc.
• Used Exachk and Sundiag to run Exadata health checks.
• Performed object analysis to set storage clause to KEEP to use Smart Flash Cache Intelligent Caching.
• Tuned free buffer waits on Exadata using WriteBack feature.
• Performed RMAN and TDPO backup tuning. Successfully fixed RMAN backup issues. Developed solutions to fix various issues with scripts for RMAN.
• Patching Oracle and GRID Binaries using Opatch Utilities.
• Planned the setup and provide continuous support to the clients and ASM on SuperCluster. Adding and dropping disk from ASM.
• Upgraded Oracle databases from 11.2.0.4 to 12.1.0.2.
• Administration of Oracle 11gR2 RAC (2 Nodes) databases.
• Converting Single instance to RAC database and RAC database to Single instance.
• Administration of Oracle Active Data Guard Standby and Snapshot databases.
• Cloning of Oracle 11gR2 Database using RMAN Duplicate.
• Successfully implemented RMAN backups using Multisection for big file tablespaces.
• Developed scripts to generate reports on security issues on database servers and in databases.
• Developed and implemented script to cleanup files under adrci in 11g database servers. Deployed the solution globally in Ford.
• Wrote documents and did presentations to Global DBA team. Wrote document on handling TDPO RMAN tickets, to perform DB migration from Windows to Linux and Linux to Linux.
• Lead project to reduce incidents. Developed strategies to reduce incidents.
• Provided KT to DBAs globally on various DBA activities.
• Piloted 12c OEM agent installations and migrations for multiple hosts in one go.
• Participate in evaluating databases for security problems prior to internal and external audits.
• Facilitate and Lead meetings.
• Developing and testing database upgrade to 12c.
• Lead Problem Management team for all Oracle Databases groups.
• Took up the expert role to perform 11.2.0.4 database upgrades for number of sites and applications.
• Worked with Confidential and internal managers to brainstorm on 12c courses. Successfully arranged for Oracle to host training at Ford for 55 Oracle DBAs.
• Brainstormed with DBAs and Engineers to developed solution for GDIA's Attunity requirement.
• Provide support to more than 3000 production databases. Render on-call support for 24 / 7 operations on a rotation basis to ensure functionality and efficiency.
• Implement policies and procedures for ensuring the security and integrity of the Oracle databases.
• Perform other duties as assigned.

Environment: Oracle 12c, 11g, 10g, Suse Linux, Windows 2003, Sun Solaris (2.8), HP-UX 11.0, 11i, IBM AIX 4.3, Oracle 9i.

Confidential, Schaumburg, IL

Oracle Database Administrator

Responsibilities:

• Administer and support the continuous operations of Oracle enterprise server databases running on UNIX and Windows environments.
• Support Oracle ERP 10.7, 11.0.3, and 11i databases.
• Utilize RMAN and Veritas Netbackup to design / implement back up methods and disaster recovery strategies.
• Implement DR solutions using Data Guard.
• Use export / import, RMAN, Veritas Netbackup3.4, and EMC BCV copy process to refresh non-production databases.
• Support in excess of 1000 production databases. Render on-call support for 24 / 7 operations on a rotation basis to ensure functionality and efficiency.
• Implement policies and procedures for ensuring the security and integrity of the Oracle databases.
• Created 9i Data Guard environments for two production datawarehouses.
• Worked on Oracle migration projects. Performed Database migrations from 8.1.7/8.0.4 to 9.2.0.5 Version with oracle 9i new features.
• Played an instrumental role in the upgrade of 11.5.5 Oracle ERP application to 11.5.8 on HP-UX. Precloning and postcloning. Implemented Autoconfig feature. Upgrade to 9iAS 1.0.2.2.2. Applied patches using adpatch and admrgpch. Used AD tools like adconfig, admrgpch, adclone, adchkcfg, adpatch, adadmin, and adctrl.
• Installed Oracle 9i. Performed database creation and setup on Sun OS. Implemented 9i features like automatic undo management, LMT’s, spfile, dynamic SGA and default temporary tablespace.
• Developed a Capacity Planning solution for analyzing database growth.
• Carried out performance tuning of Informatica Datawarehouse database using Statspack.
• Refreshing the Production over the Dev, Staging, and UAT and keeping the Test Instances in sync with other instances.
• Spearheaded migration of Oracle on HP-UNIX.

Environment: Sun OS (2.8), HP-UX 11.0, 11i, IBM AIX 4.3, Oracle 8i, Oracle9i and Oracle 7.3.4, Oracle ERP 11i, 11.0.3, 10.7.

Confidential, Chicago, IL

Database Analyst

Responsibilities:

• Worked in conjunction with Database Administrator in the design, documentation, maintenance, and administration of the internal databases on SQL Server.
• Provided short- and long-term database strategic planning and implementation for Information Services Department.
• Utilized MS Access and SQL Server on a Windows platform to develop applications.

Environment: Microsoft NT Server, SQL Server 7.0, MS Access