Oracle Database Administrator

University Support Services; United States; On-site; USD 124,000 - 135,000; Full time

Job summary

University Support Services, LLC is seeking a seasoned Oracle Database Administrator to maintain enterprise databases and ensure SQL and Oracle-based applications (ERP, CRM, LMS, Data Warehouse, Apex, and .Net) run efficiently. The role covers upgrades, patching, backups, security, and performance tuning across development and production environments.

You will design and implement new database environments, manage multi-instance setups, and mentor team members while coordinating with vendors.

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 across multiple environments and perform distinct functions
• Administer and maintain databases in a multi-user OS environment
• Assist with 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 products including Ellucian Banner components
• Establish and maintain backup/recovery policies and database security
• Design, build, patch, upgrade, tune, and support multi-instance database environments
• Tuning and performance monitoring of databases and applications
• Write complex SQL and technical documentation
• Provide 24x7 support as part of a team
• Interface with vendors for technical support
• Work within a matrixed management organization across multiple projects

Skills

SQL

Oracle DBA

Security management

Disaster recovery

Performance tuning

Education

BA/BS in Computer Science, Information Systems, Mathematics, Engineering, or related field

Equivalent experience

Tools

Oracle WebLogic

Oracle 19c

RMAN

Dataguard

Oracle RAC

Banner 9 Admin

Ellucian Banner

Oracle Cloud Control

Job description

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 are 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
• 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.