Aman Rawat
New Delhi
Summary
Accomplished Oracle Database Administrator at Coforge, skilled in performance tuning and backup strategies. Expert in Oracle 19c, GoldenGate, and PL/SQL, I automated health checks and resolved complex replication issues, enhancing database integrity and efficiency. A collaborative team player, I ensure optimal database design and security while driving successful migrations and upgrades.
Overview
3
3
years of professional experience
Work History
Oracle Database Administrator
Coforge
Greater Noida
07.2022 - Current
- Installed, configured, and maintained Oracle 19c databases across development, test, and production environments.
- Automated and performed database health checks, space management and service relocation using shell scripting.
- Implemented RMAN backup and recovery strategies to ensure database integrity and quick restoration.
- Conducted performance tuning using AWR, ADDM, and SQL trace for query optimization.
- Troubleshooted and fixed issues in Jenkins CI/CD database deployment.
- Monitored GoldenGate health using GGSCI commands and automated alert scripts for latency and error detection.
- Performed troubleshooting of Extract and Replicat processes, including data collision and conflict resolution.
- Resolved trail file corruption, replication lag, and data mismatch issues using GoldenGate log analysis and checkpointing.
- Monitored Data Guard for standby synchronization and performed role switchovers and failovers.
- Applied quarterly patching and supported minor upgrades and migrations.
- Worked closely with application developers to ensure proper design ofapplications and database structures.
- Worked closely with database architects to ensure smooth table migrations.
- Debugged Pl/Sql code to ensure no invalid packages or procedures in the database.
- Maintained database security by creating user accounts and profiles and granting appropriate privileges.
Education
Bachelor of Technology - CSE
BMIET
Sonepat04-2022
High School Diploma -
The Cambridge International School
Delhi04-2018
Class 10th -
The Cambridge International School
Delhi04-2016
Skills
- Oracle database management
- SQL
- PL/SQL
- Golden gate
- Oracle Data Pump
- Oracle Data Guard
- Oracle RAC
- Oracle ASM
- OEM
- Backup and recovery
- Performance tuning
- Shell scripting
- Rally
- Confluence
- Service now
- BMC Control M
Languages
Hindi
First Language
English
Proficient (C2)
C2
Timeline
Oracle Database Administrator
Coforge
07.2022 - Current
Bachelor of Technology - CSE
BMIET
High School Diploma -
The Cambridge International School
Class 10th -
The Cambridge International School