Database Administrator​/Data Engineer; Project

Job Description

ORIS has an outstanding opportunity for A Database Administrator/Database Engineer (12-month Project) to join their team.

Reporting to the IT Technology Services Manager, the Database Administrator/Database Engineer (DBA/DE) is responsible for ensuring the stability, performance, and security of the databases and data. This position supports databases across platforms and products, both in the cloud and on-premises and provides support through all phases of development as well as providing production support.

This is an essential position and may be required to report to work when UW suspends operations.

Operations and Administration – 60%

• Design, deploy, configure, maintain, and deprecate database environments, databases, data schema, and data elements to support novel applications development and support
• Develop and assist with SQL query design for applications and reporting to meet organizational needs and ORIS commitments
• Recommend, design, implement, and maintain automation to reduce repetitive software development and maintenance tasks and increase application performance
• Maintain configuration and management of databases across Non‑Prod and Prod environments to ensure optimal uptime and performance for ORIS products and services
• Engage and participate in ORIS’ culture of review both as reviewer and reviewee to ensure shared knowledge of development practices and high‑quality code
• Implement and maintain regular database backup and retention plans to ensure that database archiving and disposition requirements are met
• Determine, implement, and maintain performance monitoring and tuning strategies to ensure that databases operate within security, reliability, and availability requirements
• Configure logging and monitoring to ensure reliable and accurate reporting on database and application health and performance
• Participate in software release (possibly including off hours release and update times)
• Plan and carry out any needed data migrations and system upgrades and updates
• Monitor ETLs and other regular or scheduled database processes and take appropriate steps when failures occur
• Research and respond to alerts and notifications of real or potential issues to proactively communicate and address problems
• Research data and database issues as they pertain to production support and non‑production support requests, including application SQL queries
• Ensure business continuity and disaster recovery for ORIS databases
• Troubleshoot and resolve application and data infrastructure incidents

Technical Planning, Consultation, and Collaboration – 25%

• Partner with development teams to ensure data and database components and mechanisms meet all functional and non‑functional requirements, including data modeling, data schema design, database design, query development and optimization, and similar tasks
• Participate in UW technology integration initiatives that involve ORIS supported systems
• Participate in organizational risk assessment activities, security planning, and vendor analysis to ensure solutions meet data and data infrastructure standards
• Build strong relationships, working with diverse technical and business partner groups, both internal and external to the University of Washington
• Effectively communicate and collaborate technical information with a wide range of people with varying levels of technical expertise

Administrative Duties – 10%

• Attend recurring organization meetings and one‑on‑ones with a supervisor.
• Engage in unplanned communications
• Participate in recurring HR processes

Professional and Organizational Development – 5%

• Maintain an awareness of industry, institutional, and organizational trends, best practices, and standard solutions
• Socialize key concepts, industry…