SLG - 26 - 12068 - Sr. Oracle DBA - HBITS-07-14815

Greetings from Sligo Software Solutions, Inc. !!

SLIGO is a Software Development & IT Consulting company. We have around 100 IT associates working with our esteemed clients across several domains such as IT, Banking, Healthcare, and Government.

We have an urgent requirement for Sr. Oracle DBA position with our client. Role: Sr. Oracle DBA Location: Albany, New York Duration: 30 Months Job ID: SLG - 26 - 12068 Client: NY State - Department of Financial Services

Description

DFS is seeking an Oracle expert to support their mission-critical Oracle databases. The environment is very complex and utilizes many advanced features such as RAC, multitenant, DataGuard, APEX, and a highly-customized Enterprise Manager solution for monitoring and administration. The databases support numerous custom in-house as well as vendor-supported applications, some of which have a health and safety impact when down and thus have 24/7 uptime requirements.

Duties

• Work in a ""gatekeeper"" capacity to protect our Oracle environment by careful reviewing of all incoming requests from app teams, etc.
• Careful daily review of all alerts, including logging-into the server(s) and thoroughly pro-actively reviewing various logs, performance metrics, etc, and taking appropriate remedial action where necessary.
• Perform Oracle system administration activities.
• Perform Oracle hardware support such as system racking and stacking, cabling, component replacement, etc.
• Install, configure, patch, upgrade, and maintain Oracle Enterprise Manager (OEM).
• Install, configure, patch, upgrade, and maintain Oracle operating systems, firmware, clusterware, etc.
• Install, configure, patch, upgrade, and maintain Oracle databases.
• Install, configure, patch, upgrade, and maintain APEX (database tier only).
• Utilize Oracle Enterprise Manager (OEM) to pro-actively detect issues making use of advanced features such as metric extensions, monitoring templates, etc.
• Handle server and/or database crashes, performance issues, etc.
• Carefully document all processes and revise/perfect such documentation on an ongoing basis.
• Automate processes as much as possible and keep refining those processes on an ongoing basis.
• Work with application and helpdesk teams on keeping server and client-side Oracle drivers up-to-date.
• Effectively work with Oracle Support and their support portal, including understanding how their portal integrates with hardware assets, ASR fault monitoring, etc, and maintaining those functionalities.
• Mentor and train junior staff.
  
  

Mandatory Requirements

• Experience (14 Years)
• Uses specialized software to store and organize data, which may include capacity planning, installation, configuration, database design, migration, performance monitoring, security and troubleshooting, as well as backup and data recovery.
  
  

Requirements

• This is an 100% Onsite.
• Oracle Database Administration 2019 Certified Professional -or- OCP certification in version 12c or higher. NOTE: Oracle AI Database Administration Certified Professional does not count for this qualification.
• 84 months of experience installing, configuring, patching, upgrading, and maintaining Oracle database 12c or higher in a Unix-like environment (e.g. AIX, Linux, etc). Experience must be specifically with multitenant RAC databases configured with DataGaurd. NOTE: Engineered systems and cloud environments do not count for this qualification.
• 84 months of experience troubleshooting Oracle 12c or higher critical issues such as server and database crashes, failed disks, etc. Experience must include working with Oracle Support Services.
• 36 months of experience installing, configuring, patching, upgrading, and maintaining Oracle Database Appliance. Experience must be specifically with High Availability (HA) models configured with version 12c or higher RAC databases.
• 84 months of experience troubleshooting Oracle 12c or higher database performance and other related issues; specifically by working with other teams to identify if the issue is at the storage, network, database, or application tier.
• 84 months of experience using Data Pump Export/Import -and- RMAN for backup and recovery of Oracle 12c or higher databases. Experience must include using RMAN for recovery.
• 84 months of experience installing, configuring, patching, upgrading, and maintaining Oracle Enterprise Manager (OEM) 13c or higher in a Unix-like environment (e.g. AIX, Linux, etc).
• 84 months of experience utilizing Oracle Enterprise Manager (OEM) to pro-actively detect issues making use of advanced features such as metric extensions, monitoring templates, etc.
• 36 months of experience installing, configuring, patching, upgrading, and maintaining APEX (database tier) on version 12c or higher databases.
• Bachelor's degree in computer science or a related field.
• 84 months of experience documenting processes, inclusive of creation of system architecture diagrams, etc.
• 36 months of experience maintaining server hardware (racking and stacking, cabling, component replacement, etc).
• R sum
• Copy of Candidate Identification (i.e., Driver's License/Green Card/Visa and Passport if applicable)
• Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.)