
My expertise is providing Database design, implementation and tuning for large databases (sizing 500G - 150TB) using IBM DB2 UDB Database in UNIX environments. Having worked as a warehouse architect, I also have expertise in Extraction Transformation & Loading (ETL) design tool like Informatica.
I am certified IBM DB2 UDB DBA and an Informatica Designer, Administrator and Consultant having 9 years experience in full software development life cycle and DB administration.
With an experience of handling huge data (>5 TB) on multi-CPU machines (p690 16-way 32G RAM, p595 32-way 512G RAM SMP & MPP configuration), I deliver a pool of knowledge that helps my clients effectively utilize their available machine resources. A combination of ETL and database specialist that I bring with me evolves as an explosive mix to the projects, boosting its throughput.
Working calmly in periods of stress also adds another plus to my profile. While handling multiple huge production databases at the same time, it's but obvious that things keep breaking as they go. I usually multi-task in these scenarios fixing issues as soon as possible.
"Knowledge brings peace of mind" and that is what I what I bring to my clients.
Clients describe me as intelligent, confident, experienced, creative, and resourceful. They find me able to listen, assess, and make creative recommendations that fully respond to their business and technology requirements. They find me flexible in schedule given their workload and deadlines.
My commitment to my clients' success frequently makes me a long-term stakeholder in their businesses. I typically operate as a resource and subject matter expert on an as-needed basis to help clients build their technology infrastructure, leverage market advantage, and optimize cost savings and revenue growth.
Core areas of expertise include:
- DB2 UDB Database Installation, design, maintenance and performance tuning.
- DB2 UDB Database Administration including audit configuration, SQL Tuning, resource monitoring.
- Database backups and restores using Tivoli Storage Manager.
- ETL design and development handling huge data processing using Informatica.
- Informatica ETL performance tuning.
- System Integration and Automation
As a technical lead, I am more inclined towards research and new technologies emerging in my field. I always try to keep myself up-to the latest technology in order to serve my clients with the best possible, reliable and cost effective solution.
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
Services
Consulting
Database Administrator & Architect for DB2 UDB
ETL Specialist in Informatica
Read more
Resume
Read more
Projects
Advanced Broadband Solutions Inc.
Tata Consultancy Services
Tata Consultancy Serives
Read more
Skills
DB2 UDB Database Administration
Informatica 5.x, 6.2, 7.x,8.x ETL Consultant
Read more
Education
Malaviya National Institute Of Technology
Read more