Dec 2021 – Apr 2024 · 2 yrs 4 mos · Gurugram, Haryana, India · Hybrid

• Good hands on AWS, Azure & GCP provisioning of PostgreSQL databases along with creation of user and grant/revoke privileges, roles with environmental policies.
• Managing storage and add/modify storage type on AWS as per requirement.
• Have been extensively working on data refresh.
• Deployment in all environments from lower to upper as per application developers.
• Performed AWS RDS PostgreSQL database upgrade from major version 10 to 13.
• Performed backup and restore of AWS RDS instances.
• Performed enabling encryption in AWS RDS to keep RDS compliant.
• Actively involved in creation of Changes and presenting same in CAB meeting for getting them approved.
• Interacting with end-user and provide technical support to resolve the issues. Creating service request, incident, and change requests using ServiceNow.

May 2018 – Dec 2021 · 3 yrs 7 mos

• User Administration of Oracle, PostgreSQL, Redshift and SQL Server databases such as user creation, grant/revoke Privileges, Roles, Profiling, and Authentication.
• Have worked on deploying scripts, modifying the object structure as necessary from information given by application developers in all the environment including Production.
• Have worked on SOX remediation.
• Have worked on Data Refresh as per the requirement.
• Applying PSU patch on quarterly basis. Managing storage and add/modify storage type on AWS as per requirement.
• Have worked on creating Snapshots and Load/Unload via S3 in AWS environment.
• Interacting with end-user and provide technical support to resolve the issues.
• Have been actively monitoring Database housekeeping jobs and takes action accordingly.
• Adding data file, resizing data file, movement of objects into different tablespace to resolve space issues.
• Have worked on creating service request, incident, request for change using Samanage tool.

Dec 2016 – Apr 2018 · 1 yr 4 mos

• Have actively monitoring the log shipping and sync in Data guard Environment.
• Have worked on performing database health check.
• End-user requests in terms of assisting them in effectively create tables, users.
• Hands on experience in database manual recoveries.
• Have worked on database backup/restore as per need and worked on DR drill as well.
• Have worked on deploying jar files on OC4J application.
• Have worked on recovering a corrupted/lost data file on Standby database from the Primary database.

Oct 2016 – Nov 2016 · 1 mo

• Initial Learning Programe( ILP ) training.