J Akash
Oracle Database Administator
Bangalore,KA
Summary
Oracle Database Administrator with 6+ years of experience in managing and supporting Oracle 11g, 12c, 18c and 19c databases in RAC and Data Guard environments. Experienced in backup & recovery using RMAN, performance tuning, database migrations, patching and high availability solutions. Skilled in diagnosing using AWR, ASH, ADDM and SQL tuning techniques. Strong experience in production support and mission-critical database environments.
Overview
6
6
years of professional experience
2
2
Certifications
1
1
Language
Work History
Database administrator
Robert Bosch, Bangalore
07.2021 - 07.2025
- Roles and Responsibilities:
- An experienced professional in 4 years of as an Oracle DBA (11g, 12c, 18c, 19c) in production and development environments.
- Implemented Oracle Multitenant architecture (CDB/PDB) to improve resource utilization.
- Managed database storage structures including tablespaces, datafiles, redo logs, and control files.
- Implemented tablespace monitoring and space management strategies.
- Performed database cloning and patch management that resulted in smoother and more reliable application development cycles.
- Strong experience in RMAN, Data Pump, ASM and RAC environment.
- Export and import of database objects using Data pump utilities EXPDP and IMPDP.
- Responsible for Online/Offline database backups and managing Database recovery with RMAN.
- RMAN backup strategy design and restore testing.
- Database cloning using RMAN / Active Duplicate.
- Using OEM (Oracle Enterprise Manager) for routine administration, database monitoring, replication process and performance tuning.
- Installed and configured Standby database (Data Guard) for high availability/disaster recovery purpose.
- Configured and administered Oracle Data Guard physical standby databases and performed Switchover/failover during DR testing.
- Enhanced database replication and logging mechanisms to ensure real-time data synchronization across distributed systems, mitigating data loss risks.
- Performed performance tuning using AWR, ASH, ADDM reports to resolve database performance issues.
- Oracle RAC installation, configuration and troubleshooting.
- Installed and configured Oracle GoldenGate replication for real-time data replication between production and reporting databases.
- Troubleshot replication lag and trail file issues.
- Applied quarterly PSU/RU patches and works closely with Oracle to make Application environment Up to date.
- Patch management using Opatch and OpatchAuto.
- Patching and upgradation for RAC/NON-RAC databases.
- Resolved production incidents (P1/P2/P3/P4) within SLA using ServiceNow ticketing system.
- Experience in service request handling through service now.
- Conduct database migration from 11g to 12c, 12c to 19c of production Databases ensuring minimal downtime.
- Performed cross-platform database migration using XTTSv4 and Oracle Zero Downtime Migration ( ZDM ) from on-premise Oracle 19c to OCI or AWS RDS ensuring minimal downtime.
- Motivated team player and an adaptable individual with good analytical and strong interpersonal skills.
- Provided Production support for both development and 24*7 production environments.
Database administrator
Tech Mahindra, Bangalore
06.2019 - 04.2021
- Roles and Responsibilities:
- Performed day-to-day dayabase administration tasks including user management, database monitoring, and space management.
- Created and maintaining database users, roles, privileges, and profiles ensuring database security.
- Implemented backup and recovery strategies using RMAN to ensure data protection.
- Monitored database health and performance using OEM and SQL monitoring tools.
- Optimized database performance by crating indexes and tuning SQL queries.
- Handling incident tickets through ServideNow/SNOW and resolved isuues with SLA timelines.
- Assisted in database installation, configuration, and upgrades.
- Support application teams for database-related issues and deployements.
Education
B.Tech - Electrical Engineering
CUTM University
Odisha06-2016
Skills
Oracle Database: 11g, 12c, 18c, 19c RAC
High Availablity: Oracle RAC, Data Guard, GoldenGate
Certification
Oracle Cloud Infrastructure (2023)
Timeline
Database administrator
Robert Bosch, Bangalore
07.2021 - 07.2025
Database administrator
Tech Mahindra, Bangalore
06.2019 - 04.2021
B.Tech - Electrical Engineering
CUTM University
PERSONAL PROFILE:
- GENDER : MALE
- MARITAL STATUS : Single
- NATIONALITY : Indian