We provide IT Staff Augmentation Services!

Senior Db2 Administrator Resume

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

Certifications: Advanced DB2 DBA, Db2 content Manager. DB2 Z/OS

EXPERIENCE

Confidential MD

Senior DB2 Administrator

  • 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, Martin

  • 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 National computing center.
  • 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

Poughkeepsie

Db2 Administrator

  • 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
  • Developed functional specifications and responsible for handling all the technical works. Interacted with the users, other team members, Database Administrators, prospective user Groups, Siebel Systems Inc., third party vendors and the project management team.
  • 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:

Modules:

  • Customization of Company, Contact applets under Company Screen.
  • 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

Element Management System

  • 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

Confidential, 

Programmer

  • Designed and developed Confidential, a net-net-centric application targeted towards Mortgage, Car and banking Industry.
  • Created database to store the loan applications received from the client through socket

Confidential,  

Programmer

 
  • GUI design, coding, testing and delivery of the software to the client
  • Estimation, Quotation and invoicing, keeping track of serviced materials, warranty details, checking etc
  • In this application a large volume of data is ported from earlier database to application database
  • Generation of reports as per clients requirements using crystal reports
  • Documentation of discussions with the client
  • Design, development and testing of the GUI for the inventory module

Hire Now