As a Oracle DBA responsible for L2/L3 layers of operation support.Production Support with the below activities.• Working on prod Database refresh activity• Solving alerts related to databases• Worked on database upgrade from 11g to 12c• Working on RAC environment and Solving RAC database alerts.• Working on Golden Gate environment on database sync up.• Performing monthly partition activity on production environment• Performing quarterly patch on production environment through OEM tool.• Working on performance tuning at query level.• Performing quarterly patch on production environment.• Support to user queries; provide resolutions/Workaround of concerns raised by business users• Monitoring Database RMAN backups completion• Solving and RCA of alerts during the Off Business Hours inside SLA• Grooming up new team membersTechnologies Involved: OEM, Toad, SQL-Developer and MYTE & Service Now.Key Responsibilities:As a PostgreSQL DBA responsible for L2 layers of operation support.Non-prod Support with the below activities.• Working on AWS cloud database migration.• Involved in design sign off for cloud migration project• Working on manual schema conversion from on-premise Oracle DB to Aurora PostgreSQL.• Backup schedule for aurora PostgreSQL.• Restoring PostgreSQL database from backup in on-premise.• Alert setup for Aurora PostgreSQL• User management in PostgreSQLTechnologies Involved: PEM, Toad, AWS SCT , AWS DMS.

• 4.7 years of strong experience in field of IT Sector.• Strong fundamentals on Oracle Architecture.• Ability to perform Oracle software installation, configure database, perform cloning.• Well versed with the concept and configuration of Oracle Database Administration, Backup and Recovery, Data Guard, RAC database configuration.• Good knowledge on Data pump, RMAN, Data Guard, Golden Gate and RAC. • Involved in patching of oracle database using opatch and applying patch set.