SUMMARY

• 10 plus years of experience, as a Sr.DB2 LUW Database Administrator expertise in Installing, Performance Tuning, Migration, Backups, Disaster Recovery in Production,Pre - Prod & Development Environments.
• Experienced in supporting the 24*7 production databases.
• Experienced in installing, upgrading and maintaining the databases and applying post release software fix packs.
• Experience in maintaining multi Terabytes Databases.
• Subject Mater Expert(SME) for Financial Clients thru Confidential like Confidential, Morgan Stanly,JP Morgan thru Confidential for many years.
• Perform routine customer change request for new releases such as stored procedure, trigger, table structure and index changes.
• Experienced in DB2 replication such as Q- replication, DB2 HACMP, HADR,TSAMP configuring /testing /implementation and other DR methods.
• Experienced in Planning, developing and implementing Backup(Online,Offline,Incremental), Restore and Recovery Strategies using SRDF etc...
• Experienced in database performance tuning and monitoring database health and provide daily, weekly and monthly reports.
• Wrote shell scripts to execute commands and automate programs.
• Experience with opening PMR working with Confidential Technical Team (DB2 Level 2).
• Designed and developed DB2 OLTP and OLAP databases in support of Service Oriented Architecture solutions.
• Performed data architecture, collection of data assets, data management, data analysis, data migration, data modeling, data integration and database logical & physical design.
• Have good working knowledge in Decision support product suite like Informatica,Cognos.
• Technologies include DB2 UDB LUW, v10.1, v9.7/v 8.x,,v7.x,v6.x, AIX v7.x,v6.c, REHL Linux, Control Center, DB2 client, DB2 Connect, Quest, db2support, db2move, db2advis, db2batch, db2pd,db2top, Visual Explain, export/import/load, Tivoli Storage Manager (TSM), Oracle,MySql,Sql Server, Shell Script.
• Confidential Certified Database Administrator, DB2 9.7 for LUW.
• Confidential Certified Database Administrator, DB2 8.1 for LUW
• Certified Introduction to Data Science from Computer Science & Engineering University Of Washington

TECHNICAL SKILLS

OPERATING SYSTEMS: Confidential AIX, REHL Linux. Novell NetWare 3.11,Windows NTserver4/5.x

HARDWARE: Confidential pseries Clusters/ Confidential p7, Confidential RS/6000, AS/400,VCS Cluster.

DATABASES: DB2 LUW V 10.1/9.7/9.5 , /8.x/7.x, Oracle server 7.x/9i, MYSql,MS SQL Server 6.5, Netezza,MS Access7, 97, 2000, Cloudscape, DBase.

TOOLS: Tivoli Storage Manager, Tivoli Space Manager, Tivoli Performance Monitor, DB2 Connect from UNIX/AIX/Windows to Mainframe OS/390, Erwin4.0/3.5.2., EMC Storage Avamar, Net Backups.

SCRIPTING LANGUAGES: SQL, SQL*PLUS, Transact-SQL, UNIX Korn & shell scripts.

Data science: relational databases, MapReduce, NoSQL, statistical modelingBasic machine learning, and visualization, and a variety of algorithmic topics.

PROFESSIONAL EXPERIENCE

Confidential, NYC New York

Sr.DB2 Production Database Administrator

Responsibilities:

• Building and configures db2 servers that includes Server Instance and Client Instance for next release.
• Setting up and maintain db maintenance jobs like reorgs, runstats, online backup and dbrebind
• Migrated from V9.x to 10.1 production databases.
• Handling day to day production related issues.
• Setting up and maintaining Q-Replication with MQ Series from Production db server to staging db server.
• Installing db patches sent by development team after testing the same on test server.
• Experience in Change and Problem Management Process.
• Supporting 24/7 Production Databases as well Failover Drills.
• Setup various database snapshots / event monitor for tracing production issues like application locks, deadlock and system performance etc.
• Setting up debug db servers for testing team using copy of db backup from production.
• Configured, tested and implemented HADR,TSAMP.
• Involved in Memory, SQL/index tuning.
• Install and configure DB2 Connect on UNIX AIX, Linux and Windows which including update services file with port information, catalog TCPIP node, catalog database connection service, catalog database and bind utilities and applications.
• Loading data using export/import, Load utilities in DB2. Creating objects (like tables, indexes, views, Referential Integrity).
• DB2 Database maintenance, backup, restore, performance monitoring & tuning, maintenance of logs, problem identification and resolution, security and disaster recovery planning.
• Installed DB2 and configured using Active Directory on Windows 2008 server and Professional, NT Workstation.
• Configured backup and maintenance jobs on server as CRON jobs
• Designed physical, logical layout and procedures for production, development, and testing quality servers for Data Warehouse objects.
• Interacted with users and did troubleshooting of problems involved with development team, and problems related to privileges.

Environment: DB2 LUW 10.1, AIX 7.1,Linux,Windows NT 2008, Confidential pSeries VCS Cluster,VIO,MQ Series, Shell Script.

Confidential, New York

Sr.DB2 Database Administrator

Responsibilities:

• Performed data architecture, collection of data assets, data management, data analysis, data migration, data modeling, data integration and database design
• Did the DB2 Migration from V7 to V8.x to V9.x more than 50 production databases.
• Handling day to day production related issues.
• Setting up and maintain db maintenance jobs like reorg, runstat, online backup and dbrebind.
• Building and setting up db servers for next release.
• Setting up and maintaining data propagator jobs (dpropr) for propagating data from staging db server to Production db server.
• Setting up and maintaining db2uext2 (TSM) for the production databases.
• Installing db patches sent by development team after testing the same on test server.
• Setup various database snapshots / event monitor for tracing production issues like application locks, deadlock and system performance etc.
• Setting up debug db servers for testing team using copy of db backup from production.
• Configured, tested and implemented HADR.
• Involved in Memory, SQL/index tuning.
• Install and configure DB2 Connect on UNIX AIX, Linux and Windows which including update services file with port information, catalog TCPIP node, catalog database connection service, catalog database and bind utilities and applications.
• Loading data using export/import, Load utilities in DB2. Creating objects (like tables, indexes, views, Referential Integrity) in DB2 UDB EE.
• Experience in Change and Problem Management Process.
• DB2 Database maintenance, backup, restore, performance monitoring & tuning, maintenance of logs, problem identification and resolution, security and disaster recovery planning.

Environment: UDB DB2 9.x AIX 4.x/5.x/6.x,Windows NT/4//5.x RS/6000, pSeries Shell Script.

Confidential, Washington, DC

UDB DB2 Database Administrator

Responsibilities:

• Created logical and physical partitions using db2nodes.cfg file
• Loading large data using autoload.cfg file in partition database
• Creating database objects for Staging Development and UAT, Production environment for data warehouse project.
• Created Buffer pools, Table spaces and nodes in EEE environment.
• Did the performance tuning using configuration parameters.
• Automated backups (both online and offline), Reorgs, Runstats, Space monitoring.
• Did database Backup/Recovery on central database and file system backups.
• Automated administrative jobs using Script Center and Journal.
• Interacted with users and did troubleshooting of problems involved with development team, and problems related to privileges
• Provided 24x7 On Call Production Support
• Installed and configured Windows 2000 server and Professional, NT Workstation.
• Connected from OS/390 to UNIX through DB2connect.

Environment: UDB DB2 8.1 EE/EEE, AIX 4.3, Erwin 3.5/4.0,and RS/6000, ESS, Win 2000/NT, Shell Script.

Confidential, RI

Sr. UDB DB2 DBA

Responsibilities:

• ES (Enterprise Series) Provides SDK developed in J2EE environment, which is a collection of APIs for building user interfaces, developing games and also for building an e-commerce application. The developer has the framework for creating users, orders, and wallet management and for designing product catalogs.
• DB2 UDB EE 7.1/7.2 EE installation, configuration on Aix 4.3 and Windows 2000. Did data modeling design logical and physical database using Erwin3.5/40. Designed and implemented Database objects.
• Creating event monitors, analyzed event monitor data for effective database performance tuning
• Automated backups (both online and offline), Reorgs, Runstats, Space monitoring, moving db2diag.logs. Worked with Configuration Management Team (CM).
• Configured backup and recovery issues on server as CRON jobs. Did database Backup/Recovery on central database and file system backups. Automated administrative jobs using Script Center and Journal.
• Interacted with users and did troubleshooting of problems involved with development team, and problems related to privileges. Provided 24x7 On Call Production Support.
• Installed and configured Windows 2000 server and Professional, NT Workstation.

Environment: UDB DB2 7.1/7.2 EE, AIX 4.3, Erwin 3.5/4.0,and RS/6000, Win 2000/NT, Java, Websphere, Shell Script.