Database Developer/Administrator – IT Data Management (Journey)

JOB About WSDOTWashington 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.
The OpportunityWSDOT’s Technology Services Division (TSD) is seeking an experienced IT professional to fill a Database Developer/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 Developer/Administrator, you will provide advanced skill level database administration, data integration and reporting of the department's Microsoft SQL databases, and Azure SQL Databases.
This position will ensure compliance with IT Division's Service Level Agreements with WSDOT customers, and maintain open, constructive communications with IT staff and with WSDOT customers and WSDOT business partners.
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 ExpectAmong the varied range of responsibilities held within this role, the Database Developer/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.
QualificationsTo 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.
ORFour (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.
ORSix (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 analysisExperience 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 follow the directions in the Contact Us section of this posting.
Important Notes In addition to base salary, employees may be entitled to other forms of compensation depending on the type, duties, or location of the position.
For union-represented positions, more information on other forms of compensation can be found in the applicable Collective Bargaining Agreements.
Information on other compensation types for non-represented positions can be found in Chapter 357-28 of the Washington Administrative Code.
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, 2023.
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.
WSDOT does not use the E-Verify system, therefore we are not eligible to extend STEM Optional Practical Training (OPT).
For more information, please visit www.
uscis.
wa.
gov.
Why WSDOT 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 ApplyApplications 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.
All persons, regardless of race, ethnicity, age, veteran status, sexual orientation, and/or gender identity, 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 via email.
Contact UsFor inquiries about this posting, you may contact the assigned Recruiter, Robyn Lovely at Robyn.
Lovely@wsdot.
wa.
gov.
Please be sure to reference 23DOT-HQ-05102 in the subject line.