Database Administrator

JSM Consulting Inc.; City of Albany (NY); On-site; USD 90,000 - 150,000; Full time

Job summary

JSM Consulting Inc. seeks an Oracle Database Administrator with extensive hands-on experience in Oracle 12c or higher, including multitenant RAC and Data Guard, in UNIX-like environments.

84 months of related work is required, with support for installations, upgrades, and maintenance. Candidates should also be proficient with RMAN, Data Pump Export/Import, and Oracle Enterprise Manager (OEM) 13c, and have strong fault‑diagnosis skills across storage, network, and database tiers.

Qualifications

• 84 months of experience with Oracle 12c or higher in UNIX-like environments.
• Experience with multitenant RAC databases configured with DataGuard.
• 84 months troubleshooting Oracle 12c+ issues with Oracle Support Services.
• 36 months with Oracle Database Appliance HA configurations (12c+).
• 84 months of experience with RMAN for backup and recovery.
• 84 months maintaining OEM 13c+ in UNIX-like environments.

Responsibilities

• Install, configure, patch, upgrade Oracle databases and appliances.
• Troubleshoot performance and reliability across storage, network, and DB layers.
• Maintain Data Pump exports/imports and RMAN-based backups and recoveries.
• Document system architectures and create diagrams for ops teams.

Skills

Oracle 12c+

Oracle RAC

DataGuard

OEM 13c

RMAN

Data Pump

Unix/Linux

Troubleshooting

Education

Bachelors in CS or related field

Tools

RMAN

Data Pump

OEM

APEX 12c+

Job description

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).