SUMMARY

• Total 10+ years of professional experience as a Database Administrator. Experience on DB2 UDB ESE on AIX, Windows and Linux.
• Teradata V15.0. Krishna has worked on DB2 PURE SCALE, Teradata V15.0, DB2 UDB V10 DPF (Data Partition Feature with Table Compression).
• He possesses strong troubleshooting and user interface capabilities with excellent communication skills.
• Expertise in Database design and analysis with an expertise in Teradata V15.0, DB2 - UDB V11.1 Administration.
• Industry experience is varied and includes financial, manufacturing, government, insurance and healthcare.

TECHNICAL SKILLS

RDBMS: DB2 UDB V11.0, DB2 PURE SCALE, Teradata V14.0/V15.0

Operating Systems: UNIX (RS-6000, Z/OS, SUN-SOLARIS, HP-UNIX, AIX, LINUX WINDOWS NT/ 2000/XP

Languages: Korn-Shell, JCL, SQL

PROFESSIONAL EXPERIENCE

Confidential, West Chester, PA

Database Administrator DB2

Responsibilities:

• Worked on database performance analysis and optimized different queries running against the database.
• Worked on database configuration parameters and database manager configuration parameters at database level and instance level.
• Took snapshot for locks, databases, applications and database configuration parameters
• Maintained the database consistency against the multiplatform applications, like Java, under multi-tier environment. Monitored growth of table size in regular intervals by running reorg chk and run stats. Analyzed table/group functions.
• Made the database competent enough to handle the maximum number of requests
• Set the cron-jobs for backup and updating processes
• Installed the client and server software for various workstations and servers
• Worked with Nagios Monitoring tool for automation of Database Monitoring
• Worked on Creating Databases, User Roles and Profiles,
• Reviewing the BTEQ Code for Primary Index, Stats,
• Check Data Skew on Primary Index,
• Performance tuning by optimizing database sql
• for the daily batch runs
• Query Grid to move the data across multiple environments
• Presto tool to query the data from Teradata and Hive
• Database connection from Tableau. Teradata SQL Assistant
• Worked with TAYS Support for Teradata Upgrades

Confidential, Roanoke VA

Database Administrator

Responsibilities:

• Steady State Maintenance, DDL Updates in Development and Production, Scripts to automated export and Load to Tables
• Install and configure new DB2 Environment and apply fix pack upgrades and migrate to DB2 Versions
• Work with Development Team to Resolve long running sql’s and monitoring using db2pd, db2top and DB2 Buffer pool usage
• Following the change management process for Production updates KPI’s updated with growth of the database create new databases tables and table spaces and Open PMR’s with Confidential to resolve the root cause issues
• Database is Partitioned at 4 Physical Nodes for SMP Architecture for High Performance and Scalability
• Worked with Users Roles and Profiles,
• Worked with session and accounts Managing Space,
• Managing Database Resources, Archiving, restoring data using Teradata BAR Server Maintaining Database, Managing Queries Tracking Query Behavior with Query Logging,
• Setting up Administrative Environment and Trouble Shooting and On Call Support for Production Environment
• Worked with Teradata Utilities BTEQ, TPT For Data Load and Exports
• Setting up Administrative Environment and Trouble Shooting and On Call Support for Production Environment
• Monitoring Database Resources using Viewpoint, Query Monitor for High CPU Usage queries
• Production on Call Support for OLTP applications and EDW Applications

Confidential

Responsibilities:

• Worked on Q-Replication for having Active-Active Database using Capture and Apply Process
• Worked on DB2 Clustering using Windows MSCS and HADR Setup
• Worked on Migration of Databases from V8.2 to V9.5, V10.1 on Linux, AIX and Windows
• Worked on DB2 HACMP; HADR and Windows DB2 UDB Clustering
• Installed DB2 UDB ESE 8.2 /V9.5/V10.1 and DB2 Fix pack updates on AIX, Windows, Linux servers,
• Worked on DPF (Data Partition Feature) for a Commercial Bank Data warehouse environment for 100 GB Table where Table has been set for Data compression with Alter statement and Table Partition by Date Range into Multiple Table spaces where we can attach and detach partition for performance
• Worked on DB2 Security, Assistance for BIND Problems
• Assistance to end users SQL requests
• Worked on Database Performance during testing and Production operations, coordinates and implemented database sizing, restructures and index rebuilds assists with capacity planning (KPI) for future database growth, documented KPI’s and procedures needed to optimize performance
• Installed Patches, Upgrades, Supported DB2 in all environments
• Assisted application development and maintenance staff with database issues
• Implemented database strategies and procedures for physical disaster/recovery and contingency planning and implemented mechanisms to restore the production databases in development environments for testing and UAT
• Provided problem resolution support to production issues and on call support
• Worked on creating the Databases, Table spaces, Buffer pools, Database Configuration settings
• Created databases on various nodes AIX and Windows
• Involved in Physical and Disk Allocation design of the Databases
• Granted various authorizations to different users/groups
• Tuned the DB2 UDB system for better performance with Performance Variables in db cfg and Buffer Pool Allocations with snapshots across the database and locks
• Administered Databases, Table spaces, Indexes and Tables on various servers
• Configured DB2 environment on Multiple Environments Windows, Aix and Linux
• Implemented HADR on Production Servers running DB2 UDB v8.2
• Involved in Production Planning, Performance Tuning of the sql, database cfg and dbm cfg
• Supporting 24/7 support to the production environment.
• Worked with Database connectivity to Web sphere application server, Java application tier
• Worked with application team for fine tuning the sql’s, index creation, db2advis, Explain plans
• Shell scripts for automation of the snapshot for database, buffer pools, dynamic sql’s and fine tuning the database configuration parameters and registry variables
• Scripts for the automation of the database online backups, run stats and reorgs
• Having extensive experience with import, load and export scripts
• Created DMS Table Spaces, Buffer pools for data caching which increases performance of the database