Over 2 years of experience overseeing, supervising, and optimizing Oracle databases (11g/12c/19c). Skilled in executing backups, restoration processes, applying patches, and ensuring optimal availability and security measures. Solid grasp of database structures, fine-tuning performance metrics, and efficiently resolving operational challenges.
Overview
3
3
years of professional experience
2015
2015
years of post-secondary education
3
3
Languages
Work History
Oracle DBA
Soniks Consulting Pvt Ltd
11.2022 - Current
Over 2 years of hands-on experience in Oracle Database Administration across versions 10g, 11g, 12c, 18c, and 19c on Linux and Windows platforms.
Expertise in the complete Oracle DBA lifecycle: requirements gathering, analysis, design, implementation, and ongoing support.
Proficient in installation, configuration, and administration of Oracle databases in Production, Development, and Test environments.
Skilled in OEM monitoring and resolving performance and system alerts to maintain optimal database health.
Experienced in performing database cloning, data migration using Export/Import and Data Pump (Expdp/Impdp), and environment refreshes.
Strong knowledge of backup and recovery strategies using RMAN; participated in yearly Disaster Recovery (DR) drills and recovery simulations.
Conducted database tuning using AWR, ADDM, ASH reports, SQL Trace, TKPROF, and Explain Plan to identify and fix performance bottlenecks.
Applied Oracle PSU and CPU patches in both Prod and Non-Prod environments in coordination with development and application teams.
Implemented and managed Oracle Data Guard for high availability and disaster recovery in mission-critical systems.
Proficient in user and security management: creation of users, roles, profiles, privileges, and quota management.
Managed database storage: creation and maintenance of tablespaces, data files, temp files, control files, and archive logs.
Performed daily DBA maintenance tasks: space management, session monitoring, and resolution of locking/blocking issues.
Delivered 24x7 on-call production support as part of a rotational team, ensuring database uptime and availability.
Participated in Change Management processes, implementation planning, and cross-functional team meetings.
Accounts Associates at T & M Services Consulting Pvt Ltd (Works For Aditya Birla Management Corporation Pvt Ltd)Accounts Associates at T & M Services Consulting Pvt Ltd (Works For Aditya Birla Management Corporation Pvt Ltd)