SUMMARY

• Over 10 years of IT experience wif extensive database administration using DB2 V7.x/8.x/ 9.1/9.5/9.7/10.1 on AIX, Linux, Solaris, Windows and has experience of administering Oracle 9i/10g/11g & MS SQL Server 2005.
• Extensive experience supporting DB2 system administration, application development, resolving DB2 issues, performance tuning, monitoring data security and integrity.
• Expertise in Installing Base code/Latest Fix packs and maintaining DB2 environment including creating instances, databases, buffer pools, logical and physical design of database storages using DMS/SMS tablespaces (allocating containers).
• Migrating DB2 UDB databases from old to newer versions and applying FIXPACKS to keep DB2 at most recent level.
• Proficient in implementing Replication, backup & recovery Strategies, developing Architecture for building a database by using tools like Erwin, ER/Studio.
• Database utility experience including Reorg, Runstats, Rebind, Export, Import, Load, auto - load, backup, restore and roll forward utilities.
• Database monitoring and tuning experience using DB2’s Performance Monitor, Snapshot Monitor, Event Monitor, Explain, Visual Explain, and Index Advisor performance tools.
• Worked extensively on features of DB2 Client, DB2 Connect and IBM Web Sphere Application Server.
• Skillful in handling IBM Federation server issues. Creating Wrappers, Server definitions, Nicknames, User Mapping, Federated procedures from Sybase, DB2, Oracle, SQL Server and all kinds of files.
• Remotely administrating the production database 24/7 through VPN connection. This includes monitoring the database growth, checking for the performance bottlenecks, taking backups for disaster recovery and tuning SQL queries for better performance.
• Worked on data partitioning and table partitioning (DPF) for large databases and Improved performance by 40% by converting tablespaces to multiple partitions wif DPF.
• Worked wif Third party utilities like Quest Tools, BMC Tools, DBArtisan, Toad, Performance Expert etc.
• Experience wif ETL tools - Informatica and reporting tools like Business Objects, SSRS.
• Effective communication capabilities and being able to work productively wif multilevel personnel.
• Extensive Experience in writing Korn shell scripts and using AWK, SED, GAWK.
• Proficient in Scheduling/Maintaining CRON/Autosys jobs based on application requirement.
• Provided 24x7 on call support for databases supporting online applications and off-hours maintenance.

TECHNICAL SKILLS

RDBMS: DB2 8.x/ 9.1/ 9.5/9.7/10.1/10.5 , SQL Server 2005/2008, Oracle 9i/10g/11g

Database Tools: DB2 Client, DB2 Connect, DB2 Replication Center, DB2 Federation ServerIBM Data Studio, BMC & Quest Tools, ERWIN, Toad, VERITAS NetBackupSSMA, SSIS, SSRS, Business Objects (BOXI R2), Informatica 8.6.2 (ETL)IBM MTK, SSMA, DB2 Utilities

Application Server: IBM WebSphere 5.0/6.x/7.x, Apache Tomcat Server

Operating Systems: AIX, Linux, Solaris, Windows XP/NT/2000Scripting/Languages Shell Scripting (Bash, Korn), DB2 SQL PL, T-SQL, SQL/PL, .NET, C

Schedulers: CRON Jobs, Auto sys, Windows Scheduler, Informatica Scheduler

ERP: SAP R/3 4.6, 4.7, ECC 5/6 & BI 3.5, 7.0

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Sr.DB2 DBA

Responsibilities:

• Worked on Databases object creation & alteration (table spaces, schemas, tables, indexes, views, stored procedures, functions, MQTs etc.)
• Extensively involved in writing complex SQL stored procedures (load and fetch procedures) as per the project requirements.
• Extensively used and worked on creating the Range partitioned tables to allow the DB2 optimizer which is aware of the partitions and if your query needs to scan many rows to get your result set and your predicate (where clause) uses ranges dat you defined, then only partitions dat has rows dat satisfy your query will be searched instead searching the entire table.This is called “partition elimination” and can greatly reduce query elapsed times. It optimizes the management of very large tables in the Multi partitioning environment.
• Worked on writing the shell scripts as part the project to run the stored procedures and automate the process.
• Managed Database user privileges (granting & revoking permissions after proper analysis and approval).
• Used the tools like DB2 Performance Monitor, Snapshot Monitor, Event Monitor, Explain, Visual Explain, Index advisor to find the bottlenecks.
• Worked on creating and maintaining Multi-Dimensional Clustering and Materialized Query tables (both system and user maintained) to enhance system level performance.
• Trouble shoot locking, loading issues, connectivity, degraded performance.
• Checking the consistency of the databases using different db2 commands
• Data maintenance activities like REORG, RUNSTATS, LOAD, UNLOAD, IMPORT and EXPORT
• Worked on tuning application queries, databases and systems for better performance.
• Involved in supporting DB2 system administration, application development, resolving DB2 issues, performance tuning, monitoring data security and integrity
• Installed DB2 UDB on AIX, Linux and Windows. Created instances and databases on different servers and provided connectivity to development and production databases
• Migrated Oracle databases to DB2 databases using IBM MTK.
• Created stored procedures, functions dat cannot be migrated using MTK and compile, bind them to the databases.
• Developed Architecture for building a database by using tools like Erwin, ER/STUDIO.
• Determined project performance requirements, and plan for database backup & recovery, infrastructure, capacity, and health maintenance of databases.
• Run db2ckbkp utility to test the integrity of the backup image and check whether it can be restored
• Automated backups (both online and offline), Re-orgs, Runstats, Space monitoring, moving db2diag.log, monitoring size of tablespaces by setting up a threshold.
• Developed shell scripts to handle DBA tasks and alerting systems
• Excellent Interaction wif Clients, Functional and business analysts, department Managers, different levels of users and developers and experience wif Software Development Life Cycle.
• Worked closely wif Developers to create database objects (tablespaces, schemas, tables, views, indexes, triggers, stored procedures etc) as per the requirement.

Environment: DB2 UDB 8.x/ 9.5/9.7/10.1/10.5 , AIX, Linux, Windows, IBM Data Studio, INTEC InterMediate v 6.0.9, Federation Server, Quality Center, Quest Central, DB Artisan, Toad, CVS tool: Concurrent Versions System (CVSNT) 2.5.05

Confidential, New York

Sr. DB2 DBA

Responsibilities:

• Analyzed the source data coming from different sources (Sybase, DB2, Flat files) and working wif business analysts and developers to develop the data model accordingly.
• Involved in Dimension modeling to design and develop Star Schema and Snowflake schema using Erwin, ER/Studio.
• Involved in writing complicated SQL stored procedures (load and fetch), Functions (UDFs) based on the requirement mostly the load procedures to populate the tables based on the dimension, fact batch and aggregate categories.
• Created EXPLAIN tables and running the visual explain utility on SQL statements.
• Optimizing the query access plans, resource and space utilization.
• Design and documented monthly updates load process and scripts.
• Involved in scheduling Autosys jobs in both QA and PROD environments to run the load stored procedures which are called through SHELL scripts and populating the tables based on dimension, fact, batch and aggregate categories.
• Trouble shoot locking, loading issues, connectivity, degraded performance.
• Involved in writing the shell scripts to do a turnover when migrating the objects from Development to Testing and production environments which are migrated along wif permissions.
• Worked on handling Federation server issues. Creating Wrappers, Server definitions, Nicknames, Federated procedures from Sybase, DB2, Oracle, SQL Server, all kinds of files.
• Worked on Databases object creation & alteration (tables, indexes, views, stored procedures, functions etc.)
• Extensively used Multi-Dimensional Clustering and Materialized Query tables (both system and user maintained) to enhance system level performance.
• Enforced Data Compression at the database/table level and reduced the storage requirements.
• Managed Database user privileges (granting & revoking permissions after proper analysis and approval).
• Database performance tuning and troubleshooting & fixed problems faced by application developer.
• Database monitoring (free space in tablespaces, event monitor outputs, performance reports etc.)
• Deployed Web Services on Secured Servers through which database will be accessed through URL’s.
• Worked on creating transformations and Mappings using Informatica power designer DB2 (version 8.6.2) and processing tasks using workflow manager to move data from multiple sources into DB2.
• Worked wif various Warehouse modules like Informatica Server and client tools like Designer, Workflow manager and Repository manager.
• Created Sessions, reusable Worklets and Batches in Workflow manager and scheduled the batches and sessions at specified frequency.
• Using workflow Manager for Workflow and Session management, database connection management and scheduling Autosys jobs to run the batch process.
• Used most of the transformations such as Aggregators, Filters, Routers Sequence generator, Update strategy, Rank, Expression and lookups(connected and unconnected).

Environment: DB2 UDB 9.1/9.5/9.7, AIX, Linux, Windows, Informatica v8.6.1, BO XI (Business Objects), IBM Data Studio, IBM DB2 Control Center, Federation Server, Quality Center, Quest Central, DBArtisanINTECT tool, Perforce.

Confidential

DB2 DBA

Responsibilities:

• DB2 Database Administration on Linux, UNIX and Windows including audit configuration, SQL Tuning, Resource monitoring and performing security architecture review.
• Created POC (Proof of Concept) for projects wif new security levels where data is driven by Web services.
• Constantly migrated the instances, databases to current level of DB2 versions/fix packs to in corporate the new functionalities. Migrated to V9.5 from V9.1 and also to V9.7 where business demands.
• Designed system storage structure and planning future storage requirements (design and analysis of file systems, logical volumes and raw containers)
• Coordinated wif Individual Business owners for Implementing STMM on all shared servers.
• Database Backup & Recovery (offline & online Backups - Full, Incremental & Delta Incremental). Database cloning using Redirected Restores.
• Created strategy on accessing different sources through DB2 Federation having different character sets enabled on source servers.
• Worked closely wif Load Testing, Performance testing teams to narrow down and fix the unexpected response times on the applications.
• Extensively used DB2TOP for monitoring databases both in Interactive and Batch modes.
• Used tools like DB2 Performance Monitor, Snapshot Monitor, Event Monitor, Explain, Visual Explain, Index advisor to find the bottlenecks.
• Query tuning for the problematic queries sent by application developer or queries identified during database monitoring.
• Planned/Scheduled/Created CRON jobs based on application requirement.
• Developing tools using Shell/AWK scripts to automate various database administration jobs.
• Worked closely wif System engineering groups on suggestions on Server level performance.

Environment: DB2 UDB 8.x/9.1, AIX, Linux, Windows, IBM Data Studio, Visual Explain, Quest Central, Toad, Service Center, Quest Spotlight.

Confidential

Associate Engineer

Responsibilities:

• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.
• Solved data load issues and stabilized the system wif low errors.
• Resolved performance issues on data loading & reporting.
• Loading Flat files to the BW system for the Secondary sales on user request.
• Extensively worked on broadcasting the reports.
• Reconstruct the data requests from PSA in case of data load failure.
• Monitoring of info packages and analyzing the reasons for frequent failures of info packages.
• Created process chains for master data loads and Transaction data Loads wif the help of Info packages. And These Process chain are Scheduled for periodic loads.
• Involved in upgradation project (BW 3.5 to 7.0)
• Issues solved during the upgradation project by applying SAP notes, wif the Basis people support.
• Created authorizations for each plant wise users for the inventory report & sales reports.
• Database backups and recovery, export/import of data, troubleshooting.
• Installation and fix pack upgrades for various platforms.
• Perform migrations and updates.
• Design the logging strategies based on criticality of the environments.
• Configuring communications setting up the environment variables, node and database configuration parameters and cataloguing the database in clients for connectivity.
• Implementing backup strategies for development and production environments.
• Analyse the best suited backup methods to ensure high availability in short span.
• Strong in performing all kinds of backup and recoveries.
• Redirect Restore Operations.
• Written shell scripts to automate the backup and restore operations.
• Monitor the database during various phases like UAT and performance testing.
• Granting / revoking various authorizations to different Users/Groups.
• Taking care of data security by granting and revoking authorities and privileges.
• Taking care of performing REORG and run stats for the tables.
• Resolving the Problem tickets of different severity levels during on-call support.
• Performed the Weekly Server Maintenance which involves the Reboots of DB, Web and Application server.

Environment: Linux, AIX, Windows & SAP - R/3 4.6/4.7, ECC 5.0/6.0 & BW 3.0B, 3.5 & 7.0.

Confidential

Network Admin

Responsibilities:

• Established network specifications by conferring wif users; analyzing workflow, access, information, and security requirements; designing router administration, including interface configuration and routing protocols.
• Established network by evaluating network performance issues including availability, utilization, throughput, goodput, and latency; planning and executing the selection, installation, configuration, and testing of equipment; defining network policies and procedures; establishing connections and firewalls.
• Maintained network performance by performing network monitoring and analysis, and performance tuning; troubleshooting network problems; escalating problems to vendor.
• Secured network by developing network access, monitoring, control, and evaluation; maintaining documentation.
• Prepared users by designing and conducting training programs; providing references and support.
• Upgraded network by conferring wif vendors; developing, testing, evaluating, and installing enhancements.
• Updated job noledge by participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.
• Protected organization's value by keeping information confidential.
• Accomplished organization goals by accepting ownership for accomplishing new and different requests; exploring opportunities to add value to job accomplishments.

Environment: Windows NT, 98 & 2000