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