Oracle Database Administrator

University Support Services, LLC; Englewood (CO); On-site; USD 124,000 - 135,000; Full time

Job summary

University Support Services, LLC seeks an Oracle Database Administrator to maintain enterprise databases and ensure SQL/Oracle-based applications such as ERP, LMS, CRM, Data Warehouse, Apex and .Net run efficiently.

Responsibilities include database upgrades, backups, security, tuning, and cross-team collaboration. Requires 3–5 years DBA experience, preferably in higher education and Ellucian Banner. Travel may be required.

Qualifications

• BA/BS in Computer Science, Information Systems, Mathematics, Engineering, or similar technical degree or equivalent experience
• Minimum 3-5 years DBA experience required; experience in higher education strongly preferred
• ERP, CRM, LMS System or equivalent Enterprise Application experience required; experience in Ellucian Banner required
• Certifications in the relevant supported products strongly preferred

Responsibilities

• Manage databases in a multi-user OS environment
• Administer databases and related applications in development and production environments
• Assist with database upgrades, patching, cloning, query analysis, and ERP/CRM/LMS patching
• Collaborate to design, plan, and implement new database environments
• Install, configure and upgrade Oracle server software and related tools
• Evaluate Oracle features and related products
• Establish and maintain backup and recovery policies and procedures
• Implement database security and manage users/roles with privileges
• Design, patch, upgrade, tune, and support multi-instance environments
• Perform database and application tuning and performance monitoring
• Ensure application design/code integrity, security, and performance
• Review designs and code for standards adherence
• Assist with impact analysis of changes to database objects
• Plan capacity and performance growth
• Write complex SQL and technical documentation
• Mentor and collaborate with teammates and partners
• Interface with Vendors for support
• 24x7 support when required
• Travel as needed

Skills

Strong communication

Project coordination

Teamwork

Problem solving

IT Service Management

Education

BA/BS in Computer Science or related

Tools

Oracle Database

Banner ERP

Job description

Oracle Database Administrator

The Oracle Database Administrator (DBA) will assist in directing and performing all activities related to maintaining a successful database environment and supporting the core business systems critical to the Organization’s strategic plan and mission. Responsibilities of the position includes but is not limited to administration and management of all of Medforth’s enterprise databases, and ensuring SQL and Oracle-based related applications, such as the Enterprise Resource Planning (ERP) system, Learning Management Systems (LMS), Customer Relationship Management (CRM), Datawarehouse, Apex and .Net applications operate efficiently and effectively.

Essential Functions

• Ability to manage across multiple environments performing separate and distinct functions
• Perform the administration and maintenance of databases in a multi-user operating system (OS) environment
• Assist with database upgrades and patching, cloning, query analysis, and optimization, and ERP, CRM, LMS software patching in both development and production environments
• Collaborate to design, plan, and implement new database environments
• Install, configure and upgrade of Oracle server software and related products. Install and configure Ellucian Solution Manager (ESM), Application Navigator, Banner 9 Admin Pages and Banner 8 & 9 Self-Service, Jenkins Agent and Ellucian Ethos Identity and Integration services
• Evaluate Oracle features and Oracle related products
• Establish and maintain sound backup and recovery policies and procedures
• Implement and maintain database security. Manage the overall security and integrity of the Organization's enterprise database infrastructure. Create and maintain users and roles and assign privileges
• Design, build, patch, upgrade, tune, and support the multi-instance database environment
• Perform database and application tuning and performance monitoring
• Implement standards to ensure that all application design and code is produced with proper integrity, security, and performance
• Perform reviews on the design and code to ensure the Organization’s standards are being adhered to
• Assist with impact analysis of any changes made to database objects
• Plan growth and changes by completing capacity and performance planning
• Write complex technical documentation
• Influence, train, mentor, and leverage the skills of others, including business partners and technical team
• Write and debug complex Structured Query Language (SQL)
• 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

Essential Knowledge, Skills & Abilities

• Strong verbal and written communications skills with the ability to articulate complex concepts to both technical and non-technical audiences
• Demonstrated ability to work within a matrixed management organization while effectively supporting multiple projects and deadlines
• Ability to work on multiple projects simultaneously and adjust priorities based on institutional need
• Ability to coordinate assignments and establish deployment schedules
• Desire to work as part of a team
• Demonstrated experience in interfacing and supporting a diverse customer platform with a focus on individualized and high touch point service
• Desire for continual professional growth and self-motivation to achieve goals while modeling professional integrity and behavior throughout
• 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 Dataguard, Oracle RAC
• Demonstrated experience with Disaster Recovery Strategies, Oracle Grid Control, Java (JDeveloper, J2EE, Apache), Knowledge of Data Warehousing and Knowledge of Workflow
• Demonstrated experience in managing and maintaining multiple development and production Oracle database environments such as DB tunning, cloning and backups and security maintenance or Oracle users’ access as a security administrator
• Thorough understanding of the technical architecture of the Ellucian Banner software, including the latest releases (inclusive of Banner 9)
• Demonstrated experience with installation and working knowledge of third-party applications that are used with Banner such as Evisions, Intellichecks, TouchNet, PayMyTution, Parchment and Learning Management Systems
• A demonstrated understanding of application SSO and Azure SAML for the Banner 9 release
• Relevant experience with Oracle Cloud Control

Qualifications

• BA/BS in Computer Science, Information Systems, Mathematics, Engineering, or similar technical degree or equivalent experience
• Minimum 3-5 years DBA experience required; experience in higher education strongly preferred
• ERP, CRM, LMS System or equivalent Enterprise Application experience required; experience in Ellucian Banner required
• Certifications in the relevant supported products strongly preferred

Hours and Travel

• A typical work week is 40 hours Monday through Friday 9am to 5pm, however employee must be available during non-work hours
• Flexible hours required to implement strategy, enterprise initiatives and execute deliverables
• Must be flexible in coming in early, working late or during non-work hours as needed
• This job may require occasional travel

The anticipated salary range for this position is $124,000 - $135,000 per year. The final salary offered may vary and will be determined based on factors such as job-related knowledge, skills, experience, location, and education of the successful candidate. This information is provided per local law.

USS is an equal opportunity employer. As such, it is company policy to fill positions with qualified candidates regardless of race, color, sex (including sexual orientation and gender presentation), age, religion, ancestry, national origin, citizenship status, pregnancy, marital status, medical condition, genetic information, disability, status in the Uniformed Services of the United States (including veteran status) or status as a victim of domestic violence, except where there is a bona fide occupational qualification. This policy protects applicants and employees from discrimination in the hiring process.