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