Oracle Database Administrator

Job Role: Oracle Database Administrator

Location: Niskayuna, NY

Job Description

Must Have Technical/Functional Skills

Install, configure, and maintain Oracle database instances (All Versions/11g, 12c, 19c).

Perform routine database monitoring, including performance tuning and query optimization.

Configure and manage Oracle Real Application Clusters (RAC), Data Guard, and RMAN.

Implement and manage backup, restore, and disaster recovery strategies using RMAN.

Troubleshoot and resolve database issues, including performance degradation, corruption, and outages.

Manage Oracle database security (user roles, privileges, encryption, auditing).

Perform database migrations, upgrades, and patching with minimal downtime.

Automate administrative tasks using Oracle scripts (PL/SQL, Bash, Perl).

Monitor capacity planning, storage, and system resources.

Collaborate with application developers to enhance database performance and scalability.

Physical Requirements - Ability to work in a standard office environment and May also need to provide support after regular hours, including on-call assistance.

Roles & Responsibilities (L2/L3 Only)

Deep expertise in Oracle performance tuning, backups, RMAN, and database optimization.

Extensive experience with Oracle RAC, Data Guard, and ASM.

Proficient in PL/SQL scripting and automation.

Knowledge of Oracle Exadata, Oracle Cloud, and cloud-based solutions (OCI, AWS).

Strong troubleshooting skills for complex database issues.

Familiarity with Oracle Enterprise Manager (OEM) and other monitoring tools.

Generic Managerial Skills, If any

Leadership, Communication, Decision-making, Problem-solving, Time Management, Delegation,

Conflict Resolution, Adaptability, Strategic Thinking, Team Building.