SUMMARY:

• 25 years IT experience and 2 years of SAP Support (BO, BW, ECC) with good concepts of Hana 1.x and 4+ years of Exadata experience. Install/Upgrade and Migration, trouble shooting of Oracle. Well experienced in Process Methodology and Process Tuning. Handled 500+ databases in all. Installed and configured 11g SPA.
• 10+ Years of end to end performance tuning in working with developers of various technologies as well as various stake holders.
• Strong Experience In Migrations, Consolidations and Performance Tuning.
• Extensively Involved in Data Quality and Purging Process Implementation.
• Implemented Security Compliance, Encryption and provided Security Guidelines and Auditing
• 20+ years in Oracle (7.x/8.x/8i/9i/10g/11g/12c), 20+ years Oracle DBA, 3 years Oracle Apps DBA (11.x/12c/11i), 2 years UNIX Admin experience on NCR platform, 2 Years AIX experience. 6 Years Datawarehousing experience and around 6 years of Oracle Development and performance tuning experience. A couple of years of Windows NT/XP experience.
• Very Well experienced in Solutions Architecture, Development and Production support.
• 18 years experience in Various Flavors of UNIX mostly Solaris, HP, AIX. Around 8 Years experience handling Oracle Databases on Solaris Platforms. 2 Years Retail Industry Experience. Sound Logical and Physical Oracle Database Design skills.
• Extensively involved in Data Encryption, Data Masking and Developing Governance processes for protecting critical data.
• Implemented Oracle Asymmetric/Symmetric Replication. Implemented Shareplex for Oracle replication. Did Database Migration from Oracle 7.x to 8.x and 8i. Upgraded from Oracle 8.1.6 to 8.1.7. Did 8i to 9i Migration and 8i to 10g Migration and 9i to 11g Migration. Upgraded from 11.2.0.4 to 12c. Did a lot of performance tuning in 9i, 10g, 11g, 12c. Recent experience in Database Migration to 12c.
• Currently Supporting 12c in Production.
• Implemented more than 30 RAC installations.
• Implemented Oracle Parallel Query Option, Parallel DML and tested and evaluated Oracle Parallel server and the application impact of implementing Oracle parallel server. Implemented 9i RAC/10g/11g/12c RAC using RAW as well as OCFS/GPFS. Installed and Configured 9i/10g/11g/12c RAC, Connect Time and Total Application Failover and provided tuning and backup solutions. Very Strong in Dataguard and performance tuning. Did a lot of remote implementations where graphical user interfaces like enterprise manager or any such tools cannot be used because of security and firewall considerations.
• My Major strength over the years has been in performance tuning. Largest DB handled was 140+ Terabytes.
• Implemented and has very sound knowledge of 11g and 12c Dataguard.
• Frequent monitoring of the database to look for any resource drain as well as any runaway processes effecting the system response time.
• Scheduled jobs using the job scheduler as well as UNIX cron.
• 4 years experience in supporting high number of user connections. Involved in Data loading using Oracle SQL*LOADER.
• 3 years experience in implementing transaction registering mechanism using Oracle’s DBMS APPLICATION INFO. Implemented JDBC. Supported Applications using Java and PHP.
• 6 - 7 years experience in Bourne/Korn/C/bash shell scripting and some Perl also.
• 8 years experience doing Database Sizing, Capacity Planning and building Very Large and High Performance Databases. Very Much involved in Benchmarking and Server selection.
• Implemented High Availability solutions viz. Hot Standby, Replication and Oracle Parallel Server. Used VCS and EMC. Used Raid 0+1 and Raw Devices apart from ufs and nfs.
• 6 years experience in building and maintaining Oracle Datawarehouses/Data Marts.
• I have a comprehensive and in-depth experience in the System Development Life Cycle and the role of Database in this process.
• Experience in mentoring junior DBAs and documenting the dba standards/ work book. Involved in documenting the application as I consider it as one of the most important things to do. 2 years experience in Data Modeling.
• Excellent project planning, budgeting and prioritization skills.
• Experienced in SAP in sapinst, reorg, Early Watch Reports Analysis, SAP DB Cockpit, SAP DB Patching, Backup/Recovery etc.
• Apart from these, the value additions I bring to the table is, in terms of a vast experience coupled with a complete commitment to the project at hand and have a US Citizenship.

SKILL MATRIX:

Unix

Shell Programming

Oracle

Oracle DBA

Datawarehousing

DB Design

High Availability

Standby/Dataguard

Oracle 10g/11g Streams

RAC

Oracle Apps

Oracle Advanced Security, DB Vault, Audit Vault, Data Masking, VPD, RBAC

Data Architect

SAP 6.x/7.x

Exadata X2-2/X3-2/X6-2/X7-2

Oracle Fusion Middleware(SOA, Siebel,UCM, OBIEE)

Exalogic

OEM 12c

TECHNICAL SKILLS:

Operating Systems: Sun Solaris 8, 2.6, 2.5, HP-UX, AIX, AT&T System V, Red Hat Linux, Windows NT/95/XP/2003, XENIX and MS-DOS

Programming Languages: Java, PL-SQL, SQL, PERL, UNIX shell, Lighthouse, Network Shell and Bladelogic, Splunk, Sitescope, Nagios.

Databases: Oracle 11g, 10g, 9i, 8i, 8.0.5/8.x, 7.x, 6.x, 5.x, 12c RAC, 11g RAC, 9i RAC, 10g RAC, flashback, Active Dataguard, Real time apply. Exadata X2 and Exadata X3.

Oracle Tools: ADRCI, Developer 2000, Designer 2000, SQL*Loader. Remedy, Exalogic, Oracle Fussion Middleware (Siebel and SOA).

Oracle Applications: Oracle Applications 11.0.3, 11i, SAP 7.1, B.O, Hana 1.x/2.x.

Applications/Patching Tools: Adautocfg, adaimgr, adadmin, adpatch, adrelink, adclone.pl, patchmgr, opatch, QDPE.

Tools: & Utilities: Oracle DataGuard, Flashback, Quest SharePlex Replication, I/Watch, SQL Lab Xpert, Live Reorg, Quest Central, Spotlight, Oracle Streams, Oracle Replication, Microsoft Projects, Veritas Quick I/O and Oracle Enterprise Manager, Veritas Volume Manager, Veritas File system Veritas Cluster Server 3.5.

Domain Knowledge: Finance Accounts, Human Relations and Administration HealthCare, Telecom.

Hardware: Sun (E4500, E6500, E10K), Work Stations, IBM Compatible PCsHP ‘D’, ‘K’, ‘N’, ‘V’ Class servers, NCR-S50, RS-6000, Windows 2003 Server

Case Tools: Erwin, Designer 2000, Oracle*CASE

Management/Leadership Skills: Lead DBA, DBA Architect, Backup Systems Administrator, Technical Manager, People Manager

PROFESSIONAL EXPERIENCE:

Confidential, Newport Beach, CA

Sr. Oracle Exadata DBA Architect

Responsibilities:

• Performance Tuning of Highly Active 200+TB Database with Mixed OLTP and DSS workload on Exadata x7-2 and 11.2.0.4 and 12c Databases.
• Working with 8 Exadata half and full Racks.

Confidential

Sr. Oracle Exadata DBA Architect

Responsibilities:

• Design and Develop Roadmap for Migrating and Consolidating 100+ Databases to Exadata on 12c. Working with 2 Exadata half-racks.
• This is an ambitious project of Consolidating many applications.
• Played key role in Performance Tuning and Evaluation and implemented Security features of Transparent Data Encryption and Fine Grained auditing.
• Tuned a lot of SQL generated by Various Homegrown Applications.

Confidential, Worcester, MA

Sr. Oracle Exadata DBA Architect

Responsibilities:

• Migrated and Consolidating 8+ Databases to Exadata on 12c.
• Working with 2 Exadata half-racks.
• This is an ambitious project of Consolidating many applications.
• Did Db Upgrade from 11g to 12c and non-RAC to RAC.
• Played key role in Performance Tuning and Evaluation and implemented Security features of Transparent Data Encryption and Fine Grained auditing.
• Tuned a lot of SQL generated by Peoplesoft.
• Implemented Real Application Testing.
• Implemented DB Resource Manager features of DBRM and IORM.
• Functioned as a DMA.

Confidential, Chicago, IL

Sr. Oracle TDE DBA Architect

Responsibilities:

• Completed TDE Implementation of 120+TB Database on Exadata Half-rack.
• Implemented TDE using Various Approaches as a solutions architect chief being alter table move and online table redefinition.
• Developed and Implemented DB Triggers and Materialized Views for Delta Capture.
• Customs developed Approach and helped redesign application to store data differently.
• Implemented Processes for Data Purge and Data Quality.
• Used Exalogic.

Confidential, Calverton, MD

Sr. Oracle Exadata DBA

Responsibilities:

• Was Subject Matter Expert and lead Exadata X3-2 half-rack DBA and was the key person in the technical architecture team representing the database.
• Consolidated All 32 the Project's Databases to Exadata.
• Monitored and tuned Siebel SQL in EIM. Used SQL Plan Management extensively at DB level.
• Tuned SQL in OBIEE, Seibel, UCM, Identity Access Management, SOA PS5 and PS6 and other Oracle Fusion middleware COTS.
• Completed exacheck analysis.
• DBA activities calendar maintenance.
• Installed Oracle Binaries, Created Database in an Exadata Environment
• In Exadata X3 did exachk, exaconf.sh, DB Migration, developed strategies for cell server addition, metrics monitoring, DB stats and backup. used patchmgr to patch cell servers, qfsdp, qdpe, opatch for patching db servers. DataGuard Creation as per Oracle MAA.
• Configured Database Vault, Audit Vault and did Web Content Interval partitioning of UCM Securefiles Data with encrypt option. Implemented Federal DISA/NIST Security Guidance and Database Stigs.
• Maintained SOA DB, did partitioning, purging, indexing, performance troubleshooting SOA DB. Enabled TDE and used wallet and store Data as encrypt BLOB for SOA and UCM data.
• Implemented Data at rest using Transparent Data encryption, RMAN security and Network Security. Did Re-Key of tables. Implemented Data Masking.
• Upgraded from 11g to 12c and Maintaining 12c in Production. Was the Subject Matter Expert for Upgrade and patching.
• Implemented Virtual Private Database.
• Used OEM 12c. Maintained 12c Dataguard environment.
• Have automated a lot of DBA tasks by writing many shell and sql scripts.
• Implemented Database Security Compliance Standards using Database STIGs.
• Mentored Junior DBA's during end to end tuning and configuring as per best practices.
• Played a critical role in documenting and Baselining.
• Did Data Modeling for Home Grown Bio Metrics Application.
• Played the role of Database Architect in Security Products Implementation, Performance Management and Exadata Compute Nodes/ Cell Server/ILOM Maintenance. Basically, Most of my time was spent on this project in switching between a Senior Oracle DBA and an Architect. Played the role of an Oracle Subject Matter Expert to perfection. Did a lot of Logical Modeling.
• Functioned as a DMA.

Confidential, Scottsdale, AZ

Sr. Oracle DBA in SAP environment

Responsibilities:

• Configured Exadata Quarter Rack.
• Completed Exacheck of 6 2-node RAC clusters from CRS, network, storage perspective.
• Completed patching of oracle database and CRS stack.
• Extensively analyzed AWR and RAC logs.
• Extensively Analyzed node evictions.
• Supported Other Oracle projects on Exadata X2 and X3. Recovery testing, and Dataguard creation.
• In Exadata X3. Did exachk, exaconf.sh, DB Migration, cell server addition, metrics and DB stats, DB List Partitioning, Scripted RMAN for backup.
• Migrated Oracle Databases from Windows to Linux.
• Performance optimization with SQL query rewrite and involved in process tuning. Re-Architected the process by doing reverse engineering first. During this process did logical modeling.

Confidential, Oklahoma City, OK

Sr. Oracle DBA

Responsibilities:

• Oracle RAC build and maintenance of 30 4-node 11.2.0.3 RAC clusters.
• Troubleshooting of CRS and RAC logs. Extensively analyzed AWR, and RAC Logs.
• Implemented Data Cleansing and Data Quality Processes.
• Involved in Database wide wait tuning.
• Did Active Database cloning on 11.2.0.3.
• Implemented TDE.
• Mentored Junior DBA's as to the Best Practices for Configuration and Performance.

Confidential, Cumberland, RI

Sr. Oracle DBA

Responsibilities:

• Streams performance Troubleshooting in a 10.2.0.4 downstreams capture/apply and 11.2.0.3 RAC Downstreams Capture/apply. Source is in 10.2.0.4
• Extensively analyzed awr, strmmon/utl spadv, RAC logs, alert.log and streams Data Dictionary extensively.
• Involved in Database wide wait tuning. Worked extensively with Client DBA's and Oracle Support.

Confidential, Austin, TX

Sr. Oracle DBA

Responsibilities:

• One 11201 4-node RAC Build with ASM and 1 2-node 11201 RAC One Build with ASM.
• Upgrade Both environments from 3
• Upgrade existing 10gR2 RAC to 11gR2 RAC on 3 nodes.
• Apply Rolling Upgrades.
• Implemented TDE for Emerson energy as part of At Rest encryption.
• Worked extensively with Client DBA's and Oracle Support.

Confidential, Boise, ID

Sr. Oracle DBA

Responsibilities:

• Worked on Exadata X2 DB Migration of 5 2-node RAC clusters and 10+ regular databases.
• Extensively Involved in Data Cleansing - archival and purging.
• Did a lot of performance troubleshooting in 10g and 11gR2.
• Handled Data Guard for DR.
• Attended HANA Training and also was taking Oracle DBA Best Practices Class for the in house DBA's.
• Did Data Modeling during process improvement and schema changes.

Confidential, San Diego, CA

Sr. Oracle DBA Architect in SAP environment

Responsibilities:

• Worked on 3 2-node RAC clusters. This is an SAP and Oracle implementation. Adding 1 node to make it a 3-node cluster.
• Worked on brconnect, brspace, BR*Tools.
• Did a lot of performance troubleshooting on HP-UX, Linux and SAP 7 and Oracle 10.2.0.4/11.2.0.2.
• Applied SAP Bundle Patches using mopatch.
• Completed 15+Migration from 10.2.0.4 to 11.2.0.2 on RHEL and Oracle Enterprise Linux. Completed Migration across the landscape with strategies to de-install the SBP.
• Worked on BO, BW troubleshooting, core dump analysis. Supported BO 7.1. Well conversant with migration plan to HANA.
• Worked with SAP support and Oracle support.
• Using CMDB for Datacenter Migration between Orlando and San Diego.
• Evaluated Exadata quarter Rack for non SAP environments.

Confidential, Mountain View, CA

Sr. Oracle DBA

Responsibilities:

• Worked on 2 3-node RAC clusters and 20 dedicated databases. This is a new Oracle 11gR1 implementation from Sybase.
• Did a lot of performance troubleshooting on Solaris 10 and Oracle 11.1.0.7.
• Automated adrci, implemented log rotation, implemented incremental merge backups and scripted expdp. worked with Oracle support.
• Worked on Exadata X2-2 DB Migration.
• Did sql tuning to optimize for exadata features of smart scans, EHCC, storage indexes, index drops after revisiting indexing strategy and sql rewrite using ANSI sql and with clauses.
• This is a high volume and highly critical and concurrent environment as it is the Payment Gateway acquired by Confidential .
• Implemented TDE and also functioned as a Database Security Architect to address issues of At Rest and in Motion encryption.

Confidential, Ada, MI

Sr. Oracle DBA Architect

Responsibilities:

• 3 10gR2 and 11gR2 RAC configurations build and maintenance
• Grid control Configuration
• Streams configuration and Maintenance - Involved in conflict resolution
• Performance tuning - application and database
• Implemented Database on Solid State Disks (Flash)
• Implemented DB on Exadata(X2-2) Quarter Rack.

Confidential, Rosslyn, VA

Principal Oracle DBA Consultant

Responsibilities:

• Build 11gR1 RAC clusters with ASM and Active Data Guard with Real Time Apply and Flashback Database at alternate Data center. The environment was AIX 5.3 and Linux.
• Upgrade Oracle 9i to 11g and 10g to 11g.
• Highly critical database of 140+Tera Byte size and growing.
• 11g RAC Installation and Monitoring of three 2-node very critical databases. In total must have done 20+ such RAC on ASM with Dataguard configurations.
• Extensively involved in Data Encryption.
• Working in a very fast paced environment.
• Worked on datawarehouse access strategies of large objects.
• Resolve Performance Issues in OLTP as well datawarehouse environments.
• My role is one of a very high end advisory Capacity as well as a Direct Contributor.
• Involved in Architectural suggestions of implementing Oracle Resource Manager, Oracle Streams, Flashback Database etc.
• Implemented 10g, 11g and 9i streams for data Replication as part of database Upgrade. Provided Backup/Recovery Solution implementation. Fine tuned 11g restore.
• Implemented Materialized Views for datawarehouse aggregation.
• Documented all the activities which was big for SBA and DHS.

Confidential, Owings Mills, MD

Oracle Security Architect in an SAP environment

Responsibilities:

• Enabled Virtual Private Database and Implemented Transparent Data Encryption.
• Extensively involved in Data Encryption, Data Masking and Developing Governance processes for protecting critical data.
• Used TDE extensively.
• Ensured Databases are in compliance with HIPAA, SOX, PCI and GLBA standards. Data mostly confirmed to PHI. Currently working on Facets 4.5 and Portico Provider. Used Informatica PowerCenter and Informatica PowerExchange.
• Configured Auditing and written Auditing Guidelines.
• Provided Security Guidelines for many ODS projects
• Working in a very fast paced environment.
• Maintenance of RAC instance and databases
• Working with Oracle Streams 10.2.0.3 as well Oracle 10g CDC.
• Installed Oracle 11g and Upgraded from 10g to 11g.
• Environment is HP-UX and Linux RHEL5. Used Facets 4.5 and Portico
• Used SAP 7.1.
• Used Oracle Text for Text based searching. Used ctx ddl, ctx output packages, indextype ctxsys.ctxcat indexes, automatic index synchronization.

Confidential, Austin, TX

Lead Oracle DBA/Oracle Architect

Responsibilities:

• Installed, configured and maintained 5 2 node 10g RAC clusters on HP/Linux SLES9/RHEL4/Solaris/AIX 5.3. Worked with IBM LPAR’s.
• Maintained data Marts and Datawarehouse.
• Involved in suggesting alternate DB/Application designs and selection criteria for Hardware as also working on OS à applicationà database certification conformance.
• Provided direction to DBA teams
• Did capacity planning and provided Proactive Performance Monitoring and tuning solutions. Did a lot of Application Tuning. Implemented 10g Grid.
• Responsible for SLA maintenance.
• Handled/Maintained Dept of Family Protection Services Database in the State of Texas.
• Worked on Apps 11.5.x and extensively implemented 10G table/Index Partitioning.
• Migrated from Windows to Linux.
• Used Facets Application and databases.
• Secured the Oracle Database access and played a key role in Database Security Architecture and Implementation.
• Functioned as an Architect and was also maintaining schemas pertaining to Disaster Relief.