Lead DB2 UDB DBA at McKesson Corp
Greater Minneapolis-St. Paul Area
- Current
-
- Presentations - Thread Chair at International DB2 User Group (IDUG) - North America
- Lead DB2 DBA (LUW) at McKesson
- Past
-
- Lead DB2 DBA (LUW) at ChoicePoint, Inc
- Sr. DB2 DBA (LUW) at Norfolk Southern Corp
- DB2 UDB DBA at United Healthcare
- DBA at AnswerPal
- DB2 DBA (Project Lead) at Center for Software Development
- Education
-
- Birla Institute of Technology and Science
- Birla Institute of Technology and Science
- Recommended
-
5 people have recommended Vijay - Connections
-
105
connections
- Industry
- Information Technology and Services
- Websites
Vijay Sitaram’s Summary
9 years of experience with DB2 mostly on AIX with experience in architecting systems around DB2. Have extensive working and implementation knowledge of OLTP, DSS and ODS environments ranging to 40 terabyte capacity. Currently working on EDW for BI Portal using DB2 V9 with DPF using BCU standards and Viper technologies like Row Compression and Range Partitioning.
Experienced in implementing Disaster Recovery Strategy, Performance monitoring and fine tuning, UDB V8 Replication, Problem determination and troubleshooting, interacting with UNIX and Application group, and playing a diverse role with a large team of DBA’s.Have experience in working on projects as a Sr. Technical Architect driven by Business Intelligence framework with Business Objects and DB2 DataWarehouse Edition.
Have presented in many DB2 (IDUG and IOD) conferences and currently an active member of International DB2 User Group 2008 - Conference Planning Committee.
Participates in local user group and special interests in DB2 includes Storage Management and Optimizer.
Vijay Sitaram’s Specialties:
Database: DB2 UDB V9 & V8.2 ESE with DPF and DWE
DataWarehouse Tools: DB2 Cube View, Query Patroller, Intelligent Miner
ETL: IBM DataStage V8
BI Reporting: Business Objects XI
Operating System: AIX 5.3, AIX 5.4, Linux, Windows
Backup solution: TSM, Veritas
Hardware: IBM pSeries
Storage: IBM FastT with SVC, Hitachi and EMC.
Database Tools: ERStudio, ERWin, Quest Central - FogLight, SpotLight.
Vijay Sitaram’s Experience
-
Presentations - Thread Chair
International DB2 User Group (IDUG) - North America
(Non-Profit; 201-500 employees; Computer Software industry)
June 2006 — Present (2 years 5 months)
IDUG is a non-profit organization that serves the DB2 community around the world. The organization hosts several conferences a year, along with a number of web events.
Member of International DB2 User Group Conference North American Conference Planning Committee. Have the role of Thread Chair and work in the presentations team on preparing DVD content.
I have presented in the past two conferences at IDUG NA 2006 & 2007 on Core DB2 topics.
I am presenting at this years IDUG NA 2008 on a new topic:
"DB2 V8, V9 and Beyond - DBA's Life on the Fast Lane!" -
Lead DB2 DBA (LUW)
McKesson
(Public Company; 10,001 or more employees; MCK; Information Technology and Services industry)
February 2006 — Present (2 years 9 months)
This warehouse provides online reports 24x7 for all 1500 clients which were delivered offline once a month. There are two production backend database running on DB2 V9 (code named Viper) and DB2 UDB V8.2 with Data Warehouse Edition V9.1 and V9.1.1.
V9 DB2 configuration highlights:
• DWE 9.1.1 installed to run DB2 Cube Views and Query Patroller.
• DPF – 8 partitions based on BCU version 2.1
• Large table space used for fact and dim tables
• Enabled row compression resulting in 55% of storage savings.
• Fact table based on Hash, MDC and Range partitioned table
• Replicated MQTs for all DIM tables
• ETL processing area with special configuration
• Optimization techniques used: CGS, Statistical Views and Optimizer profiles/hints
• Aggregates for reporting
• Tuning database and stored procedures involved in ETL process. -
Lead DB2 DBA (LUW)
ChoicePoint, Inc
(Public Company; 5001-10,000 employees; CPS; Information Technology and Services industry)
September 2005 — February 2006 (6 months)
This project started as a joint effort by IBM and Choicepoint using IBM EAS tool with UDB as the backend engine in non-DPF mode with work inplace to make it DPF in V9 with FCM fix. In this project, I was formally trained by IBM Performance Division from Toronto Labs on the nature of the environment. The environment consisted of 40 terabyte of IBM FastT disks connected to p690 at full capacity.
Responsibilities/Roles:
• Perform Lead DBA tasks and be responsible for the complete IRW environment and the team.
• Physical design of database with IBM FastT drives.
• Work with ETL team on EAS load size and plan space allocation accordingly.
• Monitor EAS Load throughput at the database and system level.
• Perform database Maintenance following EAS loads.
• Perform routine backups to TSM.
• Help QA team with SQL query rewrites. -
Sr. DB2 DBA (LUW)
Norfolk Southern Corp
(Public Company; 10,001 or more employees; Information Technology and Services industry)
April 2002 — September 2005 (3 years 6 months)
Worked with team of DBA’s on various levels of responsibilities in a large environment converting multiple applications from Sybase to UDB V8. Support mission critical applications (highly OLTP) which enable the railroad to function 24x7 and daily transaction rates upto 12 million. Experience in tuning mixed workload environment. Carry on-call pager on rotation basis.
Major Sybase to UDB conversion projects successfully completed:
• Conversion of SIMS (Strategic InterModal Systems) – 5 p670 – 6 CPU – 64 Gig RAM – AIX 5.2 ML4+, UDB V8.1 FP6a SB12679 ( Soon upgrading to FP8 / V8.2 FP2).
Transaction Rate: 5 million / day (10 million operations / day)
DB Size: 35 Gig.
Type: Highly OLTP
• Conversion of TYES (Thoroughbread Yard Enterprise System) – 5 p690 – 16 CPU – 64 Gig RAM – AIX 5.2 ML4+, UDB V8.2 FP8 SB13188
Transaction Rate: 15 million / day (25 million operations / day)
DB Size: 40 Gig.
Type: Highly OLTP -
DB2 UDB DBA
United Healthcare
(Public Company; 10,001 or more employees; UNH; Insurance industry)
February 2001 — March 2002 (1 year 2 months)
Worked as UDB DBA supporting all phases of project. The project was running on DB2 V7.1/7.2 on AIX 4.3.3.
-
DBA
AnswerPal
(Privately Held; 51-200 employees; Information Technology and Services industry)
June 2000 — November 2000 (6 months)
Worked on a new project to collect and store searchable data into a DB2 database. This was an initiative for running searches using a natural language.
-
DB2 DBA (Project Lead)
Center for Software Development
(Educational Institution; 51-200 employees; Information Technology and Services industry)
June 1998 — May 2000 (2 years)
Worked as DBA running DB2 V5.2 on Windows NT for Center for Excellence in DB2 and Java primarily designed to build a Hospital Management System using Visual Age for Java and DB2 LUW as backend. Had the opportunity to take the role of Project Lead and successfully deliver the product.
Vijay Sitaram’s Education
-
Birla Institute of Technology and Science
M.E, Software Systems, 1998 — 2000
- Activities and Societies:
- Teaching Assistant. Lead projects in DB2 at IBM Center for Excellence in DB2 & Java
-
Birla Institute of Technology and Science
M.Sc(Tech), Engineering Technology, 1994 — 1998
This program is multi-disciplinary, technological in character and are designed to meet the requirements of newly emerging professional activities. While this program is also science and technology based, their requirements of mathematics, science, applied science etc. is unique for M.Sc. (Tech.).
The programme on Engineering Technology is planned to give to the students an exposure in all engineering disciplines and it emphasize on issues and methodologies in the operation of various technological units.- Activities and Societies:
- Dance Club - Secretary
Additional Information
Vijay Sitaram’s Websites:
Vijay Sitaram’s Interests:
Cars, especially BMWs. White water rafting Boating Trance/House music
Vijay Sitaram’s Groups:
IDUG NA - 2008 CPC Member
Atlanta DB2 Regional User Group
Minneapolis DB2 Regional User Group, TechnologyLadder, IBM, SAP, Recruitment
-
Database Experts -
DB2 Professionals -
IDUG Europe 2008 -
IDUG North America 2009 -
DB2 UDB DBA
Vijay Sitaram’s Honors:
Speaker at the following DB2 conference:
International DB2 User Group conference - May 18th 2008 - Dallas, TX
IBM Information On Demand conference - October 14th 2007 - Las Vegas, NV
International DB2 User Group conference - May 7th 2006 - San Jose, CA
IBM Information On Demand conference - October 15th 2006 - Anaheim, CA
International DB2 User Group conference - May 06 2006 - Tampa, FL
Vijay Sitaram’s Contact Settings
Interested In:
- career opportunities
- consulting offers
- new ventures
- job inquiries
- expertise requests
- business deals
- reference requests
- getting back in touch
