Senior Applications Developer

The Environmental Lab (KCEL) is a Section of the Department of Natural Resources and Parks (DNRP) Water and Land Division (WLRD). DNRP's mission is to provide regional parks and trails; protect the region's water, air, land, natural habitats, and historic properties; and reduce, safely dispose of and create resources from wastewater and solid waste. KCEL is a full-service environmental laboratory that provides quality field, laboratory, regulatory, and advisory services in support of King County and other publicly sponsored programs that protect and enhance water quality. (See http://www.kingcounty.gov/depts/dnrp/wlr/sections-programs/environmental-lab.aspx for more details).

KCEL is currently looking for a Term-Limited-Temporary full stack Senior Applications Developer to be part of a team to modernize an existing legacy Laboratory Information Management System (LIMS). Specifically, this project is focused on replacing the legacy Oracle Forms front end with a web-based solution. The primary technologies on this project are: an on prem Oracle database server, Oracle SQL, C#, .Net 5, Azure App Service hosted Web APIs, Azure DevOps CI/CD pipelines, React, Typescript, Telerik React UI components and Cascading Style Sheets (CSS). The project workflow utilizes Azure DevOps product backlog items and corresponding Kanban boards. The project is expected to end 12/31/2024.

This project offers several unique opportunities for job satisfaction: ground floor custom development working on a small dedicated team with an experienced technical leader, leveraging modern technologies to provide an efficient new system that drives the daily activities of a well engaged, on-site user community.

This position will work under an IT Supervisor both independently and collaboratively as a member of the KCEL LIMS Project Team and KCEL’s scientific staff. Duties of this job encompass all areas of custom software development lifecycle including customer interaction, eliciting user requirements, extracting requirements from the existing codebase, workflow analysis, designing, data modelling, programming, reviewing others code, assisting with test plans, testing and formally documenting all work. Duration: This is a term-limited temporary (TLT) position that is expected to last three and a half (3 1/2) years.

Who is Eligible: This position is open to the public.

Work Location: This position is located at the King County Environmental Lab, 322 West Ewing Street, Seattle, WA 98119. However, work will also be completed remotely due to the telecommuting mandate implemented by the County’s COVID-19 pandemic response.

Work Schedule: This position is exempt from the overtime provision of the Fair Labor Standard Act (FLSA) and is not overtime eligible. This full-time position works a 40-hour work week.

Job Duties Incrementally develop, release, and support modernized replacement for existing Lab Information Management System (LIMS) front end application. Duties include:

Learn aspects of a complex environmental science business domain and an in-depth understanding of those client needs. Learn business needs and determine systems requirements through client meetings and system analysis. Practice creative approaches to designing the new system to run in PARALLEL compatibility with all the existing legacy systems. Manage the full software development life cycle – conception, requirements analysis, specification design, coding, testing, documenting, training, user acceptance refinement, rollout, and support of project modules. Manage and regularly communicate personal work status to supervisor, team members, and customers. Provide user support, training, and documentation. Provide code comments and documentation of the project’s software, architecture, and processes to ensure other team members can review code and support each other. Independently develop project modules and individual web-pages. Perform an advanced degree of relational database programming on Oracle platform, including relational table design, stored procedures, set-based query design, and performance tuning. Perform an advanced degree of programming in both dotnet core C# web API domain and typescript React front end domain. Evaluate existing applications for process efficiency, system integrity, security, and data quality; proactively manage risks; redesign and replace selected application sub-systems as needed. Experience, Qualifications, Knowledge, Skills Required Qualifications

Bachelor’s degree in computer science, engineering, or management information systems (MIS), or the equivalent combination of education and experience. Minimum three years' experience developing in a multi-user production environment using the .Net development stack. Minimum five years' experience working with major relational databases (Oracle, SQL Server, MySQL, etc), developing stored procedures, relational modeling, maintaining an ERD and database tuning. Minimum two years' experience developing unit and integration testing. Knowledge of object-relational mapping, such as Entity Framework. Minimum three years' experience developing within a REST Web API architecture. Minimum three years' experience developing in a modern javascript SPA framework (e.g. React, Angular, Vue). Advanced knowledge of relational database and web frontend programming environments. Familiarity with cloud integration and Microsoft Azure. Advanced knowledge of software engineering principles, practices, and software development life cycle. Advanced skills in analyzing client business processes. Knowledge of Agile and Scrum project management principles and methods. Expertise in analysis, problem solving and troubleshooting. Ability to translate user needs, through strong written and oral communication skills, to design requirements and technical documentation. Unintimidated by multiple competing priorities. Strong customer service ethic. Inspired by working with a diverse team environment. The Most Competitive Candidates May Have: Experience working for clients in chemical or biological sciences. Experience with a Laboratory Information Management System. Experience developing Oracle SQL (stored procedures, views). Experience modernizing a legacy application to a web-based platform. Experience contributing to design of a .Net stack application architecture. Specialization in modern CSS (cascading style sheets), e.g. CSS grid. Three years' React experience versus another SPA framework. Necessary Special Requirements: Employment will be contingent upon successfully passing a background check. Supplemental Information Application and Selection Process: Application materials will be screened for clarity, completeness including online application, cover letter and resume, and responsiveness to the list of qualifications, skills, and abilities. The most competitive candidates will be invited to participate in a selection process that may include testing, code review, and one or more panel interview. Applications without the following required materials may not be considered for this position.

King County application Resume Cover Letter detailing your background and what you can bring to this position Responses to supplemental questions Union Representation: This position is not represented by a union.

For more information regarding this recruitment, please contact: Deena Prasad, Senior Human Resource Analyst Phone: 206-263-0101 Email: dprasad@kingcounty.gov

Forbes recently named King County as one of Washington State's best employers.

Together, with leadership and our employees, we're changing the way government delivers service and winning national recognition as a model of excellence. Are you ready to make a difference? Come join the team dedicated to serving one of the nation's best places to live, work and play.

Guided by our 'True North', we are making King County a welcoming community where every person can thrive. We value diversity, inclusion and belonging in our workplace and workforce. To reach this goal we are committed to workforce equity. Equitable recruiting, support, and retention is how we will obtain the highest quality workforce in our region; a workforce that shares and will help advance our guiding principles--we are one team; we solve problems; we focus on the customer; we drive for results; we are racially just; we respect all people; we lead the way; and we are responsible stewards. We encourage people of all backgrounds and identities to apply, including Native American and people of color, immigrants, refugees, women, LGBTQ+, people living with disabilities, and veterans.

King County is an Equal Employment Opportunity (EEO) Employer No person is unlawfully excluded from employment opportunities based on race, color, religion, national origin, sex (including gender identity, sexual orientation and pregnancy), age, genetic information, disability, veteran status, or other protected class. Our EEO policy applies to all employment actions, including but not limited to recruitment, hiring, selection for training, promotion, transfer, demotion, layoff, termination, rates of pay or other forms of compensation.

To Apply If you are interested in pursuing this position, please follow the application instructions carefully. If you need this announcement in an alternate language or format, would like to request accommodation or assistance in the application or assessment process or if you have questions please contact your recruiter listed on this job announcement.