Campus Pride Jobs

Oracle Data Base Administrator

 

Salary: Depends on Qualifications

 

Job Type: FT Exempt Salaried Staff

 

Job Number: FY2503218

 

Closing: 9/16/2024 11:59 PM Mountain

 

Location: 800 W University Parkway, Orem

 

Division: VP Digital Transformation/CIO

 

Position Announcement

 

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.

 

Summary of Responsibilities

 

• Design, Engineer & Advise: 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.

• Monitoring and Maintenance - 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

• Troubleshooting and Maintenance: Perform database transaction and security audits. Install and configure 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. anages third party integrations with UVU production data platform while maintaining UVU security interests. Manage sharing of resources among applications. Troubleshoots with problems regarding the data platform, applications, and development tools.

• Governance: Establish appropriate end-user database access control levels. Assess and develop 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, (i.e., how many test instances we have, recommended backup strategies, etc.). 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.).

• Professional Development - Professional Development - Contribute to a robust culture of professionalism and personal development by keeping up with current trends in the BI Engineering space and help UVU (Utah Valley University) prepare to adjust and lead in those trends.

• Performs other job related duties as assigned.

 

Minimum Qualifications

 

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, Skill, and Abilities

 

Knowledge

 

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

 

Skills

 

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

• Be able 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.

 

Abilities

 

• Able to handle multiple projects and deadlines.

• Ability to conduct research into database issues, standards, and products as required.

• A bility to communicate clearly and concisely, both orally and in writing.

• Ability to establish and maintain effective working relationships with others.

• Ability to exhibit integrity, ingenuity, and inventiveness in the performance of assigned tasks.

• Ability to adapt to changing requirements and priorities.

• Ability to solve critical issues and be proficient at troubleshooting production issues.

• Ability to prioritize and execute tasks in a high-pressure environment.

• Ability to provide prev