Summary
Overview
Work History
Education
Skills
Websites
Experience
Certification
Timeline
Generic

Ramesh Jalligampala

Bangalore

Summary

Accomplished Senior Database Administrator with extensive experience at Oracle, specializing in RDBMS management and database performance tuning. Proven ability to enhance operational efficiency and implement robust backup and recovery procedures. Adept at leading teams and fostering collaboration, leveraging skills in IBM DB2 ,POSTGRES and AWS to drive successful project outcomes.

Overview

18
18
years of professional experience
1
1
Certification

Work History

Senior Database Administrator

Oracle
Bangalore
10.2021 - Current
  • Project Overview: Permitting and Licensing Software. Oracle helps agencies fast-track approvals with intuitive self-service and guided experiences that take the complexity out of applying for a permit or business license.
  • Working on Multiple RDBMS like POSTGRESQL,IBM DB2, Oracle.
  • Offer DBA support for application development team.
  • Database design and architecture
  • Monitor database performance and recommend improvements for operational efficiency.
  • Assist in capacity planning, space management and data maintenance activities for database system.
  • Perform database enhancement and modification as per the requirements.
  • Perform database recovery and backup tasks on daily and weekly basis.
  • Develop and maintain patches for database environments.
  • Identify and recommend database techniques to support business needs.
  • Assist in implementation of new features and program fixes in databases.
  • Maintain database security and disaster recovery procedures.
  • Perform troubleshooting and maintenance of multiple databases.
  • Resolve any database issues in accurate and timely fashion.
  • Monitor databases regularly to check for any errors such as existing locks and failed updates.
  • Oversee utilization of data and log files.
  • Manage database logins and permissions for users.

Senior Database Engineer

Thomson Reuters
Bangalore
02.2016 - 10.2021
  • Establish individual performance goals, review performance against goals and provide coaching for associate development.
  • Respond to database issues and inform management. Follow through and establish permanent fixes.
  • Manage database budget, licenses, and vendor management relationship.
  • Provide guidance, direction, and managerial leadership to junior resources.
  • Develop and manage both long and short-term goals for department and staff.
  • Help develop and execute the department roadmaps.
  • Create, track and update project schedule, communicate project status to the team members and to management.

Project Lead

IBM
Bangalore
11.2014 - 10.2015
  • Maintaining Huge db2 9.7 databases.
  • Exposure on DPF environment (ISAS 5600 & 5100).
  • Created logical and physical database in DB2 as per specifications.
  • Created Database objects in Oracle database.
  • Exporting and loading the data.
  • Taking the Backups in both the databases.
  • Automated data loading into database tables from files using Load utility.
  • Involved in taking off-line and online backup.
  • Established database Backup & Recovery procedures.
  • Managed & monitored the Database space requirements.
  • HADR Monitoring.
  • Performed Exports and Imports of database, users, and tables as and when required.
  • Creating and administration of all database objects, including tables, clusters, indexes, views, sequences, packages, and procedures.

Senior Database Administrator

HTC Global Services
Hyderabad
07.2011 - 07.2013
  • Installed, Configured & designed DB2 database on Windows and Linux Environments.
  • Installed and configured db2 on Windows and Unix Environments.
  • Installed the db2 udb data partitioning feature in Linux.
  • Maintained the partitioned databases.
  • Created logical and physical database in DB2 as per specifications.
  • Created Database objects in database.
  • Exporting and loading the data.
  • Doing Restore / Redirect restore on non-prod environment.
  • Taking the Backups in both the databases.
  • Automated data loading into database tables from files using Load utility.
  • Involved in taking off-line and online backup.
  • Established database Backup & Recovery procedures.
  • Managed & monitored the Database space requirements.
  • Performed Exports and Imports of database, users, and tables as and when required.
  • Creating and administration of all database objects, including tables, clusters, indexes, views, sequences, packages, and procedures.
  • Developed PL/SQL programming that included writing of Stored Procedures, Packages.
  • Trouble Shooting and assist Java developers and Performance monitoring and tuning.
  • Performed automatic monitoring of users, table spaces, tables, indexes & Auditing of database.
  • Reorganization of database performed periodically for best performance.
  • SQL Performance tuning of SQL queries using the SQL Optimizer for DB2 UDB toolkit.

Database Administrator

Miracle Software Systems
Vishakhapatnam
09.2007 - 08.2010
  • Installed, Configured & designed DB2 database on Windows and Linux Environments.
  • Installed and configured Oracle database on Windows and Unix Environments.
  • Created logical and physical database in both oracle and DB2 as per specifications.
  • Created Database objects in Oracle database.
  • Exporting and loading the data.
  • Taking the Backups in both the databases.
  • Automated data loading into database tables from files using Load utility.
  • Involved in taking off-line and online backup.
  • Established database Backup & Recovery procedures.
  • Managed & monitored the Database space requirements.
  • Performed Exports and Imports of database, users, and tables as and when required.
  • Creating and administration of all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
  • Developed PL/SQL programming that included writing of Stored Procedures, Packages.
  • Trouble Shooting and assist Java developers and Performance monitoring and tuning.
  • Performed automatic monitoring of users, table spaces, tables, indexes & Auditing of database.
  • Reorganization of database performed periodically for best performance.
  • SQL Performance tuning of SQL queries using the SQL Optimizer for DB2 UDB toolkit.

Education

B. Tech - Computer Science Engineering

Chaitanya Engineering College,JNTU
Visakhapatnam
01.2006

Skills

  • IBM DB2
  • PostgreSQL
  • ORACLE
  • AWS
  • OCI
  • DEVOPS TOOLS
  • GITHUB
  • PYTHON
  • SHELL SCRIPTING
  • Data architecture design
  • RDBMS management
  • Database performance tuning
  • Backup and recovery procedures

Websites

Experience

Around 17 Years of experience in IBM DB2 LUW, PostgreSQL and ORACLE database administration. Around 5 Years of experience in cloud technologies like AWS OCI., Around 6 Years of experience in leading a team of 5 to 20 Members.

Certification

  • Oracle Cloud Infrastructure 2025 AI Foundations Associate (1Z0-1122-25)
  • Oracle Cloud Infrastructure 2024 Certified Foundations Associate

Timeline

Senior Database Administrator

Oracle
10.2021 - Current

Senior Database Engineer

Thomson Reuters
02.2016 - 10.2021

Project Lead

IBM
11.2014 - 10.2015

Senior Database Administrator

HTC Global Services
07.2011 - 07.2013

Database Administrator

Miracle Software Systems
09.2007 - 08.2010

B. Tech - Computer Science Engineering

Chaitanya Engineering College,JNTU

Similar Profiles

CREATE PROFILE
Ramesh Jalligampala