SUMMARY

• Over 8+ years of professional and progressive experience in IBM DB2 UDB with emphasis on Database Administration, development, migration, Business Requirement Analysis, Application design, testing, implementation and production support of critical OLTP, OLAP and Data warehouse environments.
• Expertise in development support activities including installation, configuration and successful deployment of changes across all environments
• Data Analysis, Normalization, Data warehousing, Data Cleansing, Data Modeling, Data Mapping, Erwin 3.0 in OLTP & OLAP environments
• Extensive experience in logical and physical design of databases, performance tuning, database utilities, backup and recovery strategies, capacity planning, high availability, disaster recovery, database monitoring, troubleshooting, change and problem management and production support on 24/7 basis in LUW environment
• Expertise in collecting, analyzing and performing system level tuning in LINUX/UNIX operating systems on databases.
• Expertise in Deep Compression and Table Partitioning in AIX and LUW environments
• Experience in resolving various database issues and bottlenecks by working directly with DB2 Development team and SQL team.
• Extensive experience with Incident, Problem and Change managements
• Excellent analytical and functional skills with strong communication and interpersonal skills. Actively involved in the full project life cycle, user requirements to implementation. Willing to learn and adapt to new challenges

TECHNICAL SKILLS

RDBMS: DB2 LUW V9.7, V9.5, V9.1, SQL Server, Oracle, MS Access.

Database Tools: DB2 Connect, IBM Data Server client, IBM Data studio, Quest Tools, db2top, db2fodc, db2dart, db2mon, db2pd, db2expln, db2exfmt, db2trc, db2mtrk, db2diag, nmon analyzer, svmon, VERITAS Net Backup, BMC Patrol, Erwin, Power Designer, DB Artisan, TSM and VERITAS.

Operating System: AIX 6.1/5.3/5.x/4.3.x, Solaris 8/9/10, RH Linux Advanced Server 2.1, 3.0, Windows 2000/ NT 4.0, Windows 95

Programming and Scripting Languages: Shell Scripting, Perl Scripting, AWK, SED, SQL, Visual Basic, C, C++

ETL and Other Software: Data Staging, Informatica V8.1/7.1, Abinitio 2.15/2.14, Data mirror Transformation Server, QMF

PROFESSIONAL EXPERIENCE

Confidential, IL

DB2 UDB DBA

RESPONSIBILITIES:

• Responsible to provide on - call support on 24*7 basis with rotating basis to keep the system running smooth and handle any problems very efficiently.
• Instance and database creation and configuration on partition database servers in LUW environment.
• Creating node groups and assign them for creating partition tables spaces
• Monitoring and handling table space and file systems space issues
• Installed DB2 9.7, 10.1 and Fix Packs; upgraded from version 9.1 to 10.0
• Monitoring locks & Deadlocks and identified application’s deadlocks and resolve them.
• Moving databases for various environments using utilities like db2move.
• Scheduling and monitoring regular dba jobs and job logs in LUW environment.
• Done large implementations ofOLAPenvironments using DB2 DWE, to facilitate report generation of DB2queries for the Business Intelligence teams.
• Designed data warehousedata modeling& design including star schemas and data marts using data
• Managed/executed database maintenance tasks (REORG, RUNSTATS utilities)
• Monitor CPU, Memory, Paging space, Disk I/O and analyze those using topas, nmon and other tools.
• Applying Fixpacks to keep DB2 at the most current level.
• Extensively used different Data movement utilities like IMPORT, EXPORT, and LOAD utilities to load data.
• Performed Reorgchk, Reorg, Runs tats and rebind as and when necessary to eliminate the defragmentation.
• Configured LDAP for authentication on various environments.
• Working on complete set-up of Data warehousing Tools like Appfluent, Informatica Repository etc. on DB2.
• Opened several SEV1 PMRs with IBM to troubleshoot and resolve critical issues.
• Performed backups with online full and incremental backups
• Worked on restores and roll forward restores including redirect restores.
• Set up DB2 Backup to Tivoli Storage manager (TSM)
• Tuned databases using IBM Tools like snapshot monitor, db2exfmt, db2expln, Index Advisor and problem diagnosis
• Worked closely with application team for resolving database access issues.
• Configuring and Monitoring the HADR setup on the database servers.
• Setting propagation from source databases to target databases
• Monitoring the capture process at source servers and Apply process at target servers.
• Creating and Monitoring Users, authorities and responsibilities and password management
• Tuned application, database and system for best performance

ENVIRONMENT: DB2 UDB EE 10.1,9.7 and 9.5, AIX 7.1 and AIX 6.1, Red hat Linux 5/6, Embarcadero DB Artisan 8.1.1, Clear Case, Clear Quest, Remedy,Websphere commerce, Autosys, Tivoli Storage Manager, Korn Shell.

Confidential, OH

DB2 UDB DBA

RESPONSIBILITIES:

• Providing support to system Administration (SA) in database installation, instance creation, instance upgrade and version migrations on production servers in LUW environment
• Managing Database user privileges (Granting & Revoking permissions after proper analysis & approval from Customer).
• Database monitoring (Free space in table space, event monitor outputs, security reports)
• Performing database security audit reviews by using db2cops and db2shc tools and removing all the violations.
• Migrating instances and database servers from V9.5 to V9.7 in LUW environment.
• Database backup & recovery experience with offline, online full & incremental backups and restores & roll-forward including redirected restores.
• Configuring and Monitoring the HADR setup on the database servers.
• Supported development teams by providing assistance with database structural changes and database access issues
• Expertise in understanding and using Q replication for high availability solutions.
• Expertise in DPF across large servers
• Monitoring paging space and memory usage and taking appropriate actions when they are reaching threshold values
• Increasing file systems and logical volumes as in the process of adding space to table spaces and file systems.
• Cataloging databases on client systems for accessing remote server databases
• Monitoring all scheduled jobs and job logs and taking actions if any jobs stopped.
• Responding calls from operations and resolve all database issues.
• Developed comparison criteria and evaluated Data Modeling tools (ER/Studio, ERwin, System Architect)
• Resolving the Problem tickets of different severity levels during off shore support.
• Designed (ER/Studio), developed & supported historic Student Record DW providing multidimensional OLAP perspective
• Monitoring all database servers and bring them up when databases are down.
• Troubleshooting & fixing problems faced by application developers.
• Day-to-day attending to the user queries in sorting out database problems
• Coordinating with user departments and attending their requirements for smooth functioning
• Developed document that provides an overview of the physical and logical design of the database environment implemented for IBM internal projects.

ENVIRONMENT: DB2 EE/EEE V 9.x, 8.x, 7.x, Web sphere, Solaris, AIX 5.3, Informatica Power Center, SAN, Clustered Environment, Information Integrator V8, Quest Central and HADR.

Confidential - NY

DB2 UDB DBA

RESPONSIBILITIES:

• Implemented db2 fix packs and did migrations, client installations and upgrades on AIX operating system
• Setting Crontab, scheduling jobs like backups, reorgs, run stats, space checks and Monitoring scheduled jobs for new database environments.
• Implemented UNION ALL views for improving the OLAP queries.
• Implemented db2 OPTIMIZATION PROFILE to improve the performance of the OLTP queries with parameter markers in AIX operating system
• Monitoring locks & Deadlocks and informing to application teams.
• Loading data from production servers to development and testing servers as per customer request.
• Modified and enhanced existing databases objects as per customer requests.
• Executing scheduled change management tickets and service requests.
• Increasing space to DMS table spaces when they are reaching to threshold values
• Restoring database production to different test and development in AIX environment
• Creating event monitors for monitoring deadlocks and analyzing outputs.
• Worked on export, import, load and db2look utilities.
• Monitoring and solving log space and temp space issues.
• Creating and dropping of database objects as per customer requirements in LUW and AIX operating systems
• Granting and revoking user and groups permissions as per customer requests.
• Provide troubleshooting and problem solving on critical issues.
• Monitoring queries through query patroller and fixing query issues.
• File system and table space monitoring using Koran shell scripts on DEV, SIT and PROD database servers.

ENVIRONMENT: DB2 UDB EEE V 8.x, 7.x, AIX 4.3, LUW V 9.5, 9.7,Solaris, Windows Clustered Server 5.0, Dprop, TSM, BMC Patrol

Confidential

DB2 UDB DBA

RESPONSIBILITIES:

• Performance DBA for non-DPF and DPF databases. Selecting, installing, testing, submitting final recommendation for DB2 Performance/Admin software.
• Responsible for identifying potential bottlenecks and correct database problems.
• Setup the disaster recovery for DB2.
• Responsible for upgrades on DB2 across all nodes.
• Responsible for major new system at Mervyns.
• Performance and tuning of DB2 systems and SQL.
• Performed UNIX and Linux System administration.
• Installed third party software.
• Worked on DB2 Data Warehouse
• Worked on end-to-end storage stack, including host servers and the software defined storage product.
• Experience in-depth analysis of storage product field issues having data unavailability and/or data loss.

ENVIRONMENT: DB2 UDB EE/EEE 8.2 Fix pack 4(V8.1 Fix pack 11), AIX 5.2, Solaris 5.8.