SUMMARY OF QUALIFICATIONS:

• 7 years IT experience with Database Administration at all phases of software development lifecycle i.e. Development, Analysis, Design, Testing and Implementation for various applications.
• Worked as a DB2 UDB V8.x, 9.7, 10.1 Database administrator on UNIX, LINUX and Windows platforms, with expertise in online transaction processing and multi-user systems involving large and distributed databases.
• Involved extensively in Installation and Configuration, upgrading, and troubleshooting DB2 databases.
• Skilled in database administration tasks like SQL coding, Relational Design, Referential Integrity, Index strategies, and SQL Troubleshooting Using DB2 UDB.
• Migrated DB2 UDB databases from old to newer versions and applying FIXPACKS to keep DB2 at most recent level.
• Experienced in OLTP OLAP database environments which include Single Partitioned and Multi-Partitioned Databases DPF .
• Perform AUDIT on the Databases to give users bare minimum privileges on the Database and Database objects.
• Expertise in handling DB2 UDB security, establishing replication between servers, Capacity Planning, Backup and Restore, Shipping archival logs, Corruption and Recovery, Managing login/permissions.
• Hands on experience with tools like ERWIN DM and Informatica Power Center ETL .
• Expertise in SQL, T-SQL and Dynamic SQL programming - Functions, Stored Procedures and Triggers
• Knowledge with carving and implementing Backup/Recovery strategies for clients to have desired recovery models.
• Exposure to HA setups like Clustering, HADR, etc.
• Setting up monitoring for the database like Snapshots, Event monitoring, Traces, etc.
• Strong analytical ability, communication skills and problem solving capability.
• Versatile, flexible and ability to work on multiple assignments in a given time frame.

TECHNICAL SKILLS:

Command Center, Control Center, Quest Spotlight, Quest Foglight, Quest Central, Citrix, Cacti, Developer Workbench, OPM PE , WIN SCP, TEXT PAD, ERWIN, AQT, WLM, MS Office, Putty, TOAD, SSMS, SQL Compare, SQL Sentry, SQL Profiler.

PROFESSIONAL EXPERIENCE:

Confidential

DB2 LUW Database Administrator

Responsibilities:

• Provided support for basic technical issues.
• Resolved Customer issues within appropriate timeframe to ensure customer satisfaction.
• Entered and updated incident details using our CRM system.
• Participated in the On-Call rotation when needed.
• Participated in special projects that may require direct interaction with the customer and may require work at unusual hours of the day.
• Performed simple software upgrades such as firmware upgrades, DB2/SQL Server fix packs, service packs or updates.
• Produced and maintained work instructions when required.
• Performed tests on hardware when assigned to determine its compatibility with our products.
• Troubleshooted server environment as it relates to but not limited to : proprietary products, 3rd party products, network configurations and concepts, Operating System functions, virtualization concepts and vendor specific hardware configurations.
• Understood and troubleshooted hardware and peripheral concepts, architecture, and installations. Displayed strong software troubleshooting and diagnostics skills.

Environment: DB2 UDB AIX,z/OS v8.1, v8.2, v9.1, v9.5, v9.7,DPF, SQL Server, UNIX AIX , Linux.

Confidential

DB2 LUW Database Administrator

Responsibilities:

• Installed, Configured and upgraded DB2 server software and related products
• Administered DB2 UDB for development, test and production environments.
• Upgraded many Fix Packs in version 8 and 9 and Supported v 9.5 to v 9.7 migration.
• Actively involved in figuring out the qualifying problems for IBM PMR, following up with the vendors and the teams involved.
• Automated REORG/Runstats/Backup activities and have the notifications sent to applications teams.
• Installed and monitored Disaster Recovery boxes and HADR for critical databases.
• Performed on call duties for SQL Server and DB2 databases.
• Supported multi application databases for SQL Server 2008, 2012.
• Performed daily activities like Database Creation, User access, Scheduling, Job set up, Backups/ restores, etc
• Did document and communicate the status of progress against plans and took corrective action as necessary.
• Used different utilities like DB2TOP, SMITTY, DB2LOOK, etc.
• Strong understanding of database shared memory parameters and tuning memory parameters in Db and Dbm cfg.
• Supported ETl team and worked in offshore model.
• Performed offline and online backups, restore, redirect restore and roll forward activities and make sure they are complete and successful.
• Developed backup and recovery strategies depending on the customer requirements.
• Participated in 24 7 on call support.

Environment: DB2 UDB AIX,z/OS v8.1, v8.2, v9.1, v9.5, v9.7,DPF, Oracle, SQL Server, Informatica, UNIX AIX , Linux.

Confidential

DB2 LUW Database Administrator

Responsibilities:

• Installed, Configured and upgraded DB2 server software and related products on Mainfrrame environment.
• Troubleshot day-to-day problems encountered on production, development and test database environment.
• Designed, implemented and administered DB2 UDB for development, test and production environments.
• Migrated Development DEV , Test UAT and production PROD databases from DB2 9.5 FP 5 to DB2 9.7 FP 4.
• Developed and implemented standards to create databases and various database objects
• Managed database loading, migrating and maintaining data with LOAD, EXPORT, IMPORT DB2LOOK.
• Put AutoSys job scheduling daily based for Backup, reverse engineering, Size of tablespaces, snapshot and runstats scripts
• Took online and offline backups as well as wrote shell scripts and scheduled them
• Requested space for file system and raw-devices to UNIX group
• Wrote shell scripts in Unix AIX/Solaris/HP with a good understanding of UNIX servers and architecture Cataloged multiple instances and configuring connectivity to databases from remote clients
• Tuned Database Manager configuration parameters as needed
• Bind the server DB2 utilities to the databases
• Requested TSM management class from the TSM administrator and Configure Database parameters to use TSM management class
• Tuned DBM configuration parameters and DB cfg parameters
• Drop and add users, logins, aliases, and groups to the databases and granting/revoking permissions on Database objects.
• Installed DB2 10.1 AESE on sandbox and working on Prototype scenarios for replication.
• Extensively involved in Application Support, Design, User Administration, Security, Performance Tuning, Optimization and Backup/Recovery
• Supported On call weekly based 24/7.

Environment: IBM DB2 V 9.1, 9.5, 9.7,10,1, z/OS IBM Datastudio, AIX 5.x, 6.x, Foglight V4.2, 5.6, Toad,

NetWorker, TSM, MQSeries,BMC Remedy.

Confidential

DB2 LUW Database Administrator

Responsibilities:

• Carried out knowledge transfer KT from the client DB2 team, documented the process and procedures and educated the offshore team.
• Carried out day to day work with client team which involves tickets, production support, project work, process improvement and the role of application DBA.
• Actively involved in figuring out the qualifying problems for IBM PMR, following up with the vendors and the teams involved.
• Solving the user access and security group issues.
• Documenting the standards followed by the YUM team and maintaining the version updates along with the process improvements being carried out.
• Provided inputs and implemented many process improvements like Backup Strategy and Schedule, Script modifications and standardization, naming standards, Table/Tablespaces restructuring, Maintenance activities/schedule, Performance tunings, database Creation, etc.
• Supported new environment creation starting from capacity planning, structure layout, instance creation, group/user set up, database creation, object creation and followed by supporting the tuning and performance monitoring for the application teams.
• Performed database migration from Oracle 10g to 11g, tasks included performance tuning, configuration and maintenance.
• Setted up and monitored Disaster Recovery boxes and HADR for critical databases.
• Performed on call duties for SQL Server and DB2 databases.
• Supported multi application databases for SQL Server.
• Performed daily activities like Database Creation, User access, Scheduling, Job set up, Backups/ restores, etc
• Supported Windows patches and application maintenance downtimes.
• Performed multiple SQL 2005 and 2008 Server and Client installations.
• DTSX and CFG migrations for SSIS packages.
• Failover Cluster management for 1 1 and 3 1 production clusters
• Monitoring multiple alerts and notification from over 60 applications and 400 databases.

Environment: DB2 UDB v 8.2/v 9.7, z/OSOracle 11g, SQL Server, Netezza, DB2 Mainframe, UNIX AIX , Toad, Quest Central, Quest Spotlight, SSMS, SQL Server MSSQL 2005/2008/2008 R2.

Confidential

Database Administrator

Responsibilities:

• Worked on creating Staples internal portal, which is live now and has replaced the existing home portal. Created the environment from the scratch which consists of 54 Databases.
• Compressed 100s of multi 100 GB tables and was able to save more than 8 TB of space from the EDW data warehouse .
• Upgraded many Fix Packs in version 8 and 9.
• Supported v 9.1 to v 9.5 migration.
• Created backup and recovery strategy and implemented and schedules the activities.
• Supported many development projects which include creating the tables, views, indexes, stored procedures and triggers in both OLTP and OLAP environments.
• Intensively worked on DB performance tuning and dealing with STMM, AUTO MAINT, Health Monitors, etc.
• Was involved in deploying Stored Procedures using Developer Work Bench.
• Created Backup Reporting model to send daily detailed reports to the team about the success and failure with the failure reason.
• Created and scheduled automated REORG/RUNSTATS scripts to perform automatic maintenance activities on different environments depending on the system needs.
• Familiar with different utilities like DB2TOP, SMITTY, DB2LOOK, etc.
• Dealt with different issued regarding FS usage, Grants, Profiles, Variables, etc.
• Worked with IBM to open PMRs and found solutions for different priority issues. This included performing diagnostic tests, data collection and sending it to the IBM.
• Encountered many APARs in the environment and worked with the DB and application teams along with IBM to implement the hot fixes/FPs and then monitor the performance.
• Worked with DAs and used forward/reverse engineering from Erwin to update the model or DB.
• Involved in reducing HWM and free the space and add it to the File System.
• Proficient with required UNIX commands and scripting.
• Worked in the Onsite/Offshore model.

Environment: DB2 UDB v8.1, v8.2, v9.1, v9.5, v9.7,z/OS,DPF, Oracle, SQL Server, Informatica, Microstrategy, UNIX AIX , Linux.

Confidential

Database Administrator

Responsibilities:

• Worked with Data Modeler team to understand the Business Requirements and Business Rules
• Performance tuning activities to manage database manager, database configuration, bufferpool configuration and registry variable configuration.
• Administered company's Production, Staging, Test and Development DB2 UDB databases.
• Was involved in Capacity planning work.
• Troubleshoot the problems occurring out of the backup and recovery.
• Performed offline and online backups, restore, redirect restore and roll forward activities and make sure they are complete and successful.
• Developed backup and recovery strategies depending on the customer requirements.
• Involved in upgradation from version 7 to version 8.
• Support the ETL team with the daily production issues.
• Strong understanding of database shared memory parameters and tuning memory parameters in Db and Dbm cfg.
• Involved in training junior level developers and DBA.
• Performed db2 redirected restores as and when needed to copy data.
• Created snapshot monitors and event monitors to regularly check the health of the system
• Used different data movement utilities like LOAD, EXPORT, IMPORT utilities to load data.

Environment: DB2 UDB v7/v8, Windows, AIX UNIX ,Mainframe, Erwin, Cognos, Informatica Power Center.

Confidential

Database Administrator

Responsibilities:

• DDL implementation and changes for database objects.
• Maintaining database backup and recovery and other scheduled tasks.
• Worked on explain, db2advis, taking snapshots, running list applications, checking the memory, backups and restores etc.
• Regular auditing of the database for user access to ensure the security.
• Supported FP and version upgrades.
• Worked with the application teams to tune the SQLs and DB.
• Gained experience with scripting to create automated jobs for DB maintenance.
• Involved in data modeling Logical/Physical database design design including data marts.
• Monitored and analyzed DB2DIAG logs.
• Involved in day to day database administration tasks like running reorgs, runstats, import and export.

Environment: DB2 UDB v7, Oracle, Windows, AIX UNIX