Arvind Kumar
DB2 UDB Database Administrator / Architect
Services
-
Database Administrator & Architect for DB2 UDB - - 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)
- Database Cloning using redirected restore on same/different machines. -
ETL Specialist in Informatica - - Designing transformation maps , mapplets, workflows, worklets and sessions.
- Installation and confuguration of Informatica in differnt configurations.
- Tunning Informatica workflows handling huge data.
- Extraction, Transformation & Loading mechanism design using Informatica and shell scripts.
- Metadata extraction and reporting using Informatica's SuperGlue.
Consulting
400 E Hillsdale Blvd • 214 • San Mateo, California 94403
• M:703-419-0592
