SUMMARY

• Experience in DB2 for Z/OS Versions 2.1 through 10.1,, including Upgrades, Systems Application DBA
• Experience in DB2 v8.2, 8.1 , 9.7 ESE, WSE on LUW Database Administrations
• 10 years of experience in Information Technology industry
• Experience on Multi -Partitioned DB2 UDB DPF database systems.
• 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
• Experience working with Very Large Databases 5 terabyte databases , with DPF
• 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,OPTIM -

SKILLS

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

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

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

Operating Systems: Expertise in 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 Intel Pentium PCs, Dell and HP

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

PROFESSIONAL EXPERIENCE

Systems and Application DBA

Confidential

• Administers Database Security for all DB2 LUW Platforms including AIX, RHEL, Windows 2003/8.
• Plans/implements System upgrades and Tunes Applications for conversion V9.5, V10.1 and 105 of LUW
• Designs and creates Stored Procedures in JAVA, SQL both for z/OS and LUW Federated SPs on 2008 R2 Servers
• Designs and Configures Logical and Physical Database Design and Construction with ERWIN
• Administers DB2 using Infosphere, IBM Data Studio Version 4 and DB2 tools
• Administers DB2 V9.7.10.5 for all dba tasks - upgrade, utilities, install, application, tuning
• 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 Windows 2003/2008 Servers, RHEL linux and AIX
• Assists Data Warehouse developers in tuning queries in large DPF environments
• Performs all z/OS DB2 DBA administration tasks using V10.1

Confidential

Application DBA

• Administers Database Security for all DB2 LUW Platforms including AIX, RHEL, Windows 2003/8.
• Plans System upgrades and Tunes Applications for conversion to V10 of LUW
• Designs and creates Stored Procedures in JAVA, SQL both for z/OS and LUW 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 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 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 z/OS and LUW and Platforms, and performs access Audits.
• Plans System upgrades and Tunes Applications for conversion to Version 8/9/10 of z/OS and V9 of LUW
• Designs and creates Stored Procedures in JAVA, SQL both for z/OS and LUW 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 z/OS using db2 connect administration
• Plans z/OS 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 z/OS
• Tunes db2 for LUW Instance and Database parameters
• Recommends optimal z/OS zParms for ugrades to Version 8/9/10 of UDB
• Applies Fixpack Maintenance and automates db2 for LUW 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

DB2 Database Administrator

• Assists developers with application development debugging with Source Configuration Library Manager SCLM
• Administers Database Security for all DB2 z/OS and LUW and Platforms
• Plans System upgrades and Tunes Applications for conversion to Version 8/9/10 of z/OS and V9 of LUW
• Designs and creates Stored Procedures in JAVA, SQL both for z/OS and LUW 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 z/OS using db2 connect administration
• Plans z/OS 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 z/OS
• Tunes db2 for LUW Instance and Database parameters
• Recommends optimal z/OS zParms for ugrades to Version 8/9/10 of UDB
• Applies Fixpack Maintenance and automates db2 for LUW 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

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 z/OS 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
• Supports and Installs BPM PEGA
• Supports and Upgrades of RDBMS DB2 for z/OS, SQL Server 2005/2008, DB2 for LUW
• Uses BMC Change/Catalog, Mainview and CA Insight for DB Changes and Tuning

Confidential

• 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 z/OS scripts
• Utilizes IBM Utility Suite, BMC Change Manager, and Platinum Tools
• z/OS 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

• 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 z/OS scripts
• Utilizes IBM Utility Suite, BMC Change Manager, and Platinum Tools
• z/OS 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

• Administers Database Security for all DB2 for z/0S
• Tunes Applications for conversion to Version 8 DB2 LUW and z/OS
• 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
• z/OS 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

Responsibilites: Support Global Transportation Network Worldwide 24x7

Applications: PortTerminal Management, Customs Clearance, Port Dispatch, Trucking

• 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
• 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.

Major Tool sets: DB2 V7 for z/OS

• DB2 LUW 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