Sr. Oracle Database Administrator - Provo, United States - Utah Valley University

Description

Salary: $73, $98,653.00 Annually

Location : 800 W University Parkway, Orem

Job Type: FT Exempt Salaried Staff

Job Number: FY

Division: VP Digital Transformation/CIO

Opening Date: 02/12/2024

Closing Date: 5/13/2024 2:40 PM Mountain

First Review Date: 03/12/2024

Required Documents Needed to Apply: Resume

Applicant Support:

Position Announcement

Tenaciously keep the UVU (Utah Valley University) Data Platform operational across various environments on-prem and in the cloud. The Data Platform engineer ensures the availability, integrity, and efficiency of the UVU Data Platform. Responsible for production environment backups, disaster recovery, business continuity, performance tuning database maintenance and support. The UVU Data Platform includes Oracle Databases, Oracle RAC, Azure Data Lake, Azure Synapse, MSFT SQL Server environments and API Management. Success in this role will require focus on automation, consistency of performance and reliability of delivery. Proactively identify technical obstacles early and work closely with the team to find creative solutions to build prototypes & develop deployment strategies, procedures.
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.
• 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. Manages 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.).
• Coach, Train and guide other team members through Data Platform Engineering across the Oracle, Azure Synapse, SQL Server, ADLS Gen2 and other components of the platform. 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.
• 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.
• Other duties as assigned.

Minimum Qualifications

Bachelor's Degree (Master's degree preferred) plus 10 years of related experience, or equivalent combination of education and related experience. At least 5 industry certifications related to the tools used in the job are required or required to receive within the first 90 days of employment.
Knowledge, Skill, and Abilities

Knowledge:

• Expert 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.
  
• Ability 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 preventative maintenance, troubleshooting, and quick resolution of routine problems to ensure data platform infrastructure and application stability.

EEO Statement:

UVU employment decisions are made on the basis of an applicant's qualifications and ability to perform the job without regard to race, color, religion, national origin, sex, sexual orientation, gender identity, gender expression, age (40 and over), disability, veteran status, pregnancy, childbirth, or pregnancy-related conditions, genetic information, or other bases protected by applicable federal, state, or local law.

Utah Valley University's dedication to exceptional care offers quality service and benefits to employees while staying committed to meeting the needs of a diverse workforce.

UVU is pleased to offer a competitive and comprehensive benefits package that supports employees and their family's overall physical and mental health, protects their income in case of unforeseen illness and life events, and assists in building financial security for retirement and the future.

Highlights from Utah Valley University's benefits package include:

• Medical network and plan options with low employee premiums
• Employer HSA contribution for those that elect the university's High-Deductible Health Plan
• Other tax advantage, reimbursement account options (i.e. Flexible Spending Account & Dependent Care)
• Dental and vision plan options
• Incentivized wellness program
• Employer paid basic life, Accidental Death and Dismemberment (AD&D), and Long Term Disability (LTD) coverage
• Employee Assistance Program (EAP)
• 401(a) Defined Contribution Plan with an employer contribution of 14.2% based on employee's compensation (100% vested on first day of full-time employment)
• Undergraduate tuition remission benefit waiving up to 18 credit hours (each semester) for employees and their eligible dependents (spouses & children dependents unmarried and up to age 26)
• Generous leave package which includes sick, vacation (staff only), and personal leave; 13 paid holidays; paid medical maternity and parental leave

For more information about the benefits offered, visit

01

What is your highest level of education?

• High School or equivalent
• Associates
• Bachelors
• Masters
• Ph.D.
• Ph.D. (abd)
• Juris Doctorate

02

How many years of experience do you have in this type of position?

• <1
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8+

Required Question