IT System Administration - Journey

State of Washington • King County - Seattle – Other, WA

2d • Onsite

About The Position

The Washington State Patrol (WSP) is committed to being an Equal Opportunity Employer and fostering an environment where everyone is encouraged to be their authentic selves. The Information Technology Division (ITD) supports the agency's mission by leveraging technology. This position is part of the ITD's Forensics Laboratory Services Bureau (FLSB) IT Support Unit, primarily serving the Toxicology Laboratory Division (TLD) which operates two forensic labs. The Toxicology Lab analyzes approximately 20,000 cases annually for various substances for coroners, medical examiners, law enforcement, attorneys, and the State Liquor and Cannabis Board. The FLSB also manages five multi-service crime laboratories, provides expert testimony, supports the Statewide Sexual Assault Kit Tracking System, and assists with the Impaired Driving Section and the Washington State FBI Combined DNA Database Information System (CODIS) Lab. This role is crucial for maintaining the operational status of FLSB software systems, enabling the Bureau to deliver its mandated services. The new team member will ensure daily system operation and uptime, monitor and resolve data integrity issues, act as the primary contact for system-related problems, and provide technical support to end-users. Responsibilities include coding, debugging, and testing SQL for data repair and validation, communicating system status and downtime, maintaining system security and user access controls, investigating and resolving system issues, documenting system behavior, and managing work order requests. The role also involves analyzing requests for feasibility and impact, translating business requirements into technical specifications, developing functional specifications, coding and verifying SQL queries for reports and data extracts, and ensuring adherence to CJIS and WSP security policies, including chain of custody and data integrity. The position will also design, test, and support reports and reporting systems, ensure data sharing agreements and security policies are enforced, respond to public disclosure requests, maintain instrument interfaces and network connectivity, develop testing techniques, and establish data collection strategies and standards.

Requirements

• Bachelor's in Computer Science, Information Technology, or a STEM field that provided relevant training AND Four years' of recent and relevant Information Technology experience such as consulting, analyzing, designing, programming, installing and/or maintaining computer software applications, hardware or network infrastructure equipment.
• OR An associate's degree or completion of an accredited vocational training program in an information technology program AND Six years of recent and relevant Information Technology experience such as consulting, analyzing, designing, programming, installing and/or maintaining computer software applications, hardware, or network infrastructure equipment.
• OR Eight Years' of recent and relevant IT experience such as consulting, analyzing, designing, programming, installing and/or maintaining computer software applications, hardware, or network infrastructure equipment.
• Three years of database, application or system administration experience with 1 year experience developing applications or reports using Structured Query Language (SQL), analyzing and debugging applications.
• Two years' of experience troubleshooting, problem solving, analyzing, and supporting IT systems throughout their entire lifecycle.
• The ability to take action to learn and grow.
• The ability to take action to meet the needs of others.
• Applicants must possess work authorization that does not require employer sponsorship.

Responsibilities

• Ensure daily, regular system operation and up time.
• Monitor system data integrity, resolving any discrepancies or issues.
• Serve as the primary point of contact for system-related issues, troubleshooting, resolution, and liaison to vendors.
• Provide technical support for end users.
• Code, debug, and test SQL code to repair routine issues with data records and perform data validation to ensure accuracy of changes.
• Communicate system status and scheduled downtime to systems users and other stakeholders.
• Maintain system security and ensure systems operate within all applicable security policies.
• Manage user roles, permissions, and access controls to ensure secure and appropriate access.
• Investigate system issues by identifying, documenting, and providing a resolution or requesting assistance from vendors or database teams.
• Provide high level knowledge of expected system behavior.
• Author and maintain up-to-date documentation for the system(s).
• Ensure problem management and resolution of work order requests.
• Troubleshoot and remediate incidents of varying complexity.
• Respond to all user requests by either fulfilling request or redirecting to appropriate IT service entity.
• Create and maintain documentation.
• Analyze requests to determine feasibility, impact to other business processes or systems, and compliance with Agency policies.
• Translate business requirements and functional specifications into technical requirements.
• Accept requests for changes from business stakeholders, elicit information to develop business requirements, and define use cases, then develop functional specifications for implementation.
• Code, debug, and verify intermediate to high level SQL queries to provide needed reports and data extracts.
• Use SQL queries to extract data from audit logs and system tables to recreate a sequence of events or determine the point at which a problem occurred.
• Adhere to CJIS and WSP security policy; make changes in a way that preserves chain of custody and/or system of record data integrity.
• Maintain confidentiality, integrity, availability, consistency and quality of system data.
• Determine when to reject requests that may result in incorrect or unethical updates to system data.
• Design, test, implement, and support reports, reporting systems, or data retrieval processes.
• Ensure data sharing agreements and security policies are enforced at all times.
• Respond to public disclosure requests and system searches within the specified timeline.
• Maintain instrument interfaces and connectivity to WSP network.
• Develop testing techniques to ensure cross-application impacts have been assessed and proper operation confirmed.
• Develop and implement data collection strategy for reporting or other applications to fulfill business requirements.
• Develop and administer data standards required to maintain and preserve data integrity including metadata.
• Establish and maintain data flow and architecture diagrams for the lifecycle of instrument data.

Benefits

• Flexible schedules
• Telework options
• Infants at Work Program
• Continuous growth and development opportunities
• Opportunities to serve your community and make an impact through meaningful work
• Employment opportunities that recognize military veterans and/or military spouse per Governor Executive Order 19-01
• Qualification for the Public Loan Forgiveness Program

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree