Oracle Database Administrator

Mbi Llc; Harrisburg (Dauphin County); On-site; USD 90,000 - 120,000; Full time

Job summary

A technology solutions provider is seeking an experienced Oracle Database Administrator (DBA) to manage their mission-critical Oracle 19c environment. The ideal candidate will have deep expertise in Oracle RAC and ASM, alongside strong analytical and problem-solving skills. Responsibilities include database administration, backup and recovery, access security management, and performance tuning. This role demands excellent communication and documentation skills and the ability to work independently and in a team setting.

Qualifications

• Deep expertise in Oracle RAC and ASM administration.
• Strong knowledge of Oracle 19c architecture and features.
• Proficiency in Linux shell scripting for database operations.

Responsibilities

• Perform routine and advanced database administration tasks.
• Implement and maintain database backup and recovery procedures.
• Manage access security and database integrity.

Skills

Oracle RAC

Oracle ASM

Oracle 19c architecture

Linux (RHEL) shell scripting

Performance tuning

SQL and PL/SQL scripting

Recovery Manager

Job description

- We are seeking an experienced Oracle Database Administrator (DBA) to manage and maintain our mission-critical Oracle 19c environment running on Red Hat Enterprise Linux (RHEL).

- The ideal candidate will have deep expertise in Oracle RAC and ASM, and the ability to work independently on routine maintenance as well as specialized tasks.

Key Responsibilities

- Perform routine and advanced database administration tasks for Oracle 19c RAC and ASM environments.

- Implement and maintain database backup and recovery procedures, ensuring data integrity and security.

- Manage access security, database integrity, and physical data storage design.

- Oversee data storage management and supervise performance tuning activities.

- Author shell scripts for backup, restore, and monitoring tasks.

- Monitor database performance, space requirements, and optimize system resources.

- Identify and track issues, risks, and action items; provide accurate and timely status updates.

- Assist in coordinating software releases and upgrades.

- Ensure compliance with quality standards and best practices.

- Work collaboratively in a team environment while being capable of independent execution of tasks.

Soft Skills

- Strong analytical and problem-solving skills for diagnosing complex issues.

- Excellent documentation skills for procedures and standards.

- Effective communication skills for reporting and collaboration.

- Ability to manage time and priorities in a fast-paced environment.

Fill the skill matrix below:

Skill Matrix

- Oracle RAC and ASM administration expertise (Required)

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

- Proficiency in Linux (RHEL) shell scripting (Required)

- Recovery Manager experience for backup and restore operations (Required)

- Performance tuning experience at both database and SQL query level (Required)

- SQL and PL/SQL scripting experience for automation and troubleshooting (Required)

- PATCH management experience and applying PSU/CPU updates (Required)

- Familiarity with OEM, AWR, ADDM and ASH reports for monitoring and diagnostics (Required)

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

- Experience with UDEV configuration for ASM devices

- Exposure to cloud-based Oracle deployments

- Knowledge of automation tools for database operations

• Apply Now