Senior Oracle DBA & Exadata System Administrator

Allegion Canada Inc.; Colorado; Hybrid; USD 110,000 - 145,000; Full time

Benefits offered by this job

Health, dental and vision insurance

Unlimited Paid Time Off

401K with company match

Flexible work arrangements

Job summary

Allegion Canada Inc. is seeking a Sr. Oracle DBA & System Administrator to design, implement, and optimize Oracle E‑Business Suite R12 databases on Exadata hardware.

You will lead provisioning, patching, monitoring, and automation while ensuring secure operations and 24/7 availability. With 10+ years of hands‑on experience, you will provide technical leadership, mentor DBAs, and coordinate with cross‑functional teams for deployments, DR tests, and major incidents.

Qualifications

• Minimum 10+ years’ hands‑on experience as an Oracle DBA & System Administrator supporting Oracle E‑Business Suite R12.
• Proven experience with Oracle Exadata hardware (installation, configuration, tuning, patching and troubleshooting).
• Strong experience with Oracle Enterprise Manager (OEM) for monitoring and administration.
• Solid expertise with RMAN backups, recovery scenarios, disaster recovery concepts; experience with Data Guard is a plus.
• Experience designing and executing cloning procedures for EBS environments (Rapid Clone, AD utilities, RMAN, hot/cold clones).
• Experience configuring and tuning databases and application tiers for parallel concurrent processing and Concurrent Manager optimization.
• Experience implementing and supporting model routing in EBS and configuring additional application servers to support routing and workload distribution.

Responsibilities

• Administer and support Oracle E-Business Suite R12 databases and related components on Oracle Exadata hardware.
• Install, configure, patch and upgrade Oracle databases, Grid Infrastructure, ASM and related components necessary for EBS R12.
• Implement and maintain end‑to‑end monitoring using Oracle Enterprise Manager (OEM): configure alerts, metrics, reports and dashboards for database and application availability, performance and capacity.
• Design, document and operate robust backup and restore procedures (RMAN, Data Guard where applicable), and validate recovery procedures with regular restore tests.
• Create, document and execute cloning procedures for Dev/Test/QA/DR environments (Rapid Clone, AD utilities, RMAN‑based clones), including automation where appropriate.
• Configure and tune the database and application tier to support high‑volume parallel concurrent processing (Concurrent Manager tuning, parallel execution settings, resource allocation and scheduling).
• Configure and support model routing within the EBS environment, including setup and management of additional application servers and routing of concurrent processing across servers.
• Perform performance monitoring, capacity planning and proactive tuning (SQL tuning, instance parameters, resource management).
• Troubleshoot and resolve production incidents; perform root cause analysis and implement preventative measures.
• Maintain security, user access controls, patching cycles and compliance for databases and Exadata systems.
• Provide technical leadership and knowledge transfer: create runbooks, standard operating procedures, train and mentor other DBAs and system administrators.
• Work with cross‑functional teams (applications, network, storage, middleware) for deployments, upgrades, DR tests and major incidents.
• Participate in an on‑call rotation for after‑hours support as required.
• Travel to data centers or other company locations for deployments, DR testing or hardware upgrades as needed.
• Lead efforts to automate database lifecycle activities using standard tools and practices.
• Lead architecture and design reviews for new EBS/Exadata projects, upgrades or migrations.
• Collaborate with Security and Compliance teams on audits (PCI, SOX) and enforce database‑related security controls.
• Evaluate new Exadata features Oracle releases and third‑party tools, and provide recommendations to leadership.
• Develop and maintain capacity‑planning models, cost analyses and lifecycle roadmaps for database infrastructure.
• Own the development and maintenance of runbooks, playbooks and knowledge‑base articles for self‑service.
• Participate in cross‑team post‑incident reviews and continuous improvement activities.

Skills

Oracle DBA

System administration

SQL

PL/SQL

Shell scripting

Automation tools

OCI/AWS/Azure familiarity

Education

Bachelor's degree in computer science, Information Systems, or related field

Tools

Oracle Exadata

Job description

Allegion Canada Inc. is seeking a Sr. Oracle DBA & System Administrator to design, implement, and optimize Oracle E‑Business Suite R12 databases on Exadata hardware.

You will lead provisioning, patching, monitoring, and automation while ensuring secure operations and 24/7 availability. With 10+ years of hands‑on experience, you will provide technical leadership, mentor DBAs, and coordinate with cross‑functional teams for deployments, DR tests, and major incidents.