We provide IT Staff Augmentation Services!

Senior Db2 Administrator Resume

MD

SUMMARY:

  • Over 13+ years of experience in IT with expertise in Design, Implementation & Maintenance of DB2 UDB 7.2,8.2, 9.5 & 9.7 and DB2 ZOS v9, V10 database environments.
  • Experience in Design, Development and System Analysis.
  • Implementation of software applications in Client/Server technology
  • Provided mathematical analysis of db2 changes implemented on test environments and verifying the test results before implementing the db2 changes on the production systems
  • Worked on various software applications which depend on DB2 like Confidential Db2 Content Manager, Siebel, Peoplesoft, LUMOS Element management system.

TECHNICAL SKILLS:

Programming: Java, Perl, C, PL/SQL, SQL, UNIX Shell, JCL

Databases: DB2 UDB 8.1, 7.X, Oracle 9.X, 8.X, 7.3.4, Informix 10.X, Administration

Storage: Tivoli Storage Manager

Middleware: Confidential Websphere, MQ Series, QREP

O/S: AIX 5.1, Solaris 9.x, HP - UX 10.2,11.0, Windows 2000, MVS, z/OS

Hardware: Sun Solaris, Confidential RS 6000

EXPERIENCE:

Confidential, MD

Senior DB2 Administrator

Responsibilities:

  • Creation of database / nodegroups / tablespaces and various objects in distributed databases.
  • Provided support to System Administration (SA) in database installation, instance
  • Creation, instance upgrade and version migration. Implement a library of homegrown scripts to automate the scheduling and notification of periodic maintenance jobs, including REORG, BACKUP, RUNSTATS, LOAD, IMPORT, etc.
  • Provide assistance to the development team on performance tuning, resolving locking solutions, assist data modeler with SQL scripts
  • Give consultation to development teams and end users with guidance and assistance in the effective use of database.
  • Perform capacity planning, volumetric analysis and planning growth for all partitions.
  • Analyze DB2 UDB Event Monitor information, physical design, performance characteristics of tablespaces, physical I/O rates, and table access activities.
  • On call pager support for off hour db2 alerts.
  • Write and test stored procedures on the test and production databases.
  • Performance tuning of the production and development databases using explain tools.
  • Supported the Call center Sales and service representatives with their user problems and performance problems.
  • Perform db2 performance changes by tuning relevant db2 parameters and checking Load Runner test results and provide a mathematical analysis of any db2 production implementation.
  • Schedule and execute reorg/runstat on the database tables.
  • Use db2 C-library programs to create a much faster data load tools.
  • Develop automated scripts for redirected restore of database to clone databases for development, Quality-Assurance and performance environments.
  • Used perl-XML programs to provide a better view of the db2 related reports.
  • Set up and monitor the Queue Replication tool on the mainframe ZO/S platform.
  • Worked on TSO, JES3, JCL, SPUFI, REXX, ISPF and setting up SMPE zones on the ZOS system.
  • Making sure the replication is running between the two sites on the DB2 for ZO/S platform.

Environment: Solaris OS5.0 db2udb, 9.5, 9.1, 8.2, DB2 Connect, Websphere, XML, Load Runner, Confidential DB2 content manager

Confidential, Baltimore

Senior administrator/developer

Responsibilities:

  • Migrated production databases from DB2 LUW V8.2 to DB2 LUW V9.1
  • DB2 Connect experience with activities involving design, installation and configuration
  • Creation, instance upgrade and version migration. Implement a library of homegrown scripts to automate the scheduling and notification of periodic maintenance jobs, including REORG, BACKUP, RUNSTATS, LOAD, IMPORT, etc.
  • Created perl tools to check the consistency of all the database systems of the Confidential .
  • Used perl and xml to present XML spreadsheet reports to the client.
  • Installation, configuration and upgrading of DB2 server software and related products.
  • Event monitoring and trouble shooting database issues, by enabling various diagnose level settings.
  • Provide assistance to the development team on performance tuning, resolving locking solutions, assist data modeler with SQL scripts
  • Co-ordinate with Confidential Global Support for resolving various reported issues
  • Design, analysis and creation of new databases (analysis about number of database partitions, available memory, database size, database & database manager configuration options).
  • Database objects creation & alteration (tables, indexes, views, stored procedures, functions)
  • Create and maintain users, user groups and schemas for porting applications as well as controlling database access.

Environment: Solaris OS5.0 db2 udb, 9.5, 9.1, 8.2, DB2 Connect, Websphere, XML, Load Runner, Confidential DB2 content Manager

Confidential

Db2 Administrator

Responsibilities:

  • Design, analysis and creation of new databases (analysis about number of database partitions, available memory, database size, database & database manager configuration options).
  • Database objects creation & alteration (tables, indexes, views, stored procedures, functions)
  • Ability to troubleshoot day-to-day problems encountered on production as well as development, test database environments in single and multiple partitions.
  • Optimize the query access plans, resource and space utilization.
  • Strong skills in writing perl and shell scripts in Unix and the good knowledge about UNIX servers and server architecture.
  • Worked and developed applications using Java based tools like Log trace analyzer and event monitor analyzer.
  • Develop and implement standards to create various database objects.
  • Installing and maintaining DB2 environment includes creating databases, buffer pools, logical and physical design of database storages using DMS/SMS tablespaces.
  • Worked on a LPAR virtual environment with a number of application servers on different LPAR.
  • Helped plan the optimum utilization of the CPUs and memory between the application and the database within the LPAR virtual environment.
  • Allocate database sizing with proper log space and establish securities.
  • Create and implement effective referential integrity rules for complex databases in OLTP environment.
  • Setup and monitored MQ queue depths which feed and extract data coming into db2
  • Full database administration (TSM backup, TSM restore, implementation and upgrade, capacity planning and sizing, performance tuning)
  • Managing Database user privileges (granting & revoking permissions after proper analysis & approval).
  • Monitor and trouble shoot ETL jobs running on informatica.

Environment: AIX5.X db2 udb 7.1, 8.2, DB2 Connect, Websphere, XML, MQ Series, Tivoli, Informatica, Siebel, Peoplesoft

Confidential, MA

Administrator/Configurator

Responsibilities:

  • Analysis and System and Application Architecture for project requirement
  • Application Server, Database Servers, Work stations hardware and Software requirements
  • Closely work with Project manager for project plans, deliverables and upgrades
  • Used Siebel Tools to configure and customize the applets, views, screens and then transfer the repository between environments
  • Registration of employee s in Siebel database and assign them responsibility and position.
  • Creation of user s in data base and gave them required database privileges
  • Studied the CRM legacy system, mapped legacy system to Siebel base tables and to transfer legacy data into Siebel interface table.
  • Run EIM to transfer data from interface tables to Siebel base tables.
  • Configure and Troubleshoot the IFB file for controlling and optimizing the EIM batch processing and performance.
  • Setting up the assignment manager and workflow manager
  • Supported the Call center Sales and service representatives with their user problems and performance problems.
  • Adding validations and manipulations and applying additional business logic using Siebel VB/e script.
  • Export and import repositories between Development to QA and QA production.
  • Worked on upgrade from Siebel 99.5 to Siebel 2000 using Siebel upgrade wizard.
  • Preparation of distribution of new version of repository to the existing users using Siebel Anywhere.
  • Design and Developed Reports using Siebel Reporting tool Actuate

Environment: Siebel 2000, Siebel 99.5/99.6, Assignment Manager

Confidential, NJ

Siebel Administrator/Configurator

Responsibilities:

  • Closely worked with Sales management to understand business requirements and develop Functional requirements, technical specifications and customize the Siebel application and administration aspects.
  • Modification of Opportunity Screen.
  • Adding Validation to Opportunity Screen using Siebel Visual Basic.
  • Customization of Campaign Screen.
  • Modified my Campaign and Campaign over view applet.
  • Design and Developments of Events and Actions to Computer Telephony Events.
  • Gateway Server, Enterprise Server, Siebel Server, Siebel Web Server, and Interactive Server.
  • Worked on development Environment for Global deployment and setting up of multi language Siebel
  • Monitoring Siebel Servers and Server components, Creation of Database, Transaction processing.
  • Siebel Tools, Fat/Thick Clients, Thin Clients, HTML Clients & Siebel Interactive Database: Run database Scripts like install.ksh, imprep.ksh etc.
  • Configured Siebel Applications as per functional Specs. Siebel Configuration Files: Configuring Cfg files with suitable parameters.
  • Customized Siebel2000 as per user requirements, added some validations togging the applets, Attached positions, responsibilities and views MVG, Pick lists.
  • Importing data into Siebel from Flat files using Enterprise integration Manager Tool.

Environment: Siebel 2000

Confidential, NJ

Programmer/Analyst

Responsibilities:

  • Responsible for Architecture, design, development and implementation of EMS using JDK1.1 in Windows NT environment
  • This system is a monitoring system to check the performance of the network element
  • Used a middle ware called a Telecom Management Server
  • Used TL1 between the server and the network element
  • The network element was simulated using GUI based virtual network element
  • Responsible for the server side code for the fault details and cross connect details, server side extensions
  • Responsible for the Get Cross - Connect details and Get Fault Details, TL1 commands using a TL1 adaptor
  • Responsible for designing the schema for storing the alarm details in a RDBMS based database, by defining the primary keys and the required fields
  • Responsible for the JDBC connectivity code between the database and the server

Hire Now