SUMMARY

• 10+ years of experience in Information Technology industry
• Experience in DB2 v8.2, 8.1, 9.7, 10.5(ESE, WSE) on LUW Database Administrations
• Experience in DB2 for Z/OS Versions 2.1 through 10.x,, including Upgrades, Systems Application DBA
• Experience on Multi - Partitioned DB2 UDB (DPF) database systems, including HADOOP.
• Experience administering and managing DB2 UDB on LUW installations in Versions 9 and 10.
• Strong Experience on setting up DB2 DPROP (Data Propagator or SQL and Q Replication) environments .Websphere 6.1. BLU Accelerator TMON Power Designer, Explain, Fileaid for DB2, RMF III, BMC nnd IBM suites, SPUFI, QMF, DB2
• Experience working with Very Large Databases (5 terabyte+ databases), with DPF, and Blu Accelerator
• Experience with Google BigQuery Tuning
• Implementation of DB2HADR including installation, configuration and DR testing.
• Experience in System Administration and Performance Tuning of the IBM AIX 6.1, RHEL
• Experience in ERWIN Data Modeling, Toad, DBArtisan, IBMData Studio(InfoSphere,OPTUM)

TECHNICAL SKILLS

RDBMS: DB2 UDB for z/OS v8.2, 8.1, LUW v9.7, 5,10.1,10.5, including DWE and EEE and ESESQL Server 2008.

Programming Languages: Cobol I/II, IBM 370,HLAS Assembler, Sun JAVA, REXX, C

Scripting Languages: Borne/Korn Unix Shell Scripting, Windows CMD. Perl 5

Operating Systems: Solaris, AIX Unix Operating System; AIX Administration, Performance Management and Tuning and Windows, Linux (RH and SUSE)

Hardware Platforms: SUN, IBM Power 8/9, IBM RS/6000; Windows NT Server; lntel Pentium PCs, Dell and HP, Autosys, Content Management on Demand, 8.5.3

Soft Skills: Sharp Communication (spoken and written) skills. Good interpersonal, problem solving and leadership skills.

PROFESSIONAL EXPERIENCE

Confidential

Systems Application DBA

Responsibilities:

• Administers Database Security for all DB2 LUW Platforms AIX, RHEL, db2 v10/11..
• Prepares DB2 Environments for Compatibility with FileNet for db2 5.8
• Develops AIX Korn Shel Scripts and QREP for IBM DB2 10.5
• Performs Logical Database Design using RDP,Erwin, and Physical Design with Db2 10.5/11
• Architects Designs and Configures Logical and Physical Database Design and Construction
• Administers DB2 using Freeware
• Administers DB2 V9.7.10.5 for all DBA tasks - upgrade, utilities, install, application, tuning, KSH scripts, and Tivoli TWS, TDW, IEM, models relational data using Rational DM
• Tunes db2 for LUW Instance and Database parameters for upgrades and HADR,
• Applies Fixpack Maintenance and automates db2 for LUW statistic, reorg and SNAPSHOT(on AIX & IBM Data Studio)
• Tunes Java Virtual Machines on REHL linux) and AIX, Database Management CONFIG
• Assists Data Warehouse developers in tuning queries in large DPF environments 5 TB
• Develops automated Korn Shell Scripts for ongoing db2 utilities.

Confidential

Responsibilities:

• Administers Database Security for all DB2 LUW Platforms AIX, RHEL, SQL Server 2003/8.
• Tests Resiliency of DR HACAMP Disaster Scripts in Tests for Production/Pre-Production
• Develops AIX Korn Shel Scripts and QREP for IBM DB2 10.5/11.1
• Performs Logical Database Design using Rational, and Physical Design with Db2 10.5/11.1
• ArchitectsDesigns and Configures Logical and Physical Database Design and Construction
• Administers DB2 using IBM CLP, IBM Maximo (Change Management)
• Administers DB2 V9.7.10.5 for all dba tasks - upgrade, utilities, install, application, tuning, KSH scripts, and Tivoli TWS, TDW, IEM, models relational data using Rational DM
• Implements and maintains Replication Administration on z/OS using db2 connect administration
• Tunes db2 for LUW Instance and Database parameters for upgrades and HADR,
• Applies Fixpack Maintenance and automates db2 for LUW statistic, reorg and SNAPSHOT
• Tunes Java Virtual Machines on REHL linux) and AIX, dbm config
• Assists Data Warehouse developers in tuning queries in large DPF environments of 50 TB under VMWARE
• Performs SQL Server production support BAU duties.
• Develops automated Korn Shell Scripts for update of Database Management Configuration.

Confidential

Systems Application DBA

Responsibilities:

• Administers Database Security for all DB2 LUW Platforms including AIX, RHEL, Windows 2003/8.
• Develops Perl 5, Linux Shell and SQL PL for IBM DB2 10.5
• Performs Logical Database Design using PowerDesigner, and Physical Design with Db2 10.5
• Designs and Configures Logical and Physical Database Design and Construction with ERWIN and BDA tools
• Administers DB2 using IBM CLP, IBM Data Studio Version 4 and DBartisan 9.12
• Administers DB2 V9.7.10.5 for all dba tasks - upgrade, utilities, install, application, tuning, KSH scripts, autosys
• Implements and maintains Replication Administration on z/OS using db2 connect administration
• Tunes db2 for LUW Instance and Database parameters for upgrades and HADR,
• Applies Fixpack Maintenance and automates db2 for LUW statistic, reorg and SNAPSHOT
• Tunes Java Virtual Machines on REHL linux) and AIX, dbm config
• Assists Data Warehouse developers in tuning queries in large DPF environments of 50 TB under VMWARE
• Performs all z/OS DB2 DBA administration tasks using V10.1
• Develops automated Korn Shell Scripts for update of Database Management Configuration.