Washington State Department of Transportation
Washington State Department of Transportation (WSDOT) is the steward of an integrated, multimodal transportation system that helps to ensure people and goods move safely and efficiently throughout the state. In addition to building, maintaining, and operating the state highway system, WSDOT operates the largest ferry system in the nation, manages the world’s longest floating bridge, and recently completed the world’s widest tunneling project.
WSDOT’s Information Technology Division (ITD) is seeking an experienced IT professional to fill a Database Administrator vacancy in Tumwater, WA. This position is part of the Data Management Services Data Resource Management Team and is responsible for the administration, maintenance of modernized, cloud hosted databases and data integration processes for the Bridge Preservation Office (BPO). As the Database Administrator, you will provide advanced skill level database administration, data integration and reporting of the department’s Microsoft SQL databases, and Azure SQL Databases. Our top candidate must possess effective communication and interpersonal skills and the ability to communicate technical language to a diverse audience with ease.
What to Expect
This position ensures compliance with IT Division’s Service Level Agreements with WSDOT customers, and maintains open, constructive communications with IT staff and with WSDOT customers and WSDOT business partners.
Among the varied range of responsibilities held within this role, the Database Administrator will:
Independently function as the database administrator for the BPO transactional system databases.
Design and execute data architectures, policies, standards and data extraction and load routines for the agency’s business systems.
Provide development and implementation database support for BPO’s databases and applications including BridgeWorks/WSBIS and BEISt.
Consult and provide technical support to development staff on the creation of approved data access procedures.
Independently create processes to allow WSDOT to share data between internal business systems, federal systems, and other government agencies.
Design, implement, and maintain processes to provide geospatial data.
Plan, design, construct, and maintain reports which present and deliver information derived from agency data resources.
Construct and maintain complex SQL queries to gather consistent and correct data from multiple sources.
Compose report designs based on documented requirements and business preferences, present them to clients, and conduct review sessions to identify improvements needed.
Develop complex data presentations or sets of data, i.e., dashboards and information portals that present data integrated from different sources.
To be considered for this opportunity, at least one the following are required:
Eight (8) years of experience working in Information Technology within data management or application development. – OR
Four (4) years of experience working in Information Technology within data management or application development AND a four-year degree in computer science/information technology, mathematics, or closely related field. – OR
Six (6) years of experience working in Information Technology within data management or application development AND a two-year degree in computer science/information technology.
In addition to one of the above, the following are also required:
Four (4) years of technical experience administering Microsoft SQL Server databases.
*Experience must be recent, within the last eight (8) years.
Four (4) years of experience writing complex queries in SQL for data manipulation, storage, and reporting purposes.
Two (2) years of experience writing Extract Transform and load (ETL) packages.
Two (2) years of experience developing reports, creating data sources, reports, and security models.
It is preferred that qualified candidates also have:
Experience working with Crystal Reports.
Experience with SQL Server Reporting Services (SSRS).
Experience working with SQL Server Integration Services (SSIS).
Experience using ESRI tools to create spatially enabled data for analysis
Experience using Azure application and data platforms.
A Bachelor’s degree or higher in computer science, mathematics, or related field.
**To review the full Position Description, please contact the recruiter listed in the Contact Us section of this posting.
Required experience can be gained concurrently with other required skills.
This recruitment may also be used to fill additional positions per business needs.
This position is eligible for remote work up to 100%, per supervisor approval.
The recruiting efforts for this position may be extended beyond the displayed closing date for as long and until a sufficient candidate pool has been established. However, the first review of applications will be conducted December 19, 2022. The Appointing Authority reserves the right to make a hiring decision at any time thereafter. It is to your benefit to submit your application as soon as possible.
Washington Administrative Code (WAC) 357-16-197 mandates that all employees who work for executive cabinet agencies (which includes the Department of Transportation) must be fully vaccinated against COVID-19. Compliance with this mandate is a condition of employment with WSDOT. Exemption may be granted for religious or medical purposes; however, accommodations will be subject to approval based on the essential functions required of the position.
WSDOT does not use the E-Verify system. For more information, please visit www.uscis.gov
Work-Life Balance – We are committed to ensure that our staff experience the reward of public service, while also sustaining a routine that suits each individuals’ lifestyle. As such, there are a number of flexible schedule options available, including occasional telework for eligible positions.
Paid Leave – In addition to 12 paid holidays, full-time employees earn up to 25 paid vacation days per year!
Tuition Assistance – Permanent employees have several options for assistance with education expenses, including tuition reimbursement programs, government discounts at participating colleges throughout the state, and eligibility for federal student loan forgiveness.
Plan For Your Future – WSDOT offers a comprehensive benefits package that includes a variety of healthcare options. Employees also have their choice of state retirement programs, and much more. Go to State Benefits for more information.
Check out this video to learn more: Why WSDOT?
How to Apply
Applications for this recruitment will be accepted electronically. Your relevant experience may be evaluated to determine salary. Therefore, it is very important that the “Work Experience” portion of the application be completed in as much detail as possible.
In order to be considered for this opportunity, please include the following with your online application:
An attached Resume outlining (in reverse chronological order) your experience to date.
An attached Cover Letter that further explains your qualifications and indicates why you believe you are a viable candidate for this role.
Contact details for a minimum three (3) individuals who can attest to your work performance, technical skills, and job-related competencies. NOTE: This information may be entered in the “References” section of the online application; does not require an additional attachment.
Please click the “APPLY” button to proceed. Note that you will be prompted to either sign in or create an account. This step is required in order to submit an application to this opportunity.
WSDOT is an equal opportunity employer. We value the importance of creating an environment in which all employees can feel respected, included and empowered to bring unique ideas to the agency. Our diversity and inclusion efforts include embracing different cultures, backgrounds and viewpoints while fostering growth and advancement in the workplace. Women, racial and ethnic minorities, persons of disability, persons over 40 years of age, disabled and Vietnam era veterans, as well as people of all sexual orientations and gender identities are encouraged to apply. Persons with disabilities needing assistance in the application process, or those needing this job announcement in an alternative format may contact the listed Recruiter.
For inquiries about this posting, you may contact the assigned Recruiter, Robyn Lovely at LovelyR@wsdot.wa.gov. Please be sure to reference 22DOT-HQ-05102 in the subject line.
To apply for this job email your details to HQHR@wsdot.wa.gov