Data Engineer/DBA (Temporary)

Responsibilities

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

• 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

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

Professional and Organizational Development

• Maintain an awareness of industry, institutional, and organizational trends, best practices, and standard solutions
• Socialize key concepts, industry best practices, and organizational principles, strategies, and conventions related to data and database administration to both technical and non-technical staff via mentoring, meetings, hands-on learning, and documentation
• Become familiar with research administration in an R1 university setting in order to streamline its supporting business processes