Arvind Kumar
DB2 UDB Database Administrator / Architect
Skills
I bring a broad set of skills to my customer engagements, including deep technical knowledge and business acumen.
With my specialized focus on information technology, I possess skills that are broad enough to address IT needs company-wide, while deep enough to create unique and powerful line-of-business applications.
In addition, I have extensive experience leading technical teams and managing projects from conception through development, release, and ongoing support.
Consulting
- DB2 UDB Database Administration -
-Providing support to System Administration (SA) in database installation, instance creation, instance upgrade and version migration.
-Designing system storage structure and planning future storage requirements (design & analysis of file systems, logical volumes, raw containers)
-Design, analysis and creation of new databases (analysis about number of database partitions, available memory, database size, database & database manager configuration options).
-Database object creation & alteration (tables, indexes, views, stored procedures, functions etc.)
-Federated database server creation in order to allow access of another databases (DB2 or non-DB2) inside a DB2 database.
-Managing Database user privileges (granting & revoking permissions after proper analysis & approval).
-Database performance tuning and troubleshooting & fixing problems faced by application developer
-Query tuning for the problematic queries sent by application developer or identified during database monitoring
-Exploring the use of Multi Dimensional Clustering (MDC) & Materialized Query table to enhance the system performance if required.
-Database monitoring (free space in tablespaces, event monitor outputs, security audit reports, performance reports etc.).
-Database backup & recovery (offline & online backups ? Full, Incremental & Delta Incremental). Database cloning using redirected restores.
-Developing tools using shell/AWK scripts to automate various database administration jobs.
-Performing database security review (for the databases created & maintained by other DBA)
- Informatica 5.x, 6.2, 7.x,8.x ETL Consultant - -Installation and configuration of various versions of PowerCenter server and clients on different platforms
-Design and implementation of complex mappings/ETL logic for a various processes, i.e. data cleansing and data integration
-Assessing client mappings, provide performance tuning and optimization tips.
-Set up development, testing, and production in Informatica environments
-Provided troubleshooting and problem solving on critical issues
Information Technology
- Platform - UNIX (Digital TRU64 & Sun-Solaris 2.7 on Intel/Sparc processors, AIX-5.1,5.3, Windows NT, Windows95/98
- Languages - Shell scripting, gawk scripting, C on Unix, PL/SQL, Pro*C/SQL*C.
- Tools - IBM DB2 Tools, Quest Central for DB2, TOAD, Connect:Direct, Data Modeling using Designer 2000, Erwin, Spotlight for Oracle, Compaq TRUcluster 1.6, Tivoli storage manager.
- Hardware - DEC ES40, SUN SPARC E450, DEC DS20, IBM RS6000/SP, IBM REGATTA P690 16-way 32G RAM, P575 16-way 64G RAM, P595 16-way 512G RAM, INTEL Pentium workstations
400 E Hillsdale Blvd • 214 • San Mateo, California 94403
• M:703-419-0592
