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

Utah Valley University Provo, United States

3 weeks ago

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 tuningA good knowledge of Oracle security management. Knowledge of Database Encryption methods.

Skills:
7+ years of relevant Database Platform Support experienceSkilled with Database tuning and troubleshootingSkilled 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 premiumsEmployer HSA contribution for those that elect the university's High-Deductible Health PlanOther tax advantage, reimbursement account options (i.e.

Flexible Spending Account & Dependent Care)Dental and vision plan optionsIncentivized wellness programEmployer paid basic life, Accidental Death and Dismemberment (AD&D), and Long Term Disability (LTD) coverageEmployee 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 equivalentAssociatesBachelorsMastersPh.
D.Ph.
D. (abd)Juris Doctorate

02

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

Required Question
#J-18808-Ljbffr

Database Administrator

1 week ago

ConsultNet Provo, United States

Database Administrator · Salt Lake City, UT · Long-Term Contract: $50-$80 per hour · Our client is in search of Database Administrator to join their team on a long-term contract. · Project Work: · Convert existing Oracle PL/SQL code to PostgreSQL while ensuring functionality ...
Database Administrator

6 hours ago

Insight Global Utah, United States

Must-haves: · 3-5 years of experience in the job offered or a related Database Administration role SPECIAL SKILLS AND/OR LICENSES REQUIRED TO PERFORM THE JOB: · Must have 3-5 years of experience with: For DB2 candidate : * · Supporting the following platforms: Red Hat Enterpris ...
Principle Database Administrator

5 days ago

OpenText Provo, United States

Principle Database Administrator, Open Text, Inc., Provo, UT: · * * · Lead DBA Team and Supporting Database environments for Oracle, PostgreSQL, MSSQL, MySQL & DB2. Perform database maintenance, migration, and upgrade hardware and software enhancing the success and performance. ...
Oracle Database Administrator

3 weeks ago

BYU Provo, United States

BYU's Office of Information Technology (OIT) is passionate about supporting thousands of students, faculty, and staff of our campus community every day. We are committed to growth, whether that is through offering employee trainings to build skills or providing students with inva ...
Oracle Database Administrator

3 weeks ago

BYU Provo, United States

BYU's Office of Information Technology (OIT) is passionate about supporting thousands of students, faculty, and staff of our campus community every day. We are committed to growth, whether that is through offering employee trainings to build skills or providing students with inva ...
Sr. Oracle Database Administrator

3 weeks ago

Utah Valley University Provo, United States

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/202 ...
Database Administrator

5 days ago

BankTalent HQ Midvale, United States

Zions Bancorporation's Enterprise Technology and Operations (ETO) team is transforming what it means to work for a financial institution. With a commitment to technology and innovation, we have been providing our community, clients and colleagues the best experience possible for ...
Senior Database Administrator

2 weeks ago

Insurance Services Office Lehi, United States

Company Description We help the world see new possibilities and inspire change for better tomorrows. Our analytic solutions bridge content, data, and analytics to help business, people, and society become stronger, more resilient, and sustainable. Job Description * Aid in databas ...
Senior Database Administrator

1 week ago

NetDocuments Lehi, United States

· NetDocuments is the world's #1 trusted cloud-based content management and productivity platform that helps legal professionals do their best work. We strive to win together through passionate hard work, exploring new things and recognizing every interaction matters. · NetDocu ...
Senior Database Administrator

3 weeks ago

Verisk Analytics Lehi, United States

Company Description · We help the world see new possibilities and inspire change for better tomorrows. Our analytic solutions bridge content, data, and analytics to help business, people, and society become stronger, more resilient, and sustainable. · Job DescriptionAid in data ...
Senior Database Administrator

2 weeks ago

Cotiviti South Jordan, United States

Senior Database Administrator Job Locations · US-Remote ID · Category Engineering/IT · Position Type Full-Time Overview · As a Senior Database Admin, you will help drive team(s) in meeting project objectives. You are expected to contribute to and foster high performing technical ...
Senior Database Administrator

3 weeks ago

PointClickCare South Jordan, United States

For more than 20 years, PointClickCare has been the backbone of senior care. We've amassed the richest senior care dataset making our market density untouchable and our connections to the healthcare ecosystem exponentially more powerful than those of any other platform. · With C ...
Oracle EBS Database Administrator

1 week ago

Zions Bancorporation Midvale, United States

Zions Bancorporation's Enterprise Technology and Operations (ETO) team is transforming what it means to work for a financial institution. With a commitment to technology and innovation, we have been providing our community, clients and colleagues the best experience possible for ...
Project Assistant

4 days ago

Aurora Solutions Vineyard, UT, United States Freelance

**Your Responsibilities**: · As a project assistant (m/f/d), you will work closely with our project developers, internal cross-departmental teams, and external project partners such as planners, experts, companies, neighbors, and authorities, and have an important interface funct ...
Oracle Database Specialist

1 week ago

Professional Solutions LLC Provo, United States

Professional Solutions Delivered, LLC (ProSoDel) is a total solutions provider for government and commercial customers in the areas of Program Management, Logistics, Organizational Change Management, Communications, Training, and Information Technology (IT) Support Services. We a ...
Oracle Database Architect

5 days ago

Professional Solutions LLC Provo, United States

Professional Solutions Delivered, LLC (ProSoDel) is a total solutions provider for government and commercial customers in the areas of Program Management, Logistics, Organizational Change Management, Communications, Training, and Information Technology (IT) Support Services. We a ...
Oracle Database Architect

1 week ago

Professional Solutions LLC Provo, United States

Professional Solutions Delivered, LLC (ProSoDel) is a total solutions provider for government and commercial customers in the areas of Program Management, Logistics, Organizational Change Management, Communications, Training, and Information Technology (IT) Support Services. We a ...
Cardiac Implantable Device Specialist

3 weeks ago

Intermountain Healthcare Provo, United States

Job Description: · This position is responsible for providing clinical, educational, research and administrative support for the implantable device program. The position coordinates the interrogation of the implantable devices which includes device data that is acquired during on ...
Office Administrator

2 weeks ago

Advisor Employee Services Provo, United States

Office Administrator · Are you looking for an opportunity to utilize superior client service skills and work one-on-one with clients? If you enjoy developing long-term relationships and providing superior administrative support, we would like to talk to you · Whether you are see ...
System Administrator-FT-IT-Provo

3 weeks ago

Reverhealth Provo, United States

At Revere Health, we believe there is a better path to healing and healthcare maintenance, and we're working on this mission-one patient at a time. We're a national leader in a movement called value-base care which aims to improve treatment outcomes and keep costs down. Our inter ...