SUMMARY

• 11+ years of IT experience out of which 10 years as a DB2 UDB LUW / Mainframe DBA.
• Working as a DB2 DBA 5+ years and 1 year in UK for the past projects. Involved in DB2 DBA activities like DB2 Object manipulations, DB2 Utility executions and Bug fixing.
• Experience in Performance monitoring and SQL tuning.
• Experience in DB2 Objects database design.
• Experience in DB2 Objects recovery.
• Total Team Player with Excellent Learnability, Communication, Interpersonal skills.

TECHNICAL SKILLS

Databases: DB2 UDB DPF (Data partition facility/Pure scale) 9.1/9.5/ 9.7/9.8/10.1 LUW (Oracle,Linux, Unix, Windows & AIX) and DB2 V9.x/10.1 for Z/OS/oracle 11g/SQL Server 2008 R2

Programming Languages: Cobol

Tools / Utilities: Aqua Data Studio, infosphere change data capture (CDC) replication management, TOAD for DB2, DB2 Mon, db2pd, FileZilla, Quest Central, Quest Spotlight, TSM, shell/Perl /Power shell scripting, WINSCP, Vantage, TSM,TOPAS,HADR, DB2TOP, DB Visualizer,Data studio, OPTIM, JCL, SQL, File - AID, CA7, SPUFI, QMF, TSO/ISPF, Insight tool for DB2, DB2 admin tool, DBAXpert for DB2, Tmon for DB2, PLATINUM, DB2 Object compare, Omegamon II for DB2.

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

DB2 UDB LUW DBA

Responsibilities

• Apply database object changes, involve in database structure design, capacity planning, and data movement, store procedures/functions creation and migration.
• Working closely with DA, Business analysts, COGNOS, data warehouse and Data marts and web application(OLTP) team like Disability reporting, Finance metrics, CRU reporting, LAGER application, Health care reforms, Guardian Online, Group Sales reporting and Data warehouse etc.
• Performance monitoring, query optimization/SQL tuning and monitoring of ETL Queries and database long running SQL’s.
• Experience in conversions of logical design to physical design.
• Performing Users change requests and resolve application team’s database related issues.
• Production environment monitoring using monitoring tools omegamon, DB2TOP, Topas, NMON, foglight, BSM etc.
• Database installations, upgrades, apply patches on single partition and DPF databases, pure scale installation, Table partition, and compression.
• Involve in Disaster Recovery (DR) testing.
• Executing database utilities Bind/Rebind/explain/Backup/restore/export/import/db2look/REORG/UNLOAD/ LOAD/recovery etc.
• In-house created health check scripts and jobs, database related alerts.
• Storage monitoring and take preventive actions.
• Create in-house maintenance jobs (shell/Perl//Power shell scripting) and Standard operating procedures.
• Experience in creating standard operation procedures (SOP) and run book documentation for DBA team reference.
• 24x7 on-call support and alert monitoring.
• Perform basic tasks on oracle and SQL server’s databases.

DB2 UDB DBA

Responsibilities

• Apply DB object changes; perform database refresh and data movement.
• Monitoring of Production environment using monitoring tools Quest spotlight, DB2TOP and Topas.
• Performance tuning of DB2 SQL’s.
• Performing Users change requests.
• Executing Database utilities Backup/restore/export/import of data etc.
• Co-ordinate with application teams and helps them in writing SQL’s.
• Monitoring of storage and perform other heath checks.
• Involve in database upgrades, on-call production support etc.
• Create in-house maintenance jobs for alerting and reporting purposes.
• Involve in other application designs which access database.

DB2 DBA

Responsibilities

• DB2 Database design and manipulations.
• Database refresh from Prod to TEST/QA regions and data movement.
• Monitoring of Production environment using monitoring tool Omegamon XE for DB2 PM.
• Performance tuning of DB2 SQL’s.
• Performing Users change requests.
• Resolving of production job failures/on call support.
• Executing Database utilities like Copy/Reorg etc.
• Co-ordinate with application teams and fixing of testing errors.
• Monitoring of storage/DB2 Object extents and take action accordingly.
• Performing yearly activities like Data purge/Archival etc.

DB2 DBA 

Responsibilities

• DB2 objects design and manipulations.
• Movement of DB2 object from one environment to others, Copy of data to test regions etc.
• Monitoring of Production environment.
• Performance tuning of DB2 SQL’s.
• Executing Database utilities like Copy reorg etc.
• Test environment setup and fixing of testing errors.
• Co-ordinate with ADABAS and UDB DBA’s and perform basic DBA tasks in ADABAS and UDB.

Confidential,Norwich, U.K

DB2 

Responsibilities

• DB2 object creations and alterations.
• Cloning of DB2 objects from Test Environment to User and Production regions using platinum tools.
• Monitoring of Production environment using Insight for DB2.
• Performance tuning of DB2 SQL’s using Insight for DB2.
• Granting Access to users as per Project standards.
• Performing Users change request.
• Resolving Daily, Weekly DB2 job failures.
• Performing DB2 utilities like Image copy, Reorg, Runstats etc.,
• Fixing of DB2 errors in Application Jobs.

DB2 

Responsibilities

• DB2 object manipulations and Cloning of DB2 objects using Object compare tools.
• Backup and recovery of DB2 objects.
• Data movement from Production to Test and Staging using Unload and Load utilities.
• Refreshing of Test and Staging data with production data using DB2 offline utilities DSN1COPY.
• Granting Access to users and revoking.
• Creation of DCLGEN and altering tablespaces before it reaches its Max. Extents.
• Preparing Database maintenance jobs, Scheduling, Monitoring and Restarting.
• Resolving DB2 job failures.
• Preparation of daily, weekly DB2 job failures report and Discussions.