Resume of Senior DB2 Database Administrator




Title
Senior DB2 Database Administrator

Primary Skills
Operating Systems : AIX 5.1, Linux, SOLARIS 5.8, WIN NT/2000, SCO-UNIX, MS-DOS. Languages : SQL

Location
US-GA-Smyrna (will consider relocating)

Posted
Mar-08-07

RESUME DETAILS
SUMMARY:

•Over 6 + years of experience as DB2 Database Administrator.
•Extensive experience in implementing Replication, backup and recovery strategies, performance tuning and installation of DB2 on AIX.
•Extensive database experience using DB2 UDB EE, ESE V7.x/8.x on UNIX (AIX, Solaris, Linux).
•Strong experience in supporting large volume DB2 Databases.
•Strong in db2 udb physical design.
•Experience in Implementation and supported of VLDB.
•Setup and maintained db2 udb data replication.
•Extensive experience in Database design, Data analysis, performance tuning, monitoring and application support on NT/Unix.
•Expert in UNIX programming. Very good at shell scripting.
•Strong analytical ability and good communication skills.
•Possess a strong background supporting business applications development on various platforms.
•Effective communicator capable of working productively with multilevel personnel and project management.


TECHNICAL SKILLS:


Operating Systems : AIX 5.1, Linux, SOLARIS 5.8, WIN NT/2000, SCO-UNIX, MS-DOS.
Languages : SQL
RDBMS : DB2 UDB v8.2, 7.0, SQL Server 2000/7.X, MS Access 97, 2000.
TOOLS : Embarcadero, Erwin, DB2 Replication, DB2 development Center, Control center, DB2 Query Patroller, Visual Explain, DB2 Information integrator, Replication Center, Erwin, RACF, DB2CONNECT, DB2 Data Warehouse center, DATAPROPAGATOR.
Hardware : Sun E6500, RS/6000, IBM PC's, and Pentium PCs, HP servers, IBM Pseries.


PROFESSIONAL EXPERIENCE:

Confidential July 05 - till date
(UDB DB2 DBA)

Primary DBA for EDW system, this is currently 11+ TB, system used for decision support. Brief synopsis of the tasks which were performed as a db2 dba on EDW.

Responsibilities:
•Performance tuning of production database.
•Involved in tuning of SQL queries.
•Did sanity check for all the db2 databases in the environment.
•Troubleshoot production issues.
•Monitor database performance ,like bufferpool hit ratio,package hit ratio, catalog hit ratios.
•Monitor usage of temp and swap space.
•Upgraded udb database from 8.1 to 64 8.2.
•Migrated udb database from 32bit to 64 bit code.
•Installed fixpak 11 on udb databases.
•Performance monitoring and tuning.
•Support the EEE environment with a size of 4 TB , 9 logical nodes and SMP configuration, also on call support for db2 udb ESE.
•Implemented and tested incremental backup for eee environment.
•Created a document for, the best practices to follow daily, weekly, monthly to keep the database Health.
•Recommended indexes for queries that run long.
•Involved in day to day database administration tasks like running reorg's, runstats, import, export,
Explain, db2advis, taking snapshots, running list applications, checking the memory, backups and restores etc.
•Monitoring and providing 24x7 support for the production database.
•Resolved engineering change requests.
•Worked on TSM and also supported applications on websphere, resolved performance and connectivity issues.
•Generated reports of Database statistics to present to higher management.
•Supported the development team with new releases.
•Involved in the Installation of fix packs.
Environment: DB2 UDB ESE 8.2 fp11, AIX 5.3, Data warehousing, Java 2.0, MS PowerPoint, MS Word, MS Excel, MS Outlook, MS Office, MS FrontPage, MS Access, Windows NT/2000, Lotus Notes, Web sphere v5.


Zantaz Corp, CA
Jan 04 -- Jun 05
(UDB DB2 DBA)

Responsibilities:
•Created logical/physical design for the dataware house.
•Formulate backup/recovery strategy.
•Work with system admins to make system available for production.
•Design and implement the proof of concept on development environment.
•Installed DB2 ESE v8.1 on dev / qa and production .
•Applied latest fixpaks.
•Creation of database / nodegroups / tablespaces and various objects.
•Write scripts to unload data and automate autoloader scripts.
•Create test cases for benchmark testing.
•Enhance the performance to meet the desired standards.
•Handle Engineering change requests.
•Performance tuning was an on going process, tuning queries.
•Rebalance the nodes for even distribution of load on all nodes.
•Poc for the backup/recovery process.
•Help the developers to formulate the queries.
•Involved in the Installation of fix packs.
•Expertise in SQL tuning, DB/DBM parameter tuning, different levels of memory allocations, various tools like export, import, load, autoloader and experience with all kinds of database snapshots.
•Creating and Monitoring Users, authorities and responsibilities and password management.
•Enhanced the application performance, by running RUNSTATS, REORGCHK and REORG utilities.
•Monitoring and managing disk space I/O Contention.
•Backup & Recovering Database, Online database backup, archived redo log file and offline database backup.
•Monitored Databases, using Database monitors, snapshot monitoring and Event monitoring.
•Generated reports of Database statistics using DB2LOOK Utility.
•Recovered data to a prior point in time using ROLLFORWARD command.
•SQL Tuning and Query optimization.
•Setup and maintained db2 udb data replication from aix to aix boxes.
•Tuning the application for the best performance.
•Tuning the Database and the system for the best performance.
•Day-to-day attending to the user queries in sorting out database problems
•Coordinating with user departments and attending their requirements for the smooth functioning.
•SQL Programming -- Developing Database Views and reports for respected divisions.
•Change Management -- change requests understanding, analysis of implementation, impact analysis, implementation, Feedback solutions
•Problem Management -- Problem understanding, impact analysis, Development co-ordination, implementation, Feedback solution.
Environment: DB2 UDB ESE 8.1, AIX 5.1,Data warehousing, Erwin, MS PowerPoint, MS Word, MS Excel, DPROP, MS Outlook, MS Office, MS FrontPage, MS Access, Windows NT/2000, Lotus Notes, Web sphere v5.


Solectron Corp,CA
Feb 02 -- Dec 03
(UDB DB2 DBA)

Development, implementation, and maintenance of the data mart made out of three Siebel servers each residing on RS/6000 servers with IBM AIX as the operating System, located in North America, Europe and Asia-Pacific regions, Shell Scripting and UDB DB2 V 7.2 EE special features.

Responsibilities:
•DB2 UDB EE 7.x Database administration and support.
•Experience in database restores and disaster recovery.
•Created database objects: Tables, Table spaces, Indexes, views, aliases.
•Logical and Physical Database design.
•Altered tables and added check constraints and referential integrity.
•As a member of DBA team, created and maintained databases, table-spaces, tables, views, and indexes.
•Prepared and implemented standard recovery procedures for data recovery.
•Interact with business team and development teams for incorporating new functionality.
•Participated in enterprise-wide application and database production releases.
•Designed and implemented backup architecture viz., backup requirements, backup standards and retention's.
•Developed shell scripts to handle DBA tasks and alerting systems.
•Documented plans and procedures in terms of backups, restores and disaster recovery.
•Checking the consistency of the databases using different db2 commands.
•Data maintenance activities like REORG, RUNSTATS, LOAD, UNLOAD, IMPORT and EXPORT.
•Tuning application queries, Databases and Systems for best performance.
•Performed performance tuning and capacity planning using the parameters of dbm configuration file & db configuration file and various db snapshots.
Environment: DB2 UDB V6.1/7.1, ERWIN, and AIX 4.3.

Napaonline.com, Atlanta, GA
Dec 00 -- Jan 02
(DB2 UDB DBA)

Implementation of napaonline.com, a website which sells Automotive parts, which are manufactured by NAPA and Genuine Parts Company (GPS) across the United States. Developed, implemented, and supported a number of merchandising applications from the database perspective including Store Ordering, Purchase Orders, Receiving, Direct Store Delivery and Replenishment.

Responsibilities:
•Served as the lead DBA for the development, installation, and support of all online applications including implementation of discount provision for AAA customers.
•Designed and documented monthly updates load process and scripts.
•Installation of DB2 instances on AIX.
•Migrating data from DB2 5.2 to DB2 6.1.
•Migrating Sybase ASE V 10.5 to UDB DB2 V 6.1.
•Process flow preparation for the migration from Sybase to UDB DB2.
•Used Erwin V 3.2 to migrate the Sybase data model to UDB DB2 data model. (A reverse engineer and a forward engineer would fit the purpose)
•BCP utility in Sybase to migrate data from one database into ASCII comma files to load UDB DB2 tables.
•Used DataJoiner tool to replicate/data transfer to another Sybase database.
•Compared Sybase Isolation levels with UDB DB2 isolation levels and implemented requisite bind parameter on DB2 for a smooth running of the application on DB2 without any potential of locks.
•Dealt with locking mechanisms on both databases extensively for a smoother application migration.
•Analyzed, the SQL-CW (conversion work bench) from Mantech Systems Solutions Corp., for data migration techniques, used unload and load commands from the tool for data migration.
•Helped out programmers in migrating Sybase Stored procedures to DB2 Embedded SQL programs written in Java.
•Conversion of remotely called stored procedures into UDB DB2 remote stored procedures using NFS mounted file systems
•Conversion of Views built on other views from Sybase to DB2
•Conversion of unique identifier from Sybase to DB2
•Performance monitoring and tuning for DB2 databases
•Creating EXPLAIN tables and running the visual explain utility on SQL statements.
•Run the capacity testing; perform benchmark testing, design and implement procedure for capacity testing.

Environment: UDB DB2 V 6.1EEE/EE, RS/6000 Model B50, F80, AIX 4.3.1, net. commerce 3.1, Erwin, Teamsite, AS/400, Oracle V 7.1, Quest Central, DJRA V 2.1, SQLGuy (Evaluation version), PeopleSoft, Sun Solaris, DB2 Connect.

Honda of America, Columbus, OH
Jun 99 - Nov 00
(DB2 UDB DBA)

Responsibilities:
•Used utilities to Backup and recover user data and DB2's catalog.
•Created databases and other database objects.
•Worked with export, import, load utilities to manage table data.
•Prepared and implemented standard recovery procedures for data recovery.
•Used RUNSTATS, REORGCHK and REORG to enhance application performance.
•Used DB2 access control mechanism to implement security within the database.
•Involved in installing DB2 UDB on AIX, create Instances and databases including DBM configuration on different servers and provide connectivity to Development, test, staging and production databases.
•Recovered data to a prior point in time.
•Creation of Database Objects Tables, Table space, Indexes and Storage group.
•Involved in developing database application objects like stored procedures, functions, triggers and user defined data types.
•Involved in Performance and Tuning by considering the parameters like Hardware, Database configures Parameters, SQL statements and Web Sphere App Server.
•Using EXPORT, IMPORT and LOAD utilities, moving Data between tables and output files.
•Created Buffer Pool objects to cache database data pages in memory and reduce the physical I/O access to disks.
Environment: DB2 UDB V6, AIX 4.3, Web Sphere 4.0, Stored procedures and Shell Scripts.

Certifications
See above

CONTACT DETAILS

You must be logged in and have a current resume access subscription. Login or Register »


View all resumes in US-GA-Smyrna »
View all resumes in US-GA »

View other Senior DB2 Database Administrator resumes, Database Administrator resumes