PROFESSIONAL SUMMARY:

• 5 years of IT consulting experience as DB2 DBA on LUW.
• Experience in all phases of software development lifecycle i.e. design, development, implementation and maintenance of databases using DB2 V 9.7/10.1/10.5 to support applications on AIX, Linux, and Windows environments.
• Experience in day to day db2 dba activities on regular basis and new tasks including on weekly basis tasks and upgrade, production backup refresh on LLE’s as per the business requirement.
• Experience in installation of the IBM DB2 products and latest fix packs and maintaining DB2 environment including creating instances, databases, buffer pools, tablespaces and tables.
• Experience with environments that include third party vendor products like WebSphere Commerce Suite, Transport management system and Warehouse management system with DB2 as backend.
• Experience in long term assignments handling Decision Support Systems (DSS) with DB2 as backend.
• Instrumental in physical designing of DB2 Database Servers on both UNIX (AIX) and Linux environments.
• Handled different Backup policies, and did hands on restores (version and point - in-time) and redirect restores as and when needed.
• Understands the OS level to the extent the DBA is needed to, to interact or work hands-on to layout DB Servers, file system perspective.
• Experienced in disaster recovery methodologies like HADR.
• Used shell scripts to automate and maintain DB Server activities.
• Experienced in performance tuning and monitoring of OLTP applications and DSS applications.
• Worked as Development DBA, Production Support DBA and DB2 UDB Database Engineer.
• Understands the pro-activeness needed for the DBA, and resorts to automate most of the administrative tasks.
• Evaluated DB2 new versions and features and suggested migrations from DB2 lower versions to current versions.
• Delegated work to the DBA offshore team members by giving required check lists for the DBA’s to follow for lower life cycle and production systems
• Strong communication, verbal and written skills to effectively communicate, guide, document process and responsibilities.
• Used db2expln and db2advis to tune the expensive queries that ran against the production data.
• Used DB2 utilities like Snapshots, db2batch, db2exfmt, event monitor, for performance tuning and monitoring

TECHNICAL SKILLS:

Platforms: Linux RHEL6, Data stage 8.5/8.1, AIX7.1/6.1/5.2, Windows 2008, UNIX.

Industries: Retail, Manufacturing, Insurance.

Project Domains: Enterprise Information Data Warehouse (VLDB), Application Development, Executive Reporting, Order Processing, System Integration.

Hardware: IBM-RS/6000, IBM-OS/360

Database Tools: DB2TOP, DB2PD, Data Studio, Control Center

Applications: Transport Management System, Warehouse Management System, Ab-Initio, Cognos 8.0, B2B, MS Project 2010, 2013, WebSphere Commerce Suite.

Storage : Tivoli Workload Scheduler, Tivoli Storage Management, Tivoli System Automation, RDBMS DB2 LUW 9.x/10.x.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta GA

Production Support and Development

Responsibilities:

• Involved in Database creation and Database replication along with Database objects.
• Worked extensively with Build and Deployment team in new releases and code fixes from Database side.
• Heavily involved in DDL and DML Deployments.
• Worked in conjunction with the Data Architect based on the Projects requirements and Database structure.
• Installed different versions of DB2, mostly V9 and V10 various fix packs for new built Servers and Databases.
• Performed numerous version and Fix Pack upgrades in DEV and SIT region.
• Migrated from 9.7 db2 version to 10.5 version
• Prepared SOP and Installation guide for Version and Fix pack installation and upgrades.
• Maintained, controlled and implemented more then 50+ schema along with Database objects in more than 30+ UDB DB2 Databases and 20+ servers.
• Used clear case tool for maintenance of the codes and baselines for different projects.
• Worked with system admins to create, layout and provide requirements for File Systems, CPU’s, Memory, Space and OS requirements for new built.
• Maintained the Database versions and code level according to Database/Environment/Schema and at Server level.
• Did hands on restores and backups as and when required.
• Used DB2 HPU to read data from backup images
• Scheduled and monitored db2 utility scripts to run against the databases.
• Creation and maintenance of multiple schemas for different projects in Non production Databases.
• Worked extensively with Data Modelers for creation of new tables/indexes and objects based on the new Project requirements.
• Heavily involved in execution and debugging of DDL’s and DML’s provided by the data team.
• Hands on experience with Access Database and Enumerations
• Created User and Groups and maintained/managed using them MAC request tool.
• Extensively used Remedy Ticketing system for Incidents, Work Orders and CRQ’s.
• Worked as Confidential ’s SME for HADR with TSA
• Built HADR solution for the Database.
• Implemented HADR and TSA on both AIX and Linux platforms
• Prepared SOP’s, Implementation plan and Run book for HADR with TSA
• Involved heavily in testing the Database and application failover and failback.
• Provided on-call and on-site support during the go-live of the HA Project in Production to the Production Support DBA’s and resolved issues with the implementation of the HADR.
• Extensively used Unix OS performance tools like NMON, TOP, VMSTAT, IOSTAT etc. to identify any resource bottlenecks.
• Scheduled and monitored db2 utility scripts to run against the databases.
• Implemented range partitions on the table to improve the performance and to attach (roll in) and detach (roll out) partitions as needed.

Confidential, Durham, NC

Jr DB2 UDB DBA

Responsibilities:

• Support of 30+ servers where DB2 Database is installed on AIX environment.
• Maintains more than 50 instances and 50+ databases in development, test, stage (QA) and production environment.
• Working in Process-driven environment, by following processes like Problem Management and Change Management etc.
• Providing L1/L2 level production support.
• Resolving Problem tickets of different severity levels during production support.
• Monitoring table space growth using standard scripts and working with trend analysis data.
• Handling table space and file system space issues.
• Executing DDL and DML scripts as per customer request.
• Granting / revoking various authorizations to different Users/Groups.
• Creating and updating scripts for database related automation jobs.
• Working with data movement Utilities i.e. import, export and load.
• Working with Data warehousing team to monitor LOAD operations and SQL performance tuning.
• Monitoring scheduled jobs like backup, reorganization, runstats etc.
• Trouble shooting DB2 problems using different tools and utilities.
• Regularly monitoring Prod/Test environment and making necessary changes to keep Prod and Test environment in sync.

Environment: DB2 UDB v9.7/10.1 UNIX, WebLogic server, data stage, AIX 6.1, Shell Scripting,

Confidential, Atlanta, GA

Database trainee programmer analyst in DB2 UDB support environment.

Responsibilities:

• Attend a DB2 UDB LUW architecture training program from IBM corporation provided by Confidential .
• Involved in Installs Db2 and creating empty shell DB and initiation temp dbs.
• Involved in creating DB2 DB objects as per the sr dba guidelines.
• Monitoring db instances, databases.
• Extracting /applying DDLs from UAT to Dev, UAT to SIT as per application team request.
• Involved in Datacopy process at schema level on lower environments.
• Involved in Database backups, redirect restore guides lines from Lead DBA.