We provide IT Staff Augmentation Services!

Db2 Database Administrator Resume

Princeton, NJ

SUMMARY:

  • Data Administration, Development and Modeling
  • Confidential Certified Database Administrator for DB2 Universal Database for z/OS, LUW with extensive experience in Architecture, Applications, Recovery in various Business Integration, Production
  • Warehouse, Disaster Recovery Environments Data Modeling and Administration
  • 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 Confidential 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 Confidential AIX 6.1, RHEL
  • Experience in ERWIN Data Modeling, Toad, DBArtisan, IBMData Studio(InfoSphere,OPTUM)

SKILLS:

  • 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

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, Confidential 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, Confidential z9, Confidential 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, Princeton, NJ

DB2 Database Administrator

Responsibilities:

  • Administers Database Security for all DB2 LUW Platforms AIX, RHEL, PostgresSQL V6.
  • Prepares DB2 Environments for Compatibility with AWS (Blue to Green) Hadoop/NoSQL.
  • Develops AiX Korn Shel Scripts and QREP for Confidential 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 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
  • Tunes Java Virtual Machines on REHL linux) and AIX, dbm config
  • Assists Data Warehouse developers in tuning queries in large DPF environments 1 TB under VMWARE
  • Performs SQL Server production support BAU duties:Backup, Export, Startup, Linked Server, Federation
  • Develops automated Korn Shell Scripts for update of Database Management Configuration.

Confidential

DBA

Responsibilities:

  • Tests Resiliency of DR HACAMP Disaster Scripts in Tests for Production/Pre-Production
  • Develops AiX Korn Shel Scripts and QREP for Confidential 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 Confidential CLP, Confidential 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, New, York, NY

DB2 Database Administrator

Responsibilities:

  • Administers Database Security for all DB2 LUW Platforms including AIX, RHEL, Windows 2003/8.
  • Develops Perl 5, Linux Shell and SQL PL for Confidential 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 Confidential CLP, Confidential 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.

Confidential, Reston, VA

DB2 Database Administrator

Responsibilities:

  • 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 and BDA tools
  • Administers DB2 using Infosphere, Confidential 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 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, 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.

Systems and Application DBA

Confidential, NJ

Responsibilities:

  • 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 DB Design and Construction with physical Databases ERWIN
  • Administers DB2 using Infosphere, Confidential 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 z/OS using db2 connect administration
  • Tunes db2 for LUW Instance and Database parameters for upgrades and HADR, tunes dbm cfg
  • 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, 5TB,
  • Performs all z/OS DB2 DBA administration tasks using V10.1 including system packs and zParms

Confidential

Application DBA

Responsibilities:

  • 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, using the Virtual DBA
  • 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, Confidential 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

Responsibilities:

  • 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 Confidential 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 upgrades to Version 8/9/10 of UDB
  • Applies Fixpack Maintenance and automates db2 for LUW statistic, reorg and SNAPSHOT
  • Uses Confidential Tools for DB2 and Confidential 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

Responsibilities:

  • 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 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 z/OS using db2 connect administration
  • Plans z/OS database DASD usage on Storage Area Networks
  • Assists developers in utilizing Confidential 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 upgrades to Version 8/9/10 of UDB
  • Applies Fixpack Maintenance and automates db2 for LUW statistic, reorg and SNAPSHOT
  • Uses Confidential Tools for DB2 and Confidential Log Analyzer to automate financial payment transactions
  • Tunes Java Virtual Machines on Windows 2003/2008 Servers

Hire Now