PROFESSIONAL SUMMARY

• Over 8 years of IT experience with extensive database administration using DB2 V7.x/8.x/9.1/9.5/9.7 on Unix, AIX, Linux, Windows and has experience of administering 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 re-org, 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 with Third party utilities like Quest Tools, BMC Tools, DBArtisan, Toad, Performance Expert etc.
• Experience with ETL tools - Informatica and reporting tools like Business Objects, SSRS.
• Effective communication capabilities and being able to work productively with 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.

SKILLS

• RDBMS: DB2 7.x/8.x/9.1/9.5/9.7, SQL Server 2005, Oracle 10g, Sybase
• Database Tools: DB2 Client, DB2 Connect, DB2 Replication Center, DB2 Federation Server,
• IBM Data Studio, BMC Quest Tools, ERWIN, Toad, VERITAS NetBackup,
• SSMA, SSIS, SSRS, Business Objects BOXI R2 , Informatica 8.6.2 ETL ,
• INTEC InterMediate v 6.0.9
• IBM MTK, SSMA, DB2 Utilities
• Application Server: Web sphere 4.x/5.0/6.0, Apache Tomcat Server
• Operating Systems: UNIX AIX 4.x/5.L, Linux, HP-UX , Windows XP/NT/2000, Windows
• Clustered Server
• Scripting/Languages: Shell Scripting Bash, Korn , DB2 SQL PL, T-SQL, SQL/PL, .NET, C
• Schedulers: CRON Jobs, Auto sys, Windows Scheduler, Informatica Scheduler

PROFESSIONAL EXPERIENCE

Confidential

DB2 UDB AIX Developer

Project Description :

1 Summary of Records : The purpose of the project is since we are processing approximately 450 million EDRs Daily Monthly every day and we have already witnessed that there are few reports which are taking forever when they hit the Enriched data and voice detail tables. As per the forecast provided by the Finance department and IT Projections, we will be receiving 2 billion EDRs enriched call and data records daily by end of year 2012. With this much load, we have realized that we need to go with ESN based summary and make sure that all reports should be running off the summary and EDR tables should rarely be accessed by the business users. Today with this project we are able to process 1 billion EDRs every day.

2 USF tax reports : Creating an application to run reports for Tax department I.e. Universal Service Funds USF Report to eliminate manual processes and have the ability to create automatic ad hoc reports for further analysis. The USF reports using MAX call detail Records CDRs is the business requirement to comply with Federal Communications Commission FCC reporting orders laws . Without this data and the reports generated from it, the additional estimated cost to TracFone for 2012 may exceed 90M

Responsibilties:

• 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 that you defined, then only partitions that have rows that 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 INTEC ETL tool where we enrich the tracfone raw files coming from the different carriers enrich these files and convert them into tracfone format.
• 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

Environment: DB2 UDB 9.5/9.7, 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

Sr.DB2 LUW Developer

Project Description: Confidential is a flex based dashboard application that presents data sourced from multiple systems. Data is brought from source systems into DB2 using Federation services. The data is cached locally in DB2 to improve performance. In addition to this ETL Informatica tool is also involved for data movement and transformation.

Responsibilties:

• Analyzed the source data coming from different sources Sybase, DB2 ,Flat files and working with 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 with 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 with 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, DBArtisan,

Confidential

Sr. DB2 Database Administrator

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 with new security levels where data is driven by Web services.
• Constantly migrated the instances, databases to current level of DB2 versions/fix packs to incorporate 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 with 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 with 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 with 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

Sr. DB2 DBA/Developer

Responsibilities:

• Responsible for software installation, database creation and maintenance, performance monitoring and tuning, backup and recovery, customer consultation, DBMS infrastructure creation and support, problem determination/resolution.
• 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 that 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.
• Excellent Interaction with Clients, Functional and business analysts, department Managers, different levels of users and developers and experience with Software Development Life Cycle.
• Worked closely with Developers to create database objects tablespaces, schemas, tables, views, indexes, triggers, stored procedures etc as per the requirement.
• Created Range- partitioned Tables and specified ranges Creating Tables and Indexes.
• Created EXPLAIN tables and running visual explain utility on sql statements
• Created MDC and MQT tables to improve query performance and reduce the overhead of data maintenance operations.
• Worked heavily with data movement utilities IMPORT, LOAD, EXPORT and Quest Central under high volume conditions to move data from Legacy systems.
• Created and Configured Alerts, define counters and thresholds for alerts.

Environment: DB2 UDB 8.x/9.1, SQL Server 2005, Oracle 10g, AIX 5.3, Linux, Windows Server 2003, ERWIN, ER/Studio, Quest Central, WAS server 6.0, IBM MTK, SSMA, Service center

Confidential

DB2 UDB Developer/SQL Developer

Responsibilities:

• Database development and support both SQL Server and DB2 UDB.
• Logical and Physical Database design using VISIO and ERWIN.
• Altered tables and added check constraints and referential integrity.
• Created and maintained databases, tablespaces, tables, views, and indexes.
• Prepared and implemented standard recovery procedures for data recovery.
• Interact with business team and development teams for incorporating new functionality
• Developed shell scripts to handle DBA tasks and alerting systems
• Documented plans and procedures in terms of backups, restores and disaster recovery
• Checking the consistency of the databases using different db2 commands
• Data maintenance activities like REORG, RUNSTATS, LOAD, UNLOAD, IMPORT and EXPORT
• Tuning application queries, databases and systems for best performance
• Performed performance tuning and capacity planning using the parameters of DBM configuration file DB configuration file and various Database snapshots

Environment: DB2 UDB V7.x, SQL Server 2000, AIX, WIN NT, Java 1.2, .Net, JSDK 2.0, JDBC, JavaScript, Apache Web Server EJB J2EE , XML