SUMMARY:

• Seven years of IT experience in Database administration and application development.
• Database administrator for DB2 UDB in LUW environment for nearly 6 years.
• Rich hands - on experience on various DB2 UDB versions 9.1, 9.7, 10.1, and 10.5.
• Proficient in all cycles of Software Development Life Cycle (SDLC).
• Expertise in application development support activities including database design, optimizing SQL queries, writing dynamic SQL queries and triggers, effective binding of packages and plans, concurrency planning, data refreshing and database objects migration between different landscapes.
• Proficient in writing stored procedures using embedded C (using C as a host language and embedding SQL queries in the C language).
• Worked on data movement utilities like EXPORT, IMPORT and LOAD and expertise in using REORG and RUNSTATS for better performance.
• Proficient working on daily, weekly and monthly support activities which include taking backup of the databases, restoring the database to a certain point in time, monitoring logs, resolving locking issues and contentions, scheduling administration activities.
• Experience working on different query tuning and performance monitoring tools.
• Proficient in writing complex SQL queries using different types of joins.
• Experienced in working with large table spaces.
• Experienced working on HADR (High Availability Disaster Recovery).
• Worked on monitoring/testing the COGNOS applications.
• Worked in DB2 Data Partitioning environment (DPF).
• Worked on the migration of stored procedures from DB2 UDB V 9.7 to Netezza.
• Have understanding on IBM DB2 Purescale. Purescale is a latest feature introduced in V 10.5.
• Experienced in supporting critical production databases and worked on 24*7 production support.
• Worked on ADO.NET (ActiveX data object) to connect SQL Server database and .NET framework.
• Working knowledge on Tivoli system automation (TSA) for high availability of DB2 UDB BCU (Balanced Configuration Unit) on AIX.
• Worked on DB2 UDB to PostgreSQL migration.
• Have used BMC remedy tool (ticketing tool) and resolved the issues in the database.
• IBM certified DB2 Database associate and application developer.
• Interacted with the clients for the requirements gathering.
• Strong client-oriented communication skills.
• Excellent written and communication skills.
• Ability to handle multiple assignments efficiently.
• Excellent problem solving skills.
• Ability to handle and troubleshoot issues in a live working environment.
• Outstanding ability to absorb new technologies quickly with high degree of adaptation.

TECHNICAL SKILLS:

RDBMS: Oracle 11g/10g, DB2 9.x and DB2 10.x, Netezza, SQL Server 2012/2008, PostgreSQL, MYSQL, Informix

Programming Languages: SQL, PL/SQL, SAS, Core Java, J2EE, C and C++, Visual Studio 2015, VB.Net, Shell script and Perl.

ERP: SAP ABAP, SAP BW, SAP BW powered by SAP HANA.

Tools: SQL*Plus, Toad, SQL developer, Database, SAP Lumira, Predictive Analytics, Analysis Office, IBM Data Studio.

Operating Systems: Windows, UNIX.

MS Suite: MS Project, MS Visio, Microsoft Access, Microsoft Excel, Microsoft Suite.

PROFESSIONAL EXPERIENCE:

Confidential,Omaha, Nebraska

DB2 Database administrator

• Implemented performance tuning at all levels (Application, Database, and SQL).
• Worked on DB2 installations, patching, and configuration changes.
• Used DB2 utilities like reorg, runstats to reclaim the fragmented space in the database and to update the catalog statistics.
• Offline/Online backup and restoration.
• DB/DBM configuration changes.
• Established backup strategy for the databases.
• Worked on High Availability Disaster Recovery setup for the databases.
• Performed database health monitor. Have worked on table space management and DB2 Storage optimization.
• Managing transaction log files and the space in the database.
• Managing Re-org, Runstats utility·
• Used export/import, DB2move, Load utility as part of the daily activities.
• Used different db2 LUW utilities like db2mtrk, db2look, db2move, db2iupgrade, db2cklog, db2dart, db2advis, db2admin, db2top, and db2ckrst etc.
• Performed database performance tuning using DB2dart, DB2explain utilities.
• Trouble-shooted databases issues using db2diag and notification logs, Snapshots, event monitor, db2hc.
• Wrote complex SQL queries using different types of joins like Left outer join, Right outer join, inner join and cross joins to pull data from multiple tables.
• Working knowledge of Tivoli Storage Manager Backups in DB2 environment.
• Created Databases, DB Objects, Tablespaces, Tables, Indexes.
• Experience with Database refreshes from production to QA systems.
• Upgraded bunch of databases from V 10.1 to V 10.5.
• Implemented High Availability Disaster Recovery (HADR) for some databases.
• Analyzing the capabilities of IBM DB2 Purescale for the benefit of the project. IBM DB2 Purescale is an emerging capability of DB2 which the companies with DB2 as their database are looking forward to.
• Worked on DB2 UDB to PostgreSQL migration. Imported the DB2 UDB data into PostgreSQL.

Environment: SQL, UNIX, AIX server, DB2 UDB V 10.1, V 10.5, TOAD, Aqua Data Studio 4.5.2, PostgreSQL, BMC remedy tool.

Confidential,Phoenix, AZ

DB2 Database developer

• Performed Functional understanding and requirements gathering for multiple requirements for this client.
• Created ETL jobs to pull the data from disparate sources, bringing the data to a common format by applying some transformations and rules and loaded the formatted data into the permanent tables in the database.
• Used the data in the permanent tables to show it in the reports generated using the Actuate reporting tool.
• Extensively used the UNIX commands on AIX server.
• Developed shell scripts to execute the stored procedures in the UNIX environment on AIX server.
• Expertise in dealing with different SQL error codes like SQLCODE -117, -171, -181, -818 etc.
• Used complex joins to implement the business logic and to bring the data from multiple base tables in the stored procedures.
• Good command on the physical and logical design of the tables.
• Created CMR (Change management Request) and IMR (incident management process) whenever required.
• Business Analysis and Requirements Gathering, Data Validation, ETL Coding Liaison.
• Worked on different DB2 database objects.
• Have worked on different objects like tables, indexes, triggers etc. while implementing the business logic using the stored procedures.
• Stored procedures are implemented using C as a host language and embedded SQL queries in the host language.
• Implemented different types of triggers like before triggers, after triggers, and instead of triggers.
• Performed unit testing of the code written, and system integration testing.
• Done the peer review for the code written by the team mates.
• Worked on MYSQL databases extensively to pull the data from the huge tables. With the IBMDB2I storage engine, data can be shared between MYSQL applications.
• Have worked on the migration requirement where the stored procedures in DB2 V 9.7 are migrated to Netezza database.
• Have created the new stored procedures in Netezza database to experience the speed of execution of stored procedures when compared to the execution time in DB2.

Environment: SQL, DB2 UDB V 9.x, HP Quality Center, AIX server, UNIX, TOAD, IBM Data Studio, MYSQL.

Confidential,Louisville, Kentucky

DB2 Database administrator

• Tuned the databases and queries using the query tuning tools.
• Handling the authorizations of DB2 objects to users, applications and utilities.
• Created views and other DB2 objects depending upon the application group requirement.
• Alterations of DB2 object definitions whenever needed.
• Switched to different logging mechanisms depending on the type of backup strategy used.
• Starting and stopping DB2 subsystems.
• Monitoring the database objects using the db2 utilities like db2pd, db2top etc.
• Performing daily DB2 LUW activities like monitoring the health of the database using snapshot tables and event monitors.
• Performed import and export of data into tables using the intermediate files. Performed import and export of data into tables without using the intermediate files (using cursors).
• Insertion and deletion of data into the tables whenever needed.
• Creating image backup of a database as part of the daily db2 activities. Restoring backup of a database whenever needed.
• Reorganized tables and indexes. Used DB2 utilities to maintain data in the databases. Have gained excellent performance tuning skills for tuning critical databases.
• Prevented database issues by closely monitoring the databases on a regular basis.
• Administered, analysed, recommended, designed, developed, enhanced and supported data structures and data processes required to meet business objectives.
• Created CMR’s and IMR’s.

Environment: SQL, DB2 UDB, AIX, UNIX, HP Quality Center, TOAD, IBM Data Studio, EXPLAIN tool, BMC remedy tool.

Confidential,Farmington Hills,MI

DB2 database administrator

• Performed daily, weekly and monthly activities.
• Daily activities include verifying if all the instances are up and running, verifying if all the databases are active and consistent, looking for the new administration notification log and DB2DIAG.LOG file entries, check if the previous night backups were successful, verifying databases logs have been archived successfully, checking that no configuration parameters have changed, checking for the automatic actions taken by DB2, and ensuring that there is no enough space in the database etc.
• Weekly procedures include looking for the new objects in the database, looking for the new or changed applications, looking for tables/ indexes needing REORG, looking for the 10 most active tables, archiving all the alert logs and DB2DIAG.LOG files etc.
• Monthly activities include looking for the indicators of exceptional growth, Project future performance based on projected growth etc.
• Immense experience using the DB2 Utilities like EXPORT, IMPORT, and LOAD etc.
• Used different DB2 LUW data movement utilities like db2move, db2look and db2batch etc.
• Proficient in using the DB2 LUW maintenance utilities like RUNSTATS utility, REORG and REORGCHK utilities, REBIND utility and the FLUSH PACKAGE CACHE command and DB2ADVIS command etc.
• Dealt with creating different constraints on the table like Primary key constraint, foreign key constraint, Check constraint, UNIQUE constraint, and not null constraint.
• Created views, MQT’s and have also worked on establishing backup/restore strategies.
• Created different tablespaces like Automatic storage tablespaces (AMS), Database managed tablespaces (DMS) and System managed tablespaces (SMS).
• Used monitoring and troubleshooting aids like db2pd, db2mtrk and db2top.
• Recovered the databases in multiple instances.

Environment: SQL, TOAD, IBM Data Studio, UNIX, AIX server, BMC remedy tool.

Confidential

Database administrator

• Worked on DB2 installations, patching, and configuration changes.
• Used the DB2 utilities like reorg, runstats etc. to perform certain activities.
• Performed database health monitor.
• Managed table spaces, transaction log files and worked on DB2 LUW Storage optimization.
• Dealt with database catalogs. Created tablespaces, tables, indexes, databases etc.
• Managing Re-org, Runstats utility.
• Established backup and recovery strategies including point in time recovery.
• Used export/import, DB2move, Load utility.
• Database performance tuning using DB2dart, DB2explain utilities.
• Trouble shooting database issues using db2diag and notification logs, Snapshot, event monitor.
• Written complex SQL joins to join multiple tables.
• Maintained data integrity by executing various IBM Utilities.
• Working knowledge of TSM (Tivoli Storage Manager) backups in DB2 environment.
• Have worked extensively on DB2 in SAP environment as well.
• DB2 system build and migration experience to different hosts.
• Experience with Database refreshes from production to QA systems.
• Established High Availability Disaster Recovery (HADR) for a bunch of databases.
• Worked in multiple production database environments.
• Was also involved in ADO.NET (ActiveX data object) Programming where SQL Server database is connected to .Net framework. Generated reports using crystal reports. Built several applications using ADO.NET.

Environment: SQL, DB2 V 9.1, 9.7 UNIX, AIX server, TOAD, BMC remedy tool.