Job Information
UTAH VALLEY UNIVERSITY Data Platform Engineer III - BIDP in OREM, Utah
Data Platform Engineer III - BIDP
Salary: $66,210.00 - $88,280.00 Annually
Job Type: FT Exempt Salaried Staff
Job Number: FY2503037
Closing: 9/30/2024 11:59 PM Mountain
Location: 800 W University Parkway, Orem
Division: VP Digital Transformation/CIO
Position Announcement
Utah Valley University is seeking a Data Platform Engineer III - BIDP to 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. More experienced candidates will proactively identify technical obstacles early and work closely with the team to find creative solutions to build prototypes & develop deployment strategies, procedures .procedures to ensure the integrity and availability of databases and their accompanying software. Works in support of an Oracle based administrative system Ellucian Banner.
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. Manages third party integrations with UVU production data platform while maintaining UV 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) More than 5 years of related experience, or equivalent combination of education and related experience. At least 3 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
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.
Ab ility 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.
jeid-16eb0794ff4f3043952b3397