SUMMARY

• Over 15+ years of experience in IT with expertise in Design, Implementation & Maintenance of DB2 UDB 7.2,8.2, 9.5 & 9.7 Database Administration on AIX, LINUX, UNIX, SOLARIS and WINDOWS environments and DB2 V9, V10 on ZOS.
• Experience in Design, Development and System Analysis.
• Implementation of software applications in Client/Server technology
• Strong experience in performance monitoring and fine - tuning for optimal performance of SQL queries, Database Space Management, Schema creation.
• Provided mathematical analysis of db2 changes implemented on test environments and verifying teh test results before implementing teh db2 changes on teh production systems
• Worked on various software applications which depend on DB2 like IBM Db2 Content Manager, Siebel, Peoplesoft, LUMOS Element management system, Hadoop.

TECHNICAL SKILLS

SKILLS Programming: Java, Perl, C, PL/SQL, SQL, UNIX Shell, Rexx

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

Storage: Tivoli Storage Manager

Middleware: IBM Websphere, MQ Series, QREPLICATION

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

Hardware: Sun Solaris, IBM RS 6000

Monitoring tools: Tivoli, Omegamon, Spotlight

Data Modeler: Erwin 7.x

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

Senior DB2 Administrator

Responsibilities:

• Provide assistance to teh 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 teh effective use of database.
• Analyze DB2 UDB Event Monitor information, physical design, performance characteristics of tablespaces, physical I/O rates, and table access activities.
• Create and maintain users, user groups and schemas for porting applications as well as controlling database access.
• Managing data loads based on teh referential integrity of teh DB2 tables.
• Provided DB2 administrator support on a data management project to create a data dictionary for teh metadata elements.
• Database objects creation & alteration (tables, indexes, views, stored procedures, functions)
• Performance tuning of teh Test and development databases using explain tools.
• Schedule and execute reorg/runstat on teh database tables.
• Use db2 C-library programs to create a much faster data load tools.
• Used perl-XML programs to provide a better view of teh db2 related reports.

Environment: AIX, db2udb, 9.5, 9.1, 8.2, Adelphi, Websphere, XML, Load RunnerDepartment of Social Security Administration, Baltimore

Confidential

Senior DB2 Administrator/Developer

Responsibilities:

• Worked on development and automation of teh production system for teh Social security administration’s, Confidential .
• 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 teh scheduling and notification of periodic maintenance jobs, including REORG, BACKUP, RUNSTATS, LOAD, IMPORT, etc.
• Created perl tools to check teh consistency of all teh registry, database manager and database configuration parameters between all teh environments.
• Experienced in performance tuning and query optimization using DB2 tools like db2advis, db2look, db2pd, snapshots, STMM.
• Experienced in using system tools to monitor memory, swap, space and I/O activities in large object database environment.
• Experienced in creating backup and recovery to storage areas, redirected restoration of database between production and test environments.
• Event monitoring and troubleshooting database issues, by enabling various diagnose level settings.
• Provide assistance to teh development team on performance tuning, resolving locking solutions, assist data modeler with SQL scripts
• Co-ordinate with IBM Global Support for resolving various reported issues
• Design, analysis and creation of new databases (analysis about available memory, database size, database & database manager configuration options).
• Documentation of all problem determination and change management procedures in a SSA formatted document.
• Set up and monitor teh Queue Replication tool on teh mainframe ZO/S platform.
• Set up SMPE zones on teh ZOS system.
• Prepared and executed Rexx programs for comparing datasets, for looking for patterns in datasets. And Designed and developed stored procedures in REXX and Perl for inputs into database.
• Making sure teh replication is running between teh two sites on teh DB2 for ZO/S platform.

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

Confidential

Db2 Administrator

Responsibilities:

• Ability to troubleshoot day-to-day problems encountered on production as well as development, test database environments in single and multiple partitions.
• Optimize teh query access plans, resource and space utilization.
• Strong skills in writing perl and shell scripts in Unix and teh 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.
• Monitoring backups and log shipping between primary and secondary databases.
• 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 teh optimum utilization of teh CPUs and memory between teh application and teh database within teh 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 teh applets, views, screens and tan transfer teh repository between environments
• Developed functional specifications and responsible for handling all teh technical works. Interacted with teh users, other team members, Database Administrators, prospective user Groups, Confidential Inc., third party vendors and teh 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 teh 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 teh IFB file for controlling and optimizing teh EIM batch processing and performance.
• Setting up teh assignment manager and workflow manager
• Supported teh 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 teh 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:

• 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 teh 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
• dis system is a monitoring system to check teh performance of teh network element
• Used a middle ware called a Telecom Management Server
• Used TL1 between teh server and teh network element
• Teh network element was simulated using GUI based virtual network element
• Responsible for teh server side code for teh fault details and cross connect details, server side extensions
• Responsible for teh Get Cross-Connect details and Get Fault Details, TL1 commands using a TL1 adaptor
• Responsible for designing teh schema for storing teh alarm details in a RDBMS based database, by defining teh primary keys and teh required fields
• Responsible for teh JDBC connectivity code between teh database and teh server

Confidential

Programmer

Responsibilities:

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

Confidential

Programmer

Responsibilities:

• GUI design, coding, testing and delivery of teh software to teh client
• Estimation, Quotation and invoicing, keeping track of serviced materials, warranty details, checking etc
• In dis 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 teh client
• Design, development and testing of teh GUI for teh inventory module