SUMMARY:

Oracle DBA/Developer/Data Architect/Performance Tuning; Oracle/Pl/SQL Unix/ksh/Perl/C/C++; WebLogic; JEE. More than 25 years of experience as Soft. Eng/Oracle DBA Specialized in Performance Tuning and Internals;

PROFESSIONAL EXPERIENCE:

Confidential

Sr. DBA/Data Analyst

Responsibilities:

• Participated in MDM - Master Data Management implementation.
• As Sr. DBA supporting Development and performed many duties as DBA & Data Analyst on Database running MDM and MDM’s client DBs.
• Managed backup, created Test Environment, duplicated databases, managing Database Objects, users, data migration, monitoring, troubleshooting & performance tuning, and data analyzing. (DB2, SQL Server).
• Wrote queries for data matching, validation and data cleansing in Production DBs.
• Supporting Production Data Database that is running MDM & MDM’s client DBs and resolve many incidents. (DB2; SQL Server)
• Performed reverse engineering on Landing and Staging and created “Canonical Model” for Staging and Loading Area. Supporting ETL processes, wrote procedure and queries to extract XML used by MDM Services and ETL tools.

Tools: DB2 v.10, SQL Server 2014, SQL; T-SQL; PureXML, Erwin

Confidential

Sr. Oracle/Exadata DBA/Architect

Responsibilities:

• Participated in consolidation project, upgraded and migrated huge number of DBs into Exadata environment including GRID Control (OEM 12c). Participated in High-Availability EM12c Configuration as Level 4 (RAC & Data Guard).
• Installed/Configured Performance environments & tuned PL/SQL& queries in Exadata, RAC and Single instances environment.
• In Exadata improved offloading/smart scan by eliminating unnecessary indexing; setting properly table storage parameters; setting properly parameters for parallel processing & PX Adaptive offloading; force direct path read & Bloom Filter
• Moved from one department to another (Exadata; RAC 12c; Oracle 11g/12c; Data Guards; OGG), checked configurations, analyzed performance and created document with finding and recommendations.
• Wrote scripts for “Object Statistics” including Partitioned tables & resolved problem with Dynamic Sampling & prevent Out-of range condition
• Rewrote scripts for backups (RMAN table Backup) and dramatically speed up backup process. Performed point in time restore.
• As Infrastructure DBA responsible for capacity planning, configuration (Prod and QA environment), upgrading and patching of Production Data Bases and GRID Infrastructure. Performed rolling upgrade (Production RAC 11g & GRID infrastructure into 12c) using SQL Apply with minimum downtime. Monitoring and analyzed AWR & “Health Check”, and resolving a huge number of incident on Productions DBs (Exadata; RAC 12c; Oracle 11g&12c)
• Configured new environment for People Soft DB and Reporting system. People Soft DB is configured as Oracle RAC 12c with multitenant option. Using OEM 12c set-up & managed ADG-Active Data Guard for Production DB (People Soft). Installed Target Environment for Reporting System (Oracle 12c; OBIEE). Configured replication using OGG between ADG and Reporting DB (Staging Area). Created all mapping including “Soft Delete in DW”. Provided data model for Staging Area (Reference Partitioning) and Dimensional Model for Reporting DB (star schema; Zone Maps; Vector Transformation; Bitmap & Bitmap Join Indexes). Wrote PL/SQL code to refresh Fact Tables from Staging Area using PL/SQL Collection, Bulk & Array processing. Wrote queries used by report in DW. Supported Production database & maintained Reporting Infrastructure (ADG; Oracle RAC 12c; Oracle 12c; OBIEE; OGG) ensuring their optimum Performance, high availability & security.

Tools: Linux/Oracle 11g&12c&Exadata X5-2 ; RAC 12c; OEM 12c; Erwin

Confidential, Dallas, TX

Sr. Oracle DBA/Performance Expert

Responsibilities:

• Detected hangs in LGWR in RAC 11g environment and resolved issue by changing “method used by LGWR to notify FG processes of commit” back to “semaphore-post mechanism” (temporarily solution)
• Configured new environment including Oracle RAC 12c & MS SQL Server; Db2 & replication based on OGG & Streams & successfully solving all contentions, and permanently solved problem with hangs by switching back to “Adaptive Log File Sync”. (Oracle RAC 12c; SQL Server; DB2; OGG) (permanent solution)
• Tuned new environment. Enhanced Physical Data Model and resolved Indexes and Tables contention. Tuning, re-writing for critical parts of PL/SQL code. (OEM; AWR; PLSQL Profiler). Preformed Code Review and wrote suggestions.
• Tuned Oracle Golden Gate configuration. Created scripts for “replication monitoring” and scripts that could be used to generate & re-run problematic portion of trail file. (Ksh; GG/LogDump)

Tools: Oracle RAC 11g/12c, Golden Gate/LogDump; Linux/ksh; Oracle/PlSQL

Confidential

Sr. Oracle DBA/Architect

Responsibilities:

• Wrote Scripts for "Statistics Gathering" and “change control process" from modification to production.
• Provided fine tuning of Oracle Server and OS System (Production Oracle 11g RAC 4 nodes; Linux OS). Improved I/O on SSD for LGWR by adjusting Oracle parameters for SSD, and LGWR (LGWR priority; & SSD's Block Size for Redo Log) and successfully reduced "Log File Sync" and "Direct Path Read" Wait Events on busy "E-Payment DBs". Changed many parameters that improving performance. Stabilized execution plan by applying SQL Plan Baseline.
• Configured new platform for Performance environment, installed RAC 12c & & ASM & GRID Infrastructure and GRID Control (OEM 12c). Tuned RAC components and application using ADDM and AWR reports.
• Performed reverse engineering & suggested changes to Physical data model (Tables & Partitioning; Index & Partitioning) for "E Pay Application".
• As Sr. DBA responsible for backup (Oracle DBs and SQL Server)
• Provided Logical and Physical Data Model
• Wrote PLSQL code for Scoring Engine. (PL/SQL; Erwin)
• Participated in Big Data implementation (Hadoop) ETL process. Participated in ETL process implementation that load data from Oracle and SQL Server DBs into Hadoop

Tools: RDBMS Oracle RAC 11g/12c, Linux/ksh, OEM 12c, RMAN, OGG, Erwin;

Confidential, Washington, DC

Sr. Oracle & SQL Server DBA /Architect

Responsibilities:

• Led all tuning effort that result in significant improvement in all DBs including Production DBs by using wait-based analysis approach (RAT, Oracle Wait Event Interface, SQL Plan Management, AWR, ASH, PL/SQL Profiler and custom scripts).
• Wrote all critical parts of the code (PL/SQL) & templates for Java code for Loan Accounting System. Owned and designed Physical Data Model for LAI project (Partitioning, Indexing and setting Storage Oracle parameters) and creating QA/Test environments to resolve bugs and performance issues using RMAN, DB Capture & Replay Workloads. Tuning OS (Linux and SunOS) and File system, added ODM on Veritas FS.
• Wrote procedures & scripts that can be used to install, updated, monitor & manage RAC & GRID infrastructure & ASM instances, Exadata, Data Guard, Delphix, VMware, and Oracle Fusion Middleware. Scripts used by Oracle infrastructure DBAs. Changed backup strategy for all Prod DBs and Configured Database Backup to Amazon S3 (RMAN). Created scripts for disaster recovery (RMAN; ksh)
• As infrastructure DBA participated in Migration Prod DBs to new Storage, Patching & Upgrading Prod DBs from 11g to 12c (GRID Control- OEM; RAC & ASM & GRID Infrastructure, Data Guard, WebLogic & Middleware Infrastructure; OEB Suite and Oracle Identity (RAC 12c) ; SQL Server 2014 (clustered);
• Participated (technical lead) in Prod DBs consolidation into Exadata.
• Participated in Investor Reporting Sys (DW) implementation. Designed and configured Environment (Oracle 12c; OGG; Netezza). Enhance Physical Data Model and tuning all component of the Reporting system). Wrote PL/SQL code to manage partitions in staging area (exchange & archive partitions)
• Maintaining, responding to alerts, monitoring all DBs (80% Oracle DB, 20% SQL Server) including Real Time Replication environments that is using replication technology including Golden Gate and Active Data Guard (Oracle; SQL Server).

Tools: Solaris, Linux, Perl, Oracle 11g / RAC / 12c / Exadata, Data Guard, GRID/OEM 12c, Golden Gate; RMAN, PL/SQL; Netezza; SQL Server; PL SQL; SQL; T-SQL; MySQL;

Confidential, Austin, TX

Sr. Oracle DBA/Architect

Responsibilities:

• Participated in MDM- Master Data Management implementation (VLDB)
• Participated in Pilot database (RAC 4 node) & Production database (RAC 8 node) configuration including Grid & Middleware Infrastructure. Wrote documents for Oracle Database Best Practices (Installation, Statistics, Monitoring & Maintaining, and Disaster recovery)
• Provided Physical Data Model for Search Engine in MDM (Indexing, Functional, Indexes, IOT, Reference Partitioning, Advanced Compression, Physical Storage options and successfully created High Performance Solution for MDM. Wrote PL/SQL procedure and function for Search Engine (PL/SQL)
• Provide performance analysis & tuning of Physical DM, Load Balancing, SQL, fine-tuning of DB Servers to achieve over 300 TPS on VLDB using Oracle Wait Event Interface, ADDM, AWR, ASH, custom scripts, SQL Plan Management, and trace event 10046 & 10132.
• Configured replication using Golden Gate. Participated in ETL D&D. Wrote conversion & validation scripts that loads & validates data from many different DBs (Oracle, SQL Server; DB2) into new target DB (Oracle) using PL/SQL, Korn Shell, Perl. Provided system support for Informatica team.

Tools: Linux/Bush Shell, Oracle 11g/PL/SQL; OEM, Erwin, RMAN, WebLogic

Confidential

Software Applications Engineer

Responsibilities:

• Enhancing & tuning Physical Data Model, and SQL of DCM (Demand Chain Management). DCM is an analytical solution typically associated with Decision Support System.
• Worked with Teradata Core Team to test Performance of DCM on “Teradata vs Exadata (Oracle Version of DCM)”, created Test Case to test parallelism, test case “to force Hot AMPs on Teradata”, test case for Smart Scan & Smart Flash Cache on Exadata
• Tuned SQL on Teradata platform: Fixed Hot AMP & BLOB redistribution & skewing of DCM System. (Teradata platform, Client eBay with over 900 AMPs)
• Enhancing Data Base Installer (Perl & Apache) & created UDF UniTest framework (Teradata/UDF/C).

Tools: Linux/Bash/Perl; Teradata/UDF/C/SQL/BTEQ; Oracle11g/Exadata, Jira, SVN

Confidential

Sr. Oracle DBA/Unix Admin

Responsibilities:

• Upgrade all DBs to 11.1.07 & 11.2, and OEM Grid Control to 11g Migrate Middleware &DBs &OID to new servers & Data Sun Storage 7310. Patched & maintained all Oracle Software and OS (Linux; Solaris)
• Created plan & scripts for backups (Oracle DBs & Oracle Fusion Middleware), disaster recovery, switchover & failover and tested all scenarios ensuring availability of critical components
• Created scripts for monitoring, source code control system, DB migration & deployment. Assisted with UNIX administration (Linux, SunOS), configured OS including virtualization and configured Nagios monitoring system.
• Successfully maintained peak performance by providing advanced tuning methods including AWR, Workload Management (Services, Load Balancing), OEM Performance Manager, enhanced Physical Data Models (Partitioning & Partition-Wise Joins, Indexing, Compression).
• Participated in “data transformation and integration” development using (OWB; PL/SQL)
• Supported client's Portal. Migrated client's Portal based on Oracle AS 10g to Oracle WebLogic Portal & to new servers. Migrated SSO & OID to new servers. Installed and supported OIAM-Oracle Identity Access Management
• Configured and supported application in Heterogeneous Environment (Oracle 10g & SQL Server & Oracle Database Gateway). Participated on DW & BI & Reporting System implementation using WebLogic & WLST, BI Publisher, RCU and ODI; OIAM. Using ODI & Golden Gate and setup data integration and replication in Heterogeneous Environment (Oracle & MySQL & SQL Server & Teradata). Provided data model & designed Star Schema used to support the Angoss’s clients Enterprise BI System (Erwin). Developed new code & tuning existing for Reporting Sys. (PL/SQL)
• Supporting development of “Decision Tree” on SQL Server. Created QA environment. Installed and configured client production data base (SQL Server). Participated in development of “Decision Tree” (T-SQL; C#); Configured all infrastructure in clustered environment. (SQL Server)

Tools: Solaris, Linux, Perl, Oracle 10/11g/PLSQL, OAS, GoldenGate, Data Guard, OWB, OEM, MySQL, SQL Server/T-SQL; C++; C#; WebLogic/WLST, Erwin

Confidential

Senior Oracle DBA/Data Architect

Responsibilities:

• Provide performance analysis and tuning.
• Performed Physical Data Model, Application, SQL and fine-tuning of DB Server to match specific application requirement using AWR, Wait Event Interface, SQL trace (event 10046, 10104), CBO analysis (event 10053), OEM & custom scripts.
• Configured Prod and Test environment (RAC 11g, 2 nodes) used for Retail Portal
• Designed & developed Event Engine and Statements and provided Logical & Physical Data Model within Retail Commissioning Portal, system enables the automated calculation of pre & post-paid commission & claim process activity (PL/SQL; Erwin; WebLogic-Prod; Apache Tomcat-Test; LDAP; EE)
• Created an automated monitoring & recovery infrastructure including scripts that automatically Roll Forward a Physical standby database using Incremental Backup (RMAN, UNIX/ksh, SQL)
• Provided DBA support by maintaining change control process from modification to production database
• Participated in ETL & provided data models for data mart. (Erwin; PLSQL)

Tools: AIX, Linux, Unix, Korn Shell (ksh), Oracle10g/11g (RAC), OWB, WebLogic, OEM, RMAN, Erwin, Veritas

Confidential

Sr. Oracle DBA (Technical lead)

Responsibilities:

• Involved in Donation System implementation & Architecture Definition.
• Wrote design document for Migration & Conversion.
• The system maps & loads data from existing DBs (Oracle; DB2; SQL Server) into the target new database for “Advance System” Oracle 10g using many different tolls (export/import; SQL Loader/External tables; DB Links; SQL Developer; custom scripts,…)
• Perform Oracle installation, tuning & capacity planning and supporting the development team during implementation of Donation System (SunGard/Ellucian).
• Created scripts to automatize creation of QA environment for Prod DB's backup (RMAN)
• Setup fine-grained audit facilities & Advanced Security, developed scripts for Oracle user activity auditing (Unix/ksh sql scripts)
• Enhanced Physical Data Model, tuned application & SQL, performed instance tuning using Statspack & wait events interface and Profiler & custom scripts for PL/SQL that resulted in significant improvement in response time for application and data migration modules.
• Implemented high available solution for DW/Reporting System using Logical Standby DB.
• Provided Physical Data Model for Reporting System (Erwin)
• Developed Migration & Conversion packages. (Oracle & SQL Server)
• Developed generic utility based on metadata to load files and map predefined values (PL/SQL)

Tools: Oracle10g/PLSQL; Windows/Sql Server; Unix/ksh/Perl; Erwin; RMAN

Confidential

Senior Software Engineer

Responsibilities:

• Involved in Banking System Software, Teller System development.
• Enhanced Distributed Message System.
• Improve performance by eliminating memory leaks & resolving synchronization issues. (C++)
• Developed interface between Oracle DBs and SQL Server DBs. (Unix/C++)

Tools: Solaris/TCP/IP/C++/pthreads lib; Purify, Insure++; Oracle10g/C++ SQL Server

Confidential

Sr. DBA / Software Developer

Responsibilities:

• Working on Reports projects aimed to create online reporting facility for Advisors & Dealers (PL/SQL)
• Enhancing & tuning Physical Data Model and SQL of Rates of Returns subsystem (Mutual Funds).
• Developed generic Splitter using table functions & bulk & array processing (PL/SQL) to meet the demand, business-level performance requirements

Tools: Linux/Ksh/Perl; RDBMS Oracle10g/PL/SQL

Confidential

Software Architect (Technical lead)

Responsibilities:

• Worked on Confidential ’s modules RMS & DW-Retail Management System & Data Warehouse
• Enhanced Data Warehouse system using Oracle9i/PL/SQL New Features &Tools in DW;
• Implemented EDI- electronic data interchange Iteration, developed generic OS File Watcher, parser, and loader.
• Designed Data Warehouse Interface. Created Logical and Physical Data Model (ERwin).
• Provided performance analysis/tuning of DW Interface (PL/SQL, C/C++), and Reports

Tools: AIX/Oracle9i/PL/SQL/Pro*C/C++; Oracle Application Server; OWB; Erwin

Teradata Software Engineer

Confidential

Responsibilities:

• Participated in Demand Chain Management (DCM) development. DCM is an analytical solution that helps companies increase sales and decrease inventory, designed for data intensive operations on VLDB, historic sales typically associated with Decision Support Sys, and Data Warehouses.
• Provided DBA support for all internal & client based Teradata implementations of DCM. Developed new components for contribution, forecasting, replenishment modules to generate accurate orders & automatically replenish some, or all, of store’s entire inventory (Teradata)

Tools: Unix/ ksh/C/C++/Message Queue; Tertadata/Fast Load; Multi Load; C/C++/BTEQ;

Confidential

Sr. DBA (Oracle; SQL Server)(Team Leader)

Responsibilities:

• Provided Oracle and UNIX expertise in application development, troubleshooting, performance tuning, and database architecture including configuration, installation, migration, and upgrades Participated in physical and logical schema design and tuning for Data Warehouse DB.
• Maintained Physical Data Model Monitor database, performance issue, security threads, contention issues and successfully maintained peak performance
• Designed, developed system modifications & new system components for RMS& DW
• Designed, developed Cross Dock Solution, PO Acknowledgment, Advance Shipment Notice as new modules in Confidential to support EDI- Electronic Data Interchange processing (Erwin; PLSQL; Pro*C/C++; J2EE
• Assisted in CRM, Gift Card, Customer Loyalty System D & D (Oracle 9i new features)
• Enhanced DW & DW Interfaces. Tuning Marketing Datamart reporting sys. (SQL Server)
• D&D Enterprise App Scheduler, Monitor & Err Handling System. ProC/C++, AQ, Java, XML).

Tools: UNIX/ORACLE/ProC/C++/PLSQL/OWB; Perl; DB2; SQL Server/T-SQL; J2EE

Confidential

Application DBA/Developer

Responsibilities:

• Worked on conversion, interfaces & developed generic utility for ETL for DW project using PL/SQL / Pro*C / C++
• Developed modules for Confidential ’s packages and batch processes (PL/SQL; Pro*C)
• Provided performance analysis and tuning of Oracle and Confidential (RMS and DW) system and successfully maintained performance of all primary databases
• Perform Oracle installation, tuning & capacity planning. Established standards for all Oracle DB environments based on Oracle's Optimal Flexible Architecture and Best Practices.
• Provide mentoring and knowledge transfer to operational DBA team.

Tools: UNIX/ORACLE/PL/SQL, Pro*C/C++; UNIX/Shell; MVS & JLC