SUMMARY

• Accomplished leader with proven record of managing complex IT projects and programs in global enterprise environments in Banking, healthcare, retail and the wireless industry.
• Demonstrated hands - on experience designing and implementing enterprise technology architectures that enable global business growth.
• Proven ability to lead global teams, projects, and ITIL V3 process initiatives on capacity, availability, Information Lifecycle Management (ILM) and manage Service Level Agreements.
• Adept at analyzing strategic business objectives, developing solutions that increase operational efficiency and leading continuous improvement initiatives supporting productivity and business development.
• Various roles as Vice President, Sr. Director, Lead D Confidential base Architect, Lead Physical D Confidential base Administrator, Lead Logical D Confidential base Administrator and Technical Team lead with a result oriented approach in solving business problems by leveraging cutting-edge technologies.
• Hands on technical expertise in DB2 UDB ESE/EEE with DPF, Confidential BCU, HADR and expertise in d Confidential partitioning, parallel processing in Parallel Environment both MPP and SMP environments for the largest D Confidential Warehouse (over 15+ terabytes in size distributed across 7 Servers, over 56 d Confidential and 3 coordinator nodes) and OLTP environments.
• Exceptional experience in Oracle D Confidential base Administration on ORACLE 11gR2/10g using Maximum Availability Architecture solutions like 11gR2/10g GRID Clusterware RAC, ASM, D Confidential Guard, Oracle Enterprise Manager Grid Control Monitoring for 1000+ d Confidential bases out of over 5000 targets.
• Technical expertise in DB2, SQL, COBOL II, CICS, IMS, MQSERIES, VSAM, JCL, MVS, SPUFI, SYNCSORT, FILE-AID, TSO/ISPF, Confidential Mainframe including migration from Mainframe to AIX platforms.

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Chase Personal Online (CPO): CPO program was one of the 2016 GT Innovation finalists as it’s a next generation, customer-centric online banking experience built with modern and robust infrastructure that was recognized by the Senior Management.
• DB2 Container Upgrade from DB2 V9.7 to DB2 V11.1.
• Agile methodology and SRE guidelines used for all the projects.
• Automation as a service for Customer Service Improvement, Risk Mitigation and Elimination of manual work and involvement of DB2 DBAs during both Emergency and Non-Emergency modes.
• Weekly status and monthly service review with the higher management.
• Team management functions such as hiring, weekly team meetings, bi-weekly cross functional team meetings, Objective Settings and Performance review meetings.
• Audit and Risk related functions.
• Leadership Edge .

Environment: DB2 UDB, AIX 7/6, Linux 6.5, HADR, MQ QREP, AGILE, SRE, Confidential DSMGENEOS, DYNATRCE, SPLUK, RSAM, ESM, GUARDIUM, TAMS, VORMATRIC, JIRA, ITSM, PDPA, ITPAM, EURC.

Confidential

Sr. Director

Responsibilities:

• Delivered the c Confidential log of services as the D Confidential base Architect, Physical DBA and Logical DBA for the 1000+ in-house mission critical production, UAT, QA and Development DB2 & ORACLE D Confidential bases.
• Ensured all DBMS hardware and software infrastructure met standards for performance, stability, availability, and scalability to meet SLAs and enable the execution of the Confidential Growth Playbook.
• Provided Technical Leadership on New Products/Feature Feasibility/Usability.
• Disaster and Backup/Recovery Implementation/Execution.
• Define Holistic Monitoring Requirements, Generated Runbook documentation and performed 24x7 production performance monitoring/alerting and On call support.
• Migrated DB2 version to 9.5 fix pack 3 from version 8.2.5 as well as migrated DB2 d Confidential bases from Solaris to Linux OS.
• Configured and implemented DB2 HACMP and HADR.
• Installed and Managed Oracle 11g/10g RAC environments with ASM instance.
• Installed and configured Oracle OEM grid monitoring platform.
• Configured and implemented Oracle 11g D Confidential GUARD.
• Evaluated and implemented GREENPLUM d Confidential warehouse.
• Migrated DB2 d Confidential bases/Applications (AIX) into Oracle D Confidential bases/Applications (AIX).

Environment: DB2 UDB EEE, HADR, Oracle 11gr2/10g, RAC, D Confidential GUARD, ASM, RMAN, D Confidential PUMP, GLODEN GATE, GREENPLUM, DBARTISAN, AIX 6/5.3, SOLARIS 10, RHEL 6.2.

Confidential

Lead DB2 DBA

Responsibilities:

• Creating and configuring new d Confidential base objects (instances, d Confidential base, tablespaces, tables, views, indexes, etc.) and assigning proper authorities.
• Configuring/altering DBM, DB config and registry parameters/variables.
• Involved in DB2 v 8.1 fix pack 12 (64 bits) upgrade.
• Evaluated Confidential Query Patroller, DB2 Governor and Performance Expert tool (Ver 2.2.1). Implemented Confidential Performance Expert tool in production/QA/development severs. Also, using BMC patrol for the monitoring and alerting tool.
• Participating in 24/7 on call rotation, recycling the d Confidential bases (production, development as well as test) and supporting ETL, daily-weekly-monthly loads as well as maintenance windows.
• Created many AIX shell scripts to accomplish the DBA task.
• Providing an expert technical assistance and mentoring/coaching to the junior DBA team members.
• Check for adherence to rules on required best-known methods, known d Confidential base idiosyncrasies.
• Canceling bad queries from the d Confidential base and report the d Confidential base activities to the management. Follow-up with the users for the tuning of cancelled queries.

Environment: DB2 UDB EEE 8.2.5, AIX 5.3, SAN STORAGE, ABINITIO, MAESTRO, TSM, SQL, SAS, BRIO, AUTOSYS, D Confidential STAGE, ERWIN, PERL/SHELL SCRIPTING.

Confidential

Lead DB2 DBA

Responsibilities:

• Created and configured the new d Confidential base objects (instances, d Confidential base, tablespaces, tables, views, indexes, etc.) and assigned proper authorities.
• Configured/altered DBM, DB config and registry parameters/variables.
• Involved in UDB EEE v 8.2 implementation (from 7.2) project and servers/d Confidential base re-platform project.
• Opened PMR and working with Confidential tech support team to resolve the issues.
• Worked with Confidential tech support team, EMC storage team and sys admin to resolve the performance issues.
• Pro-actively monitored and tuned the d Confidential base and application performance.
• Participated in 24/7 on call rotation, recycling the d Confidential bases (production, development as well as test) and supporting ETL, daily-weekly-monthly loads as well as maintenance windows.
• Created many AIX shell scripts to accomplish all the DBA tasks such as automated query canceled for high cost/cardinality, idle connections, concurrent queries and using illegal coordination node used to submit the query.
• Canceled the bad queries from the d Confidential base, documenting them into the Query Tuning Log to report the d Confidential base activities to the management. Follow-up with the users for the tuning of cancelled queries.
• Advance SQL design/development with solid understanding of relational d Confidential base design concepts such as d Confidential normalization, d Confidential types with emphasis on DB2 d Confidential base as per standards.

Environment: DB2 UDB EEE 8.2.3/7.2, Confidential BCU, AIX 5.2, EMC SAN STORAGE, D Confidential STAGE, AUTOSYS, OPTILOAD, AUTOLOADER, SQL, SAS, SAGENT, ERWIN.