SUMMARY:

• US Citizen and qualified Confidential with over 25 years IT experience and 2 years of SAP Support (BO, BW, ECC) with good concepts of Hana 1.x and 3+ 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.
• Implemented Security Compliance, E Confidential yption 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 Confidential 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, Confidential, 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 E Confidential yption, 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. I mplemented 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.
• Did a lot of trouble shooting Confidential

TECHNICAL SKILLS:

Operating Systems: Sun Solaris 8, 2.6, 2.5, Confidential - UX, AIX, Confidential &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

Developer 2000, Designer 2000, SQL*Loader. Remedy: 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, Confidential -S50, RS-6000, Windows 2003 Server: Case Tools

Erwin, Designer 2000, Oracle*CASE: Management/Leadership Skills

PROFESSIONAL EXPERIENCE:

Confidential, Worcester, MA

Sr. Oracle Exadata DBA Architect

• Migrating and Consolidating more than 50+ Applications and 80+ Databases to Exadata on 12c.
• Working with 2 Exadata half-RACS as a start with much more to come. This is an ambitious project of Consolidating many applications.

Confidential, Chicago, IL

Sr. Oracle TDE DBA Architect

• Completed TDE Implementation of 120+TB Database on Exadata.
• 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.

Confidential

Sr. Oracle Exadata DBA

• Was Subject M Confidential er Expert and lead Exadata X-3 half-rack DBA and was the key person in the technical architecture team representing the database.
• Monitored and tuned Siebel SQL in EIM. Used SQL Plan Management extensively Confidential 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 e Confidential ypt 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 e Confidential ypt BLOB for SOA and UCM data.
• Implemented Data Confidential rest using Transparent Data e Confidential yption, 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 M Confidential er 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 M Confidential er Expert to perfection. Did a lot of Logical Modeling.

Confidential

Sr. Oracle DBA in SAP environment

• 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
• 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

• 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.
• 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

Sr. Oracle DBA

• 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

Database Architect in SAP

• Responsible for Compaq merger (Server/Database Consolidation), database uptime, involved in capacity planning and involved in designing and implementing High Availability needs.
• Involved in Selection of Hardware and gave a lot Application DBA support. Implemented DBMS APPLICATION INFO for Transaction registering and implemented Hints in a Cost based Optimizer environment. Lead the architecture groups.
• Provided the client with Backup/Recovery and High Availability Solutions. Implemented Data Guard.
• Did a lot of Database Migration. From COBOL to Oracle and other Flat files to Oracle.
• Extensively involved in Production DBA Support. Worked with ‘K’, ‘N’ and ‘V’ class servers. Worked with Confidential Super Dome.
• Database was implemented using AutoRaid. Did the Database design for the comcat databases which are slated to account for 70% of Confidential ’s revenue.
• Written Shell Scripts and did PL/SQL coding.
• Designed and implemented Oracle Advanced Replication.
• Installed, configured and worked with 9i RAC.
• Did a lot of application and Database/OS tuning. Largest Database was 1.6 Terabytes.
• Did Application Development using PL/SQL and data feeds were from SAP R/3.

Confidential

Lead DBA/Data Architect.

• Completed Migration from 7.3.4 to 8.1.6 on 5 servers. On these Upgraded from 8.1.6 to 8.1.7.
• Migrated from Sybase 10 and Mysql (SOLID) database to Oracle 8i using external loading of text files and migration workbench. These were carried on Solaris 2.x platform.
• Installed 9i on a development server. Installed and Maintained Forms 6i. Led the effort in redesigning the database architecture. Involved in strategizing the Data access strategies for large and heavily used tables. Developed a lot of PL/SQL Code. Tuned a lot of PL/SQL Application Code.
• Did a lot of shell scripting using Korn Shell.
• Implemented Veritas Quick I/O.
• Configured and Implemented Veritas Cluster Server.
• Implemented Oracle Parallel Server.
• Studied the database for Parallel server implementation versus Veritas Cluster Server configuration. Implementing Replication and High Availability needs. Implementing EMC and Configured and Implemented Veritas Cluster Server. The databases involved are very critical with a very high number of persistent database connections. Worked with Shareplex. Evaluated the application effects of implementing Oracle Parallel server.
• Implemented Table/Index Partitioning and Multi Threaded Server Option of the Database. Capacity Planning and Optimal setting of Storage Parameters.
• Created and Maintained Hot Standby. Given Development DBA support and Optimized SQL. Did a lot of performance tuning in an OLTP environment. Used Erwin. Built the datawarehouse database from Production.
• Designed and implemented Oracle Advanced Replication.
• Involved in Datawarehouse requirement gathering and implemented Star Schema.
• Worked on Apps 11.0.3/11.5.4. Was on 24x7 Production support on-call. Application used Tuxedo.
• Given a lot of Development DBA Support.

Confidential

Senior Production DBA.

• Capacity planning
• Database Sizing
• Database Migration from 7.3.3 to 8.0.4.
• Converted from COBOL to Oracle 8.
• Performance Monitoring and troubleshooting
• Implemented Multithreaded Server and wrote scripts to monitor the MTS.
• Implemented Oracle Asymmetric and Symmetric Replication.
• Did Shell scripting and a lot of performance tuning both Confidential UNIX and Oracle level. Used TOP and SAR extensively along with Oracle Data Dictionary monitoring. Standardized DBA practices. Was actively involved in Junior DBA mentoring.
• Implemented and maintained Oracle Standby Database. Used Erwin for Logical design. Functioned as a Sr. DBA for their Data warehouse. Involved in Datawarehouse requirement gathering and implemented Star Schema. Worked on Confidential, Solaris and Confidential -UX and AIX platforms. Handled Databases of various sizes, largest being 3 Terabytes.
• Installed and Maintained Confidential -UNIX. Functioned as a backup System Administrator.
• Migrated Oracle Database from Windows NT to UNIX.
• Created Datawarehouse database and partitioned Objects implemented parallel DML.

Confidential

Sr. Oracle Datawarehouse DBA.

• Handled very large databases and used Oracle Enterprise Manager.
• Did Capacity Planning, Database Sizing. Worked with the logical model team. Involved in the Design of Summary Level abstractions in the Datawarehouse Design.
• Did physical database design, implemented the logical model into Oracle Schema. Used Erwin for Data Modeling. Did Periodic Database Refreshes.
• Extensively implemented Oracle 8.0.4 features, Used Star Schemas, used Object Partitioning, Index Organization, local indexes, Parallel DML. Implemented the DB on Confidential Raw volumes. DB size was 1.6 Terabytes on Confidential -UX 11 and other Gig databases on Solaris 2.4/2.5. Written Oracle Stored Procedures.
• Was the primary Database Architect in sizing the Server and Database, Building the Datawarehouse and populating the Datawarehouse.
• Functioned as a Sr. DBA for their Data warehouse. Involved in Datawarehouse requirement gathering and implemented Star Schema. The Front-end for generating SQL was Business Objects and for Data extraction Prism was used.
• Did a lot of Performance Monitoring/Analysis and Tuning and Standardized DBA practices.
• Was the Primary Datawarehouse DBA. Also worked on Oracle 10.7 Apps as Apps DBA.

Confidential

Senior Production Oracle DBA

• Handled 20 servers and around 30 databases and did replication and handled Oracle Financials databases. Given on call technical support to production databases of size 200 Gigs.
• Handled Hot Standby database. Maintained Snapshots, Snapshot logs and Refreshes for the Main Production server to a Replicated Server for reporting purposes. Troubleshooting and server database uptime was one of the responsibilities. Used explain plan and TKPROF to good measure in tuning the application on all the production systems.
• Handled on a regular basis Rollback segment management, Transaction Management.
• Helped developers optimize SQL statements. Was involved in DB design Confidential the application level. All the servers are on Solaris 2.5/2.6 platforms. Supported Oracle Databases Remotely. Used Erwin. Extensive Solaris experience. Did a lot of shell scripting using Korn Shell and C Shell.