Senior Oracle DBA & System Administrator

Allegion•Remote, Colorado, CO

6d•$110,000 - $145,000•Remote

About The Position

The Sr. Oracle DBA & System Administrator is responsible for the design, implementation, administration and ongoing optimization of Oracle E-Business Suite R12 databases running on Oracle Exadata hardware. As a Sr. Oracle DBA & System Administrator, you will ensure availability, performance, backup/recovery and secure operations of the EBS database and related infrastructure; provide technical leadership; lead and develop automation efforts for database provisioning, patching, monitoring and deployment; and transfer knowledge to the broader team. This role requires 10+ years of hands-on experience supporting Oracle E-Business Suite R12 and Exadata environments. Qualified candidates must be legally authorized to be employed in the United States. The company does not intend to provide sponsorship for employment visa status (e.g., H-1B, TN, etc.) for this employment position. At Allegion, we recognize that great talent and breakthrough ideas can come from anywhere. That’s why this position offers a flexible remote work arrangement, with occasional on-site visits as needed based on the role. Whether you’re working remotely or collaborating in person, we’re committed to providing the tools, support, and dynamic environment you need to succeed. At Allegion, your career thrives where innovation meets flexibility, empowering you to achieve your goals while maintaining a healthy work-life balance. While this is the current structure and we currently have no plans to change, we reserve the right to make changes to the remote schedule as needed at the Company’s discretion.

Requirements

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.
Strong knowledge of ASM, Grid Infrastructure, Oracle RAC, Linux for Oracle, and storage/networking concepts as they relate to Exadata.
Proficiency in SQL, PL/SQL and shell scripting (bash); experience with automation/orchestration tools (Ansible, Puppet, Chef, etc.) and CI/CD is a plus.
Strong troubleshooting, analytical and problem-solving skills.
Excellent written and verbal communication skills; experience creating technical documentation and conducting knowledge transfer.
Oracle certifications (OCA/OCP/OCE) are preferred.
Bachelor’s degree in computer science, Information Systems, or related field preferred; equivalent relevant experience will be considered.
Must be able to participate in an on-call rotation and travel to data centers or other sites as required.

Nice To Haves

Hands-on experience with automation/orchestration tools beyond basic scripting
Familiarity with cloud or hybrid Exadata-Cloud architectures (OCI, AWS RDS, Azure)
Proficiency in a general-purpose scripting language (Python, Perl) for complex automation tasks
Understanding of database security standards and best practices (encryption-at-rest, key management)
Strong collaboration and stakeholder-management skills—able to translate technical concepts for business partners
Oracle Exadata Database Machine Administrator or Oracle Cloud Infrastructure certifications (preferred)
Commitment to continuous learning: staying current on Oracle technology roadmaps, best practices and emerging trends

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.

Benefits

Health, dental and vision insurance coverage
Unlimited Paid Time Off
401K plan with a 6% company match and no vesting period
Health Savings Accounts
Flexible Spending Accounts
Disability Insurance –Short-Term and Long-Term coverage
Life Insurance – Term life coverage with the option to purchase supplemental coverage
Tuition Reimbursement
Voluntary Wellness Program
Employee Discounts through Perks at Work
Community involvement and opportunities to give back
Opportunities to leverage your unique strengths through Clifton Strengths assessment & coaching