SUMMARY

• Have over 10 years of focused experience in IT industry in various fields like banking, insurance, finance, retail and manufacturing. Extensive experience in relational database design, analysis, modeling, migration, administration, implementation, troubleshooting and quality management.
• Comprehensive experience as a DB2 UDB DBA, Oracle, SQL SERVER, INFORMIX proficient in IBM DB2 11.1, 10.5,10.1, 9.7, 9.5 along with Oracle 12C, 11g/ 10g/ 9i IBM DB2 11.1, 10.5,10.1, 9.7, 9.5
• Administration and knowledge and trainings on various Database systems like MongoDB, Postgre SQL, Tera Data, Netezza, DynamoDB, SQL Azure, Aurora .
• DB2 11.1, 10.5, 10.1, 9.7, 9.5 database administrator functions including, database object creation and alters implementation, reorgs, statistics collection and analysis.
• DB2 DPF, Recoveries, performance tuning, schedule and manage maintenance of production application databases, disaster recovery testing.
• Job scheduling utilities and database management tools and utilities.
• Experience monitoring DB2 Databases sizes ranges from 500MB - 100TB.
• Problem determination and resolution for supported application databases and maintenance utilities.
• Perform change management activities using standard change processes in support of application database related changes.
• Use and learn standard DB2 utilities and DBMS related products to perform DBA tasks.
• Configured the plug-in modules by setting values in the IBM LDAP security plug-in configuration file IBMLDAPSecurity.ini after consulting with LDAP administrator to determine appropriate values.
• Diagnosed and troubleshoot UNIX and Windows processing problems and applied solutions to increase company efficiency.
• Column Masking using RCAC to enhance Row and Column security.
• Build database systems of high availability and quality depending on each end user’s specialised role.
• Design and implement database in accordance to end users information needs and views.
• Define users and enable data distribution to the right user, in appropriate format and in a timely manner.
• Use high-speed transaction recovery techniques and backup data.
• Minimise database downtime and manage parameters to provide fast query responses.
• Professional experience in Oracle Installation, administration, performance tuning, backup & recovery with proven ability Confidential Server side & Client side responsibilities.
• Expertise in Oracle RAC, Replication, Standby databases, and database designing.
• Expertise in handling 24X7 mission critical production databases, versions 11g/10g/9i primarily in AIX / UNIX based environments.
• Successfully upgraded databases from 9i to 10g & 11g.
• The expertise of Crontab to automate and schedule the various routine maintenance tasks.
• Administration of GoldenGate (10.x/11.x/12.x) replication solutions to facilitate data flow between heterogeneous (SQL Server / DB2 and Oracle) environments.
• Experience in Data warehousing and ETL.
• Experience in Database Security and Auditing.
• Experience in basic and advanced replication using Oracle Streams and experience in using OEM, TOAD, and Data Migrations using export/import, benchmarking using load testing tools.
• Training and Conceptual knowledge on MongoDB, Postgre SQL, Tera Data, Netteza, DynamoDB, SQL Azure, Aurora Databases.
• Professional experience in DB2 Installation, administration, performance tuning, backup & recovery with proven ability Confidential Server side & Client side responsibilities.
• Risk analysis, managing risks and issues and monitoring and reporting progress
• Team leadership including DBA’s, SA, NSA.
• Strategic influencing, working with vendors, controlling quality.

TECHNICAL SKILLS

Operating system: AIX, LINUX, UNIX, SUN SOLARIS, Windows 2003 server, XP.

Languages: SQL, UNIX, Shell Scripting.

RDBMS: DB2 UDB v8.x, v9.x, v10.x, MS SQL.

Software: IBM Tivoli TSM and HADR

Monitoring Tools: DB2MON and IBM Optim Performance Manager

Tools: ManageNow, BMC Remedy, Maximo and Service Desk.

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

Sr. DB2 DBA

Responsibilities:

• Responsible for installations for DB2 ESE on AIX/Linux environment and migration of DB2 UDB version 9.1 to DB2 UDB V9.5, V9.7, V10 and V11.1.
• Worked with DB2 LUW V8 and V9.5, 9.7, 9.8 Pure Scale and above.
• Implemented HACMP Strategy and High Availability Disaster Recovery (HADR with TSA), Federation, Performance monitoring and fine tuning OLTP and DSS Applications, and Problem determination and troubleshooting.
• Interacted with UNIX and Application group, and playing a diverse role with a large team of DBAs.
• Extracted Mainframe data, using Data Stage to DB2 LUW.
• Implemented Q-Replication method to sync data from OLTP to Data Warehousing environment.
• Created large table spaces, using Automatic Storage Management.
• Supported UDB DB2 4 node cluster from the server side and allocated additional disks for the Pure Scale cluster.
• Used Erwin data modeling tool for designing logical and physical data model.
• Monitored and tuned database software after installation and applied fix packs for peak performance.
• Mentored customers on managing complex environment, database performance tuning through database physical design, configurations and implementations of data aggregations, MQTs, partitioning, indexing and related settings.
• Extensive Knowledge on Shell Scripting.
• Performed database objects creation and alteration (tables, indexes, views, stored procedures, functions).
• Responsible for query performance optimization, tuning implementations, and production support.
• Established standards, controls, and procedures to ensure data integrity and security.
• Established effective security processes plans and policies, like SOX.
• Command Substitution is also done using shell scripting.
• Implemented database auditing with the help of db2audit tool.
• Implemented security administration tasks, such as identification and authentication controls.
• Performed version migrations from V9.7 and V10.1.
• Provided recommendations for ongoing tuning of environment based on growth projections.
• Monitored tasks with respect to database performance on packaged applications.
• Escalated performance exceptions and worked with the application.
• Supported team to improve package performance.
• Implemented Backup/Recovery of databases.

Environment: IBM DB2 V9.5, 9.7, 10.1, 11.1 DB2 Pure Scale, AIX 6.1, TOAD, OPM, Erwin, TSM, Q-Replication, Data Stage, Cisco Storage Manager, Flash Copy Manager.

Confidential

Sr. DB2 DBA

Responsibilities:

• Installation and Configuration of DB2 environment in LUW.
• Upgradation of database from v9.5fp7 to v9.7fp11 from v9.7fp11 to v10.5 fp6.
• Actively Involved in design/configuring databases on HADR-TSA.
• Apply the db2 patches by using zero down time Approach.
• Setting up the Q-Replication as per customer requirement by using Bi-Directional strategy.
• Experience in managing Table Space Capacity Management, Archival logs and DB Backups.
• Extensive work experience in DB Tuning, Performance issues and Query Optimization using db2batch & db2advis.
• Having experience on DPF environment servers.
• Setting up the Zero Down Time server as per customer requirement by using database WRITE SUSPEND/RESUME mode.
• Strong knowledge in Database Physical Support and Design.
• Shell Scripting is used for manipulation of files, executing programs and text printing.
• Hands-on experience on DB Backup and Recovery strategies.
• Hand-on experience in Migrating Databases from DB2 v9.x to v10. x.
• Extensive experience in working with db2 specific tools such as db2pd, db2dart, db2support, db2top, db2inspect, db2advise,db2explain, db2diag,db2look, db2move & db2relocatedb.
• Ensure availability of databases through database backups, verifying backups, ensure proper functioning of Jobs.
• Improve security by controlling user privileges/roles and implement profiles to meet the Security Standards.
• Create and maintain DB2 UDB instances and databases for development, test, and production environments within AIX operating environment.
• Implemented backup compression techniques and can support Time finder backups.
• Having good knowledge of AIX and Linux Operating System.
• Monitor security breaches, error log(s), database and log space, user activity and resource utilization of production environment. Work with application programmers to ensure that application problems do not adversely affect production operations.
• On-call 24x7 production support and Training guidance to offshore DBA's.
• We have supported L1 activities like database health check monitoring and script executions (DDL, DML), batch jobs monitoring.
• User security management.

Environment: DB2 UDB v9.5, v9.7, v10.1& v10.5, OS - AIX, Linux& Windows.

Confidential

Senior System Administrator

Responsibilities:

• Install IBM DB2 9.7 on AIX Server on seven systems, install DB2 client on Workstations and Catalog the Databases.
• Upgradation of database from v9.7 fp4 to fp6 and from v9.7fp4 to fp7.
• Data compression Confidential DB level for DB2 systems to get optimum performance of sql queries and storage savings.
• Implemented the Compression feature to reduce the storage costs and improve the performance of the applications.
• Extensive experience in fine tuning of long running queries.
• Implemented ARCHIVELOG process to maintain active log files.
• Performed Database migration/upgrades between multiple versions.
• Hands on experience on DB Backup and Recovery strategies.
• Analyzing and implementing DB2 reorg utility based on the need for database reorganization
• Handling table space and file systems space issues. Extending Table space
• Working and troubleshooting on day-to-day problems via opening and closing tickets.
• Automate the db2diag and notification log files by updating dbm parameter.
• Create PMRs with IBM in case of any software and problems issues with DB2
• Setup and maintain documentation and standards.
• Performed Server migration.
• Provide 24/7 Oncall support on rotational basis.
• Upgradation of database from v9.7fp4 to fp6 and from v9.7fp4 to fp7.
• Extensive experience in loading large volumes of data across DB’s.
• Cataloging Databases on various nodes.
• Involved in physical database layout design.
• Implemented Database partitioning and Archival logging in DB2 UDB.
• Troubleshoot the issues as and when required.
• Attending Weekend calls with offshore and onsite teams.
• Setup and maintain documentation and standards.

Environment: DB2 UDB V9.1, v9.5,v9.7&v10.1, OS - AIX, Linux

Confidential, OH

DB2 DBA

Responsibilities:

• Designing and Implementing Database objects
• Creating and Altering DB2 objects like Databases, Tablespaces, Tables, Indexes
• Planning and Implementing Backup and Recovery strategy.
• Performing online utility such as Load, Copy, Reorg, Runstats
• Tuning utility job to improve performance
• 24/7 on call support.
• Hands of experience in migration of DB2 versions from V9 to V10
• Setup of HADR to ensure high availability
• Took Offline and Online backup as well as wrote shell scripts and scheduled them.
• Put AutoSYS job scheduling daily based for Backup, Reverse engineering, Size of tablespaces, Snapshot and Runstats scripts
• Extensively used DB2TOP for monitoring database both in irrespective and Batch modes.
• Altered tables and added check constraints and referential integrity.
• Checked consistency of the databases, using DB2 commands
• Implemented DB2 Security, Locking, Concurrency Control

Environment: DB2 UDB V9.5, V9.7, V10.1, V10.5 5fOS - AIX, LINUX

Confidential

DB2 DBA

Responsibilities:

• Create and Manage Servers, instances and databases
• PerformedSQL TuningusingEXPLAIN,tuningDatabase/ Database Manager configurationparameters for optimal database performance
• Worked on Workload Manager to explicitly control and influence resources during execution by mapping all the queries to service classes.
• Maintained database concurrency by setting properIsolation LevelsandLocksfor queries
• Worked on data movementIMPORT,EXPORTand LOADutilities.
• Recovered database usingcrash, version and roll-forwardrecovery methods.
• Experience in setting up and maintaining High availability disaster recovery (HADR).
• Performed database maintenance tasksREORGCHK, RUNSTATS, REORGon daily/weekly basis.
• ImplementedDB2 Performance Expertmonitoring tool on Dev, QA and Prod servers.
• Useddb2expln, db2ckbkp, db2look, db2move, db2pd, db2rbind and db2mtrkutilities
• Wroteshell scriptsand setting upCRONjobs to take backup, runstats, reorg, disk space monitoring, I/O contention, log growth and rate of database growth.
• Expertise in SQL tuning, DB/DBM parameter tuning, different levels of memory allocations.
• Maintaining and troubleshooting health parameters of the database such asDeadlocks, Lock timeouts/escalations, Buffer Pool/Cataloghit ratio, Utility/Databaseheaps.
• Monitoring Tablespace utilization,Diaglog, Disk I/O,CPU utilizationon a regular basis.
• Establish standards and procedures to implementdatabase securityandauditing procedures
• Involved in applying latestfixpakson all UDB databases.
• Troubleshoot database production problems and database connectivity issues
• Implement Business Continuity Solutions such as Database refresh, cloning, Database Backups, etc.
• Monitoring the database environment on a regular basis for performance and other issues
• Configure and maintain database high availability
• Monitoring all the database and Instance parameters usingFoglight monitoringtool.
• Responsible for designing, implementing and testing Disaster Recovery procedures and processes
• Experience on that Computer Security Policies, General IT and SOX Controls are followed
• Experience on compliance with naming standards
• Participate as a team member in projects that require outages, upgrades and patches to databases
• Produce documentation and procedures regarding the proper use and operation of the DBMS Capacity Planning
• Coordinate the resolution of DBMS problems that require DBMS vendor intervention
• OpenedPMR'sandService ticketsto get the resolution fromIBMfor critical database issues
• Experience with change control management for moving changes from Development to Production.
• Supportedon-call DBAresponsibilities in UDBoff-hour (24/7).

Environment: DB2 V9.1,V9.5,V9.7,V10.1 Sun solarise, AIX, Linux, Oracle, IBM Data Stage and Netezza