Previous Job
Previous
Sr Oracle DBA
Ref No.: 19-09004
Location: San Diego, California
 

Sr Oracle DBA (10+ years)


Responsibilities:-

- *****Setup & Monitor DB servers proactively to ensure optimized usage of resources using various monitoring tools (OEM, ExtraHop, Dynatrace, Veridata etc)
- *****Monitor the occurrence of spikes in the user data load. In case of spiking, track the utilization of components and identify the issue, Analyze the log files, if required.
- *****Perform and setup daily environment health checks and generate reports to capture the findings.
- In case of any network/ database related issues, work with the respective teams to resolve the issues.
- *Setup & Maintenance of Golden Gate new instances and channels
- Work and Resolve various incidents under technical guidance of the senior administrator.
- Participate in day to day meetings and provide status updates
- Code Deployments in DEV/QA/PROD environments
- *Test & Deploy the latest patches in the environment to improve the stability of development system to avail the latest features and to ensure the bugs of the earlier version are fixed.
- Comply with the security protocols and audits in the organization; Create specification documents for security on need basis
- *Maintain Primary and Standby servers.
- Identify the hardware requirements /prerequisites to set up the environment/ to install and configure the tool based on the tool/ product document and the inputs gathered from Senior administrator.
- Identify prerequisites to set up the environment/ configure the tool.
- Database/ tool Administration New upgrade/ new version/ New tool administration.
- Partiton Maintenance
- *Upgrade production databases from 11g to 12c.

Skills:

***Expertise in OID/OEM setup, patching and resolve ongoing issues
***Experience with Oracle 11g to 12c upgrade
***Experience with DR (Disaster Recovery) site set up and automation of fail-over
*Experience in setting up and managing various DB monitoring tools

***Experience in Golden Gate
*Experience in RMAN
*Experience in shell scripting