Ramanjaneyulu Email: ramnalluri.db2@gmail.comMobile+91-9643464667

EXPERIENCE SUMMARY

3.8 years of extensive experience as Database Administrator of DB2 UDB, V9.x and V9.7 on Windows, Linux and UNIX servers.

Having experience in Database migration and upgradation across different versions and installation of fix packs.

Instance and database creation and configuration in non-partitioned database servers. Client server communications configuration experience using TCP/IP protocols.

Database utility experience including reorg, runstats, rebind, export, import, load, backup, restore database utilities.

Database backup and recovery experience with online full and incremental backups, transaction log archiving, restore and roll-forward (including redirected restore), and recover database utilities.

Having experience in setup and working with HADR environment. Database backup and recovery experience on both TSM. Instance and database monitoring and tuning experience using the DB2 Health Center, Snapshot

and Event monitors to monitor and optimize instance and database configuration parameters, table spaces, and buffer pools.

Diverse background with good learning skills, analytical abilities and excellent technical skills. Highly motivated and result oriented professional with very strong technical, interpersonal and

communication skills.

ACADEMIC QUALIFICATIONS

(B.Tech) Electronics and Communication Engineering from JNTU Hyderabad.

WORK EXPERIENCE

Infosys Technologies Limited, Feb 2013 – November 2013 CSC India Pvt LTD (DB2 UDB DBA),June 2010 -.January 2013

TECHNICAL SKILLS

Operating System : Windows Server 2003, HP UNIX and LinuxSoftware : DB2 V9.1 and V9.5 for Windows, Linux and UNIXTools : Control Center, DB2 Recovery ExpertLanguages : Shell Scripting

PROJECTS:

MCA21 (Ministry Of Corporate Affairs) Gurgaon, February 2013- Nov 2013 Database Administrator

Description:

It is designed to fully automate all processes related to enforcement and compliance of the legal requirements under the Companies Act. Among others, MCA-21 envisages electronic filing of documents, registration of companies and public access to corporate information online through a secure interactive portal.

Responsibilities:

Database(DB2 UDB) maintenance and support Tuning db and instance level parameters Working heavily on Database restores including redirected restores within production, stage and

development environment as per user request Checking DB performance bottlenecks and fixing the same Using RUNSTATS, REORGCHK and REORG to enhance application performance Database creation as per user request Working on data movement utilities using IMPORT, LOAD, and EXPORT Resolution for the user queries on application errors which are affected Troubleshoot using Snapshots and occasionally using Event monitors on

statement/connection/transaction Table space management – Adding, dropping, extending, reducing and resizing table

space containers. Checking DB performance bottlenecks and fixing the same Involved in 24x7 support and On-call support Instance management – Starting, stopping, creating, dropping instances. Security – Setting authentication, authorization and granting/revoking privileges on

database objects to users/groups.

ORGANIZATION : CSC India Pvt LTD. Hyderabad, June 2010 -.January 2013.

Title : Chrysler DBRM GroupRole : DB2 UDB Database AdministratorEnvironment : DB2 UDB V9.1, v9.5 & v9.7, AIX, Linux,Unix.

Description : Chrysler Group LLC, formed in 2009 from a global strategic alliance with Fiat S.p.a., produces Chrysler, Jeep, Dodge, Ram, SRT, Fiat and Mopar vehicles and products. First established by Walter P. Chrysler in 1925.Headquartered in Auburn Hills, Mich., Chrysler Group’s product lineup features some of the world's most recognizable vehicles, including the Chrysler 300, Jeep Wrangler, Dodge Challenger and Ram 1500. Fiat contributes world-class technology, platforms and power trains for small- and medium-size cars, allowing Chrysler Group to offer an expanded product line including environmentally friendly vehicles. Chrysler is automobile manufacturing company with major Applications runs on UDB DB2.Chrysler had around 310 UDB servers which support Test, Staging and Production environment .It has the data warehouse, OLTP applications running on DB2 databases. It has the databases size ranging up to 600 GB.

Responsibility as a DB2 DBA:

Helped the engineering team in designing the databases. Installed DB2 V9.5 Fixpack 3b on AIX and SUNOS Servers. Working Knowledge on HADR environments. Applied DB2 V8.1 Fixpack 14 on many production boxes. Performed Migration of V8.1 Fixpack 14 servers to V9.5. Instance management – Starting, stopping, creating, dropping instances. Creating Client instances for application servers and cataloged the required databases. Security – Setting authentication, authorization and granting/revoking privileges on database

objects to users/groups. Table space management – Adding, dropping, extending, reducing and resizing table space

containers. Experience in Utility of Dropped Table Recovery. Performance Tuning – Buffer pool tuning, database manager, database configuration parameter

tuning for optimal functionality. DB2 Performance Utilities - REORGCHK, REORG, RUNSTATS. Database Cloning – Across same platform using Redirected Restore, different platform using

db2look and db2move. DB2 data movement utilities – db2 Export, Import and Load. DB2 Product installation, fix pack installation and up gradation on Linux servers. Create DB2 databases. Database Backup and Recovery Implementation and Management, Incremental Backups, Full

Backups, Point-in-time/Point-of-failure Recovery. Obtain and modify the values of DB2 Database Manager and database configuration file.