DATABASE ADMINISTRATOR

Company: University of Washington
Location: Seattle
Posted on: May 27, 2023

Job Description:

If you are using a screen reader and experience any difficulty accessing our web pages, please call 206-543-2544 or email UWHires and we will be happy to assist you. jump to content Department: OFFICE OF RESEARCH INFORMATION SERVICES (ORIS) Job Location: Seattle - Other Job Location Detail: This is a hybrid position in an open office environment. 100% remote work can be considered on an individual basis. Benefits: As a UW employee, you will enjoy generous benefits and work/life programs. For a complete description of our benefits for this position, please visit our website, click here. As a UW employee, you have a unique opportunity to change lives on our campuses, in our state and around the world. UW employees offer their boundless energy, creative problem-solving skills and dedication to build stronger minds and a healthier world.

UW faculty and staff also enjoy outstanding benefits, professional growth opportunities and unique resources in an environment noted for diversity, intellectual excitement, artistic pursuits and natural beauty.

The University of Washington is one of the world's preeminent public universities in impact and funding. Since 1972, the UW has continued to receive more externally sponsored research funding than any other U.S. public university and we are one of the few universities in the U.S. with total research funding nearing two billion. That funding drives crucial, ground-breaking research that transforms lives around the globe. In the Office of Research at UW, we take pride in creating an outstanding climate of support for UW researchers that helps them compete and succeed. However, the complexity of research administration and regulation grows each day.

POSITION PURPOSE
The Database Administrator (DBA) will be responsible for ensuring the stability, performance, and security of the databases that sustain the Office of Research systems and integrations with UW's enterprise resource planning system, Workday. This position advances the Office of Research's mission to support the integration of electronic research information systems. This will reduce the administrative burden on researchers across the University by improving the amount of time researchers can spend on researching; improving University compliance; and ensuring that the University can continue to be at the forefront of academic research.

The Database Administrator position is charged with ensuring that database resources meet security, performance, availability, reliability, and availability requirements. The DBA will partner with development teams across multiple areas and will need to work with different database systems and hosting platforms. The DBA will provide consultation and assistance in database design and will be responsible for provisioning, optimization, operations, and business continuity. The DBA will work to ensure secure and dependable database performance and operations through implementation, test, integration test, and migration and Production deployment and cutover phases.

The Office of Research supports a culture of diversity, equity, and inclusion. Recognizing and valuing all of our differences makes our office stronger and enhances our support for researchers; it will enrich the research carried out at the UW. Read more about DEI in the Office of Research on our website

The DBA supports databases across platforms and products, both in the cloud and on-premises. The DBA must provide support through all phases of development as well as production. A successful person in this position must ---

Collaborate and consult with multiple teams of diverse staff including junior and senior engineering staff as well as technical leads, product owners, and project managers across multiple parts of the University.

Align database configuration, maintenance, and operations with overall Office of Researcher IT operational goals and business objectives that support UW's -$1.7 billion research enterprise.

Lead, plan, and advise on the strategic and tactical direction of all facets of database administration across multiple products, from meeting minimum security requirements to ensuring stability, performance, and availability requirements are met.

As an administrator responsible for ensuring the security and reliability of core database operations, this position advances the Office of Research's mission to support the integration of electronic research information systems. This position supports the systems that process -$1.7 billion in grant awards. This will reduce the administrative burden on researchers across the University by improving the amount of time researchers can spend on researching; improving University compliance; and ensuring that the University can continue to be at the forefront of academic research.

DUTIES AND RESPONSIBILITIES

Operations and Database Administration

• Provision and configure new database environments and databases.
  
• Maintain configuration and management of databases across Non-Prod and Prod environments.
  
• Implement and maintain regular database backup and retention plans.
  
• Ensure that databases operate within security, reliability, and availability requirements.
  
• Ensure that database archiving and disposition requirements are met.
  
• Determine, implement, and maintain performance monitoring and tuning strategies.
  
• Configure logging and monitoring to ensure reliable and accurate reporting on database 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.
  
  Technical Planning, Consultation, and Collaboration
  
• Partner with development teams to ensure database components and mechanisms meet all functional and non-functional requirements.
  
• Participate in UW-IT and UW Medicine ITS integration initiatives that involve supported systems.
  
• Participate in organizational risk assessment activities, security planning, and vendor analysis.
  
• 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.
  
  Maintenance and Troubleshooting
  
• 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 database issues as they pertain to production support and non-production support requests.
  
• Ensure business continuity and disaster recovery for supporting databases.
  
• Troubleshoot and resolve incidents arising around and within the databases.
  
  Professional and Organizational Development
  
• Engage in professional development opportunities and share knowledge attained with other staff.
  
• 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 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.
  
  Administrative Duties
  
• Attend recurring organization meetings and one-on-ones with a supervisor.
  
• Engage in unplanned communications.
  
• Participate in recurring HR processes.
  
  MINIMUM REQUIREMENTS
  
• Bachelor's degree in Computer Science, Math/Statistics or equivalent experience.
  
• 6 Years of experience in database administration to include at least the following minimum professional experience:
  - 6 years hands-on experience as an individual contributor on database
  implementation, maintenance, and operation in accordance with industry
  standards, data policies, and security best practices using:
  - Enterprise relational database management system such as Oracle, Microsoft
  SQL Server, or IBM Db2.
  - Indexing strategies.
  - DB performance and monitoring tools such as SolarWinds or Redgate.
  - Query profiling and optimization tools.
  - ETL tools such as SQL Server Integration Services.
  - Modeling tools such as erwin or DbSchema.
  - Secure data management practices.
  
• 2 years' experience configuring and managing databases in a cloud environment - either AWS or Azure (AWS preferred).
  
  Equivalent education/experience will substitute for all minimum qualifications except when there are legal requirements, such as a license/certification/registration.
  
  ADDITIONAL REQUIREMENTS
  
• 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.
  
  DESIRED QUALIFICATIONS
  Experience with:
  
• Workday suite of applications/modules.
  
• Workday data model, security, integrations and data load capabilities.
  
• 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, etc.
  
• Information Security standards and frameworks.
  
• Working in a Scrum-Agile environment.
  
  Application Process: The application process may include completion of a variety of online assessments to obtain additional information that will be used in the evaluation process. These assessments may include Work Authorization, Cover Letter and/or others. Any assessments that you need to complete will appear on your screen as soon as you select "Apply to this position". Once you begin an assessment, it must be completed at that time; if you do not complete the assessment you will be prompted to do so the next time you access your "My Jobs" page. If you select to take it later, it will appear on your "My Jobs" page to take when you are ready. Please note that your application will not be reviewed, and you will not be considered for this position until all required assessments have been completed.
  Applicants considered for this position will be required to disclose if they are the subject of any substantiated findings or current investigations related to sexual misconduct at their current employment and past employment. Disclosure is required under Washington state law .
  
  Committed to attracting and retaining a diverse staff, the University of Washington will honor your experiences, perspectives and unique identity. Together, our community strives to create and maintain working and learning environments that are inclusive, equitable and welcoming.To request disability accommodation in the application process, contact the Disability Services Office at 206-543-6450 or dso@uw.edu .COVID-19 VACCINATION REQUIREMENTEmployees of the University of Washington are required to be fully vaccinated against COVID-19 unless a medical or religious exemption is approved. Being fully vaccinated means that an individual is at least two weeks past their final dose of an authorized COVID-19 vaccine regimen. As a condition of employment, newly hired employees will be required to provide proof of their COVID-19 vaccination. View the Final candidate guide to COVID-19 vaccination requirement webpage for information about the medical or religious exemption process for final candidates.

Keywords: University of Washington, Seattle , DATABASE ADMINISTRATOR, IT / Software / Systems , Seattle, Washington