Database Administrator / Data Engineer (12 Month Project)-2

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. Key Responsibilities 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 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 Required Qualifications To be considered for this opportunity your application must demonstrate you meet both the minimum qualifications and additional qualifications listed below. Equivalent education and/or experience may substitute for minimum qualifications except when there are legal requirements, such as a license, certification, and/or registration. Minimum Qualifications Bachelor’s degree in Engineering, Computer Science, Math/Statistics, Business A minimum of 6 years of experience in SQL database administration and software engineering database support to include at least the following minimum professional experience: 6 years of the 6 years hands‑on as an individual contributor on database implementation, maintenance, and operation in accordance with industry standards, data policies, and security best practices using SQL. The six years should include the following: Expertise troubleshooting application database issues in an enterprise production environment Expertise with database performance tuning, indexing, query profiling, query optimization, and monitoring, and the tools associated with these tasks (such as SolarWinds, Datadog, RDS Database Insights, and/or Redgate) Proven success designing, implementing, and maintaining backup and disaster recovery strategies and retention lifecycles in a cloud environment Experience with secure data management practices Experience designing, implementing, and maintaining relational database schemas, structures, and models to #J-18808-Ljbffr University of Washington