Title: Oracle Database Administrator Location: Jersey City, New Jersey, US (Work Model – Hybrid – 2-3 days a week from Client office in New Jersey, USA office.) Type: Contract
Responsibilities
• Handled large database estates and managed TB size of databases
• Installation and administration of multiple versions of databases on multiple Unix platforms and Windows servers
• Design and implement the high availability solutions (RAC, Golden Gate and Dataguard)
• Install, configure and manage ASM instances in oracle
• Plan and execute major migrations and upgrades
• Define and configure the disk and diskgroups in ASM and troubleshoot
• Plan and implement the backup/recovery on need basis
• Hardware tech refresh (host to host database move)
• Coordinate and work with database vendors for resolution on major incidents
• Database refresh, re-org, backup using RMAN and 3rd party tools
• Install and configure grid control database monitoring tools
• Install, Administer, manage and troubleshoot Oracle grid control
• Define performance benchmarks and metrics
• Write and troubleshoot shell scripting, SQL and PL/SQL scripts
• Primarily role is supporting the production and non-prod database environments selection
• Implement and Periodical check on Automation
• Implement and Periodical check on DB Security
• Identify, document and track Technology related risks and mitigation plan in the project
• Technical and Process guidance to L2 and L1 DBA
Skills Must have
• Excellent knowledge in Oracle databases (12c, 19c, 23ai)
• Excellent knowledge required in cloud concepts related to OCI and Azure
• Excellent knowledge in provisioning and Managing Oracle databases in On Prem, OCI and Azure.
• Excellent knowledge in Real Application Cluster (RAC) & OEM
• Excellent knowledge in performance tuning and optimization
• Excellent knowledge in Database migrations between different OS platforms from 12c to 19c and upgrades from 11g/12c to 19c
• Good knowledge of automation (Ansible, Jenkins, Python)
• Experience in Multitenant (Container/Pluggable databases) is a must for this role
• Experience in configuring Oracle dataguard and assist in DB Switchovers/Failovers.
• Strong experience in database backup and recovery.
• Strong experience in automation , configuration/deployment management tools like Jenkins, Ansible, Groovy.
• Proficient with Python or other relevant scripting languages.
• Familiarity with agile tools (Jira) & version control concepts (GitHub) Strong people and leadership management skills with proven ability to lead, motivate, inspire, develop, and encourage people.
Nice to have
• Insurance domain exp.
• Below trainings/certifications completed, is preferred
• Oracle Service Cloud Administration
• Oracle Service Cloud Analytics
• Oracle Service Cloud Integration for Developers
Thanks, and Regards Vinoth, Sr. Recruiter Seven Hills Group Technologies Inc E: vinoth@sevenhillsgrouptech.com Contact: (510) 698-6550 EXT: 408 http://www.sevenhillsgrouptech.com// Disclaimer: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you.
Tagged as: Database administrator