Capgemini
Capgemini
Capgemini is a consulting and technology services company that helps organizations transform and manage their operations. Its work spans industries including aerospace, automotive, banking, healthcare, and logistics, with services covering cloud, cybersecurity, data and artificial intelligence, and enterprise management. Capgemini also focuses on innovation and sustainability as part of its approach to digital transformation. The company hires across a broad range of professions and experience levels, with an emphasis on building an innovative and diverse workforce.

Oracle Database Administrator — Remote Canada | Capgemini

Capgemini is hiring a remote Oracle Database Administrator in Canada to manage secure, reliable enterprise databases. The role covers PL/SQL optimization, performance tuning, backup and recovery, upgrades, migrations, and production support.

Description

  • Provision, configure, upgrade, and maintain Oracle Database environments
  • Track database health, performance, capacity, and availability across Production, UAT, QA, and Development environments
  • Administer RH Linux, Bash, Oracle RDBMS, Shibboleth SP, HTTPD, and JBoss AS platforms
  • Build, maintain, and optimize complex PL/SQL packages, procedures, functions, triggers, and views
  • Tune database performance with AWR and ASH reports, Explain Plans, SQL Trace, and Oracle diagnostic tools
  • Diagnose and resolve locking, blocking, deadlock, memory utilization, and query performance problems
  • Implement and administer database backup, recovery, and disaster recovery processes
  • Assist with database patching, upgrades, migrations, and refresh operations
  • Administer Oracle accounts, roles, privileges, and database security controls
  • Manage tablespaces, storage consumption, and database growth
  • Conduct index analysis, SQL tuning, partitioning, and execution plan optimization
  • Handle production incidents, problem management, Root Cause Analysis (RCA), and Corrective Action Plans (CAP)

Requirements

  • Bachelor’s degree in computer science, engineering, or a related discipline
  • Four to six years of hands-on Oracle Database Administration experience
  • Strong background in PL/SQL development and optimization
  • Experience with Oracle Database 12c, 19c, or later versions
  • Solid knowledge of SQL and PL/SQL performance-tuning methods
  • Experience administering RH Linux, Bash, Oracle RDBMS, Shibboleth SP, HTTPD, and JBoss AS

Benefits

  • 12–25 vacation days, determined by grade
  • Paid company holidays
  • Personal days
  • Sick leave
  • Medical, dental, and vision coverage, or coordination with provincial healthcare in Canada
  • Retirement savings programs, such as 401(k) in the U.S. or RRSP in Canada
  • Life and disability insurance
  • Employee assistance programs
  • Additional benefits according to local policy and eligibility
  • Variable incentives, bonuses, or commissions may apply based on the position and applicable laws
  • Reasonable accommodations during the recruitment process

Related Jobs

Knowtion Health

Remote Talent Acquisition Manager

Knowtion Health

Oversee recruiting systems, requisitions, analytics, and contingent workforce operations at Knowtion Health. Help support scalable hiring processes for a growing healthcare company.

Open