PROFILE:

• 11+ Years of experience in managing mission critical DB2 Database Systems in AIX, Linux, Z/OS environments.
• Upgrading db versions from V9.7 to V10.1, V10.5, V11.1 and working with product vendors to get the bug fixes and applying fix packs.
• Experience in Installation and configuration of DB2 Connect and able to configure client connections to host servers
• Experience to perform online split mirroring, snap, clone.
• Expertise in evaluating and implementing new features like deep compression, adaptive compression
• Experience in supporting High Availability and Disaster Recovery (HADR), TSA solutions. Implement Multiple HADR Standby for High availability and Disaster recovery.
• Experience in supporting and configuring Confidential Q - replication.
• Supporting and resolving technical issues with DB2 UDB for LUW databases. Tuning poorly written SQL statements, creating indexes to improve the query performance
• Expertise in the installation, configuration and setting up of Confidential infosphere CDC replications for database.
• Expertise in taking Database Backups like online/offline/incremental/delta. Ability to implement Rollforward Recovery and Disaster recovery procedures
• Expertise in using database utilities like IMPORT/EXPORT/LOAD, db2inidb, db2move, db2look, db2pd, db2support, db2exfmt, REBIND, REORGCHK, REORG, RUNSTATS.
• Expertise in working with Product vendors such as Confidential and SAP to resolve product bugs by getting evaluating and implementing patches and fixpacks.
• Experience database administration tasks, using utilities RUNSTAT, LOAD, UNLOAD, REORG, COPY, CHECK, RECOVERY, DSN1COPY, MODIFY RECOVERY, REBUILD INDEX, REPAIR.
• Worked in specific Domain Areas - sales and Distribution Industry, Energy and Utility, Industrial sector, Pharmacy, Banking.
• Experience in executing Projects in Technical Skills area’s like DB2 DBA, DB2 Application Programmer, SAP, Confidential WebSphere commerce, Confidential Sterling Order Management, Confidential Mainframes Z/OS, ASP.net

SKILL:

Hardware Platforms: Confidential System p series, Confidential Z/OS

Operating Systems: AIX, Z/OS, VM, Windows, Unix, Linux

Languages: shell scripting, COBOL, PL/I, JCL, Easytrive, REXX, C, C++,Asp.net C#, HTML

Database Managers: DB2 Linux UNIX and Windows V9.5, V9.7, 10.1, 10.5, DB2 mainframes Z/OS V7, V8, VSAM, IMS, MS Access

Software, Tools and Environments: DB2TOP, DB2PD, SAP DBA Cockpit, Ignite, DB2 Connect, Omegamon monitoring tool, DB2 Admin Tool, ITM, TSM, SCLM, SPUFI, QMF, File Manager, RMDS,CA-Scheduler, TWS,CA-Dispatch, TOM, TSO, ISPF, SDSF, EXPLAIN, Fault Analyzer, Confidential Debug tool, Confidential Fault analyzer, IIS (Internet Information Services), Remedy tool, GRS, Service Now, MS Office 2000/XP

Querying Tools: QMF for Windows, BRIO reporting tool, Microsoft-Access

Configuration Tools: SCLM, PVCS

PROFESSIONAL EXPERIENCE:

Sr. Database Administrator

Confidential

Responsibilities:

• Database Installation, apply fix pack, upgrades, configure databases
• Implement and configure Confidential Q-replications for DB2 databases.
• Migrate database from one data center to another with minimum outage.
• Implement and configure Confidential Data server manager (DSM) for monitoring and performance analysis.
• Install, configure DB2 client and configure/troubleshoot client connections to host servers
• Using database utilities like IMPORT/EXPORT/LOAD, db2inidb, db2move, db2look, db2pd, db2support, db2exfmt, db2relocatedb, Reorgs, runstats Configuring Database Backups and recovery procedures, implement Roll-forward Recovery and Disaster recovery procedures
• Troubleshooting for application team for SQL errors, SQL tuning and object issues and performance issues
• Performance monitoring and tuning using db2pd, snapshots, monitors, db2expln and db2advise, explain, reorg, run stats.
• Setup SSL connection, Database encryption.
• Implementing and supporting High Availability and Disaster Recovery (HADR)
• Database administration and maintenance: routine DBA tasks like grant access, space management, database backups, database refreshes, database migration, database recovery etc.

Environment: DB2 9.7, 10.5, 11.1, Jboss, informatica, shell scripting, HADR, Linux, Confidential Q-replication.

Confidential, York, PA

Responsibilities:

• Production support: Provide 24x7 production supports to the users and application team related to database issues.
• Migrate DB2 database from Intel X86 64 (little endian) to Confidential Power8 server (Big Endian).
• Implement HADR Standby for High availability and Disaster recovery.
• Build Performance metrics tool to monitor production databases.
• Confidential commerce utilities like dbclean, stageprop
• Perform Database cloning.
• Perform OS DB Migrations.
• Application DB performance testing.
• SQL tuning: Database SQL tuning
• Database administration and maintenance: routine DBA tasks like grant access, space management, database backups, database refreshes, database migration, database recovery etc
• Database Installation, apply fixpack and Upgrades.
• Automation of tasks: Scripting for automation of routine DBA tasks.
• Mentoring team members.
• Opening Confidential PMR for issues.

Environment: DB2 9.7, Confidential WebSphere commerce,Solr, Confidential Sterling, shell scripting, HADR, Linux, HP Data Protector, Confidential Sterling Order Management, HP 3PAR.DB2 Z/OS.

Confidential, Indianapolis, IN

Responsibilities:

• Production support: Provide 24x7 production supports to the users and application team related to database issues.
• Database Installation, apply fixpack and Upgrades.
• Implement Multiple HADR Standby for High availability and Disaster recovery.
• Implement DB2 HADR TSA to migrate from VERITAS cluster to TSA.
• Migrate SAP IDM application from Oracle to DB2.
• Perform OS DB Migrations
• Develop best practice for compression, Enable adaptive compression.
• Setup & support Confidential InfoSphere Change Data Capture replicating data between DB2 and Oracle.
• Backup performance tuning; - evenly resize tablespaces using SAP db6conv utility.
• Migrating BW application from physical DPF to logical DPF.
• Database Performance tuning: Database performance tuning is required when database or session is performing slowly than normal.
• Implementation and validation of database related changes.
• Database monitoring, daily alert handling and production support 24X7.
• Testing: - Support the Development and Testing team on Database issue.
• Automation of tasks: Scripting for automation of routine DBA tasks.
• SQL tuning: Database SQL tuning, when end user’s queries are taking more than normal time to execute.
• Database administration and maintenance: routine DBA tasks like grant access, space management, database backups, database refreshes, database migration, database recovery etc.
• Participate in weekly meeting with client and other vendors.
• Opening SAP messages & Confidential PMR for issues.
• Estimation and Design Document: Preparing technical design document, Impact & Risk assessment, work prioritization and estimation for allocated work.

Environment: DB2 9.7, 10.5, Linux, VMware, SAP, SAP DBA Cockpit, SAP environments APO/BW/ECC, shell scripting, Confidential CDC, HADR, VCS, TSA

Confidential, Minneapolis, MN

Responsibilities:

• Provide 24x7 production support to the users and application team related to database issues.
• Database Performance tuning: Database performance tuning is required when database or session is performing slowly than normal.
• Database Installation, apply fixpack and Upgrades.
• Setup TSM for new systems and troubleshoot backup issues.
• Working with SAP DBA Cockpit for Database Administration Tasks.
• Monitoring and ensuring good and healthy Database.
• Perform Database cloning using EMC SNAP’s technology.
• Worked on DB2 Row Compression.
• Online/offline table moves using SAP db6conv utility.
• Assist infrastructure teams (Storage, network, backup, monitoring) in the validation of their respective datacenter infrastructure products with standard database systems and servers.
• Monitoring and ensuring good and healthy Database
• Support the Development and Testing team on Database issue.
• Scripting for automation of routine DBA tasks.
• Database SQL tuning, when end user’s queries are taking more than normal time to execute.
• Database administration and maintenance: routine DBA tasks like user access, space management, database backups, database refreshes, database migration, database recovery etc.
• Perform SAP BASIS administration tasks like schedule reorgs, add db activities to DBA planning calendar.
• Open SAP OSS messages, Confidential PMR’s on critical issues and work with them for resolution.
• Estimation and Design Document: Preparing technical design document, work prioritization and estimation for allocated work.
• Perform work prioritization and estimation for allocated work
• Mentor new/junior team members.

Environment: AIX, DB2 9.5, 9.7, 10.1, SAP, Confidential Tivoli workstation scheduler, Confidential Tivoli Monitor, Confidential Tivoli Storage manager, SRDF, HACMP, SAP DBA Cockpit, NetBackup, SAP environments APO/BW/GTS/CRM/R3/SRM

Confidential, Dallas, TX

Responsibilities:

• Provide 24x7 production supports to the users and application team related to database issues.
• Database Performance tuning: Database performance tuning, it is required when database or session is performing slowly than normal.
• Monitoring and ensuring good and healthy Database
• Testing: - Support the Development and Testing team on Database issue.
• Automation of tasks: Scripting for automation of routine DBA tasks.
• SQL tuning: Database SQL tuning, when end user’s queries are taking more than normal time to execute.
• To work on change requests and design/create/alter database objects: - Tables, Table spaces, Indexes, views, aliases.
• Involved in day to day database administration tasks, using utilities RUNSTAT, LOAD, UNLOAD, REORG, COPY, CHECK, RECOVERY, DSN1COPY, MODIFY RECOVERY, REBUILD INDEX, REPAIR.
• Database administration and maintenance: routine DBA tasks like grant/revoke access, object management, space management, backups, database refreshes, recovery etc.
• Code in COBOL using DB2 & IMS
• Responsible for migrating databases from one environment to another
• Code the SPUFI and JCLs for the Adhoc request.
• Planning and execution of disaster recovery.
• Estimation and Design Document: Preparing technical design document, work prioritization and estimation for allocated work.
• Perform work prioritization and estimation for allocated work
• Perform work allocation for fellow team members

Environment: Mainframes, DB2, Confidential Z/OS, CICS, IMS, DB2, Confidential DB2 ADMIN TOOL, COBOL, JCL, VSAM, Easytrive, Microsoft Access, REXX, DB2 Connect. DB2 9.7

Confidential, Columbus, OH

Responsibilities:

• Deliver new and complex high quality solutions to clients in response to varying business requirements
• Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.
• Utilize in-depth knowledge of functional and Technical experience in conjunction with industry and business skills to deliver solutions to customer.
• Code the business logic in COBOL using DB2, C# using SQL Server as the database.
• Doing Database refresh in different environments.
• Performance tuning, SQL query enhancements, code enhancements to achieve performance targets.
• Write routines in CICS, ASP.net for the communication between GUI and Mainframes.
• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.
• Peer Reviews
• Root Cause Analysis
• Preparing new JCL & SQL as per Project Requirement.
• Debugging of Various Issue rose during Functional Testing.
• Preparing weekly / Monthly progress / achievement reports.

Environment: Mainframes, DB2, Confidential OS/390, VM, CICS, IMS, DB2, CA-Dispatch, COBOL, JCL, VSAM, Easytrive, Microsoft Access, REXX, ASP.net, C#, SQL Server, PVCS, IIS.