Post on 12-Apr-2017
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.