Summary:

Seasoned and Certified Oracle DBA in both OLTP and DW/BI landscapes with over two decades of experience from Oracle version 6 thru 12c RAC using ASM supporting VLDB. Well rounded experience in design, development, testing, implementation, administration, and management of custom built, ERP packages like PeopleSoft and BI applications like OBIEE using both normalized and dimensional modeling techniques, analytical functions, design of dimension and fact tables, efficient ETL design, database partitioning, query rewrite, and parallel processing. Installed and configured Grid Infrastructure and RAC databases in line with the best practices. Delivered end to end implementation of disaster recovery architecture with extensive testing of failover and switchover features. Architected efficient reporting solutions by leveraging the strength of STAR schema, dimension and FACT tables, SCD, surrogate keys and bitmap indexes. Solid understanding of Oracle internals on various locking strategies, recovery principles, CBO behavior, parallel processing, cache fusion, replication techniques, etc. Mentored client representatives with documentation and coaching to enable them in maintaining a stable and healthy system. Configured end-to-end monitoring framework using OEM Grid/Cloud Control and UDMs to proactively raise alerts and implement corrective actions. Improved performance of business applications by optimizing resource utilization, minimizing IO required to assemble a result set, leveraging the strength of parallel and distributed processing, and eliminating redundant operation. Adept in leveraging the strength of engineered systems like Exadata by utilizing the capabilities of smart scan, column projections, predicate filtering, storage indexes, HCC etc. and balancing the workload between the database server and the storage cell nodes.

Expertise:

• Well rounded database architect with hands-on deep level expertise in designing highly available database infrastructure to meet the demands of flexible business application framework involving a mix of OLTP and data warehousing workloads.
• Highly experienced in multiple disciplines within the Oracle RDBMS landscape including RAC 10g,11gR2, and 12c Data Guard Physical Standby, Logical Standby, Snapshot Standby, Active Data Guard, DG Broker, role switching, Near Real-time Apply, etc. CDC Streams Real Application Testing RAT SCAN TAF RMAN Backup and Recovery procedures Database Cloning Work Load Management Grid Infrastructure ASM and multipath technologies HA configurations expert shell, SQL, and PL/SQL scripting and automating mundane DBA tasks.
• Specialist in database performance tuning using best practices and implementing performance improvement measures at application, database, host, and storage tier. This includes the discovery of the weakest link in sub-optimal performance using various tools like OS-Watcher, AWR, ASH, HA logs and traces, tkprof determining Global Cache contention, run queue levels, CPU, memory, and I/O utilization, queuing up of parallel slave processes within the database, resource contention in the database, various wait events, timed model statistics, sub-optimally performing SQL statements, and utilization of DB-TIME leveraging the strengths of SPM, SPA and paying due diligence in assessing new execution plans before enabling them. Always pay attention to the identification of the root cause and its remediation rather than implementing short term solutions to suppress the symptom.
• Highly proficient in tuning SQL statements by first reviewing the construct of the statement to eliminate redundant joins, improper co-relationship in sub-queries, in-efficient combination of outer and inner joins, unnecessary enforcement of cursor based row by row processing, and redundant retrieval of data blocks thoroughly reviewing the execution plans to ensure existence of right indexes, leveraging partitioning, using analytical functions to optimize sub-queries used in evaluating group functions like max, min, and sum using parallel slave processes wherever appropriate and ensuring end-to-end parallelization of the execution plan implementing stored outlines, SQL Profile, set based processing, function based indexes, virtual columns, hints, sub-query factoring, query rewrites, inline views, Top-N SQL, provisioning of missing joins and predicates, join simplification, pre aggregation and summarization of data, and optimal filtering of result set at the earliest possible stage in the execution path. Leveraged the strength of PL/SQL where non-procedural SQL hits a dead end like in case of range lookup .
• Extensive experience in optimizing large multi TB data warehousing processes including ETL loads, designing star schema and leveraging the performance edge of bit-mapped indexes in star transformation/joins. Well versed with the design and maintenance of dimension and fact tables, leveraging the strength of surrogate keys in maintaining slowly changing dimensions aka Type-2 dimensions. Identified several opportunities of performance improvements by designing mini dimensions, Fact of Fact tables, etc. Implemented various partitioning method and schemes to leverage the strength of partition pruning and parallel processing of partition-wise joins. Designed and implemented materialized views with appropriate refresh type and frequency of refresh to facilitate query-rewrite and incremental data load.
• End-to-end expertise in facilitating database monitoring and health check, high availability and optimal performance using various tools like OEM Grid Control, RAC-Check, CVU, User Defined Metrics, custom alert mechanisms, automation of pro-active corrective actions.
• Extensive experience in implementing database security, Fine Grained Auditing, Virtual Private Database VPD , load testing, database upgrades, custom procedure using DBMS STATS to maintain database statistics, setting up list of tasks for all team members to meet future requirements, implementing scheduled installation of PSU, resource planning and projection for future database requirements, and implementation of latest DBMS features towards effective management of databases.
• Analysis of historical resource utilization data captured by tools like AWR and ASH generated from OEM Grid Control to identify periods of peak resource utilization, identifying the top resource consuming processes, wait events, resource contention, etc. and resolving them by applying a holistic performance tuning approach involving technical and functional solutions.
• Implementation of automated procedures for Database backup, recovery, and cloning using RMAN, shell scripts, NetBackup, EMC Replication Manager, snap-clone, and RMAN Duplicate techniques with built-in validation and notification routines.
• Design, testing, and implementation of DR solution for the database tier with minimal loss of data. Configured multiple standby databases from primary databases using active data guard. Implemented automated routines to monitor gaps in log shipping and apply lag and generate alerts if need be. Configured Data guard broker and integrated the components of data guard environment with OEM Grid Control. Provisioned Active Data Guard copies of primary database to reporting environments and facilitated automated procedures to turn the apply process on/off as needed. Tested switchover, failover and failback of primary and standby databases. Automated the process of converting physical standby database to snapshot standby database back and forth. Used snapshot standby in conjunction with RAT and SPA to proactively assess environmental changes, version upgrades, etc. and analyze and resolve performance regressions.
• Adept at understanding logical data model and converting it to a physical data model to comply with all the data definitions, integrity constraints and relationships at the physical layer. Additionally, leveraging the strength of elements in the physical layer like isolating sub-types from logical model into separate tables, indexing, partitioning, parallel processing, normalized/star schema design, materialized views in conjunction with query rewrite, stored procedures, advanced compression, and other techniques to ensure optimal data processing.
• Deep level understanding of elements at the CRS aka Cluster Ready Services / Clusterware layer and expertise in troubleshooting database and cluster issues associated with architecture performance connectivity backup and recovery security and administration.
• Well versed with the concepts of Oracle's engineered systems and distribution of workload between the DB server and the storage cell nodes using smart scan, column projection, predicate filtering, storage index, bloom filter, HCC, and other techniques.
• Software: Oracle RDBMS, RAC, ASM, OEM Grid Control, DBCA, DBUA, NETCA, RMAN, Data Guard , AWR, ASH, SQL Profile, ADDM, Golden Gate 10.4, Advanced Replication, FGA, Designer 2000, load runner, Weblogic, Web-sphere, JAVA, XML, JVM, JDBC, ODBC, Autosys, ControlM, PL/SQL, Tuxedo 6.3, 6.4 , HP UX 10.20, 11.0, IBM AIX 3.5, 4.2, 5.0, NT, Linux 4,5 , Peoplesoft 5,6,7,8,9 HRMS, FINANCE, EPM, PORTAL , People Tools, Application Engine, Integration Broker, Erwin/BPWin, Autosys, UC4, BMC Patrol, Foglight, LDAP, SiteMinder, STAT, HP Openview, IBM Data Stage, COGNOS, Data Protector, TSM, OBIEE 10g/11g, BI Publisher, Informatica 9.0, Net-Backup, EMC Replication Manager, EMC PowerPath, EMC Replication Manager.
• Hardware: Intel Xeon x86 64, HP PA-RISC and ITANIUM, IBM RS6000, Sun Sparc II, IBM mainframes, DEC alpha, Windows NT workstation/server, IBM and Unisys mainframes, EMC Symmetrix, HP MC Service guard, IBM high availability cluster, Cisco CSM WS-X6066, F5 BIG-IP, SLB.
• Languages: C, COBOL, Korn Shell, Bash, SQL, PL/SQL, SQR, JAVA, XML, HTML

Work Experiences

Confidential

Senior Oracle Performance DBA

• End-to-end implementation of Oracle 11gR2 RAC and BI infrastructure in support of PeopleSoft Finance, CRM, Portal, HCM applications on the OLTP side and OBIEE, ESSBASE, Informatica, BI publisher on the data warehouse side. Deep involvement in installation, configuration, and upgrade of 11gR2 RAC, 12c RAC, Grid Infrastructure, RMAN backup and recovery procedures, Active Data Guard, 11gR1 and 12c OEM Grid Control, and maintaining optimal performance across the entire framework. Migration of the legacy PeopleSoft environments from Windows/SQL Server platform to RHEL 5/6 and Oracle 11gR2/12c platform.

Previous assignments/responsibilities:

Confidential

Lead Oracle DBA:

• Recalled for continuation of effort performed before Confidential listed below.

Confidential

Senior Oracle DBA:

• Implemented Oracle RAC architecture 10g/11g in support of multiple custom applications.
• Tuned performance of various OLTP and data warehouse applications.
• Scripted procedures to consistently implement patches and upgrades across the board.

Confidential

Lead Oracle DBA:

• Implement and support a 2TB data warehouse environment and several large OLTP environments PeopleSoft Finance, HCM, CRM, and ELM applications used by 65000 end users implemented on multi-node Oracle 10.2.0.4 RAC environment on HP PA RISC, HP ITANIUM, and 64 bit x86 clusters using HP-UX 11.23. Supported Enterprise Data Warehouse environment using IBM Data Stage and COGNOS.
• Provided DBA support in all areas Install/Upgrade of CRS and RDBMS, Backup and Recovery, cloning of databases, automating DBA tasks, system and application performance tuning, monitoring and alert generation, capacity planning, and DR implementation.

Confidential

Peoplesoft Architect:

• Provided technical expertise and best practices for capacity planning, set up the infrastructure and operational strategies for a global implementation of Peoplesoft HRMS 8.8, FINANCE 8.8, and SPRO 8.8 on AIX 5.1, Win2K, using Oracle9i RDBMS, RMAN, DataGuard, Websphere 5.1, WBI, MQ series, Peoplesoft Integration Broker, JMS, WBI adapter for Peoplesoft, and component interface.

Confidential

Peoplesoft Admin and DBA:

• Provided infrastructure and application management support to implement Peoplesoft HRMS 8.3, PORTAL 8.4, and EPM 8.1 for a large volume of end users in an environment consisting of HP-UX 11.0, Windows 2000, Oracle 8i, PeopleTools 8.1,8.4 , Weblogic 5.0 and 6.1, LDAP, and SiteMinder.

Confidential

Lead Oracle DBA and PeopleSoft architect :

• As a technical architect and the lead DBA, implemented an integrated ERP solution using Peoplesoft financial and HRMS, Oracle8, HP UX 10.20 and 11.0 running on K and V series, IBM AIX 4.2, 5.0 running on S80 and SA70, Tuxedo 6, and Weblogic 5.1 supporting a widely distributed user environment. Applied numerous upgrades Tax, Maintenance pack, bundles, application upgrades etc. since version 5.0 to 8.1 of Peoplesoft. Installed and administered Oracle RDBMS, BEA Tuxedo, Web logic on UNIX and Windows NT. Estimated disk capacity, designed database, disk layout and striping, high availability and fault tolerance.

Confidential

Principal Oracle DBA :

• Architected and implemented a strategy to migrate various Confidential legacy applications in IBM mainframe environment using COBOL, CICS to a distributed client server environment using HP and Sun Solaris, Oracle7 DBMS, Encina TPM, Oracle designer 2000, developer 2000 and discoverer 2000. Provided Oracle DBA support to stage and convert massive amount of legacy data.

Confidential

UNIX Admin and Oracle DBA :

• Implemented and supported custom applications for life and health department using MF COBOL, Oracle7 RDBMS and AIX operating system to process new policies, and claims from existing policies. Provided ORACLE DBA, AIX systems administration, and data modeling expertise to design and implement home grown applications.

Confidential

Senior DBA :

• Performed logical and physical database design, capacity planning, backup and recovery strategy, and integrated testing under the guidelines of Confidential.

Confidential

Senior Consultant :

• Developed and implemented an overpayment detection and benefit administration application package for Job Services of North Dakota.

Confidential

Senior Consultant :

• Reengineered a travel management package for Confidential Corporation to manage and control travel expenses incurred by its employees. Also, designed, developed, and implemented an insurance package for Minnesota Mutual Fire and Casualty.

Confidential

Systems Analyst :

• Under progressively increasing responsibilities worked on various applications materials management, payroll, human resources, and procurement to perform analysis, design, programming, DBA support, and project management tasks.