Ekta Singhal Email and Phone Number

PROJECTS SUMMARY:Project 1 : Jaguar Land RoverRole : Oracle DBADuration : (Sep 2019 – till now)Tools used : Remedy, Putty, notepad++ , WinSCP.Functional areas:● Support and Enhancement Project.● Requirement Analysis, Change request.● Automation for auto archive deletion.● Fixes for long pending issues for ticket reductions.● Handling SOX weekly audits for JLR. Responsibilities and Contributions: ● Working on 12c standalone/ RAC database.● Experience in 19c RAC environment activities.● Responsible to work on troubleshooting ORA errors, managing priority issues with consistency of keeping customer satisfied with the approach followed in handling the issues.● Backup and Restore functionality using RMAN.● Oracle database cloning and patching.● Prod to test refresh activity.● Logical backup of database, schema using IMPDP/EXPDP.● Monitoring log sync in Primary and Standby.● Half yearly switchover and switch back activity in data guard.● Fetching AWR, ADDM, SQL advisory reports for Sql tuning.● Experience in fetching technical support from Oracle Support.● Starting up and shutting down the database and application.● Managing the database's storage structures.● Managing users and security.● Managing schema objects, such as tables, indexes, and views.● Proactively monitoring the database's health and taking preventive or corrective action as required.● Weekly team meetings for better understanding of team progress and issues catch up.● Working on SOX weekly audits.

● Working on 12c standalone/ RAC database.● Experience in 19c RAC environment activities.● Responsible to work on troubleshooting ORA errors, managing priority issues with consistency of keeping customer satisfied with the approach followed in handling the issues.● Backup and Restore functionality using RMAN.● Oracle database cloning and patching.● Prod to test refresh activity.● Logical backup of database, schema using IMPDP/EXPDP.● Monitoring log sync in Primary and Standby.● Half yearly switchover and switch back activity in data guard.● Fetching AWR, ADDM, SQL advisory reports for Sql tuning.● Experience in fetching technical support from Oracle Support.● Starting up and shutting down the database and application.● Managing the database's storage structures.● Managing users and security.● Managing schema objects, such as tables, indexes, and views.● Proactively monitoring the database's health and taking preventive or corrective action as required.● Weekly team meetings for better understanding of team progress and issues catch up.● Working on SOX weekly audits.

Project : British petroleum Role : Oracle DBATools used : Toad, Putty, Reflection, notepad++, Remedy, OEM.Functional areas:● Support and Enhancement Project.● Handled SOX audits for BP.● Requirement Analysis, Change request and Enhancements ● Development of new requirements as per customer need.● Automation to reduce ticket counts.● Fixes for long pending issues for ticket reductions.● Lead and managed a team of 7 members.● Worked under different teams at the same time. Responsibilities and Contributions: ● Implemented a project on upgrade of databases from 11g to 12c on ASM for Solaris 11 machines.● Refresh and restorations of test databases from productions.● Implemented a CI (continuous improvement) create a clone of database with customized configurations.● Hands on experience on RAC configurations, Apps configurations, RMAN backup and recovery, Cloning, Patching, Upgrades.● Implemented a CR (Change Request) to upgrade OEM from 11g to 12c.● SSO integrations for applications.● Starting up and shutting down the database and application.● Managing the database's storage structures.● Managing user and security, schema objects, such as tables, indexes, and views.● Making database backups and performing recovery when necessary.● Proactively monitoring the database's health and taking preventive or corrective action as required.● Client interaction during development and requirement analysis.● Helping junior team members with issues and CR (change requests).● Responsible to work on troubleshooting ORA errors, applying Customized releases , Managing priority issues with consistency of keeping customer satisfied with the approach followed in handling the issues.● Worked in 24 hour environment at time of Go live for upgrading 7 instances in 1 go.● Supported out of office hours at time of CR activities, Go lives and On-call tasks.● Received excellent contributor award for 3 consecutive years with client.