SUMMARY

• UDB DB2 Database installations starting from V6.1/7.1 EE and EEE/8.1 ESE V9.x (9.1 & 9.5) V10.x (10.1 & 10.5. Done migrations from UDB DB2 V6.1 to V7.1 & UDB DB2 V8.2 to DB2 V9.1 & V9.7 to DB2 V10.1 upgraded multiple databases to V 9.7 V10.1 v10.5.
• Participated in DB2 logical database design and been instrumental in doing DB2 on AIX physical design for large Data warehouse environments and also highly transactional customized OLTP databases. Experience in various aspects of DB2 UDB including physical and logical design,
• Experience including reorg, runstats, rebind, export, import, load, backup, restore and roll forward utilities.
• Database recovery experience with backup, restore, roll - forward utilities with the different option & including flash clone technology and Active/archival log maintenance.
• Good experience High availability (HA) with HACMP, HADR environment Control, maintenance of production application databases and (DR) disaster recovery testing,
• Database Performance monitoring, Tuning, query analysis, optimization and maintenance experience using like db2 Snap shot Monitor, Event Monitor, db2 Explain and Index Advisor performance tools.
• Carried pager 24/7 On-call rotation, performed On-Call duties taking care more than 210 UDB databases various client servers during the regular time and off hours. Resolved many on Non-production and production issues like, failed backups, moving archiving logs to TSM, Tablespaces & file system maximum used file systems limit alert, and databases down, etc.
• Running the long running queries, to capture those Sqls to take the db2advis and db2 Explain function to create indexes and examine the access plan working with the developers and application team.
• Addressing the DB issues submitted on PR Ticket with Sev 3 to Sev 1. And also reported the PMR Tickets for the various issues on db2
• Database performance benchmarking tool experience using Quest Software Benchmark Factory and Mercury Interactive Load Runner benchmarking tools, Toad, DBI and other etc.
• Scripting experience using both the shell programming batch programming
• Good experience of ManageNow R1 & R2, Service Now and other incident, change/problem management activities using standard change/problem processes in support of application database related changes and issues.
• Monitor, troubleshoot and validation qcapture & qapply programs status both side on source and target databases. Set up SQL replication for new tables.
• Problem identification, management, and resolution experience with DB2 diagnostics, trace facilities, and database analysis reporting tool (DART).
• Provide 3rd party application support with relation to databases - testing, implementation and upgrade .
• GSD331 DB’s Health Checking report and database fixes (Custom term in IBM internal Projects) for doing IBM Internal quarterly audit HC report of the database checking as for the GSD331 version 7.0 SP6. Document.

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

UDBDB2 DBA

Responsibilities:

• Confidential is a Fast paced and high profile OLTP production environment. Design and create relational databases from E1/E2/E3.
• Good experience of Service Now for Incident, change/problem management activities using standard management support of application for database related changes and issues.
• Database performance monitoring and tuning .
• Refresh production database to E1/E2/E3 other environments from the TSM.
• Service Now Review, approve and Implementation on CMRs (Implement/Migrate schema, tables, stored procedures Changes from one environment to other in E1/E2/E3) .
• 24/7 Peak season readiness & support .
• To Perform Root Cause Analysis (RCA) for incidents and outages of IMR & PMR
• Provide BAU Steady state support for the databases.
• Database Infrastructure Support and Work with DBSA during OS upgrades/patches/db2 upgrades. worked on Configure, monitor and troubleshoot active-active qrep replication.
• Configure, monitor and troubleshoot HADR . worked on Participated in new software/tools POCs .
• Miscellaneous (Work with Control M team/TSM/Data requests ( Artifact ) /MINF ).
• I worked with the TSM team, UNIX System admin and with the other application team for testing the Filesystems alert when it got 100% filled. ( I created a dummy file with 3GB using the command = dd if=/dev/zero bs=60k count=50000 of=dummy )
• To open the SDT request for BMC patrol monitoring on e1, E2 and E3 servers for db HEALTH fixes and database alerts fixes.
• To Monitored, troubleshoot and fixes applications db2locktimeout and dead Lock .
• To moved old archived logs and old backups to TSM from their directories and Clean up and reduces the file systems bellow thresholds levels .
• Supported various patch upgrade for TSA, OS and
• Monitored Data loads and various batch jobs on databases and worked with the development team to troubleshoot various the issues on databases performance
• Health Checking report and GSD331 databases fixes (Custom term in IBM internal Projects) for doing IBM Internal audit every quarterly HC report of the database checking as for the GSD331 version 7.0 SP6. Document.
• Worked on Configure and monitored databases for Optim Performance Manager to create reports on Real-time monitoring and automatic data collection.
• To Configured databases for qrep Data replication Dashboard in Optim Tool .
• To set up SQL replication for new tables in the database.
• Supported oncal on shift basis for 4 different shifts for 24/7 around 200 databases. worked with the application team to fix the issues on Data sync on the databases.

Environment: IBM db2 V9.7 FP6, AIX 6.1, AIX on Power Systems servers (IBM Power PS703 and PS704 ), TSM and TSA, Power HA 6.4 ( PowerBroker ) and Required heartbeat SAN will required 1 GB. MQSeries 7 Fix pack 13, IBM InfoSphere Data replication Dashboard ( Qrep Dash board), Infosphere Optim performance Manger v5.1, GSD331 version 7.0 SP6. Websphere 8 FP9, SDC - BMC Patrol, Serice Now, CONTROL M .

Confidential, Austin, TX

UDB DB2 DBA

Responsibilities:

• Installation, administration and maintenance support primarily for DB2 UDB Database systems and related products in a fast paced production environment.
• Participated in enterprise-wide application testing in the Development, QA and production database releases
• Monitored the Data loads and various batch jobs on databases worked with the development team and other teams To monitored databases performance.
• Worked with DBA team for the effort for building a high availability solution using HACMP, bi-directional SQL replication and HADR.
• To set db2 registry variables after Db2 PureScale instance in created. knowledge of to check the status of the node and Domain, to stop and start a TSA managed node, to Verify Cluster Configuration Updates .
• Worked with the teams to test and coordinate the implementation of DB2, TSA, AIX, WCS and other applications patches and upgrades..
• Analyzing new application requirements and associated database changes
• Creating new database and Creating database standards and naming conventions with the Implementing DDL changes
• Performing database db2 version and fixpack upgrades and also Helping application (example: WCS ) version/patch upgrades
• Troubleshooting database errors with the Track, troubleshoot and resolve all database issues; maintain an issue resolution log .
• Reporting the DB issues submitted on PR Ticket with Sev 3 to Sev 1. And also reported the PMR Tickets for the various issues on db2
• Good experience with the change and problem management tool for the database and application changes with the database.
• Monitoring the Load test and provide the KPI reports with the DBI tool . - even if client doesn’t do load testing, look for problem SQL review .

Environment: IBM P710 and PS702 Blades, DB2V10.5.0.2, db2 V10.1.0.4 and DB2 v9.7.0.5, AIX6.1., 7.1 and 7.16 TL07, Linux Server release 5.3, Websphere Commerce 6.0.0.7, websphere 6.1.0.29,IBM JAVA 5 SR10, IMS ( Wherehouse Management SYSTEM) HP G6 dl380'S Red Hat Enterprise Linux Server release 5.3 (Tikanga), Redhot 5.3, MQ, WAS7.0 and IHS7.0, Mysql, SQL, TSM, TSA, Toad and DBI tool.

Confidential, CHICAGO

UDB DB2 DBA

Responsibilities:

• Worked with DBA team for provide technology road map to considering growth and various Online Business initiatives.
• The DBA support for Production/development teams for supporting Web sphere Commerce Suite databases (5 TB) related tosears.com,kmart.comand its subsidiaries.
• Worked with DBA team in building and mentoring a 24x7 support DBA team using onsite/offshore model.
• Worked with DBA team for the effort for building a high availability solution using HACMP, bi-directional Q replication and HADR.
• Deep knowledge in Database performance tuning and SQL Optimization
• Worked with DBA team for the 100% DB availability effort for 2012, and 2012 Holiday readiness (forsears.com,kmart.com, mygofer.com and shop your way ).
• Monitored the databases on the DashBorad user friendly GUI (Graphical user Interfaces ) for CPU usage, Memory Utilization, Lock-wait per interval, Locks Held, Applications Executing, lock time out, Dead locks, Sorts overflows and etc. alerts .
• Monitored and notified the USER CPU & KERNEL CPU. To find out the cause for sqls, Batch Jobs, Solrx Jobs and other jobs, to resolved the issues to worked with the related teams .
• Addressing the DB issues submitted on PR Ticket with Sev 3 to Sev 1. And also reported the PMR Tickets for the various issues on db2.
• Monitored the Data loads and various batch jobs and SOLRX jobs, on databases worked with the development team and other teams To monitored databases performance, tablespace sizes, & filesystems usages, tablespaces state and table state using Shell scripts and db2pd tool and other snapshot monitor tools .
• Database monitoring and tuning experience using DB2’s Performance Monitor with the utility for db2pd tool .
• Worked with the team to research, test and coordinate the implementation of DB2 patches and upgrades. Performs physical database analysis, monitoring and change control, logical and physicaldatabase design.
• Participated in enterprise-wide application testing in the Development/QA Environment and database production releases.
• Participated in the on- call support rotation and provide immediate responses to high priority alerts from the 24/7 Operations teams and automated monitoring. Provide after hours and weekend support as needed.
• Worked with vendors, customers and internal personnel on project implementations and to resolve business and technical issues. Functions as a key point of contact with IBM on all database related concerns.

Environment: IBM P720 Blades,, DB2V10.5.0.2, db2 V10.1.0.4 and db2 v9.7.0.6, AIX 6.1.7.16 TL07, Linux Server release 5.3, Web sphere Commerce 6.0.0.7, web sphere 6.1.0.29, KANA, Solrx, IBM JAVA 5 SR10, IMS ( Wherehouse Management SYSTEM) HP G6 dl380'S Red Hat Enterprise Linux Server release 5.3 (Tikanga), MQ 6.0.1WEBSErvices HP G6 DL380'S, Redhot 5.3, Mysql and SQL, TSM, Netbackup, Toad and DBI tool.