Arvind Kumar
DB2 UDB Database Administrator / Architect
Projects
- Advanced Broadband Solutions Inc. - Database Administrator/ Architect - 11/2004 - Current - Executive Information & Decision Support (EI/DS) has various systems (TED, PEPR, PCDW, HL7, MCFAS, M2, DCS, PHOTO and Data Tracker), which works on DB2 UDB database at backend. There are more than 50 DB2 UDB Production/Development/QA/Benchmark databases, which are maintained by a core Database Administration (DBA) team. The size of database varies from 10 GB (a small development staging database) to multi-terabytes (a production ODS or a production data warehouse). There are big multi-partitioned databases residing on single IBM Regatta nodes (16-way SMP) as well as on clustered (MPP) IBM Winter hawk nodes. IBM's Enterprise Storage Architecture (shark disks, Megamouth) is used to provide the huge amount of disk storage. IBM's Tivoli Storage Manager is used for database backups & recovery
- Tata Consultancy Services - Data Warehouse Architect - 2/2003 - 11/2004 - Purchased Care Data Warehouse (PCDW) is a part of the Patient Encounter Processing and Reporting (PEPR) system application being built for Executive Information / Decision Support (EI/DS) and TRICARE Management Activity (TMA). PCDW will be designed to integrate the HCSR and TED records (Source Systems) in order to provide more quantitative and analytical capabilities to the MHS business analysts/users.
- Tata Consultancy Serives - Database Administrator - 11/2001 - 1/2003 - TriCare Encounter Data (TED)
United States Department of Defense introduced the TRICARE program in response to the challenge of maintaining medical combat readiness while providing the best health care for all eligible personnel. It is a regionally managed health care program that is meant to define and establish methods to reform the Military Healthcare system into a totally managed care enterprise, for active duty and retired members of the uniformed services, their families, and survivors.
400 E Hillsdale Blvd • 214 • San Mateo, California 94403
• M:703-419-0592
