TECHNICAL SKILLS:

SKILLS: Oracle 5.x/6.x/7.x/8.x/9i/10g/11g, Oracle 8i/9i Standby Database Convert/Oracle 10g and 11g RAC and DataGuard, Solaris 2.x, SunOS 4.x (BSD), HP - UX 9.x/10.x/11.x, AT&T System V.3.x, AIX 4.x/5L, X Windows, Windows NT 3.x/4.x/XP, Sybase 4.9.2/10.x/11.x, SAP R/3 (DBA), SQL*Forms, SQL*Reports, Oracle*Names, PL/SQL 2.3.x, Toad, SQL*Net 1.x/2.x/NET, Multi-Threaded Servers, EBU 2.0/2.1.x, Veritas NetBackup, Designer 2000, PRO*C, RMAN, Advanced Replication Server, Sybase DB-LIB, CT-LIB, CS-LIB, Open Servers, NET-LIB, Transact-SQL (TSQL),Replication Server, SQL Server 2000 DTS, SQL Server 2005 DTS and SSIS, T-SQL, SQLXML, Backup/Recovery Server, Active Directory, Platinum Infopump, DB-Vision, Server Vision, BMC Patrol, Veritas NetBackup, Platinum Desktop DBA, VMS ThruNet, Quest SharePlex, Precise SQL, BusTech Datablaster, Embarcedaro DBArtisan 6.x/7.x/8.x, Quest Central, Platinum SQL Station, Erwin 4.0.1, Autosys, PVCS Tracker, Manugistics 6.x/7.x, Tivoli Library Management system, BMC SQL*Backtrack, Informatica Power Center & Power Mart, IBM DS-4800 and EMC Symmetrix/Clarion SAN, Oracle 10g/11g Streams, 11gR2 Exadata X2-8, Spatial and OBI/EE, Visual Studio 2005 BI, Exadata x2-2 and x3-2 Half-Rack, Erwin All Fusion Data Modeler v 7.x/8.x, Oracle Golden Gate 12.2.x, Migration of Oracle 11gr2 and 12c databases from AIX 7.1 to RedHat Linux 6.7 on Exadata X6-3

PROFESSIONAL EXPERIENCE:

Confidential, Buffalo, NY

Senior Oracle DBA with EXADATA/Architect

Responsibilities:

• Migrating Oracle 11g Release 2 to 12.2 on Exadata X6-3 from AIX 7.1 to RedHat Linux 6.7
• Performance Tuning
• Upgrades of Oracle 11g Release 2 to 12.2 on AIX 7.1

Confidential, Chicago

Senior Oracle DBA with EXADATA/Architect

Responsibilities:

• Re-designedthe existing PAYConnexionDatabase model and databaseson 11gr2 to migrate to Oracle 12.1.0.2.
• Upgraded the OEM 11gr2 to OEM 12.1.0.2 and removed the Database Control that no longer exists in 12c.
• Installed Oracle 12.1.0.2 databaseson a2 node RAC on Linux 6.x VMs.
• Implemented new Oracle 12c features such as Flashback Data Archiving and advanced compression and data encryption with data redaction.
• Created DBFS file systems to store SecureFiles LOBs in the tables in 12.1.0.2.
• Data redaction policies were implemented on views that were created on some of these base tables for the UI.
• Established SQL Plan baselines and froze some of the good execution plans for a later date.
• Wrote number ofshellscripts to enhance automation of the application batch scripts for report generations to thecustomers and ad-hoc UI based operations.
• Installed and configured IntegratedModeExtract andReplicatewith Data Pump for bi-directional DDL replication using Wallet authentications (Credential Store).
• TRANDATA option included in the Extract parameter for supplemental logging.
• Kept the Extract process running on both the source and the target databases with Replicat process running only on the Target server. Sequences was the only object type excluded from being replicated.

Confidential, Detroit, MI

EXADATA Tech Lead Admin

Responsibilities:

• Leverage the custom-built enterprise wide Advantage Ally project to in corporate Dealer Onboarding, Financial using third party Alfa software on Exadata x5-3 and x6-6 machines.
• A number of databases exist on the development, UAT, prod support and production servers.
• The size of the production database is currently at 14TB.
• Written a number of views, pl/sql procedures, packages and functions to facilitate an intermediate Virtual layer called the Integrated Operational DataStore that accepts all the information from a wide variety of Sources into this layer for downstream applications such as Reporting (using Cognos framework 9.x).
• Implemented and managed Real time replication of data from source to target databases using Oracle 12.2.x Golden Gate (schema level) using Extract in Integrated, ode, with data pump and Replicate in the Basic mode.
• Performance tuning of the views at all levels of core/custom development, enabled Flashback Data Archive on most of the target schemas to avoid ORA-1555 error altogether.
• Implemented Oracle 12c ILOM policies for Heat Map and Storage optimizations.
• Implemented multiple RMAN backup policies and setup DataGuard on the DR site in Texas.

Confidential

Sr Oracle with EXADATA/ RAC Architect

Responsibilities:

• Installed, configured Oracle 11gr2 Rac/non-Rac databases on RHEL 6.4 VMs and applied Quarterly PSUs using OEM12c
• Performance tuning of large 11gr2 and 12.1.0.2 databases ranging from 1TB to 7TB (OLTP, DW and Hybrids)
• Configured Logical & Physical Standby databases along with DG Broker in MAX AVAILIBILTY mode and FSFO u
• Migration of old legacy Oracle/SQL Server 2005 databases to the new Data Center
• Complete Data Center Migration of Abbott databases in Franklin Park to Confidential Data center in Elk Grove Village
• Built custom databases for both OLTP and DW from scratch using Erwin All Fusion Data Modeler v 8.3 for the “new” Confidential databases
• Configure Oracle Database Appliances v 5.x and upgraded them from 11.2.0.4 to 12.1.0.5 for infra na d grid and applied PSUs to 11.2.0.4 databases in QA and prod environments

Confidential, Chicago, IL

Sr. Oracle DBA with Exadata

Responsibilities:

• Configured silent install scripts for Oracle 11.2.0.3 Grid Infra with ASM (HA CONFIG option for Oracle Restart) and DB s/w for non-RAC databases ranging from 3TB to 13TB
• Set up Max Availability Data Guard using silent scripts with DG Broker and Observer on RHEL 6.4 VMs.
• Set up CDC on the 3-node VM cluster for interface between DB2 and Oracle on the Primary.
• Set up the CDC replication failure by setting up a unique database service for F5.
• Established DG FSFO. Support and tuning of various applications such as TU Direct, DMART, ICA, BCS and CIS. Diagnosed issues with the DBA APPLY process of Oracle 11gr2 Streams on a 4-node RAC.
• Reconfigured the Positive Rule Sets and recreated the enqueue tables. configured and managed Exadata x3-2 Half Rack. Used cellcli,cellsrv utilities to extensively manage Cell Disks, cells and iDB protocol

Confidential, Chicago, IL

Senior Oracle RAC DBA/EXADATA

Responsibilities:

• Full support of DBA activities for MAP and Content RAC databases on 10g and 11gr2 on OEL Linux 2.6.
• Performed a database upgrade of 17Tb 2-node RAC database with ASM on 10. .2.03 on OEL Linux 2.6 using the RMAN cloning of the database and performing an out-of-place upgrade to 11gr2 GRID.
• Performed diagnostics and fixed corrupt CLOBs in several tables as part of the migration.
• Set up the Map Reporter on the new 11gr2 platform to support the old maps and contents (metadata defining the maps).
• Resolved the issue of ora-08177 error during the RAT capture process of a 10.2.0.5 database employing the Map Load application. The RAT pre-process and Replay was successfully performed on an 11.2.0.3 database. This was a mandated exercise before migrating another MAP application from 10.2.0.5 to 11.2.0.3 database engine on a 2-Node RAC on OEL Linux 2.6.

Confidential, Vernon Hills, IL

Senior Oracle RAC DBA, EXADATA

Responsibilities:

• Full support for Siebel 8.x CRM and OBIEE Analytics databases on 4-node 11gr1/11gr2 RAC on Solaris 10 zones.
• Fine-tuning and Resource Control Manager implementations for OBIEE ETL Loads.
• Developed a number of custom built PL/SQL packages, Procedures and functions to support the Siebel Apps for Invoicing, Demand Planning and Filed Service Engineers.
• Developed custom built scheduler jobs to collect database statistics on some very large Siebel tables on a daily basis and for some on a monthly and quarterly basis. This segmentation was done in conformance with the Siebel Oracle team recommendations.

Confidential, Atlanta, GA

Senior Oracle RAC DBA/ Exadata

Responsibilities:

• Configured and deployed 11gr2 RAC (4-node) in Dev, QA and Prod to support PEGA Applications. Fine-tuned RAC configurations and the databases as a daily activity. Configured RAC One Node in QA for one off the Credit Card Theft Application. Built a number of shell scripts and PL/SQL modules to support the infrastructure of Complex Pega Apps especially for the Mortgage Rewrites. Tuned BLOBs prevalent in the Pega base tables. Cross-trained other DBAs on the latest enhancements in 11gr2 databases specifically for RAC. Put in place best RMAN backup/restore/recovery procedures for ASM Disk Groups and RBAL load balancer for ASM disks (all raw logical volumes). All the servers were on AIX 6.1.
• Did the SUS Migration of ASM Disk Groups in prod on 11gr2 from Hitachi SAN to IBM DS8700.
• POC on x2-2 and x2-8 Exadata for Pega Credit Banking application using cellcli interface for configuration and tuning of storage cells.
• Lead the effort as a the principle team lead for setting up base standards for the PEGA application modules and worked with the SAN team in migrating ASM disks from Hitachi SAN to IBM DS8700 without going through the long drawn procedure of RMAN backup/restore/recovery of their existing production databases that were in the size range of 1.2 to 1.4TB.
• Extensive tuning of databases and SQL queries generated by the Pega Application modules using OEM Grid Control Automatic Tuning Advisor, ADDM, AWR and ASH. Used Stored Outlines and SQL Tuning Sets to generate and freeze the optimal and highly tuned Execution Plans based on reverse indexing of some of the highly volatile indexes that performed extensive Index FFS, high Cache Buffers Chains and Cache Buffer LRU chains, reduced latch contention in the Shared Pool and modified the buffer cache based on the Buffer Pool Advisory from the AWRs
• Utilized pipelining function and the WITH operator wherever possible for tuning the large warehouse queries for one of their data warehouses that was in the size range of 1.5 to 1.7TB.
• Configured and managed x2-2 Quarter rack Exadata Machine. HCC tuning is one of the main tasks apart from the daily maintenance jobs. Created an Active DG on the Exadata m/c
• Migration of Oracle 11gr2 on Aix 6.1 to RedHat Linux 5.6

Confidential, Chicago, IL

Senior Oracle Database Administrator

Responsibilities:

• Configured Oracle 10g and oracle 11gR2 Data Guard using RMAN Duplicate - cloning
• Tuning of Oracle production databases in the range of 12TB - 17TB in oracle 10g and 11gr2
• Wrote and developed a number of stored procedures, functions and packages for application enhancements
• Set up disaster/recovery procedures in oracle 10g and 11gR2 for VLDBs using Data Guard as the back bone between the primary and the Physical Standby in Real-time recovery mode
• Upgraded 4 Oracle 9i databases to 11gR2
• Worked with the existing DBA team to put in best practices for optimal performance of the VLDBs for their 3 major applications - PACE, PARE and SecLending

Confidential, Atlanta, GA

Senior Oracle RAC Database Administrator

Responsibilities:

• Installed, configured Oracle 10g and 11gR1 Streams between two geographical disparate sites for a 3-node RAC on Solaris 2.10
• Installed, configured Oracle 10g, Oracle 11gR1 and R2 on a 6-node and 4-node cluster
• Configured ASM disks with luns up to a total size of 11TB
• Extensive tuning of Oracle 10g and Oracle 11g databases in a data warehouse environment
• Built Oracle 11gR2 OLAP cubes for Reporting

Confidential, Chicago, IL

Senior Datawarehouse Architect

Responsibilities:

• Installed, configured, and troubleshooting of Oracle RAC 11g environment. Environment was a 3 node RAC, UAT, and QA environment.
• Designed Oracle 11g OLAP models (Facts and Dimension modeling) based on existing data warehouse and data marts - 1.1 terabytes in size

Confidential, Lombard, IL

Senior Consultant

Responsibilities:

• Created a cluster of 6 nodes on RHEL 5.0 using CRS with non-RAC implementation. Configured oracle 3-node RAC with ASM using NetApps Shared Storage network on OCFS2 file systems.
• Configured and implemented APEX on oracle 10g AS using SSO and Work Flow Manager using 32 CMMs. Upgraded an oracle 10g data warehouse (1.4TB) to Oracle 11g on Solaris 2.10 platform for a client. Migrated all the data and redesigned the tables using oracle 11g Virtual partitioning techniques. Configured and implemented Active Data Guard for a Standby database using Archive log, ASYNC mode. Installed and configured OC4J BI FORMS on middle tier for another client using Virtual server methodology (port# 7777).

Confidential, Chicago, IL

Senior Database Administrator

Responsibilities:

• Installation, configuration and management of Oracle 10.2.0.3 on Solaris 2.10 in a 2-node RAC environment. Implemented Oracle10g Data Guard in a Managed Physical Standby ASYNC mode.
• Performance tuning of Oracle SDO packages for Oracle Spatial and OBI/EE applications using ADDM, AWR, SQL Tuning Advisor.
• Configured EMC Symmetrix with SRDF and BCV sync/split (FC) routines.
• Configured and implemented EMC Clarion 7.0.
• Performed proof of concept with exadata v1
• Installed and configured Grid Control and CCR for managing the nodes in the cluster.

Confidential, Westmont, IL

Senior Architect/Database Administrator

Responsibilities:

• Installation, configuration and management of 4-Node RAC and a 2-Node RAC using OCFS in Oracle 10.2.0.2 on Red Hat Linux Advanced Sever 4.x using ASM on p560 servers and rebalancing feature of cluster enabled raw logical volumes. The RAC on Linux is primarily used for managing Web hosting for Ann Taylor and Confidential . Used ASMLib to configure ASM instances on each node. Adjusted TCP receive and send buffers and gened the kernel to optimize TCP packet sizes and lower the network traffic. Optimized the Oracle instances to tune the Global Cache, LMSnn daemons etc. Created 2 production databases of 500 GB and 1TB using partitions and list sub partitions.
• Monitoring the performance using ADDM, OEM DB Console, Grid Control and DB Advisor. AWRs are run at 10 minute intervals. Optimized some enqueues such as HW, Library cache during production load tests. Eliminated hot block contention on some segments and adjusted the LOB chunks for optimal growth of some large tables having BLOBs. Re-design of some schemas for 2 and 3-dimnsional OLAP structures for reporting purposes.

Confidential, Chicago, IL

Senior Database Administrator

Responsibilities:

• Set up of Oracle Streams for real-time replication of data. The apply feature was used using the rule sets and rule groups specific to the data warehouse tables. Built five Queue tables for the Capture process. Wrote PL/SQL wrappers for the Capture, Change and Apply features.
• Configured and implemented large data warehouses using FC SAN. Used OMF in each of these implementations. Tuned parameters related to I/O throughputs such filesystem io options ect.
• Used SAN Visibility and Designer to configure and micromanage 4GPS C-Series switches.
• Data Warehouse design of Clearing IT applications such as Deliveries, FEC, RAS and Positions using AllFusion Erwin 4.5
• Reverse engineering of Oracle databases for redesign of the existing Data marts

Confidential, Chicago, IL

Senior Consultant

Responsibilities:

• Installation, configuration and management of 4-Node RAC using OCFS in Oracle 10.2.0.3 on AIX 5.3 with 1MB stripe size across all the disks on 4 disk groups. Installed and configured ASM+ on each node and used raw logical volumes with AIX CIO and file system type access
• Installation, configuration and management of 2 -Node RAC using OCFS in Oracle 10.2.0.3 on Linux (Oracle Enterprise Linux 4.5) using NFS to provide the shared storage. Setting up of kernel parameters such as kernel. shmall, kernel. shmmax, kernel. shmmni and kernel.sem in /etc/sysctl.conf file. Configured the NFS shared disks and installed and configured Oracle Cluster software. This was done for the in-house applications for report generations from the hybrid data mart
• Re-engineering, Installation, configuration and management of Oracle 9i and 10g databases in the size range of 400GB to 1.3 TB. The total number of databases are 15 in number and cater to the various applications such as accounts payable/receivables, HR, sales and reinsurance.

Confidential, IL

Senior Data Warehouse Architect

Responsibilities:

• Built a VLDB (1.4 TB) on p570 series (10 CPU 2-way) system on IBM DS-4800 SAN (RAID 10).
• The phases included the inception, elaboration, and implementation into production of the data warehouse with snowflakes for Promo Planning application from Demantra.
• Tuned the warehouse from both the Oracle and Unix perspective, setup of Advanced Replication servers (master-master configuration).

Confidential, IL

Senior Consultant

Responsibilities:

• Job responsibilities included design of large data warehouses (4 in no) in the size ranges of 5Tb to 18TB supported on 2-node and 4-node RACs.
• Configured and implemented large data warehouses using FC SAN. Used OMF in all of these implementations.
• Configured EMC Symmetrix with SRDF and BCV sync/split (FC) routines.

Confidential, IL

Senior Oracle Consultant

Responsibilities:

• Manugistics6.x/7.x modules SCNP, Order Management, CPFR, Sales Forecasting and Network Operations; Kraft Transport Systems; Ariba 7.1 application servers for Order management and shop floor MES databases.
• Configured and implemented of each phase of the Manugistics modules in Oracle 8I and 9i on AIX 5L IBM RS6000 servers.
• Configured and implemented large data warehouses using FC SAN. Used OMF in all of these implementations.
• The reports used CGI links to an SSO Portal within the OracleAS 10g server.
• Used the automated Work-load manager to administer and automatically deploy load balance across the applications in the grid.
• Extensive performance tuning of all production servers of Manugistics, Ariba and Kraft Transport Systems.

Confidential, IL

Senior Oracle DBA

Responsibilities:

• Remediation of PeopleSoft CDC from Oracle 9i to Oracle 10g. The back-end servers were on HP-UX 11.x on HP T-600 servers
• Implemented new features of Oracle 10g for Data Dumps (fast exports/imports), Dynamic Block Management tables and patched the Oracle 9i RAC to Oracle 10g platforms.
• Created multiple partitioned and hash-based subpartitioned fact tables and developed a number of Procedures, Functions and Packages to implement semi-denormalized dimension tables for aggregate, ranking and ratio-to-reports.
• Extensively used Materialized Views (with QUERY REWRITE) on Master tables along with Advanced Replication for multi-site master/master replication of data across production servers in Oracle 10g.

Confidential, Chicago

Senior Oracle/SQL Server DBA

Responsibilities:

• Senior Oracle 8i/9i, Sybase 11.x and SQLServer2000 DBA, on strategic projects for Portals, Data warehousing and middle-tier implementations. The back-end servers were on HP-UX 11.x on HP T-600 servers with Oracle 8i data warehouse and multi-dimensional data marts. The dimensions were time and geo-customer based.
• Implemented each phase of the architecture with hands-on development. Implementation and production rollouts in Oracle 8.1.6.3 that were migrated to Oracle 9.2 on IBM RS6000SP AIX 5L.
• The disk sub-systems were designed using EMC Connectrix with re-silvering and checker boarding striping methodology. support), RAC (Fault-tolerant besides the existing SCN-based Standby Database Convert), Schema dimensioning and dynamic SBU management

Confidential, Downers Grove, IL

Sr. Data warehouse Consultant/Unix System Administrator

Responsibilities:

• Installation, capacitization, and database design of McDonalds Data Warehouse (1 TB) on Oracle 8.1.7.3.0 and Oracle 9i platforms on HP-UX 11.0 T-600 systems.
• Data warehouse enhancements (that included Restaurants, Co-ops and tv markets) using Erwin 4.x, Database and extensive SQL and PL/SQL tuning (aggregations, ranking and roll-ups), troubleshooting day-to-day problems.
• Unix systems administration of HP-UX 11.0 kernel, swap space and Auto raid disk configurations (RAID 10).
• One of the main tasks was to tune SQL scripts for an open-ended production environment.

Confidential, Itasca, IL

Sr. Oracle Consultant

Responsibilities:

• Installation, maintenance, tuning and troubleshooting Oracle databases in Oracle v 8.1.5 on SUN E3500/450 platforms.
• Designed, developed and implemented disaster/recovery procedures (SCN & Time-based) using Korn Shell.
• Used Shareplex for advanced replication in multi-master configurations. Used Precise SQL to tune the Oracle engines and SQL statements. Supported applications such as Order Point (Java based) and used ODBC and JDBC drivers to connect to the Oracle databases.

Confidential, Downers Grove, IL

Senior Oracle DBA

Responsibilities:

• Installation, maintenance, tuning and troubleshooting Oracle databases in Oracle v 8.0.5 on RS6000 platforms.
• Designed and implemented Oracle Advanced Replication servers in multi-master configuration on AIX 4.x operating system.
• Designed their customer relation management system using Designer2000 and implemented it in production.
• Performed the daily DBA activities and tuned the AIX kernel on an ad-hoc basis.
• Used smit, cfgmgr and shell commands like lsps, lsdev, lsattr etc. extensively for user, network, swap and logical volume configurations and management

Confidential, Downers Grove, IL

Senior Consultant

Responsibilities:

• Re-engineered the existing Ingres system onto Oracle 8.0.5 on HP-UX 10.20 platforms on the D380 and K400 series for KRAFT Y2K project. Worked with Rockwell engineers to perform data acquisition of PLC data from KRAFT Cheese plant floor in California and using ODBC connectivity stored the real-time data in the MES Oracle databases.
• Designed the MES (Manufacturing Execution System) database-using Designer 2000.

Confidential, IL

Senior Oracle DBA

Responsibilities:

• Installation, maintenance, tuning and troubleshooting Oracle databases (15-20 GB) in Oracle v 7.2.x/7.3.x on HP-UX 10.20 platforms (T-500/T-600 servers).
• Designed, developed and implemented disaster/recovery procedures using Oracle Enterprise Backup Utility v 2.1.x in Oracle v 7.3.3.0.0 with Veritas NetBackup API for StorageTek DLT 7000 Tape Library systems. This incorporated both HOT and COLD BCV splits of EMC 3700 Disk volumes followed by respective HOT &COLD EBU backups & subsequent EBU restores & recovery procedures for Complete & incomplete (SCN, Cancel) Media recovery.
• Used remsh, rcp to remotely execute Unix shell scripts for the above and move files remotely

Confidential, Downers Grove, IL 8

Senior Consultant

Responsibilities:

• Installation, maintenance, tuning and troubleshooting Oracle databases ( GB) in Oracle v 7.2.x/7.3.x on HP-UX 10.10/10.20 (T-500/T-600 servers) and SUN Solaris 2.5.x/2.6.1 (SUN E-10000 Ultra Server) platforms.
• Created file systems (up to 128Gb) using LARGEFILES options.
• Designed and developed large data warehouses (logical & physical models with optimum capacitization) for clients such as Confidential, Prudential, Sears and Green Tree Financial.

Confidential, Palo Alto, CA

Senior Consultant

Responsibilities:

• Installation, maintenance, tuning and trouble shooting of Oracle databases v 7.x on SUN Sparc stations 10/20/1000/2000 and HP-UX 9.x/10.10 on Series 800 (T-500).
• Configured Oracle MTS, SMP Job Queues and SQL*Net v 1.x/2.x (for TCP/IP), OPS, SAP R/3 engines on Sun Solaris 2.x. SunOS 4.x and HP-UX 9.x/10.10 operating systems for Oracle and Sybase engines.
• Created backup (cold & hot), restore and recovery scripts in Oracle and Sybase for PeopleSoft Payroll & Human Resources packages, Oracle Financials v 2.0 and Sap R/3 engine.

Confidential, Mountain View, CA

Oracle Database Administrator

Responsibilities:

• Worked as an Oracle v 7.x DBA on SUN Sparc stations.
• Used SQL*Forms 3.0 and SQL*Reportwriter 2.0 for the Oracle Financials 1.x packages such as General Ledger, Accounts payable & receivables and Inventory Control.
• Note: The short duration at Confidential was due to the project getting shelved by the company at its infancy.