Senior Applications Developer
- Summary
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 full stack Senior Applications Developer to be part of a team to modernize an existing legacy Laboratory Information Management System (LIMS) and support it into the future. 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.
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 of about 65 scientists.
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.
Commitment to Equity and Social Justice:
As the only jurisdiction in the world named after Dr. Martin Luther King, Jr., one of the most influential civil rights leaders in our nation's history, King County is a vibrant international community with residents that represent countries from around the world. It is a region with increasing diversity that cherishes the traditions of many cultures.
We have a deep commitment to equity and social justice and advancing practices, strategies, and policies that promote fairness, justice, and opportunity for all – in our workplaces and our communities. With this commitment, King County has adopted a pro-equity agenda to advance regional change and ensure that residents from vulnerable communities are incorporated into our emergency planning and public outreach efforts. To learn more, please visit http://www.kingcounty.gov/equity.
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. It is expected that this position will be intermittently allowed to telework when the workflow permits.
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 webpages.
- 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.
- Minimum five years' experience working with major relational databases such as Oracle, SQL Server, and/or MySQL; developing stored procedures, relational modeling, maintaining an Entity Relationship Diagram (ERD) and database tuning.
- Knowledge of object-relational mapping, such as Entity Framework.
- Experience using databinding patterns such as Model View Controller (MVC) and Model View – View Model (M-V-VM).
- 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.
- Experience using the .Net development stack.
- Experience developing within a REST Web API architecture.
- Experience developing unit and integration testing.
- Experience developing in a modern JavaScript SPA framework (React preferred).
- Advanced knowledge of User Interface (UI) programming.
- 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.
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 and completeness. This includes the online application, resume, and responsiveness to the list of supplemental questions that outline your qualifications, skills, and abilities. The most competitive candidates will be invited to participate in a selection process that may include a phone interview, testing, code review, and one or more panel interviews. Applications without the following required materials may not be considered for this position.
- King County application
- Resume
- Responses to supplemental questions
For more information regarding this recruitment, please contact:
Deena Prasad, Senior Human Resource Analyst
Phone: 206-263-0101
Email: deprasad@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.
King County offers a highly-competitive compensation and benefits package designed to meet the diverse needs of our employees and support our employees' health and well-being. Eligible positions receive the following benefits and have access to the following programs:
- Medical, dental, and vision coverage: King County pays 100% of the premiums for eligible employees and family members
- Life and disability insurance: employees are provided basic coverage and given the opportunity to purchase additional insurance for both the employee and eligible dependents
- Retirement: King County employees are eligible to participate in a pension plan through the Washington State Department of Retirement Systems and a 457(b) deferred-compensation plan
- Transportation program and ORCA transit pass
- 10 paid holidays each year (plus 2 personal holidays)
- Generous vacation and paid sick leave
- Paid parental leave, family and medical leaves, and volunteer leave
- Flexible Spending Account
- Wellness programs
- Onsite gyms and activity centers
- Employee giving program
- Employee assistance programs
- Flexible schedules and telecommuting options, depending on position
- Training and career development programs
This is a general description of the benefits offered to eligible King County employees, and every effort has been made to ensure its accuracy. If any information on this document conflicts with the provisions of a collective bargaining agreement (CBA), the CBA prevails. Also, in the event of any incorrect information in this document, applicable laws, policies, rules, CBAs, or official plan documents will prevail.
NOTE: Benefits for Term Limited Temporary (TLT) or Short Term Temporary (STT) positions, including leave eligibility and/or participation in the pension plan through the Washington State Department of Retirement Systems, will vary based upon the terms and details of the position. Short Term Temporary positions are not eligible for an ORCA transit pass.
For inquiries about the specifics of this position, please contact the recruiter identified on this job posting.
-
01Are you applying to this position as an eligible Current or Previous King County Employee Priority Placement Program Participant AND Is this position the same or lower percentage of full-time when compared to the position held at the point of the notification of layoff AND Do you possess the skills and abilities to qualify for this position?
- Yes, I was given a layoff notice from my role at King County AND I am within two years of the effective date of my layoff. AND The position I was laid off from was the same or a higher percentage of FT status when compared to this one.
- No.
02If you answered yes to the question above and you are applying for this position as a Priority Placement Participant, to be considered, you must provide the following three pieces of information in the space provided: 1. The title you held when you received your layoff notice 2. The department you worked in 3. The effective date of your layoff03How many years of experience do you have with .Net?04How many years of experience do you have with JavaScript UI Frameworks? How many years of React experience do you have?05How many years of experience do you have with SQL programming & tuning on a major database platform (e.g. Oracle, Microsoft, MySQL)? Which platforms have you used?06How many years of experience do you have with web API programming?07How many years of experience do you have with practicing unit and integration testing?08How many years of experience do you have with Azure and/or other cloud services?09Describe your work on a major project which demonstrates your web and relational database experience. Include the project size, complexity, and number of team members. What primary technologies were used? What were your primary contributions? What were the biggest challenges? Were the projects successful? (Limit your answer to no more than one page)10How does your education and experience make an excellent candidate for this position? (Limit your answer to no more than one page)Required Question