Rajesh Mupparapu

Client : Zurich Farmers Insurance & EMEA

• Having very good knowledge on Linux, Aix & Windows environments.
• Good working knowledge on DB2 HADR TSA Setup and implementation.
• Good working knowledge on Database partitioning (DPF).
• Good hands on experience on Q-replication Setup and implementation.
• Good working Knowledge on DB2 Range partitioning.
• Performed New Server builds for Production database environments.
• Handled PDOA Production server with 5 physical partitions and 46 logical partitions which has 120TB of data with all GPFS file systems.
• Good experience in 24*7 production environment support.
• Good Experience in handling RCA calls with clients.
• Ability to troubleshoot day-to-day problems encountered on production as well as development database environments.
• Good experience in Backup and restore of databases using Redirected Restores.
• Expertise in using DB2 Movement Utilities like as Export, Import, Load and db2Move.
• Ability to automate jobs and day to day tasks using Shall scripting.
• Having very good knowledge on Performance tuning using db2explain & db2advis tools.

Client: Canada Airlines & AMEA

• Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
• Performing data maintenance utilities like REORGCHECK, REORG and RUNSTATS.
• Performing data movement utilities like EXPORT, IMPORT, LOAD, and DB2LOOK.
• Resolving Dead lock & time out issues.
• Backup and Restore of Table Spaces and Databases.
• Resolving Transaction log file issues.
• Creation and Administration of Instances, Databases, Buffer pools and Table space.
• Granting/Revoking privileges on DB2 objects.
• Performing redirect restore between different servers.
  

Client: Standard Chartered Back

• Tested programs and databases to identify issues and make necessary modifications.
• Provide Data Administration support for maintenance of production database environments.
• Taking online and offline backups for databases.
• Monitoring DB2 Activities using Db2pd, Snapshots & Event monitors.
• Performance tuning of databases after recommendations.
• Periodic monitoring on health of databases.
• Granting user privileges as per business rules.
• Implement LBAC security model as per application team requirements.
• Root cause analysis for issues in production environment.
• Plan and participate in db servers DR (disaster recovery) drill and make sure it would complete without any issues.