DB2 DBA, Shell scripting
Resume:
Kotaiah
+1-817-***-**** **********@*****.***
Career Summary:
Around 3 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.
Knowledge in Unix Shell Scripting
Installed and supported DB2 software in both partitioned and non-partitioned environments
Configured DBM and DB parameters, applied Patches and performed Upgrades in various environments; ensured appropriate Quality analysis was performed to ensure no issues.
Created Instances, Databases and Ddatabase objects as per Organizational standards and requirements
Catalogdatabases and installed DB2 on clients and created various client instances.
Experienced in incident, process and change management as per ITIL process
Involved in planning and scheduling Backups to disks, TSM and hp data protector tools.
Well versed with full databases, Incremental, delta and tablespace level backup in both online and offline modes
Well versed also with Recovery of databases 1in different forms of restores; performed redirected and tablespace level restores to recover accidental delete of data refresh across environments; roll forwarding
Knowledge in MongoDB.
Ensured proper Backup and Recovery mechanisms are in place by maintaining DB2 backup image copies for Recovery.
Implemented DB2 HADR, configured appropriate monitoring, performed Disaster recovery tests to ensure DB is fault tolerant.
Performed data maintenance using Reorgchk, Reorg, Runstats and db2rbind,
Expert in handling Data movement utilities like Load, Import and Export in moving data.
Good at performance tuning, monitoring and troubleshooting databases using db2diag, db2pd, db2top, snapshot and event monitoring and with custom Shell scripts.
Implementation of DB2 security, Locking and Concurrency Control with appropriate monitoring in place.
Worked closely with various teams to resolve database issues to ensure good availability and performance of databases
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.
Worked in 24x7, Sun and Offshore Onsite model and participated in rotational on call support
Wiling to relocate and willing to travel anywhere.
Technical skills:
RDMS
DB2 LUW UDB on 9.x and 10.x, SQL server and oracle
Database Tools
Erwin, Optim performance Manager, DB2 performance expert, DProp, DB2 connect and Quest tools, Change data Capture(CDC), Rational Data architect, DB2 Governer, DB2 replication tools, ER/studio, TSM, NetBackup, DB2Query patroller, DB2 federation, Veritas, db2top and db2pd.
Application server:
WebSphere, WebLogic, JBoss
Operating systems:
Linux (RED HAT and SUSE), Unix (AIX and SOLARIS), Windows.
Project experience
Title:
DeviseSoft
Role:
DB2 DBA
Environment:
DB2 V10.5 FP7. 1V9.7 FP 10, Sun Solaris, AIX P6, Linux, Oracle, IBM Data Stage and Netezza
Duration
Feb 2016 to till date
Location
Roswell, GA
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.7 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 iOS tat) 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 analyzing 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.
Analyzing 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.
Title
Datalogic Technologies Pvt.Ltd
Role
DB2 DBA
Environment
Windows 7, Windows 2008, DB2 UDB v 9.5 to v 9.7., AIX
Duration
Feb 2013-July 2015
Location
Mumbai, India
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 modeling including Star Schemas and data marts using data
Monitor CPU, Memory, Paging space, Disk I/O and analyze 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, tablespace, 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.
Contact this candidate