SUMMARY:

• Almost 7 years of professional and progressive experience in IBM DB2 UDB with emphasis on Database Administration, development, migration, Business Requirement Analysis, Application design, testing, implementation and production support of critical OLTP, OLAP and Data warehouse environments.
• Expertise in development support activities including installation, configuration and successful deployment of changes across all environments.
• Data Analysis, Normalization, Data warehousing, Data Cleansing, Data Modeling, Data Mapping, Erwin 3.0 in OLTP & OLAP environments.
• Extensive experience in logical and physical design of databases, performance tuning, database utilities, backup and recovery strategies, capacity planning, high availability, disaster recovery, database monitoring, troubleshooting, change and problem management and production support on 24/7 basis.
• Expertise in collecting, analyzing and performing system level tuning of databases.
• Expertise in Deep Compression and Table Partitioning.
• Experience in resolving various database issues and bottlenecks by working directly with DB2 Development team.
• Extensive experience with Incident, Problem and Change managements.
• Excellent analytical and functional skills with strong communication and interpersonal skills. Actively involved in the full project life cycle, user requirements to implementation. Willing to learn and adapt to new challenges.

TECHNICAL SKILLS:

RDBMS: DB2 LUW V11.1, V10.5, V10.1, SQL Server, Oracle, MS Access.

Database Tools: DB2 Connect, IBM Data Server client, IBM Infosphere Guardium, IBM Database Server Manage, TOAD for DB2 (Dell/Quest), Foglight Performance Analysis, Spotlight, SQL Optimizer (Dell/Quest) IBM Data studio, ERStudio, Quest Tools, db2top, db2fodc, db2dart, db2mon, db2pd, db2expln, db2exfmt, db2trc, db2mtrk, db2diag, nmon analyzer, svmon, VERITAS NetBackup, BMC Patrol, Erwin, Power Designer, DB Artisan, TSM and VERITAS,XManager.

Operating System: IBM Pure App, AIX 7.2/6.1/5.3/5. x/4.3.x, Solaris 8/9/10, RH Linux Advanced Server 2.1, 3.0, Windows 2000/2003/2008 NT 4.0, Windows 95.

Programming and Scripting Languages: Shell Scripting, Perl Scripting, AWK, SED, SQL, Visual Basic, C, C+.

Other Skills: VMWARE Server/Workstation, Web sites Development, Unix Shell scripting.

PROFESSIONAL EXPERIENCE:

Confidential

DB2 Database Administrator

Responsibilities:

• Has overall responsibility for all DB2 products in production, dev and test environments. These include the DB2 software itself, monitoring tools.
• Installation and configuration of the new DB2 11.1, 10.5, 10.1 and 9.7 on Pure Scale and standalone Production environments.
• Monitoring DB2 24x7 production servers for potential problems.
• Taking offline/Online backup and restore on Pure Scale and standard environments.
• Implementing and managing Pure Scale and HADR on production and test environments along with IBM Infosphere Guardium.
• Applying upgrades along with Business System Services to DB2 in test and production.
• Along with Business Systems Services, installs and maintains software used for supporting and monitoring DB2.
• Occasionally performing BLOB offload on PROD and non - PROD databases.
• Actively working and monitoring Q replication on PROD databases and performing Cold start whenever required on PROD and non-PROD environments.
• Using IBM Database Server Manager, monitoring databases health check and performing Administration tasks.
• Used Utilities like DB2look, DB2top, load, Export, Import, Runstats, Reorg.
• Assisting all development work on DB2. This includes helping with application development, designing and creating database objects, migrating from test to production, and implementing batch schedules with the appropriate DB2 utilities.
• Developed and documented overall vision for DB2 in our environment.
• Provided information to developers and operators on all components of DB2 that are of interest through the Web, Infospheres etc.
• Serve as an overall DB2 resource and keep abreast of new developments in the DB2 world through journals, newsgroups, the Web, and the DB2 Users Group.
• Tickets handling based upon the Priority (Like High, Medium, Low).
• Proficient in performance tuning using Data Studio, DB2TOP, DB2PD, IDSM, Monitor Traces etc.

ENVIRONMENT: IBM DB2 11.1,10.1,9.7, Pure Scale, HADR, Solaris10, AIX, Linux, IBM P795 Servers.

Confidential, Chandler, AZ

DB2 UDB DBA

Responsibilities:

• Primarily involved in providing production support of DB2 UDB databases on AIX and Linux servers.
• Created and maintained instances and databases in development, test and productionenvironments.
• Migrating instances and database servers from V10.5 to V11.1.
• Created multiple buffer pools for optimal performance and allocation of resources.
• Implemented automated backups, Space monitoring, moving db2diag.logs, monitoring size of tablespaces by setting up a threshold.
• Running the REORGCHK, REORG and RUNSTATS utilities to reduce disk fragmentation and improve Performance.
• Worked on apply and implement of the DATA DISTRIBUTION STRATEGIES.
• Experience in data processing and data modeling.
• Worked on performance tuning and measurements.
• Knowledge on data management software section setting up Q Replication between DB2 UDB on AIX and DB2 UDB on LINUX.
• Setting up an HA or Active-Active solution.
• Involved in building databases on fail over servers using redirected restore.
• Applying Fix packs to keep DB2 at the most current level.
• Setting up High Availability Disaster Recovery (HADR) and involved in testing fail over scenario.
• Involved in Importing and Exporting data and database structure using db2look and db2move Utilities.
• Opened several SEV1 PMRs with IBM to troubleshoot and resolve critical issues.
• Monitored database performance and work with senior peers to determine corrective actions.
• Granted various authorizations to different users and groups.
• Worked with different GUI tools like db2mon.control center, command center, replication center, and client configuration assistant tools.
• Worked on IBM DB2 utilities like Runstats, Reorgchk and Reorg.
• Involved in Performance tuning & Query optimization.
• Performed high-speed bulk data loads using DB2 load utility.
• Interacted with the customers and gathered the requirements and analyzed the data for theapplication.
• Provided 24x7 On Call Production Support.

ENVIRONMENT: DB2 ESE 11.1/10.5/10.1, DB2 UDB DPF 9.5/9.1, SAN Media Server, HADR, TSAMPWebSphere Federation Server V9.5, DB2 Connect, BMC Patrol, NAS, Informatica.

Confidential

Database administrator

Responsibilities:

• Installed third party software.
• Responsible for identifying potential bottlenecks and correct database problems.
• Applies upgrades along with Business System Services to DB2 in test and production.
• Instance Creation and maintenance. Database creation, Maintenance of the Databases.
• Cataloging Databases on various nodes.
• Performance and tuning of DB2 systems and SQL.
• Worked on export, import, load and db2look utilities.
• Performed Reorg, Runstats when necessary to eliminate defragmentation, Setup the disaster recovery for DB2.
• Worked on DB2 Data Warehouse.
• Provided Support for application developers by providing SQL, testing SQL’s, Troubleshooting application problems.
• Handling table space and file systems space issues.
• Provide troubleshooting and problem solving on critical issues Worked on end-to-end storage stack, including host servers and the software defined storage product.
• Experience in-depth analysis of storage product field issues having data unavailability and/or data loss.
• Resolve any database issues in accurate and timely fashion.
• Monitor databases regularly to check for any errors such as existing locks and failed updates.

ENVIRONMENT: IBM DB2 9.7,10.1, Unix 9,10, Red Hat Linux 5, AIX 5, 6, IBM P795 Servers.