We provide IT Staff Augmentation Services!

Senior Db2 Administrator Resume

2.00/5 (Submit Your Rating)

Washington, DC

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 the test results before implementing the db2 changes on the 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 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.
  • 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 the referential integrity of the DB2 tables.
  • Provided DB2 administrator support on a data management project to create a data dictionary for the metadata elements.
  • Database objects creation & alteration (tables, indexes, views, stored procedures, functions)
  • Performance tuning of the Test and development databases using explain tools.
  • Schedule and execute reorg/runstat on the 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 the 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 the production system for the 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 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 registry, database manager and database configuration parameters between all the 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 the 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 the Queue Replication tool on the mainframe ZO/S platform.
  • Set up SMPE zones on the 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 the replication is running between the two sites on the 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 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.
  • 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 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, Confidential 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:

  • 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

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

Confidential

Programmer

Responsibilities:

  • 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

Responsibilities:

  • 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

We'd love your feedback!