Thanks for visiting our job posting. The Housing & Food Services IT Team invites you to consider joining us as we work together to support HFS in delivering excellent service to our student residents, staff, faculty and visitors to the University of Washington.
The Database Developer/Administrator works on MSSQL dBMS, SQL dBs, PowerBI and Data analytics tools and will have the opportunity to experience and contribute to the UW-wide conversion to a new financial system that will touch and transform everyone’s work. This is also a tremendous opportunity to work within an organization that is sensitive to the work life impacts of the pandemic and is taking our lessons learned to improve our services and work environment.
View additional information about HFS, and this position here.
PURPOSE The Database Developer/Administrator (payroll title = Senior Computer Specialist) is responsible for all operational data throughout the Enterprise and the connected data sources, including new data sources and connecting them to a coherent data warehouse, to support business analytics, operations reporting and customer – client data management with various visualization tools.
The Database Developer/Administrator works with project management, Operations, Business users and Clients to gather requirements and design, create, and implement database systems based on their requirements and operational needs. The DDA supports existing database servers, data systems and participates in their design, implementation, optimization, and ongoing management and maintenance. This role is vital to HFS’s drive for application availability, scalability and performance. The ideal candidate will have a wide range of experience supporting and interacting with several business units, operations, students, staff, and support teams.
Development (60%): •Provide lead support in the creation and modification of the data warehouse environment. •Review, design, and implement processes to backup, archive, and restore database information. •Designing logical and physical database structure to facilitate analysis of data from both operational and client perspectives. •Designing Architecture for ETL/SSIS packages and Designing SSIS packages with different data sources (SQL, Flat files and XMLs, etc.) and loaded the data into target source by performing various kinds of transformations. •Development and Deploying of the SSRS reports using reporting services. •Create, design, and maintain coding standards for the views and procedures used by the development staff in the application development process. •Create, design, and maintain data marts and/or data cubes. •Create and maintain a data dictionary that supports the HFS data structures. •Prepare functional and technical documentation for data applications and warehouses. •Maintain a solid understanding of the organization’s data sources to support BI Team.
DB Administration (30%): •Collaborate with the software engineers, systems, subject matter experts, and end-users to provide views of our data in support of business operations. •Communicating with the clients and end-users to gather, document, and track known issues and work with the development staff to solve the identified issues. •Lead the design and development of database(s) to meet customer needs, respond to/anticipate technological innovations, and support the technical infrastructure of HFS. •Work on the performance tuning of the database and Writing queries used for front-end applications. •Work with system administrators to devise, develop and implement disaster recovery and archiving procedures. •Maintain Alerts, notifications, Jobs, Job schedules. Monitor SQL server connections and locks and performance to track historical peak load on servers and proactively manage them. •Maintain database systems and support software, including analyzing, planning, and implementing database maintenance scripts or plans and installing software patches. •Assist systems administration with the install and tune database-related programs, when possible, also giving guidance for effective use of database features/functions/tools. •Manage database security including account administration, data encryption and network encryption.
Administrative (10%): •Maintain environment operations reports for leadership. •Provide support and leadership to department data initiatives. •Provide guidance and feedback on department analytics services. •Other duties may be assigned.
IMPACT TO THE UNIVERSITY This position supports the infrastructure for HFS. HFS supports students with housing and dining, the campus and visitors with dining, conference and meeting space.
POSITION COMPLEXITIES This position works with diverse, cross-functional teams. The position must be able to communicate technical information and requirements to a diverse group of end-users in an understandable way. The operating environment within HFS IT is complex, with multiple lines of business.
WORKING CONDITIONS Position works days, Monday through Friday. Hybrid schedule. Able to work from home up to two days a week. Additional work outside regular schedule is required infrequently for special projects and department special events.
SUPERVISION RESPONSIBILITIES The position has no direct reports but must facilitate work through others including most Business and Technical positions.
REPORTS TO Technical Manager
MINIMUM REQUIREMENTS •Bachelor’s degree in Computer Science, Business Administration or Related. Equivalent combinations of education and experience may substitute for requirements. •3 + years’ relevant experience, including some time architecting and developing schemas and stored procedures, and developing ETL, ELT and data warehousing solutions.
Additional requirements: •Programming languages: TSQL/SQL, C#, PowerShell, Java script •Excellent organizational, analytical, and interpersonal communication skills •Experience supporting business operations and reporting •Proficient in the use of a variety of analytic and reporting tools (R, Microsoft OLAP, SSRS, PowerBI, SSDS, SSRS, Etc.) •Experience with data management and modeling processes •Endpoints: SSAS, SSIS, SSRS, SharePoint, Web-Apps, and other information delivery platforms •Experience with analytical skills designing and using cubes and additional reporting and visualization tools •Familiarity with SDLC/AGILE DevOps environments
Equivalent education and/or experience may substitute for minimum requirements.
DESIRED REQUIREMENTS •Data Analysis on the Microsoft SQL platform •Experience with large data bases •Experience data marts or OLAP cubes •Experience with multiple databases (eg, SQL Anywhere, SQL Server, Oracle) •Experience supporting and administrating an ERP system (Dynamics GP, MAS 200, etc.) •Microsoft AZURE Database platform, Dynamics 365/Dynamics GP •Technologies: Kubernetes, Data Lake, Synapse •Workday, Microsoft CRM, other CMS platforms •Experience with SharePoint
CONDITION OF EMPLOYMENT The application process for UW positions 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.
Founded in 1861, the University of Washington is one of the oldest public institutions in the west coast and one of the preeminent research universities in the world. The University of Washington is a multi-campus university comprised of three different campuses: Seattle, Tacoma, and Bothell. The Seattle campus is made up of sixteen schools and colleges that serve students ranging from an undergraduate level to a doctoral level. The university is home to world-class libraries, arts, music, drama, and sports, as well as the highest quality medical care in Washington State and a world-class academic medical center. The teaching and research of the University’s many professional schools provide undergraduate and graduate students the education necessary toward achieving an excellence that will serve the state, the region, and the nation. As part of a large and diverse community, the University of Washington serves more students than any other institution in the Northwest.