UDB DB2 DBA Resume

Title
UDB DB2 DBA

Primary Skills
DB2 DBA , AIX/UNIX/LINUX

Location
US-GA-Atlanta (will consider relocating)

Posted
Apr-16-09

Summary of Qualifications
Seasoned DB2 database administrator with extensive experience supporting application development, resolving DB2 issues, monitoring data security and integrity, as well as assessing data models to ensure technical accuracy. Diligent and detail-oriented, able to Lead and manage projects, direct personnel, and design, implement and analyze systems. Effective communicator capable of working productively with multilevel personnel and project management. Possess a strong background supporting business applications development on various platforms.

Work Status :- US Citizen

Technical Skills
Databases: DB2 UDB V8.2 ESE fixpak 15(8.2), 7.x EEE/EE, SQLServer
App Server: Web Sphere (Net. Commerce 3.1), Tomcat, Apache
OS: AIX V 5.3 on RS/6000, AIX v 5.1, Linux, UNIX
Windows 2000/2003
Tools: people Tools, event monitors, snap shots using shell scripts, Quest Center, BMC Patrol, BMC Change Manager, DB2 Everyplace(Evaluation), DB2 Gateway, DB2 Connect, DB2 Replication Center (DB2RC)
BI Tools: Informatica, Business Objects
Hardware: RS/6000, p670, IBM 370/390, OS/390, 3270 Emulator, Dell, SAN



Professional Experience

NORTHROP GRUMMAN, LA Sep 2007 -- Present
DB2 UDB DBA


• Participated with the business analyst in analyzing business requirements and designed databases to support the business requirements.
• Performance monitoring and tuning.
• Collaborated with developers to devise DDL and DML, in addition to contribution to code walk-thru's to analyze SQL code efficiency.
• Monitor databases and make adjustments to improve performance of database or applications that use the data.
• Develop and maintain compliance to database standards and procedures. Assist with design and organization of database during systems development process
• backups, Reorgs, Runstats, Space monitoring, moving the db2diag.logs.
• Taken care of data skew
• Installing and maintaining DB2 environment includes creating databases, buffer pools, logical and physical design of database storages using DMS/SMS tablespaces.
• Optimize the query access plans, resource and space utilization.
• Maintain security administration includes handling instance / database level authorities.
• Dealt with locking mechanisms on both databases extensively for a smoother application migration
• Performance monitoring and tuning for DB2 databases
• Troubleshoot locking, loading issues, connectivity, degraded performance
• Creating EXPLAIN tables and running the visual explain utility on SQL statements.
• Help the developers to formulate the queries.

Environment: UDB DB2 8.2 ESE, Quest Central, Tivoli Storage Manager (TSM), DB2 V8.2.



IBM Global Services, Oct 2006 -- Aug 2007
DB2 UDB DBA (work remotely)


• Part of the IBM Global Services team handling American Express account.
• Served as the UDB DBA for the development, installation, and support of all online applications including implementation of various Amex projects.
• Designed and documented monthly updates load process and scripts.
• Installation of DB2 instances on AIX.
• Installed and configured the multi node environments residing on AIX with UDB DB2 V 8.1 EEE and also with UDB DB2 V 8.2 ESE.
• Resolved various tickets pertaining to EE and EEE issues.
• Excellent experience working on multi node environment with database sizes ranging from a few GB to multi terabytes.
• Implemented DMS tablespaces with autoextend features.
• Implemented a Disaster Recovery Solution for the database.
• Did capacity planning for the existing database when the data was supposed to increase and new schemas added.
• Implemented db2 fixpaks and did migrations, client installations and upgrades.
• Implemented the purge strategy keeping in mind that there should be no need for reorganization.
• Achieved great performance improvement by migrating to p690, lesser maintainence. Down time and maintainence window was reduced.
• The Backup restore process was brought down drastically.
• Collaborated with developers to devise DDL and DML, in addition to contribution to code walk-thru's to analyze SQL code efficiency.
• Ensured that developers adhered to standards during program preparation and implementation by assessing program SQL, verifying efficient access path, giving security access, and providing support.
• Extensive DB2 UDB DBA and DB2 Connect experience with activities involving design, installation, configuration, requirements gathering, data modeling, tuning, security, backup, recovery and integration of database applications.
• Migrating data from DB2 7.1 to DB2 8.2.
• Performance monitoring and tuning for DB2 databases
• Creating EXPLAIN tables and running the visual explain utility on SQL statements.
• Run the capacity testing; perf, design and implement procedure for capacity testing.
• Production support to various db servers and participated in On-Call rotation on weekly basis
• Acted on the tickets opened in ManageNow, on production servers providing level 2 support and on some projects providing level 3 support
• Configured and Implemented the server including setting up the database filesystems(with sudo root access privileges) and implemented the full physical design for a VLDB Datawarehousing environment.
• RCA(Root Cause Analysis) team

Environment: UDB DB2 V 8.2 ESE, RS/6000 p-series, 5.3, Web sphere Commerce Suite, Teamsite, AS/400, Quest Central, Sun Solaris, DB2 Connect, Linux.




AXIANT, Atlanta, GA Oct 2003 -- JUL 2006
DB2 UDB DBA


• Created logical/physical design for the datawarehouse.
• 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 (FP 7a) on dev / qa and production.
• Applied latest fixpaks.
• Installing db2 software on server and 2 tier clients.
• Setting up connectivity on 2 tier clients.
• Populating database, preparing SQR.
• Building Peoplesoft views and temporary tables.
• Loading stored SQL Statements.
• Use Data Mover, People Tool to transfer data between Peoplesoft databases, control database security access.
• Analyze Performance bottlenecks and proactive monitoring.
• Troubleshoot Peoplesoft application problems, locking, loading issues, connectivity, degraded performance etc.
• Scaling database, partitioning databases, relocating db containers.
• Design and implement the proof of concept on development environment.
• Installed DB2 ESE v8.1 (FP 7a) on dev / qa and production.
• Creation of database / nodegroups / tablespaces and various objects.
• Write scripts to unload data and automate autoloader scripts.
• Enhance the performance to meet the desired standards.
• Handle Engineering change requests.
• Evaluated DB2everyplace for connecting to various other servers within our environment
• Evaluated DB2 Recovery Expert for recovering the lost objects on a EE environment
• 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.
• Work with Peoplesoft application development team to design new and re-engineer existing applications.
• Automation of weekly update process using scripts.
• Creation and implementation of triggers and stored procedures for implementation of custom required processes.
• Performance monitoring and tuning.
• Automated the backups, Reorgs, Runstats, Space monitoring, moving the db2diag.logs, monitoring the size of the table spaces by setting up a threshold (70%) etc.
Environment: UDB DB2 V 8.2 ESE, AIX, WINDOWS NT, DB2 Connect, DB2e, People Soft, PeopleTools.

Certifications
See above


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

Resumes in Atlanta, GA | Resumes in Georgia

View other UDB DB2 DBA resumes, Database Administrator resumes