SUMMARY

• 8+ years of proven DB2 DBA experience expertise in leveraging DB2 database platform for enterprise - wide solutions. Work experience includes DB2 Application Programmer/ DB2 Database Administrator.
• Administered DB2 Z/OS for v 9.x/8.x/7.x/6.x on IBM mainframe and AIX DB2 environments.
• Hands on experience as DB2 DBA for mainframes and AIX environments and Lead team of 7 DB2 DBA. Provided mentoring services in DB2 DBA, Data Modelling and Development.
• Experienced as Application & Support DBA. Hands on experience in Data Integration, Performance Tuning and troubleshooting problems. Exposure to Complete Software Development and Maintenance Life Cycle.
• Strengths include Data Architecture, database administration, production support, Performance Monitoring and Tuning.
• Has extensive experience in using Third party tools like Platinum for Database operations like Tuning, monitoring, backups & recovery, Data loads and other Database operations.
• Extensively worked with DB2 Z/OS 6.x/7.x/ 8.x/9.x on Z/OS system on mainframes.
• Has knowledge of Power Designer for data modelling.
• Exceptional skills in Tuning and analysing application code such as SQL, Triggers, Stored Procedures, CPU, I/O, Memory, setting up Backup and recovery strategies, scheduling jobs, developing database procedures, functions and packages.
• Worked closely with Project Architects/Technical Managers to assure adequate technical directions / standards are followed and issues are addressed.
• Has mentored Users and IT Staff in Application development in Db2 Database Technologies.
• Extensively worked with DB2 Explain, Runstats, REORG and other ONLINE and Offline utilities. Experienced in (24 x 7) Production Support
• Knowledge of Disaster recovery, Buffer pool maintenance/tuning.
• Experience in supporting critical production databases on 24x7 basic.
• Worked with Data Team for developing and tuning SQLs for data reconciliation from various data sources.
• Extensively worked with RTS to optimize production environment.

TECHNICAL SKILLS

Hardware: IBM Mainframe, NT, PC

OS: OS/400, Windows, DOS

Databases: DB2, SQL Server, MS Access, ORACLE

Data Modelling: Power Designer

Db2 Tools: Platinum, Db2 Admin, Visual Explain, TMON, QMF, BMC utilities OMEGAMON, Replication Center, SMPE

Languages: SQL, COBOL, JCL, CSP, VB, CICS, REXX

Other Skills: RACF admin, RMDS admin

Version Control Tools: Microsoft VSS, Clearcase, SCLM, Endevor, ISPW

Scheduling Tools: OPC, Control - M, CA - 7

PROFESSIONAL EXPERIENCE

Confidential

DB2 Database Admin

Responsibilities:

• Production Support for all DB2 related applications on 24X7 basis.
• Provided full range of production DB2 support for all mission critical databases.
• Designed Implemented and supported databases as well as Custom developed.
• Database Performance monitoring, tuning and capacity planning.
• Backup Planning and Recovery.
• Object Creation/alteration and Granting access.
• Object / Data Migration from one DB2 subsystem to another.
• Running Offline/Online utilities for data maintenance.
• Doing BIND/REBIND for new / existing applications.
• Planning for VSAM to DB2 conversion.
• Data Modelling and implementation of Database design.
• Resync of Subsystems on two different machines.
• Imparting training to the Application Development Team.
• Resolving developer issues with accessing Production data from non-mainframe sources.
• Support and Administer Db2 Queue replication between DB2 Z/OS and distributed environments.
• Testing zparms features and optimizing suggestions to DBMS group for implementation.
• Exposure to SMP/E for migrating from DB2 V7 to V8 and installation.

Confidential, Phoenix

DB2 Database Admin

Responsibilities:

• Apply database object changes, involve in database structure design, capacity planning, and data movement, store procedures/functions creation and migration.
• Working closely with DA, Business analysts, COGNOS, data warehouse and Data marts and web application (OLTP) team like Disability reporting, Finance metrics, CRU reporting, LAGER application, Health care reforms, Guardian Online, Group Sales reporting and Data warehouse etc.
• Performance monitoring, query optimization/SQL tuning and monitoring of ETL Queries and database long running SQL’s.
• Experience in conversions of logical design to physical design.
• Performing Users change requests and resolve application team’s database related issues.
• Production environment monitoring using monitoring tools omegamon, DB2TOP, Topas, NMON, foglight, BSM etc.
• Database installations, upgrades, apply patches on single partition and DPF databases, pure scale installation, Table partition, and compression.
• Involve in Disaster Recovery (DR) testing.
• Executing database utilities Bind/Rebind/explain/Backup/restore/export/import/db2look/REORG/UNLOAD/ LOAD/recovery etc.
• In-house created health check scripts and jobs, database related alerts.
• Storage monitoring and take preventive actions.
• Create in-house maintenance jobs (shell/Perl//Power shell scripting) and Standard operating procedures.
• Experience in creating standard operation procedures (SOP) and run book documentation for DBA team reference.
• 24x7 on-call support and alert monitoring.
• Perform basic tasks on oracle and SQL server’s databases.

Confidential, Dallas

DB2 Admin

Responsibilities:

• DB2 Database design and manipulations.
• Database refresh from Prod to TEST/QA regions and data movement.
• Monitoring of Production environment using monitoring tool Omegamon XE for DB2 PM.
• Performance tuning of DB2 SQL’s.
• Performing Users change requests.
• Resolving of production job failures/on call support.
• Executing Database utilities like Copy/Reorg etc.
• Co-ordinate with application teams and fixing of testing errors.
• Monitoring of storage/DB2 Object extents and take action accordingly.
• Performing yearly activities like Data purge/Archival etc.

Confidential

DB2 DBA

Responsibilities:

• Design database physical layout using ERwin, created reports on database model (Entities, attributes) through ERwin tools. Maintain and track different model version.
• Setup database three-tier environment which include backend --DB2 UDB, middleware--Sybase EA Server, Front-end GUI application developed by PowerBuilder. Plan for the DB2 implementation including database sizing, new volume group, logical volume, file system, how data placement on disks.
• Designed and implemented Backup and Disaster Recovery Plan using TSM.
• Designed and implemented security plan.
• Performance tuning and troubleshooting the database server. Developed application and database system update process.
• Wrote stored procedures using SQL and Java, enable debug function for stored procedure builder in development environment.
• Changed Database structure, extracted and loaded data. Automated routing operation using Korn shell, Perl scripts and SQL scripts.
• DB2 SQL coding support for the applications development team.
• Use crontab to automate system operation. Using vmstat, iostat to check the system I/O and CPU using condition.
• Designed and implemented the database file system structure and mirrored some important file system.
• Database capacity planning and monitoring.