Oracle Database Administrator

Utah Valley University - Orem, UT

Full-time - Mid Level

Orem, UT

Educational Services

About the position

Utah Valley University is seeking a skilled Oracle Database Administrator to ensure the smooth operation of the UVU Data Platform across on-premises and cloud environments. This role is vital in maintaining the availability, integrity, and efficiency of the platform, which includes Oracle Databases, Oracle RAC, Azure Data Lake, Azure Synapse, MSFT SQL Server environments, and API Management. Key responsibilities include managing production environment backups, disaster recovery, business continuity, performance tuning, and database maintenance. A focus on automation, consistent performance, and reliable delivery is essential for success in this role. The ideal candidate will proactively identify and address technical challenges, working closely with the team to develop innovative solutions and deployment strategies that uphold the integrity and availability of databases and their accompanying software. This position also supports the Oracle-based administrative system, Ellucian Banner, ensuring a robust and resilient data infrastructure that aligns with the university's goals. Join UVU and contribute to the continued success of its data operations.

Responsibilities

• Develops and maintains scheduled auto database instance cloning mechanism to clone production instance to any testing.
• Develops and maintains data loading/refresh mechanisms for all other IT related database and Data Platform instances.
• Creates and maintains data platform roles and profiles to ensure appropriate access to information.
• Monitors and analyzes the performance of all other Dx related database instances, fine tuning where necessary.
• Develops plans and supporting information relating to the RDBMS and host platform.
• Verifies satisfactory short- and long-term data platform operations of all other Dx related data platform instances.
• Establishes and maintains an up-to-date library of relevant publications and resource materials.
• Attends conferences, seminars and training classes and any other meeting necessary.
• Serves as a technical resource for other Dx personnel.
• Ensures data platform backups can be restored.
• Partners with others to design and implement UVU Disaster Recover and Business Continuity plans.
• Ensures cross training of UVU Platform Administrators.
• Creates and maintains all databases required for development, testing, education, and production usage.
• Performs the capacity planning required to create and maintain the databases.
• Plans and implements the backup and recovery of the Data Platform.
• Plans, maintains, and tests Data Platform (Oracle Database, ADLS Gen2, Synapse, etc.) backup and recovery procedures.
• Monitors and analyzes performance of data platform database instances and fine tunes where necessary.
• Reviews production Data Platform alerts, logs, and performance daily.
• Designs and builds resilient systems and processes.
• Performs ongoing tuning of the data platform.
• Performs database transaction and security audits.
• Installs and configures relevant network components to ensure data platform access and database consistency and integrity.
• Maintains and keeps current on availability of applicable vendor releases and associated installation requirements; installs updates and releases in a timely and organized manner.
• Verifies availability of testing database instances, allowing user community many opportunities to explore and test.
• Uses log files, related trace files and other methods for troubleshooting and optimization of backup, system up-time and serviceability of third-party integrations.
• Manages third party integrations with UVU production data platform while maintaining UVU security interests.
• Manages sharing of resources among applications.
• Troubleshoots with problems regarding the data platform, applications, and development tools.
• Establishes appropriate end-user database access control levels.
• Assesses and develops long-term strategic goals for production databases with data owners and department managers.
• Audits current content and availability of relevant Oracle RDBMS and IAS patches and upgrades.
• Documents UVU DBA best practices and processes for database setup, backup, tuning and troubleshooting, serves as expert of Database services office procedures.
• Establishes standards & guidelines for UVU Databases that will be followed / implemented by other DBAs.
• Determines Oracle Standards for UVU (i.e., File Structure, Directory Structure, etc.).
• Contributes to a robust culture of professionalism and personal development by keeping up with current trends in the BI Engineering space.

Requirements

• Bachelor's Degree (Master's degree preferred) and more than five years of related experience, or equivalent combination of education and related experience totaling nine years.
• At least 3 industry certifications related to the tools used in the job are required or required to be received within the first 90 days of employment.
• Knowledge of the tools and methodologies of data analysis, database administration and performance analysis and tuning.
• Knowledge of the availability, integrity, and security as well as performance management of various Oracle OLAP and reporting databases.
• Strong knowledge of database structures, theories, principles, and practices.
• Technical experience with designing, building, installing, configuring, and supporting database servers including Oracle RAC.
• Knowledge of data processing flowcharting techniques.
• Knowledge of data privacy practices and laws.
• Experience with a team-oriented, collaborative environment with limited supervision.
• A good knowledge of the way Oracle enforces data integrity.
• A sound knowledge of both database and program code performance tuning.
• A good knowledge of Oracle security management.
• Knowledge of Database Encryption methods.
• 7+ years of relevant Database Platform Support experience.
• Skilled with Database tuning and troubleshooting.
• Skilled at project management.
• Strong analytic skills.
• Strong aptitude and willingness to learn and master new technologies.
• Skills with technical documentation.
• Good interpersonal and customer service skills.
• Ability to provide strategic database direction for the organization.
• Excellent knowledge of Oracle backup and recovery scenarios.
• Experience and knowledge in migrating code, database changes, data, and menus through the various stages of the development life cycle.

Nice-to-haves

• Experience with Azure Data Lake and Azure Synapse environments.
• Familiarity with MSFT SQL Server environments.
• Experience in a higher education environment.

Benefits

• Dental insurance
• Employee assistance program
• Employee discount
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Parental leave
• Professional development assistance
• Retirement plan
• Tuition reimbursement
• Vision insurance