SAI YERAMAKA

Email:acxfl5@r.postjobfree.com

Phone: 216-***-****

DBA experience Summary:

Rich experience with DB2 UDB 9.1, 9.5, 9.7 and 10.5 Installations, Configurations and

Administration with strong database programming skills.

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

Good Experience on Restore the Backup images using Redirect Restore method from source

server to destination server.

Expertise in applying PATCHES (Fix Packs) on db2 servers.

Good experience on HADR setup lying between primary and standby servers.

Expertise in version migration from lower to higher versions.

Good knowledge on preparing purging policies and backup policies.

Scheduling database backups in Backup scripts using Cron Jobs and Scheduled Jobs..

Expertise in creating Instances, DB2 databases, bufferpools, Tablespaces as per client

requirement.

Good experience on monitoring archive mount points and data mount points and temp utilization.

Expertise in running REORG and RUNSTATS for better performance of the database.

Expertise in scheduling compressions on big tables and monitoring the reorgs and runstats.

Good experience on maintaining Database Level (DB CFG) and Database Manager Level

(Instance) Parameters.

Experience in design and maintenance of databases, performance tuning and troubleshooting.

Highly motivated team player with strong communication, analytical and interpersonal skills.

Capacity planning, reclaiming unused space.

TECHNICAL SKILLS:

OPERATING SYSTEMS AIX, Linux, Windows NT server, Sun Solaris

C, C++, VC++, SQL, PL/SQL

LANGUAGES

SCRIPTING Shell script

DB2(UDB 8.1 to 10.5)

DATABASES

HIGH AVAILABILITY SOLUTION HADR

Page 1 of 6

GUI DB2 Control center, Autosys, DB Artisan, Rapid Sql, Ignite,

CDC Console Management, Clear Case

TICKETING TOOL IBM Maximo, Citrix, BMC remedy tool, Service now

Insurance, Banking, Financial

DOMAIN KNOWLEDGE

PROFESSIONAL EXPERIENCE:

Client: All State Insurance Company, Chicago IL Feb' 15 to till Date

Role: UDB DB2 DBA

My Responsibilities:

Understand requirement of new project and estimate project duration and deliver it on time

Understand and execute new requirement on existing environment.

Work proactively to gauge the performance of the application & database and provide

recommendations to achieve the optimal architecture.

Maintain standard procedural documentation related to all aspects of operating the database

platforms.

Document known errors or workarounds in the shared Knowledge Base.

Work on different kind of issue raised by user.

Work on different JIRA request and insure timely completion of it.

Work on different issue related to Q replication.

Setup Q replication between different environments.

Onboard system/environment in different tools.

Create and Schedule automated scripts

Support different maintenance or environmental activity.

Environment: DB2 UDB LUW EE/EEE(DPF) V9.7 FP8, V10.1, AIX 5.3/6.1,Zlinux, Linux, Java,

WebSphere 6.1, putty.

Page 2 of 6

Client: Chrysler Group LLC

Role: UDB DB2 DBA Dec13jan15

Roles & Responsibilities:

Daily management, maintenance, monitoring, tuning and support for DB2 v9.0 and V9.5 databases in

UNIX environment (RHEL 5.0) and windows platforms.

Perform database software installations including database creation, configuration and applying fix

packs.

Responsible for application SQL Query tuning, database parameter tuning, operating system tuning,

memory tuning.

Database Backup/Recovery on databases and file system backups. Redirect Restore to move

application from Development, QA and Production.

Implement and test HADR performance for production environments.

Efficiently carried out DBA responsibilities in planning DB2 version migration activities, in migration

phases and in performing post migration tasks

Daily and weekly database Maintenance and data movement activities such as backup, reorgchk, reorg,

run stats, export, import, load and all related activities for OLTP database.

Provide oncall support in adherence to specific business and customer Service Level Agreements.

Environment: DB2 UDB V9.0/V9.5, RHEL V5.0, Putty

PNC Bank, Ohio, USA

Role: DB2 UDB DBA Oct 12 Nov13

Roles & Responsibilities:

Expertise in development support activities including installation, configuration and successful

deployment of changes across all environments

Made recommendations to the managers on what hardware and software to purchase

Implemented Database partitioning and Archival logging in DB2 UDB

Worked on fix pack installation as well as version upgrades

Created databases and instances in DB2 UDB

Instituted new data definitions for system enhancements

Developed and maintained compliance to database standards and procedures

Understanding of database access and ability to assist developers in implementing efficient SQL code

Perform file system copy from production to nonproduction using TSM backup and

recovering DB2databases in nonproduction environment

Database sizing, Table space Management, Transaction Management and Security Administration

Establish standards, controls, and procedures to ensure data integrity and security

Responsibilities include disaster recovery, capacity planning and Real Time monitoring, troubleshooting

Page 3 of 6

and proactive maintenance

Helped developers in adhoc reports

Strong in performance monitoring and filetuning of database for optimal performance of SQL queries

using visual explain

Provide assistance to the development team on performance tuning, resolving locking solutions, assist

data modeler with SQL scripts

Data maintenance utilities used REORGCHK, REORG, RUNSTATS, BACKUP, RECOVER/RESTORE,

LOAD, QUIESCE, IMPORT, EXPORT, DB2LOOK, IMPORT and INGEST

Performed routine maintenance, database performance tuning and monitoring

DB2Look utility is used to find all DDL and DML commands in the databases

Snapshot monitoring was done to detect deadlocks, buffer pools and lock escalations

Involved in writing scripts to trouble shoot triggers and stored procedures

Offshore coordination, work allocation, monitoring junior DBA's and work review etc

Provided production support for critical applications running on 24/7 basis

Duties included being oncall during the weekends, setting up restores, performing backups and creating

new tables, table spaces, buffer pools, etc.

Environment: DB2 UDB EE V 8.1 fp14, V 9.5 fp1, V9.7 FP1, AIX (5.3), Solaris 10, Java,

WebSphere 5.1.

Client: State Bank of India, Pune India Sep'10Aug'12

Role: UDB DB2 DBA

Roles & Responsibilities:

24x7 Production Support.

DB2 Installation on severs and upgradation.

Monitoring the database on Partitioned and nonpartition Environment

Participated in restructuring of Multipartition environment.

Solving Tickets Related to Any DB issue.

Conversion of tablespace storage type.

Used db2 governer and query patroller.

Deadlock detection and troubleshooting.

Page 4 of 6

Using db2top in efficient way.

Implementation of HADR

Write script to automate the regular activities, Reorg, Runstats, backup.

Automated regular monitoring like tablespace monitoring, memory, mount points, HADR

Interact with business team and development teams for new functionality and requirement.

Perform restore on different situation depending upon requirement

Apply fix pack on HADR, HACMP environment and troubleshooting.

Purging activity as per application team requirement.

Environment: DB2 UDB EE V 8.1 fp12, V 9.5 fp1, AIX (5.3), Solaris 9, NetBackup, Java,

WebSphere 6.0.

Client: CSCChennai, Tamil Nadu, INDIA

Role: UDB DB2 DBA June'08 Aug'10

Roles & Responsibilities:

24x7 Production Support.

Involved in database installation.

Handling DBA Tickets.

Fix pack installation.

Database, tablespace and DB objects creation and maintenance

Analyze and implement DB2 Reorg utility based on the need for database reorganization

SQL Analysis and optimization.

Monitor DB2 UDB databases for space utilization and performance degradation and tune

as needed.

Monitoring Backup, Roll forward, etc.

Determine need for DB2 UDB utilities and implement to enhance performance.

Backup and Recovery Procedures planning and implementation.

Performance tuning.

Migration from DB2 V8 to DB2 V9.

Daily / weekly /Monthly DBA maintenance tasks.

Environment: DB2 UDB EE V 8.1 fp12, V 9.0 fp1, AIX (5.3), NetBackup, Java, WebSphere.

Page 5 of 6

EDUCATION:

Bachelor of Technology, 2008, JNTU, India.

Page 6 of 6

Contact this candidate