SUMMARY

• 10+ years of extensive IT experience in DB2 UDB Database Administration on AIX including Project Management & leadership, Data Modelling, Technical and business analysis, Programming, Capacity Planning, Migration.
• Installation, configuration, tune, manage of DB2 UDB Systems.
• Experience with various industries like Finance, Health Care, Data processing and child support services.
• Experience managing teams in USA, UK and Asia Pacific in offshore and onshore model.
• Extensive experience working with DB2 UDB (Ver 8.1/V9.5/V9.7/V10.1) Enterprise Server edition & DB2 Infosphere on AIX including Admistation, Monitoring, Performance tuning, Database backup and recovery, Database design, Migration.
• Experience working with data warehouse and OLTP Systems.
• Experience managing terabytes (TB) of DSS (DW), 500+ TB, 120+ partitions and 6 TB of OLTP system.
• Extensibly worked on Performance tuning especially SQL using different techniques including building MQT, MDC, native explain, Visual explain. Best tuning effort is to bring down the query running from 18 hours to 5 minutes.
• Excellent in automation using Shell scripting language.
• Good understanding of SAN architecture.
• Familier working on HADR (High Availability Disaster Recovery) environment.
• Excellent working knowledge of Database Partitioning Feature (DPF) systems including Administration, Maintenance, Tuning, Implementation.
• Migration experience on moving DB2 UDB V8.1 to V9.5 on AIX and DB2 V9.5 to V10.1.
• Fix pack installation as needed.
• Familier working on WLM (Work load manager) / QP (Query Patroller) in DB2.
• Familiar working on Q/SQL replication.
• Proven track record in doing capacity planning for small/medium/big projects.
• Proven track record in troubleshooting and addressing production issues like performance tuning and enhancement.
• Excellent Business and System analysis skill to understand the requirements for the client applications.
• Effective in cross - functional and global environments to manage multiple tasks & assignments concurrently.
• Goal-oriented individual with strong leadership capabilities. Experience managing team of 8-10 DBA’s.
• Highly motivated with strong commitment to quality and customer service.
• Proven ability to work in unison with staff, cross departments and management.
• Organized, highly motivated, and detail directed problem solver.
• Excellent knowledge sharing skill.
• Created training document/materials/plan for many junior DBAs and mentored them.
• Conducted several training for application team across organization on DB2 new features, best practices etc. All of these training really helped the application team and considered as a great success to the DBA department.
• Was part of product evaluation team for the organization. Help client save time and money by doing thorough analysis of the product and providing recommendation accordingly.
• Received recognition from big Financial client as “Best Performer DBA” award for the year 2006.
• Excellent working knowledge of Onsite / Offshore architecture.
• Excellent team player.
• IBM LUW Certified.

TECHNICAL SKILLS

Hardware: IBM P Series

Operating Systems: AIX 5.3/6.1, Windows 9X/NT/2000, Unix, MS DOS, Linux

Databases: DB2 UDB (Ver 8.1/V9.5/10.1) enterprise edition on AIX, DB2 Infosphere V9.5/10.1, MSACCESS, SQL Server

Languages: DB2 Stored Procedure, DB2 UDF, DB2 Triggers, Unix Shell Scripting, C++, SQL, HTML, JAVA, JSP, Javascripts, XML

Tools: /Utilities: Query Patroller, Control Center, SQL/Q Replication, Rational Suite Tools (Rational Team Concert, Rational Quality Manager, Rational Clearquest, Rational Clearcase)Erwin 4.0, Microsoft Visio, Veritas Netbackup, db2top aix utility, db2pd, IBM / Ascential DataStage 6.0, IBM Tivoli Monitoring, WLM (Work Load Manager), native explain, Visual explain, IBM Data Studio, Commvault

Methodology: Agile, Dimensional Modelling

PROFESSIONAL EXPERIENCE

Database Administrator

Confidential, CA

Responsibilities:

• Physical database design.
• Monitor and tune database performance.
• Estimate work effort for a CR/RFC.
• Capacity planning.
• Backup and recovery planning.
• Documents benchmarks and procedures needed to optimize performance.
• Review and analyzes change requests to determine scope of work.
• Install, patches, upgrades, maintains and support system.
• Implement database change request (DBCR).
• Assist application development and maintenance staff with database issues.
• Review and tune brio/hyperion reports.
• SQL tuning.
• Create optimization objects as and when needed.
• Health check of the system.
• Plan and coordinate performance regression runs.
• Database Metrics Tool - This tool was designed based on the daily snapshot data. This tool reports lot of metrics in grahical fashion like workload, locks, bufferpool usage, average page read/write time, connections, sorts etc. In short this tool can help you understand how your system behave during the defined timeframe. This tool is quite handy when we have to analyze our production or comparing our performance regression run with production or previous regressions.
• Table and Index Usage Analysis Tool - This tool can help you understand how each tablees and indexes are used on the system like how many rows are read, how many times indexes are used, how the index looks like etc. This tool works on the historical data and produce the reports accordingly. These reports can help you decide further course of action like if some tables are read more then you know what to do next or if index is not used from last 1 year then it’s a good candidate for drop etc.
• SQL snapshot file parser - I created Unix script to parse the SQL snapshot files and load it into DB2 table for further analysis. This is quite useful in some scenarios like for instance if I know which table is read more and which day, then I can load the SQL data for that day into tables using this script as data is stored in a files. I can then run the simple SQL statements on the DB2 table for further analysis.

Environment: - IBM DB2 UDB V9.5/10.1, IBM clearcase, IBM clearquest, Wily, AIX

Senior Professional Database Administrator

Confidential, Foster City, CA

Responsibilities:

• Estimate work effort for an RTN.
• Capacity planning.
• Attend all the relevant meetings related to a RTN and gather volumetric details for an work effort.
• Reviewing the DDLs provided by DA’s to make sure that it follows our standards.
• Design and deploy the DDLs as per the volumetric details
• Review and tune reports (Sometimes 200+ reports at a time)
• SQL tuning
• Create optimization objects if needed like MQT, stats views or indexes.
• Develop script/job to effectively rollin/rollout of data for a range partitioned tables.
• Fully support the project from development till production.
• Create the turn over document and hand it over to Production DBA team once the project is ready to go.
• Health check of the system.
• New product evaluation.

Environment: - IBM DB2 UDB Ver 9.7 DPF

Database Administrator

Confidential, Omaha, NE

Responsibilities:

• Gather and analyze requirements of the business users from JAD (Joint Application Development) sessions
• Analyze business and system requirements along with functional specifications with supporting business process flows and risk analysis
• Understand and fully document the Technical requirements for the project
• High Level Architecture of the System
• Data Source Mapping
• Develop the Blueprint for Data Integration Methodology
• Data research
• Logical Design of the database
• Coordinate between Technical (Java,ETL) and Business Teams
• Data evaluation
• Data Quality Assessment
• Involve in Business data validation
• System documentation
• Fix pack installations as needed
• Project Planning and Effort Estimation
• Capacity Planning
• Physical implementation of the database
• Working closely with Programmers on Troublesome SQLs and Performance Tuning Effort, used native explain OR visual explain to figure out any bottleneck
• Program reviews
• Setting SQL/Q replication from OLTP to EDW
• Initial setup of Query Patroller on EDW environment
• Initial setup of WLM on OLTP environment (new with Ver 9.5)
• Setting new Test Environments for Project as needed along with all needed tasks (like setting maintenance jobs through cron, tuning different db/dbm parameter if needed, tuning bufferpool and other memory areas etc)
• Perform redirected restore as needed (very frequent for one of our project)
• Working with vendor (IBM) on different issues
• Lead Migration effort of DB2 UDB Ver 8.1 to 9.5 (includes layout migration plan, fallback planning, test strategy, communication plan, building inventory, impact analysis, status reporting etc)
• Extensibly worked on HADR Testing
• Korn Shell development for critical functions (lik health check of the database). These scripts are executed through cron
• Create MQT, MDC as needed to boost Performance
• 24*7 support
• Writing UDF, Triggers, Stored Procedures as needed
• Responsible for Tools evaluation/selection/proposal
• Working on POC (Usually on new feature in new release)
• Study New Features with new Realease and document it
• Identify DB2 objects that can be benefitted by New Features (like Range Partitioning in Ver 9.5 can be used by some of our Monthly Tables)
• Conducting Trainings for Application Developers
• Mentor Junior DBA’s
• Define Standards & Procedures and Published it to Programmers and other DBA’s
• Document Best Practices

Environment: - IBM DB2 UDB Ver (8.1/9.5), Rational clearcase, Rational clearquest, Rational team concert, Rational quality manager, Erwin 4.0, AIX 5.3, SQL, MS-Access, Window NT, DB2 Client (includes control center, query patroller client, replication client etc), Event Publisher, SQL/Q replication, Query Patroller, WLM, Veritas Netbackup, Tivoli Monitoring, IBM High Performance Unload

Database Administrator

Confidential

Responsibilities:

• DB2 Maintenace & Support
• Creating & Administrating DB2 objects
• Development Support
• Performance tuning especially SQL
• Tuning/Administrating of DPF systems
• Working with Programmers in troubleshooting Performance issues
• 24*7 Production Support
• Automating different routines like daily backup using korn shell
• Defining Standards and procedures and document
• Collecting requirements and send it to Offshore
• Coordinate Onsite and Offshore Team

Environment: - Erwin 4.0, IBM DB2 UDB V8.1, AIX 5.3, DB2 Control Center

Lead Database Administrator

Confidential

Responsibilities:

• Implement DCRs (Database change request) for database changes in Development/Test/Production Regions
• Generate Health reports as preventive analysis and take corrective action
• Participate in User requirement Meetings
• Compare database objects of different regions and synch up across the regions
• Creating & Administrating DB2 Objects
• 24*7 Support
• Physical and Logical Design
• Performance Tuning
• Assist developers on Performance and Locking issues by using different utilities like native EXPLAIN, db2top, db2pd, visual EXPLAIN
• SQL Reviews of Development Programs to enforce Standards, best practices and Tuning for performance
• Develop process for automatic generation of periodic status reports for Image copy, Statistics, Growth forecast of Production Objects etc.
• Develop Drop Recovery Process - This process will take the backup of the data and structure before dropping any object so that if needed this object can be recovered in future.
• Develop Unused Columns Report - We had an issue with one of our DSS table, this table grown to 200+ columns. So whenever our users access this table they usually face performance issue. We then decided to split this table into two, one is having frequently used columns and one is having non-frequently used columns. This process will generate the list of unused columns and hence helps splitting the columns to frequently / rarely used list.
• Played the role of QA (Quality Analyst) for DBA team. That means making sure we are following all the defined Standards and procedures.
• Status reporting
• Allocation of Work / Resources
• Project Planning
• Managing DW team, consists of 10 – 15 peoples including both Offshore and Onsite

Environment: – AIX, Windows NT/2000, Erwin, Microsoft visio, IBM DB2 UDB V8.1, DB2 client (including everything like control center), in-house applications “DBA Tracking System” for daily status