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

University of Washington•Seattle, WA

12d•$117,600 - $124,800•Hybrid

About The Position

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.

Requirements

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.
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 support application and pipeline performance, maintainability, and data integrity
Experience partnering directly with software engineering teams through the application lifecycle to support data structure and data infrastructure needs (such as creation, transformation, optimization, support, etc.)
Experience with peer review and collaboration on data schemas, stored procedures, and data model changes to ensure adherence to standards, data quality, performance, maintainability, and security
Experience with Microsoft SQL Server
Experience supporting ETL processes and data integrations, and using associated tools (such as SQL Server Integration Services (SSIS), AWS Glue, Informatica, or Alteryx)
2 years of the six years to include experience configuring and managing databases in the AWS cloud environment including services such as RDS, EC2, DMS, and infrastructure as code (Terraform or CloudFormation)
2 years of the six years to include experience with data engineering practices incorporating AI capabilities, including:
Proven success leveraging generative AI, agent-based solutions, and automation technologies to accelerate database administration and data engineering activities that result in improved operational efficiency, decision support, or engineering outcomes
Demonstrated application of generative AI, AI-powered agents, machine learning and other AI tools to support and improve data engineering lifecycle activities, artifacts, and assets
Experience evaluating, selecting, implementing, and supporting AI-enabled tools and services appropriate for cloud-based data engineering environments
Demonstrated ability to communicate clearly and effectively in both oral and written mediums with individuals and groups in order to socialize information and knowledge with a diverse group of colleagues
Demonstrated ease in technical and non-technical review as both reviewer and reviewee in order to facilitate collaborative group activities such as change control and pull request review

Nice To Haves

Experience with AWS Services such as Glue, DMS, Quicksight, Redshift, data pipeline
Performing security audits and reviews of databases and data systems
REST API development and management platforms, such as MuleSoft or Boomi (Mulesoft preferred)
Open-source database technologies: PostgreSQL, MySQL, MongoDB, Oracle, etc.
Information Security standards and frameworks
Working in a Scrum-Agile environment
Workday suite of applications/modules
Workday data model, security, integrations, and data load capabilities

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
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
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
Attend recurring organization meetings and one-on-ones with a supervisor.
Engage in unplanned communications
Participate in recurring HR processes
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