SUMMARY

• 10 + years of IT experience with emphasis on database design, administration, maintenance and performance tuning using DB2 UDB LUW EE and EEE on UNIX (AIX), Linux and Windows.
• Worked through all phases of system development life cycle and has performed as a DB2 UDB DBA.
• Extensive DB2 UDB DBA experience with activities involving design, installation, configuration, requirements gathering, data modeling, tuning, security, backup, recovery and integration of database applications.
• Involved in setting up Q replication between Operational Database and Reporting database and troubleshooting issues associated with Qrepl control and source tables.
• Upgrading versions, installing fixpacks, day to day monitoring.
• Extensive experience in setup HADR and managing failover scenarios.
• Monitoring and troubleshooting systems using db2top, db2pd, SYSIBMADM views and customized monitoring scripts.
• Worked closely with IBM premium support on critical issues by providing diagnostic information.
• Analyzing and troubleshooting SQLs using db2exfmt, db2explain and db2advis.
• Extensive experience in setting up HADR and managing failover scenarios.
• Expertise in developing support activities including installation, configuration and successful deployment of changes across all environments.
• Worked on several data migration projects
• Monitored the database growth and performance bottlenecks using db2pd and OS monitoring tools.
• Provided production support for critical applications on a 24x7 rotating basis for databases on EE.
• Experience in writing shell scripts for various kinds of administration and maintenance tasks.
• Extensive Experience as UDB DBA in AIX, Solaris and Windows environments.
• Worked with performance teams to establish a baseline values to compare against for any changes or upgrades.
• Data maintenance utilities used REORG, RUNSTATS, RESTORE, LOAD, QUIESCE, IMPORT, EXPORT, DB2LOOK, and DB2MOVE. configured of pure scale.
• Involved in implementing Disaster Recovery strategy.
• Worked with third party tools like BMC Tools, Embarcadero DBArtisan and Aqua Data Studio.
• Experienced in documenting process, issues and resolutions for repetitive production issues.
• Excellent Interaction with functional and business analysts, department managers, different levels of users, developers and experience with Software Development Life Cycle.

PROFESSIONAL EXPERIENCE

Confidential

DB2 Database Administrator

Responsibilities:

• Worked as a production support DB2 DBA UDB for Confidential .
• Involved in design, analysis and creation of new instances and databases with automated storage.
• Provided a high degree of coordination between user, technical, application, and corporate entities to ensure effective data management as a corporate enterprise.
• Created shell scripts to generate Replication entries for new tables and columns that were deployed with new releases.
• Manage MQ Managers and MQ queues used by QReplication.
• Worked with IBM by creating PMRs for various issues involving installation and deployment.
• Performed QReplication and SQL Replication bypass procedures to avoid full refresh of data whenever needed with data consistency.
• Developed various shell scripts for backups, runstats, reorgs, rebinds, QReplication health check and other database maintenance activities.
• Documented various standard procedures in the shared knowledge base for the DBA team.
• Provided shell scripts for various WebLogic needs such as copying log files on daily basis, syncing directories on various servers.
• Worked with IBM to resolve db2 installation, upgrade and HADR issues. Most of the PMRs created were acknowledged by IBM to be defects and APARS were created.
• Involved in developing database application objects like stored procedures, functions, triggers and user defined data types.
• Extensively worked with data movement utilities like import, export, load and db2move for data migration between databases to sync production and UAT environments.
• Implemented backup and recovery strategies using regular and redirect restores as needed.
• Provided scripts and instructions to the production dba to apply the DDL, DML, DCL changes for various versions that were promoted into production.
• Monitored db2pd, db2top output and application snapshots from production for expensive queries based on db2explain, db2exfmt and db2advise I/O and CPU cost.
• Documented procedures for various database activities like installing a Fixpak, rebind a single package, troubleshooting QReplication issues, checking lock waits, current active SQL and other monitoring jobs.
• Monitor and benchmark performance tests using custom created scripts that monitor the workload.
• Identified and resolved performance issues for queries requiring too many locks, missing indexes, high shared memory and CPU utilization.
• Created table space containers using links in Unix to avoid a redirect restore even with different raw device naming conventions every time a prod refresh was needed in uat.
• Created scripts using various SYSIBMADM table functions to effectively monitor the databases.
• Involved in federation setup to access mainframe databases which includes creating wrappers, servers and nicknames.
• Assisted on configuration of pure scale in the lower Confidential to test.
• Involved in High Availability Disaster Recovery (HADR) setup and tested failover scenarios.
• Provided on call Production support.

Environment: DB2 UDB EE 10.5, V9.7 and V9.1 Fixpak 7, AIX 6, Linux, Crontab, Replication center, Control Center, WebSphere MQ series.

Confidential

DB2 UDB LUW DBA

Responsibilities:

• Involved in Design and development of logical and physical layers of databases.
• Installation and configuration. Of different versions of 10.x/9.x DB2 UDB on AIX 5.x.
• Worked on HADR setup with Tivoli System Automation (TSA).
• Created database and managed various database objects like indexes, tables and Tablespaces.
• Collected the database statistics using RUNSTAT, REORG, REORGCHK utilities and involved in analyzing the statistics
• Created scripts for backup, recovery and roll forward for the databases on weekly bases
• Used Import, Export and Load utilities in accordance with db2move command to populate large amount of data like databases.
• Designed and implemented back - up, recovery, archiving, and conversion strategies.
• Responsible for Database performance tuning analysis.
• Responsible for backup and logging/recovery policy.
• Developed database security strategy to provide access to large number of users in production Confidential .
• Install, configure and test new LDAP DB2 plug-in; work with Security Analysts to develop new DB2 security policy24X7 on-call support and problem resolution.
• Provided technical assistance and mentoring to staff for developing conceptual and logical database design and the physical database.
• Responsible for monitoring database and perform tuning when necessary.

Environment: DB2 V10.x/9.x, AIX 5.x, DBArtisan, Visual Explain, BMC Patrol, IBM Performance Expert, windows NT/XP, Server, Erwin, SAN.

Confidential, Chicago, IL

DB2 UDB DBA

Responsibilities:

• Involved in DB2 UDB v9.5 and v9.7 Upgrades on Data warehouse and Data-marts.
• Installation and configuration of different versions of 10.x/9.x DB2 UDB on AIX 5.x.
• Test and certify the new versions of software and fixpacks and making proof of concepts.
• Granting and revoking the access to the users and groups on the database and database objects.
• Closely working with Informatica team to improve their batch performance.
• Worked on corrupted and unrecoverable database to recoverable by using db2dart utility.
• Performed db2 redirected restores as and when needed to copy data from production to non-production Confidential .
• Experienced in using different utilities such as db2move, Load, export, Import, reorg and Runstats process.
• Experience in creating Wrappers, servers, user mappings and Nicknames to setup a federation view.
• Successfully used online table move stored procedure for Reorganizing and compressing the Fact tables.
• Involved in monitoring Database read and write activity using get snapshot commands, administrative views and table functions.
• Creation of databases and execution of DDL to create database objects like tables, Indexes, views, stored procedures and Triggers.
• Creation of databases and execution of DDL to create database objects like tables, Indexes, views, stored procedures and Triggers.
• Plan and coordinate many production changes and drive them till successful completion.
• Successfully tested and implemented Range partitioning technique on Fact tables.
• Involved in using db2expln, db2exfmt, db2batch and db2advis on SQL workloads to collect performance statistics that can be used to benchmark database and application changes.
• Monitoring the Production batch cycles, resolved various abends, ensure smooth execution of the production batch cycles and availability of the database.
• Drive intermediate Sev-1 issues through the resolution and interact with IBM for resolving high Priority PMR issues
• Implemented Compression to reduce disk and memory requirements, and improve the application performance.
• Efficient in solving problems which are critical during my on call schedule which included all the production databases irrespective of the projects I am involved in.
• Knowledge of comprehensive change control procedures.
• Involved in Capacity planning and space management. Worked on space estimates and tablespace design to accommodate large amount of data in data warehouse environments.
• Supporting the development team and also 24x7 productions on call support.

Environment: DB2 UDB v9.1/v9.5/ v9.7 FP 1, AIX 5.3/6.1, Informatica power-center 8.1/6, Windows NT servers, DB2 Connect, Federated databases and TSM.

Confidential

DB2 LUW DBA

Responsibilities:

• Migrated databases from V8.x to version 9.5 of DB2 UDB on AIX 5.x and Windows 2003.
• Supported mission critical applications like online Banking, and Bank Branch applications.
• Worked on Proof of concept for V9.5 testing.
• Supported partitioned Confidential (DPF) with 16 physical partitions and ware house Confidential . Experience working with MDCs, MQTS, Range-Partitioned tables, and Range-Clustered tables.
• Worked on migrating databases from Windows to AIX platforms.
• Worked on setting up log archiving to TSM for SQL replication Confidential .
• Developed Capacity Planning strategy for all UDB applications.
• Worked on Hardware upgrade for a mission critical production database.
• Provided support on DB2 connect related applications.
• Extensively worked on tuning complex SQL queries, developing stored procedures, and functions.
• Experience in developing Perl scripts for maintaining and monitoring databases on Windows Platform.
• Developed shell scripts for daily maintenance tasks, archiving DB2 log files, and performance monitoring.
• Generated ERD for the database using Erwin.
• Involved in managing log files and thereby ensuring high availability of database in a 24X7 scenario.
• Performed capacity planning and performance tuning.

Environment: DB2 EE V 8.1/8.2/9.x, Web sphere, AIX 5.x, windows NT/XP, Server, and ERwin

Confidential

Desktop Support Engineer

Responsibilities:

• Single point of contact for end user to receive support and maintenance for computers and network system.
• Diagnose and quickly resolve a wide range of Windows applications and networking problems to help minimize downtime.
• Troubleshooting network connectivity in a LAN/WAN Confidential .
• Coordinate and Works with vendor support contacts to resolve technical problems of Desktop, Printers and Laptops.
• Performs general preventative maintenance tasks on computers, laptops, printers and any other authorized peripheral equipment.
• Installation and deployment of desktops (Windows XP,7, 8, 2008, 2008 R2 serves).
• Implementation of desktop solutions to fulfill business unit requirements.
• Installation and configuring of Antivirus and troubleshooting of MS Office products.
• Configuration & installation of approved Applications.
• Follow-up and Escalate (Internal / External) desktop related issues.
• Technical documentation of hardware/software additions or changes.
• Updates of inventory additions and changes to the inventory database.
• Updates and closures of trouble tickets and service requests. knowledge of A.D, DHCP, DNS

Environment: Windows7/Windows XP/2003/2008, MS Office Suit-2007, 2010, MS Exchange 2007, Windows Active Directory.

Confidential

Technical Support Executive.

Responsibilities:

• Provide technical support for PXE base Thinclient.
• Provided telephonic, remote and onsite technical support to client for Thinclient machine And its Linux base embedded OS and also for Storage device.
• Monitoring cases and calls that logged by Customer and provide the solutions of their Technical issues
• Installation of Server and it’s configuration
• Trouble shooting of Server and Computer systems, Network printer
• Firewall configuration (Fortinet).
• Outlook express/Microsoft Outlook.
• Testing embedded OS with Active Directory Infrastructure.
• Preparing Technical Docs and also Tech videos.
• Storage configuration.(NAS) User creation and proper security rights as per user Requirement
• Network Trouble Shooting.
• Maintain network infrastructure, Diagnose problems with connectivity.
• Arrange webinar and give training to our customers and channel partner's