Job Description

Location: Harrisburg, PA
Position Type: Mostly Remote
Hybrid Schedule: Onsite as needed
Contract Length: Long-term with annual extensions

We are seeking an experienced Oracle Database Administrator (DBA) to manage and support a mission-critical Oracle 19c environment running on Red Hat Enterprise Linux, with a strong focus on RAC and ASM. This role requires a highly skilled professional capable of independently handling both routine maintenance and complex database operations while ensuring performance, security, and reliability.

Duties:

• Perform routine and advanced database administration for Oracle 19c RAC and ASM environments

• Implement and maintain backup and recovery strategies using RMAN to ensure data integrity and availability

• Manage database security, user access, and ensure compliance with established standards and best practices

• Design and maintain physical data storage structures and oversee overall storage management

• Monitor database performance, space utilization, and optimize system and query performance

• Develop and maintain shell scripts for automation of backup, restore, and monitoring processes

• Troubleshoot database issues, track risks and action items, and provide timely status updates

• Support and coordinate database-related software releases, patches, and upgrades

• Apply PSU/CPU patches and manage ongoing patching activities

• Utilize tools such as OEM, AWR, ADDM, and ASH reports for monitoring and diagnostics

• Perform SQL and PL/SQL scripting for automation, reporting, and issue resolution

• Conduct capacity planning and forecasting to support future database growth

• Assist in implementing security hardening measures including encryption and auditing

• Collaborate with cross-functional teams while also executing tasks independently

Required Skills:

• Expertise in Oracle RAC and ASM administration

• Strong knowledge of Oracle 19c architecture and features, including Pluggable Databases (PDBs)

• Proficiency in Linux (RHEL) shell scripting for automation and system management

• Hands-on experience using Recovery Manager (RMAN) for backup and restore operations

• Experience performing performance tuning at both the database and SQL query level

• Strong SQL and PL/SQL scripting experience for automation and troubleshooting

• Experience with patch management, including applying PSU/CPU updates

• Familiarity with OEM, AWR, ADDM, and ASH reports for database monitoring and diagnostics

Preferred Skills:

• Experience with Oracle Data Guard for disaster recovery and high availability

• Experience configuring UDEV for ASM devices

• Exposure to cloud-based Oracle deployments

• Knowledge of automation tools for database operations