Oracle Database Administrator

St. George's University•Englewood, CO

15h

About The Position

The Oracle Database Administrator will assist in directing and performing activities that maintain a successful database environment and support core business systems critical to the Organization’s strategic plan and mission. The role administers and manages Medforth’s enterprise databases and supports SQL- and Oracle-based applications, including ERP, LMS, CRM, data warehouse, Apex, and .NET applications, to help ensure they operate efficiently and effectively. The DBA works across multiple environments and manages database administration, maintenance, upgrades, patching, cloning, query analysis, optimization, security, backup and recovery, performance, and capacity planning. The position also supports related enterprise applications and Ellucian Banner services, collaborates on new database environments, maintains technical documentation, and works with colleagues, business partners, and vendors. The role is part of a team that provides 24x7 support when required. The typical work week is 40 hours, Monday through Friday, 9 a.m. to 5 p.m. Flexible hours and availability outside normal working hours are required to implement strategies and initiatives and deliver work; the employee may need to start early or work late. Occasional travel may be required. The anticipated salary range is $124,000–$135,000 per year; the final offer may vary based on job-related knowledge, skills, experience, location, and education.

Requirements

BA/BS in Computer Science, Information Systems, Mathematics, Engineering, or a similar technical field, or equivalent experience.
Minimum 3–5 years of DBA experience.
ERP, CRM, LMS system, or equivalent enterprise application experience.
Experience with Ellucian Banner.
Strong verbal and written communication skills, including the ability to explain complex concepts to technical and non-technical audiences.
Ability to work within a matrixed management organization while supporting multiple projects and deadlines.
Ability to manage multiple projects and adjust priorities based on institutional needs.
Ability to coordinate assignments and establish deployment schedules.
Demonstrated experience supporting a diverse customer platform with individualized, high-touch service.
Demonstrated problem-solving skills and ability to logically analyze complex processes and systems.
Hands-on experience in process mapping, process improvement, and process re-engineering.
Knowledge of IT Service Management best practices.
Working knowledge of Oracle Database Appliance (ODA) management and patching and maintenance in a VM IT landscape; working knowledge of Oracle Data Store (ODS).
Knowledge of Oracle 19c, Oracle WebLogic Fusion Middleware, Oracle Streams, RMAN, Oracle Data Guard, and Oracle RAC.
Demonstrated experience with disaster recovery strategies, Oracle Grid Control, and Java (JDeveloper, J2EE, Apache); knowledge of data warehousing and workflow.
Experience managing and maintaining multiple development and production Oracle database environments, including database tuning, cloning, backups, and security maintenance or Oracle user access as a security administrator.
Thorough understanding of the technical architecture of Ellucian Banner, including current releases such as Banner 9.
Experience installing and working with third-party applications used with Banner, such as Evisions, Intellichecks, TouchNet, PayMyTuition, Parchment, and Learning Management Systems.
Understanding of application SSO and Azure SAML for the Banner 9 release.
Relevant experience with Oracle Cloud Control.
Availability outside typical work hours when needed, flexibility to work early or late, and ability to travel occasionally.

Nice To Haves

Experience in higher education.
Certifications in relevant supported products.

Responsibilities

Administer and manage the Organization’s enterprise databases across multiple environments and perform database maintenance in a multi-user operating system environment.
Assist with database upgrades, patching, cloning, query analysis and optimization, and ERP, CRM, and LMS software patching in development and production environments.
Collaborate in designing, planning, and implementing new database environments.
Install, configure, and upgrade Oracle server software and related products, including Ellucian and Banner-related services and tools.
Evaluate Oracle features and related products.
Establish and maintain backup and recovery policies and procedures.
Implement and maintain database security and the integrity of the enterprise database infrastructure; create and maintain users and roles and assign privileges.
Design, build, patch, upgrade, tune, and support a multi-instance database environment.
Perform database and application tuning and performance monitoring.
Establish standards to help ensure application designs and code meet integrity, security, and performance requirements; review designs and code for adherence to organizational standards.
Assist with impact analysis of changes to database objects.
Plan for growth and changes through capacity and performance planning.
Write complex technical documentation and complex SQL; debug complex SQL.
Influence, train, mentor, and leverage the skills of colleagues, business partners, and technical teams.
Work as part of a team and provide 24x7 support when required.
Interface with vendors for technical support.
Perform other duties and projects as assigned.