Database Administrator

Sandeep

Mobile: 469-***-****

Email: *****@******************.***

Professional Summary:

Around 8 years of IT experience as DB2 for Linux, UNIX and Windows (LUW) Database Administrator with exclusive experience administering, managing and maintaining DB2 LUW installations in v9.x and 10.x in Production and Non-Production environments.

Installed and supported DB2 software and fix packs in both Partitioned and Non-Partitioned environments

Knowledge in Unix Shell scripting.

Configured DBM and DB parameters, applied Patches and performed Upgrades in various environments; ensured appropriate Quality analysis was performed to ensure no issues.

Experienced in Incident, Problem and Change Management as per ITIL process

Ensured proper Backup and Recovery mechanisms are in place by maintaining DB2 backup image copies for Recovery.

Involved in planning and scheduling Backups to disks, TSM and hp data protector tools

Well versed with full database, Incremental, Delta and Table space level backup in both online and offline modes, Recovery of databases in different forms of Restores; performed Redirected and Table space level restores to recover accidental delete of Data and to perform data refresh across environments; Roll forwarding databases

Performed data maintenance using Reorgchk, Reorg, Runstats anddb2rbind,

Implemented DB2HADR, configured appropriate monitoring, performed Disaster recovery tests to ensure DB is fault tolerant.

Expert in handling Data movement utilities like Load, Import and Export in moving data

Created Instances, Databases and Database objects as per Organizational standards and requirements

Worked closely with various teams to resolve database issues to ensure good availability and performance of databases

Good at performance tuning, monitoring and troubleshooting databases using db2diag, db2pd, db2top, snapshot and event monitoring and with custom Shell scripts.

Catalog databases and installedDB2 on clients and created various client instances.

Implementation of DB2 security, Locking and Concurrency Control with appropriate monitoring in place.

Familiar with SOX, PCI and HIPAA policies and guidelines

Strong collaboration, Team building, interpersonal, and good at grasping modern technology concepts and utilizing the same.

Experience working on Waterfall and Agile Methodologies - Scrum.

Technical Skills:

RDBMS DB2 UDB LUW on 8.x,9.x and 10.x, SQL server and ORACLE

Database tools Erwin, ER/studio, Change Data Capture (CDC), Optim Performance Manger, Rational data architect, DB2 performance expert, DB2 Governer, DProp, DB2 replication center, DB2 Connect and Quest Tools, TSM, DB2 Query Patroller, Veritas Net Backup, DB2 federation, db2top and db2pd

Application Server WebSphere, WebLogic, JBoss.

Operating Systems Linux (RED Hat and SUSE), Unix (AIX and SunOS), Windows

Education:

• Master’s in Industrial Management

California State University LA, California, USA.

• Bachelor of Science in Civil Engineering

Jawaharlal Nehru Technology University, INDIA.

Professional Experience:

Client: Kroger – Nashville, TN. Oct 2018 – Till date

Role: Sr. Database Administrator / DB2 DBA

Responsibilities:

Designed logical and physical databases and database objects for DB2 UDB on Development, Test and Production environments.

Involved in HADR set up. Developed SOPs for database backup and recovery strategy and Disaster recovery strategy.

Installed DB2 9.7, 10.1 and Fix Packs; upgraded from version 9.1 to 10.1

Wrote several scripts to monitor and resolve any issues related to the input files for the 24/7 loads

Performed database system performance tuning by using Snapshot, Event Monitor, and OS commands (vmstat and iostat) and updating DB and DBM configuration parameters.

Used db2look, and import/export utilities to move structure and data between databases.

Performed SQL statement performance tuning by using Explain Plain, db2exfmt, and db2expln tools, and running the reorgchk, reorg, runstats and db2rbind commands.

Implemented High Availability Disaster Recovery (HADR) on PROD and QA DB system.

Strong understanding of database shared memory parameters and tuning memory parameters in db and dbmcfg.

Coordinating with the core development team for coding static PL/SQL stored procedures.

Coordinated with application team for SQL Optimization, SQL Analysis and Streamlining. Has experience working and analysing with SQL Visual Explains output.

Maintained Shell Scripts for Monitoring Databases.

User creation and providing necessary Roles, Privileges and quota as per the requirements

Wrote shell scripts in Unix (AIX/Solaris/HP) with a good understanding of UNIX servers and architecture

Created snapshot monitors and event monitors to regularly check the health of the system

Overseeing the daily data feeds and load process and weekly full load of the data, worked with data export, import and load utilities.

Actively involved in figuring out the qualifying problems for IBM PMR, following up with the vendors and the teams involved.

Analysing buffer pool usage, catalog stats, objects design and providing suggestion to improve the performance as the part of daily activities.

Identifying the root cause for performance bottlenecks and providing the solution in the effective way.

Generated various performance reports like SQL base comparison report etc. using OPM tool.

Creation of Maintenance plan, Scheduled Jobs for backups.

Perform AUDIT on the Databases to give users bare minimum privileges on the Database and Database objects.

Involved in writing of SQL queries for posting and retrieving of data from database.

Involved in reducing HWM and free the space and add it to the File System.

Participation in large-scale Data Warehouse development projects and knowledge in DB2 DPF.

Supported project releases in production and lower environments.

Environment: Db2 LUW on 11.1, 10.x and 9.x, AIX, SunOS, Linux

Client: CVS - Woonsocket, RI. Nov 2017 – Sep 2018

Role: Database Administrator

Responsibilities:

Involved in DB2 UDB support, Physical Database design, installations, security, integrity, Backup & Recovery.

Migrated many databases from V9.1 FP5 to V9.7 FP3a (DPF), V9.7 FP8 to V10.1 (DPF).

Managing project transition, client handling, POC, Training and setting up DBA team for DB2 with Teradata.

Provided DBA support for various applications on AIX and Linux.

Designed and implemented the test cases for capacity testing.

Tuned DBM, DB Configuration parameters and Registry variables for optimal database performance.

Involved in database sizing estimates for the new projects in pipeline.

Extensively worked with designing and developing optimal process for data extraction, transformation, loading, integrating data in warehouse Environment.

Provide database size estimates at each stage of implementations and suggest solutions for optimizing ETL(Ab Initio) process.

Extensively involved in data maintenance activities like REORG, RUNSTATS, LOAD, INGEST, IMPORT and EXPORT.

Wrote many korn shell scripts for automating many manual tasks.

Migrated the databases from existing IBM P 570 Servers to IBM P 770 Servers.

Worked with the SAN administrators to design the physical storage.

Worked closely with Application teams in tuning SQL queries performing badly in terms of elapsed time and CPU and also implemented MQT's, Replicated MQT's, Statistical Views, created appropriate indexes and thus improved the performance of the queries.

Created V9.7 Locking event Monitors for analysis of Lock-waits and deadlocks.

Extensively used query tuning related tools like db2exfmt, db2advis and db2batch for improving query performance.

Worked on Attaching and detaching table partitions for Range Partitioned tables.

Implemented DDL and DML changes in the database using new features of V9.5/V9.7/V10.1.

Worked with ETL teams to develop the patterns for data movements and loading data into Data warehouse environments.

Migrated databases from one data centre to another data centre using redirected restores.

Developed and documented configuration best practices, create and maintain solution documentation.

Created and documented test procedures and scenarios for the pre-UAT phases. And supported

Operational teams during the UAT and rollout phases.

Environment: Linux, Db2 on LUW, Oracle, WAS, MQ

Client: Anthem – Norfolk, VA Mar 2016 – Nov 2017

Role: Database Administrator

Responsibilities:

Responsible to provide on-call support on 24*7 basis with rotating basis to keep the system running smooth and handle any problems very efficiently.

Instance and database creation and configuration on partition database servers in LUW environment.

Creating node groups and assign them for creating partition tables spaces

Monitoring and handling table space and file systems space issues

Monitoring locks & Deadlocks and identified application’s deadlocks and resolve them.

Moving databases for various environments using utilities like db2move.

Scheduling and monitoring regular dba jobs and job logs in LUW environment.

Done large implementations of OLAP environments using DB2 DWE, to facilitate report generation of DB2queries for the Business Intelligence teams.

Involved in designing data warehouse, data modelling including Star Schemas and data marts using data

Monitor CPU, Memory, Paging space, Disk I/O and analyse those using topas, nmon and other tools.

Applying Fix packs to keep DB2 at the most current level.

Extensively used different Data movement utilities like IMPORT, EXPORT, and LOAD utilities to load data.

Performed Reorgchk, Reorg, Runstats and rebind as and when necessary to eliminate the defragmentation.

Configured LDAP for authentication on various environments.

Opened several SEV1 PMRs with IBM to troubleshoot and resolve critical issues.

Performed backups with online full, table space, incremental and delta backups

Worked on restores and roll forward restores including redirect restores.

Set up DB2 Backup to Tivoli Storage manager (TSM)

Tuned databases using IBM Tools like snapshot monitor, db2exfmt, db2expln, Index Advisor and problem diagnosis

Worked closely with application team for resolving database access issues.

Configuring and Monitoring the HADR setup on the database servers.

Setting propagation from source databases to target databases

Monitoring the capture process at source servers and Apply process at target servers.

Creating and Monitoring Users, authorities and responsibilities and password management

Tuned application, database and system for best performance

Environment: Db2 on LUW, Oracle, WAS, AIX and Linux

Client: Indi Technology - India. Apr 2012 – Aug 2015

Role: Database Admin

Responsibilities:

Created new databases, database objects and users.

Exposure to DB2 UDB 9x installation, configuration and administration on LUW machines

Experience in Migration and Up-gradation (Fix Packs) on existing database servers.

Maintaining DMS Table-space spaces, tables in DB2 databases running on Unix/Windows platforms

Implemented Backup and Recovery strategies.

Restoring the database from one Linux server to another using Redirect Restore method.

Worked with export, import, load utilities to manage table data.

Expertise in using DB2 Movement Utilities like Export, Import, DB2Move and DB2look.

Expertise in getting entire DDL’s for a database using db2look and creating those objects structure in Target database based on the DDL script.

Hands on experience in cataloguing the Data Bases.

Experience in using DB2 Maintenance Utilities like (Reorgchk /Reorgs/Runstats).

SQL Query Tuning using db2advisor, db2explain.

Troubleshooting database issues using db2diag, db2pd, db2dart, db2top, Snapshots and event monitors.

Acquired knowledge on moving entire database objects from Source database to Target database using db2move and redirected restore.

Primary Knowledge on HADR (High Availability Disaster Recovery).

Good knowledge on Incident / Problem and Change management process.

If problem occurs then reporting issues to IBM and closing PMR.

Generating DDL statements to database objects and moving database objects from test to production environments using DB2move.

Environment: DB2 UDB V10.x &V9.x, WAS, AIX and Linux

Contact this candidate