Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Ramchandra Sawant

Ramchandra Sawant

Cloud Database Engineer
Pune

Summary

Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.

Overview

8
8
years of professional experience
4
4
years of post-secondary education
2
2
Certifications

Work History

Cloud Database Engineer

NICE
03.2022 - Current
  • Conducted regular audits to identify areas of improvement in database management practices, leading to increased efficiency.
  • Maintaining and monitoring multiple DB engines (Oracle/MSQL/ Postgres/MYSQL) on AWS cloud platform.
  • Administrative tasks like creating/assigning parameter group, resizing of RDS instances, resource/performance analyzing through Performance Insight on AWS console.
  • Expertise in backup,recovery & point in time restore activities on multiple db engines.
  • Periodically performing DB maintenance activities like gather-stats,index rebuilding, Vacuum.
  • Successfully performed schema migrations from on-premises DB to AWS cloud environment.
  • Part of cross DB migration projects like Oracle/MSSQL to modern database platforms like Postgres using DMS services on AWS.
  • Performed Oracle(12c to 19c)/MSSQL RDS DB instance major version upgrades.
  • Well understanding of security groups and option groups on RDS instances.
  • Provisioning and decommission of RDS instances.
  • Handson experience in creating/ managing Read-replica instances and DR setup for MSSQL DB.
  • Improved database performance by optimizing queries and implementing efficient indexing strategies.
  • Developed custom scripts to automate routine tasks, resulting in significant time savings for the team.

Senior Oracle DBA

Tech Mahindra
12.2018 - 03.2022
  • Communicated effectively with key stakeholders regarding database changes or improvements that affected their responsibilities within the organization.
  • Provided technical support during application development processes to ensure seamless integration with existing databases.
  • Maintained detailed documentation of database configurations, changes, and procedures for easy reference by team members and future troubleshooting efforts.
  • Set up and controlled user access levels across databases to protect important data.
  • Involvement in weekly DB housekeeping activities, OS patching activities start/stop of golden gate processes.
  • Detailed Analysis of AWR, ASH reports on daily basis to review DB performance.


Oracle DBA

Softenger
08.2016 - 06.2018
  • Managed Oracle databases, maintaining high levels of performance, availability, and security.
  • Handle day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements. Checking Alert Logs, Archive Logs, Trace files, backup verifications & Health checkups of database.
  • Setting Up Static and Dynamic Parameters as per requirements of database.
  • Tablespace resize by adding/resizing data files. Managing Archive log destination.
  • Performing Database refresh activities using Datapump utilities. Database build, backup trigger, dB registration on OEM.
  • Extract/review AWR report and analyzing I/O utilization of database or specific SQL job.

Education

Bachelor of Science - Computer And Information Systems

Symbiosis College of Art And Commerce
Pune
08.2009 - 07.2013

Skills

Oracle,MSSQL,Postgres,MYSQL DB

AWS RDS

Data Migration

Backup and recovery

Effective communication

Adaptability and flexible

Certification

Oracle Database administrator training

Timeline

Cloud Database Engineer

NICE
03.2022 - Current

Senior Oracle DBA

Tech Mahindra
12.2018 - 03.2022

Oracle DBA

Softenger
08.2016 - 06.2018

Bachelor of Science - Computer And Information Systems

Symbiosis College of Art And Commerce
08.2009 - 07.2013

Similar Profiles

CREATE PROFILE
Ramchandra SawantCloud Database Engineer