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

University of Washington; Seattle (WA); On-site; USD 110,000 - 160,000; Full time

Job summary

ORIS is seeking a Database Administrator/Database Engineer for a 12-month project. You will stabilize, optimize, and secure databases across cloud and on‑prem environments, reporting to the IT Technology Services Manager at UW.

Responsibilities include design, deployment, tuning, backups, disaster recovery, and production support, with collaboration across development teams and organizational risk/security planning.

Qualifications

• 6 years hands-on experience in SQL database administration and software engineering database support
• Experience with enterprise production environments and performance tuning
• Proven backup/DR strategy design and cloud retention
• Secure data management practices
• Experience with relational database schemas and data modeling

Responsibilities

• Design, deploy, configure, maintain, and deprecate database environments to support applications
• Develop and assist with SQL query design for reporting and applications
• Automate repetitive tasks to improve performance
• Maintain databases across Non-Prod and Prod to ensure uptime
• Participate in code reviews and development practices
• Implement and maintain backup and retention plans
• Monitor performance, security, and availability of databases
• Coordinate data migrations and system upgrades
• Monitor ETLs and schedule processes; respond to failures
• Research and address alerts and production issues
• Ensure business continuity and disaster recovery for ORIS databases
• Troubleshoot incidents in data infrastructure

Skills

SQL database administration

Software engineering database support

Database performance tuning

Backup and disaster recovery

Secure data management

Relational database design

Education

Bachelor’s degree in Engineering, Computer Science, Math/Statistics, Business

Tools

SolarWinds

Datadog

RDS Database Insights

Redgate

Job description

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