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