SUMMARY:

IBM DB2 LUW Database administrator with 13.5 years of experience having extensively worked on database designing, data modelling, administration and production support. DBA experience in other databases like Oracle and MS SQL Server.

TECHNICAL SKILLS:

• DB2 LUW Database Administration
• DB2 Install, Upgrade, Configure
• Monitoring and Performance Tuning
• Data Security, Backup & Recovery
• Standby/Failover Administration
• Data Movement Utilities
• Database design and modelling
• Federation and SQL/Q - Replication
• Database Partitioning (DPF)
• DB2 pureScale Administration
• Troubleshooting & Capacity Planning
• Database Auditing
• Database Logging and Compression
• Shell Scripting for DB2 tasks
• Oracle and SQL Server Administration
• SQL Server to DB2 migration

EXPERIENCE:

Confidential, Troy, MI

DB2 Database Administrator

Key Responsibilities:

• Worked as a Level-3 production support DBA on DB2 standard, DPF and pureScale Environments on Linux, AIX and Windows Operating Systems.
• Resolved incidents and requests using HP Service Manager ticketing tool.
• Worked as a product support for IBM Infosphere Information Server repository tool, Data Studio, WinSQL, IBM Installation Manager, WebSphere Application Server.
• Performed Oracle DBA activities like configuring Oracle databases on DB2 server and import database metadata into Infosphere Information Server, database maintenance and change requests on Oracle and DB2 databases.
• Monitored DB2 database health summary and locks using IBM Data Server Manager, IBM Infosphere Optim Performance Manager.
• Installed DB2, upgraded fix packs and configured databases on Linux and Windows.
• Performed database backups and restores to and from TSM and disk.
• Performed space maintenance activities for database logs/archival logs, DB2 backups
• Worked on database partitioning and table partitioning.
• Extensively used utilities like Import, Export, Load, Runstats, Reorg, and Rebind.
• Performed Data Modelling and Database Design.
• Automated jobs using Crontab and shell scripts.
• Performed Database Monitoring using db2pd, MON GET reports, OPM and DSM tools.
• Worked on database performance and SQL tuning using db2exfmt.
• Used DB2 utilities db2move and db2look for movement of data between production and test servers.
• Configured DB2 audit using db2audit utility.
• Implemented standby database for high availability using HADR utility with TSA.
• Configured data compression, DB2 native encryption and self-tuning memory manager.
• Configured Federation between DB2 and Oracle
• Configured SQL Replication between DB2 tables.
• Worked on Q-Rep using WebSphere MQ.
• Regularly checked for software updates/fix packs and end of support on vendor sites.
• Used Agile tool VersionOne (Epic, features and stories) for planning and tracking the work.
• Infrastructure as a Service (IaaS) - Provisioning Linux RHEL virtual servers and creating file systems to install DB2 using puppet code.
• Worked on PMRs with IBM.

Confidential

DB2 Database Administrator

Key Responsibilities:

• Worked as a production support DBA
• Resolve incidents and requests using HP Service Manager ticketing tool
• Database monitoring using snapshot, event and health monitoring
• Worked on database performance and SQL tuning using db2exfmt.
• Performed database backup and redirected restores and Troubleshoot DB2 issues
• Check and validate DB2 backups for disaster recovery
• Monitored database health using IBM Infosphere Optim Performance Manager.
• Used DB2 utilities db2move and db2look for movement of data between production and test servers.
• Execution of standard database utilities like import, export and load
• Suggest DBM and DB parameter changes as necessary to support application needs
• Job scheduling using Crontab

Confidential

Lead DBA

Key Responsibilities:

• Developing and managing database objects
• Develop logical and physical data models
• Interact with subject matter experts to understand information needs and embed into a logical data model.
• Review source systems and business publications to accurately capture new data requirements and integrate them into the logical data model.
• Conduct data model reviews with developers, business analysts and subject matter experts to gain consensus.
• Keep logical and physical models in sync.
• Making table changes in production according to the change requests received
• Write/modify SQL queries to database for data manipulation.
• Database monitoring using snapshot, event and health monitoring
• Performed database backup (incremental and full)/redirected restore procedures, scheduled incremental backups in production
• Store all project documents in Clear Case repository for maintaining version history
• Check and validate DB2 backups for disaster recovery
• Execution of standard database utilities like import, export and load
• Performance tuning using db2explain/db2exfmt.
• Managing restricted access to database
• Apply DBM and DB configuration changes as necessary to support application resource needs
• Implemented standby database for high availability using IBM DB2 UDB - HADR utility
• Job scheduling using Autosys and DB2 task center (Runstats, Reorg & Rebind utilities to enhance application performance)
• Open PMR’s (problem management reporting) and other discussions with IBM to resolve critical issues
• Troubleshoot production DB2 issues and problems (db2diag.log, db2 traces)
• Configured db2audit & analysis of ‘db2audit.log’ for auditing database changes
• Research, test and coordinate DB2 patches/upgrades, 3rd party tools and Interaction with IBM Sales team for software pricing
• Participated in Disaster Recovery drills
• Involved in sales meetings with IBM for pricing of DB2 UDB 9.7 (Enterprise Server Edition).
• Upgraded DB2 databases from version 8.2 to version 9.7.
• Provided DB2 UDB training to team members
• Research, analyze and resolve issues with minimal supervision and escalate issues as appropriate.
• Participate in team and client meetings as requested.

Confidential

DBA/ Developer

Key Responsibilities:

• Preparation of technical specifications
• Performed database backups and restores in DB2
• Creation/modification of stored procedures
• Loading data into Oracle database using SQL*Loader
• Creation of tables, data import/export
• Execution of change requests on Oracle databases
• Coordinating activities with client on a daily basis

Confidential

Developer

Key Responsibilities:

• Analyzed and upgraded the reports from Oracle Applications 11.5.9 to 11.5.10
• Performed testing and review in both Oracle Applications 11.5.9 and in 11.5.10 versions
• Coordinating activities with onsite coordinator and offshore team as offshore team member

Confidential

Database Administrator/Developer

Key Responsibilities:

• Analysis of SQL Server 2000 objects that need to be converted to DB2
• Conversion of tables, functions and store procedures from SQL Server to DB2
• Developing additional stored procedures in DB2
• Compilation and execution of DB2 stored procedures using DB2 development center
• Exporting data from SQL Server and loading into DB2 database
• Testing of DB2 stored procedures to match the outputs as of SQL Server
• Resolving performance issues of DB2 stored procedures and database
• Performing basic administration tasks in DB2 and SQL Server
• Preparing release documents and installation scripts
• Shell scripts for database monitoring and administering activities
• Coordination with onsite team.

Confidential

Software Engineer - Database

Key Responsibilities:

• Installation and configuration of DB2 UDB instances and databases on AIX and Windows
• Logical and Physical database design and implementation.
• Database monitoring and performance tuning
• Database backup to TSM and troubleshooting
• Execution of import/export/load commands
• Execution of database change requests
• Develop logical and physical data models using Erwin
• Prepare data models using MS-Visio 2002, Rational XDE
• Interact with SMEs to understand information needs and embed into logical data model.
• Review source systems and business publications to accurately capture new data requirements and integrate them into the logical data model.
• Conduct data model reviews with developers, business analysts and subject matter experts to gain consensus.
• Keep logical and physical models in sync.
• Database comparison with CDB comparator tool
• Store all project documents in Clear Case repository for maintaining version history
• Implement database security
• Used BMC tools to optimize system performance
• Shell scripts for database monitoring and administering activities
• Compile and execute DB2 stored procedures using DB2 development center