Forensic IT Systems Administrator - Hybrid

About the Agency & Division:The Washington State Patrol is committed to being an Equal Opportunity Employer and strives to foster an environment in which everyone is encouraged to be their authentic selves, communicate openly, and act with courage. The WSP is dedicated to promoting fair and equitable hiring, training, and promotional practices through innovative recruitment and retention strategies.

The Information Technology Division (ITD)exists to leverage technology to enhance and sustain business processes, public safety infrastructure, and statewide emergency communications to facilitate the accomplishment of all agency goals.

This position is a member of ITD's dedicated Forensics Laboratory Services Bureau (FLSB) IT Support Unit and is primarily assigned to the Toxicology Laboratory Division (TLD) who operate two forensic labs in the state. The Toxicology Lab performs analysis of samples for approximately 20,000 cases per year involving drugs, alcohol, and other substances for coroners, medical examiners, law enforcement agencies, attorneys, and the State Liquor and Cannabis Board.

The FLSB also operates five multi-service crime laboratories, provides expert testimony to the judicial system as required in criminal court cases, operates the Statewide Sexual Assault Kit Tracking System, supports Washington’s Impaired Driving Section and the Washington State FBI Combined DNA Database Information System (CODIS) Lab. This position is a critical member of the IT support team keeping FLSB software systems operating in order for the Bureau to provide its state mandated services.

Our new teammate will be able to:

• Responsible to 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…