Database Administrator

Job Title: Database Administrator - Expert
Task ID: HBITS-07-14815
Position Duration: 30 Months
Client: State of NY
Agency: Department of Financial Services

Please call | | or email at

Description

• Work in "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 Qualifications 1 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. 2 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. 3 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. 4 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. 5 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. 6 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. 7 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). 8 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. 9 36 months of experience installing, configuring, patching, upgrading, and maintaining APEX (database tier) on version 12c or higher databases. 10 Bachelor's degree in computer science or a related field. 11 84 months of experience documenting processes, inclusive of creation of system architecture diagrams, etc. 12 36 months of experience maintaining server hardware (racking and stacking, cabling, component replacement, etc). Required Documentation Resume
Copy of Candidate Identification
(i.e., Driver's License//Visa and Passport if applicable)
Any documents referenced in the above Requested Qualifications
(i.e., professional certifications, degrees, etc.)
Disclaimer: i-Link Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability