Oracle DBA

This is a fully remote position, open to applicants in Canada.

📋 Description

• Install, configure, upgrade, and maintain Oracle Database environments.

• Oversee database health, performance, storage utilization, and availability across Production, UAT, QA, and Development environments.

• Manage RH Linux, Bash, Oracle RDBMS, Shibboleth SP, HTTPD, and JBoss AS.

• Design, maintain, and optimize intricate PL/SQL packages, procedures, functions, triggers, and views.

• Conduct database performance tuning utilizing AWR Reports, ASH Reports, Explain Plans, SQL Trace, and Oracle performance tools.

• Diagnose and resolve issues related to locking, blocking, deadlocks, memory usage, and query performance.

• Implement and oversee backup, recovery, and disaster recovery strategies.

• Assist with database patching, upgrades, migrations, and refresh activities.

• Handle Oracle user accounts, roles, privileges, and database security measures.

• Monitor and manage tablespaces, storage usage, and database growth.

• Execute index analysis, SQL tuning, partitioning, and execution plan optimization.

• Support production incidents, problem management, Root Cause Analysis (RCA), and Corrective Action Plans (CAP).

⛳️ Requirements

• Bachelor’s degree in computer science, engineering, or a related field.

• 4–6 years of practical experience in Oracle Database Administration.

• Proficient experience in PL/SQL Development and Optimization.

• Familiarity with Oracle Database versions 12c, 19c, or later.

• Strong comprehension of SQL and PL/SQL performance tuning methodologies.

• Experience in administering RH Linux, Bash, Oracle RDBMS, Shibboleth SP, HTTPD, and JBoss AS.

🏝️ Benefits

• Vacation: 12-25 days, based on grade.

• Company-paid holidays.

• Personal Days.

• Sick Leave.

• Medical, dental, and vision coverage (or provincial healthcare coordination in Canada).

• Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada).

• Life and disability insurance.

• Employee assistance programs.

• Additional benefits as outlined by local policy and eligibility.

• Variable incentives, bonuses, or commissions may be available based on the position and applicable laws.

• Reasonable accommodations during the recruitment process.