Database Administrator

Nys Opwdd•Schenectady, NY

1d•Hybrid

About The Position

The Database Administrator will assist the Database team with ongoing database work, including installation, configuration, hardening, backup validation, performance tuning, monitoring, and recommending best practices and procedures. The role provides support to Application Development staff, internal users, and external data exchange partners. The position is a 30-month contract and follows a hybrid work model, with 50% telecommuting and 50% in-office work in Schenectady, New York. Interviews are virtual.

Requirements

At least 84 months of experience with Oracle RMAN, including backup and repository configuration and maintenance and implementation of RMAN backup and recovery using Commvault.
At least 84 months of experience installing, upgrading, patching, and using Oracle Enterprise Manager (OEM) to monitor and analyze database issues and find solutions.
At least 84 months of experience as an Oracle DBA in an AIX/Unix environment, including database implementations, upgrades, conversions, and consolidations, and database compliance, security, and auditing, including Oracle Advanced Security, remote authentication, and Oracle Wallet configuration.
At least 60 months of experience installing, maintaining, and tuning databases that support OBIEE and Oracle Business Intelligence Application software.
At least 84 months of experience with Oracle RAC, Oracle ASM, Oracle ASM Cluster File System, Oracle Data Guard, and Oracle Database Security.
At least 24 months of experience maintaining Oracle databases on AIX that support SAP Business Object Info View and applications using Oracle Forms and Oracle Reports.
Bachelor's degree in Computer Science or a related discipline.

Responsibilities

Install, upgrade, patch, and maintain Oracle databases on AIX, including backup and recovery.
Configure and maintain Oracle Recovery Manager (RMAN), including backup and repository maintenance and RMAN backup and recovery using Commvault.
Use Oracle Enterprise Manager (OEM) to monitor and analyze database issues and identify solutions.
Allocate storage and plan future database storage requirements.
Collaborate with application programmers and system architects to develop solutions that meet business goals.
Perform off-hours evening or weekend work as needed for emergency or maintenance tasks.
Support internal users, external data exchange partners, and Application Development staff.
Perform optimization and tuning, capacity planning, historical usage tracking, future resource trending, and resource allocation adjustments.
Recommend technical architecture and best practices and procedures.
Recommend approaches for Oracle Advanced Security, including TDE, Oracle Wallet, and remote authentication.
Provide hands-on training and mentoring to other database administrative staff.
Perform root cause analysis and recommend remediation for issues.
Handle requests and incidents submitted through ITSM tickets.
Install, maintain, and tune databases supporting OBIEE and Oracle Business Intelligence Application software.
Maintain Oracle databases on AIX supporting SAP Business Object Info View and applications using Oracle Forms and Oracle Reports.
Work with Oracle RAC, Oracle ASM, Oracle ASM Cluster File System, Oracle Data Guard, and Oracle Database Security.