SUMMARY:

• 10+ years of experience in Information Technology industry
• Experience in DB2 v8.2, 8.1, 9.7, 10.5(ESE, WSE) on Confidential Database Administrations
• Experience in DB2 for Confidential 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 Confidential 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
• 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 Confidential v8.2, 8.1, Confidential 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 z9, IBM RS/6000; Windows NT Server; Ilntel 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, Southbury, CT

Database Admin

• Administers Database Security for all DB2 Confidential 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
• Performs Logical Database Design using Rational, and Physical Design with Db2 10.5
• 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 Confidential using db2 connect administration
• Tunes db2 for Confidential Instance and Database parameters for upgrades and HADR,
• Applies Fixpack Maintenance and automates db2 for Confidential 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, New, York, NY

• Administers Database Security for all DB2 Confidential 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 Confidential using db2 connect administration
• Tunes db2 for Confidential Instance and Database parameters for upgrades and HADR,
• Applies Fixpack Maintenance and automates db2 for Confidential 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 Confidential DB2 DBA administration tasks using V10.1
• Develops automated Korn Shell Scripts for update of Database Management Configuration.

Confidential, Reston VA

• Administers Database Security for all DB2 Confidential Platforms including AIX, RHEL, Windows 2003/8.
• Plans/implements System upgrades and Tunes Applications for conversion V9.5, V10.1 and 105 of Confidential
• Designs and creates Stored Procedures in JAVA, SQL both for Confidential and Confidential Federated SPs on 2008 R2 Servers
• Designs and Configures Logical and Physical Database Design and Construction with ERWIN and BDA tools
• Administers DB2 using Infosphere, IBM Data Studio Version 4 and and BMC BDA tool, BLU Accelerator
• Administers DB2 V9.7.10.5 for all dba tasks - upgrade, utilities, install, application, tuning, KSH scripts, autosys
• Implements and maintains Replication Administration on Confidential using db2 connect administration
• Tunes db2 for Confidential Instance and Database parameters for upgrades and HADR,
• Applies Fixpack Maintenance and automates db2 for Confidential statistic, reorg and SNAPSHOT
• Tunes Java Virtual Machines on Windows 2003/2008 Servers, RHEL(linux) and AIX, dbm config
• Assists Data Warehouse developers in tuning queries in large DPF environments of 50 TB under VMWARE
• Performs all Confidential DB2 DBA administration tasks using V10.1
• Develops automated Korn Shell Scripts for update of Database Management Configuration.

Confidential, NJ

• Administers Database Security for all DB2 Confidential Platforms including AIX, RHEL, Windows 2003/8.
• Plans/implements System upgrades and Tunes Applications for conversion V9.5, V10.1 and 105 of Confidential
• Designs and creates Stored Procedures in JAVA, SQL both for Confidential and Confidential Federated SPs on 2008 R2 Servers
• Designs and Configures Logical and Physical DB Design and Construction with physical Databases ERWIN
• Administers DB2 using Infosphere, IBM Data Studio Version 4 and DB2 tools, with Autosys
• Administers DB2 V9.7.10.5 for all dba tasks - upgrade, utilities, install, application, tuning
• Implements and maintains Replication Administration on Confidential using db2 connect administration
• Tunes db2 for Confidential Instance and Database parameters for upgrades and HADR, tunes dbm cfg
• Applies Fixpack Maintenance and automates db2 for Confidential statistic, reorg and SNAPSHOT
• Tunes Java Virtual Machines on Windows 2003/2008 Servers, RHEL(linux) and AIX
• Assists Data Warehouse developers in tuning queries in large DPF environments, 5TB,
• Performs all Confidential DB2 DBA administration tasks using V10.1 including system packs and zParms

Confidential

DB2 DBA

• Administers Database Security for all DB2 Confidential Platforms including AIX, RHEL, Windows 2003/8.
• Plans System upgrades and Tunes Applications for conversion to V10 of Confidential, using the Virtual DBA
• Designs and creates Stored Procedures in JAVA, SQL both for Confidential and Confidential Federated SPs on 2008 R2 Servers
• Designs and Configures Logical and Physical Database Design and Construction on DWE, ESE and EEE
• Administers DB2 using Infosphere, IBM Data Studio Version 4.
• Administers DB2 V9.7.10.5 for all DBA tasks - upgrade, utilities, install, application, tuning
• Implements and maintains Replication Administration on Confidential using db2 connect administration
• Tunes db2 for Confidential Instance and Database parameters for upgrades and HADR
• Applies Fixpack Maintenance and automates db2 for Confidential statistic, reorg and SNAPSHOT
• Tunes Java Virtual Machines on Windows 2003/2008 Servers, RHEL and AIX
• Assists Data Warehouse developers in tuning queries in large DPF environments

Confidential

DB2 Database Administrator

• Assists developers with application development & debugging with Source Configuration
• Administers Database Security for all DB2 Confidential and Confidential and Platforms, and performs access Audits.
• Plans System upgrades and Tunes Applications for conversion to Version 8/9/10 of Confidential and V9 of Confidential
• Designs and creates Stored Procedures in JAVA, SQL both for Confidential and Confidential Federated SPs on 2008 R2 Servers
• Designs and Configures Logical and Physical Database Design and Construction
• Administers Source Configuration Manager for related source change control
• Administers DB2 V9.7 for Windows 2008 R2 for all dba tasks - upgrade, utilities, install, application, tuning
• Implements and maintains Replication Administration on Confidential using db2 connect administration
• Plans Confidential database DASD usage on Storage Area Networks
• Assists developers in utilizing IBM CICS Web Services application for Customer Information System Modernization
• Plans and Administers Unix System Services on Confidential
• Tunes db2 for Confidential Instance and Database parameters
• Recommends optimal Confidential zParms for upgrades to Version 8/9/10 of UDB
• Applies Fixpack Maintenance and automates db2 for Confidential statistic, reorg and SNAPSHOT
• Uses IBM Tools for DB2 and IBM Log Analyzer to automate financial payment transactions
• Tunes Java Virtual Machines on Windows 2003/2008 Servers
• Models Data using ERWIN

Confidential, NYC

DB2 Database Administrator

• Assists developers with application development & debugging with Source Configuration Library Manager(SCLM)
• Administers Database Security for all DB2 Confidential and Confidential and Platforms
• Plans System upgrades and Tunes Applications for conversion to Version 8/9/10 of Confidential and V9 of Confidential
• Designs and creates Stored Procedures in JAVA, SQL both for Confidential and Confidential Federated SPs on 2008 R2 Servers
• Designs and Configures Logical and Physical Database Design and Construction using ERWIN
• Administers Source Configuration Manager for related source change control
• Administers DB2 V9.7 for Windows 2008 R2 for all dba tasks - upgrade, utilities, install, application, tuning
• Implements and maintains Replication Administration on Confidential using db2 connect administration
• Plans Confidential database DASD usage on Storage Area Networks
• Assists developers in utilizing IBM CICS Web Services application for Customer Information System Modernization
• Plans and Administers Unix System Services on Confidential
• Tunes db2 for Confidential Instance and Database parameters
• Recommends optimal Confidential zParms for upgrades to Version 8/9/10 of UDB
• Applies Fixpack Maintenance and automates db2 for Confidential statistic, reorg and SNAPSHOT
• Uses IBM Tools for DB2 and IBM Log Analyzer to automate financial payment transactions
• Tunes Java Virtual Machines on Windows 2003/2008 Servers

Confidential, Mountain Lakes NJ

DB2 Administrator

• Assists developers with application development and debugging
• Administers Database Security for all RDMS Platforms
• Tunes Applications for conversion to Version 8/9 (stat automation)
• Stored Procedures Tuning, JAVA(WAS) and COBOL and C++
• Logical and Physical Database Design(Erwin) and Implementation SDLC rollforwards
• DB2 V9.2 on Confidential with NFM and CM
• Administers DB2 V9.7 for AIX for all dba tasks - upgrade, utilities, install, application, tuning
• Implementation and maintenance of DPF and Replication
• Physical layouts and designs with SAN disk design EMC and others
• Uses BMC Change/Catalog, Mainview and CA Insight for DB Changes and Tuning

Confidential, Plymouth Rock

DB2 UDB DBA

• Administers Database Security for all DB2
• Creates Entity Relationship Diagrams using ERWIN
• Tunes Applications for conversion to Version 8 - DB2 - Buffer Pools, Advanced SQL
• Stored Procedures Tuning, JAVA and COBOL, SOA, JXML
• Logical and Physical Database Design and Implementation
• Performs database recovery, stats REXX/JCL, reorgs, LOADs
• Assists system administrators with DB2 Replication Websphere, Informatica
• Administers with BMC Change Manager V7/V8, BMC Catalog Manager, IBM Utilities Suite
• Makes logical and physical using ERWIN Examiner, SAP Process Modeling
• Makes AIX Shell Scripts and REXX Confidential scripts
• Utilizes IBM Utility Suite, BMC Change Manager, and Platinum Tools Confidential V7/V8 Performance Tuning using Stored Procedures. Strobe, Mainview, Triggers, DB2
• SQL and JAVA Stored Procedures, Perl Scripting AIX and RH Linux
• Makes forecasts for SAN administration and other space management functions

Confidential

DB2 UDB DBA

• Administers Database Security for all DB2
• Creates Entity Relationship Diagrams using ERWIN
• Tunes Applications for conversion to Version 8 - DB2 - Buffer Pools, Advanced SQL
• Stored Procedures Tuning, JAVA and COBOL, SOA, JXML
• Logical and Physical Database Design and Implementation
• Performs database recovery, stats REXX/JCL, reorgs, LOADs
• Assists system administrators with DB2 Replication Websphere, Informatica
• Administers with BMC Change Manager V7/V8, BMC Catalog Manager, IBM Utilities Suite
• Makes logical and physical using ERWIN Examiner, SAP Process Modeling
• Makes AIX Shell Scripts and REXX Confidential scripts
• Utilizes IBM Utility Suite, BMC Change Manager, and Platinum Tools Confidential V7/V8 Performance Tuning using Stored Procedures. Strobe, Mainview, Triggers, DB2
• SQL and JAVA Stored Procedures, Perl Scripting AIX and RH Linux
• Makes forecasts for SAN administration and other space management functions

Confidential

DB2 UDB for Confidential DBA and DB2 V8

• Administers Database Security for all DB2 for z/0S
• Tunes Applications for conversion to Version 8 - DB2 Confidential and Confidential
• Stored Procedures Tuning, JAVA and COBOL
• Logical and Physical Database Design and Implementation.
• Performs db recovery, stats REXX/JCL, reorgs, LOADs
• Uses BMC Change Manager V7/V8, BMC Catalog Manager,
• Makes logical and physical using ERWIN Examiner Confidential V7/V8 Performance Tuning using Stored Procedures. Strobe, Mainview, Triggers, DB2
• SQL and JAVA Stored Procedures
• Makes forecasts for SAN administration and other space management functions

Confidential

Data Base Administrator

• Manages production enterprise transaction database systems 24x7
• Configures and updates systems parameters in upgrades
• Makes and promotes Application Changes to all Database Objects
• Schedules and executes Database Utilities(reorg,load,runstats)
• Designs and configures enterprise reporting diagrams using ERWIN
• Assists developers with application development and debugging
• Creates ETL and Data Warehouse strategies
• Develops enterprise disaster recovery strategies(V7 and V8 BACKUP SYSTEM))
• Administers Database Security for all RDMS Platforms
• Tunes Applications, SQL and Stored Procedures.
• Utilizes PMBOK and CASE for Project Management with MS Project.
• MS SQL Server 2000 Enterprise Manager. Oracle Enterprise Client V8i/9i.
• Oracle 9i RMAN, PeopleSoft, IMS V10.Informix Visual Explain. Data Sharing, Parallel Sysplex. Replication Admin/DPRopR. Warehouse and CUBES, MSAccess, MS C++ and Visual Basic V7.
• DB2 Confidential for W2K, AIX, Linux
• Sun OS
• BMC Change Manager V7
• BMC Catalog Manager, V7 ERWIN Examiner
• DBArtisan for DB2 Oracle Version 8/9i for W2K, SunOS, AIX. AIX Shell Scripting
• V7/V8 Performance Tuning