Developer 3

Department: Information Technology

Anticipated Work Schedule: M-F

Reports To: Administrator, Web & Applications Development

Full Time or Part Time: Full Time

Regular or Temporary: Regular

Bargaining Unit: Non Bargaining

Classified or Unclassified: Classified

FLSA: Exempt

Summary

The purpose of the classification is to design, develop, implement and maintaining robust database solutions that support our organization's applications and data management needs. This role requires a strong understanding of database structures, theories, principles, and practices, as well as hands-on experience with SQL and other database programming languages.

This is a technical, advanced journey level classification in the Developer series. Employees at this level work under general supervision and are expected to work independently, exercising judgment and initiative. The Developer 3 possesses a thorough technical knowledge of software and application development and database structure. Tasks require regular innovative problem-solving within broadly stated guidelines. This classification is distinguished from the Developer 2 in that this classification provides technical consultation to IT Management, performs more complex analysis and development work, and contributes to the development of department standard operating procedures and best practices.

Essential Job Functions

The following duties are normal for this classification. These are not to be construed as exclusive or all-inclusive. Other duties may be required and assigned.

• Leads the planning, analysis, design, development, testing, and deployment of new software systems, applications, or websites; defines input and output system requirements and prepares graphic and narrative representations of solutions (including current and/or future business process flows, programmatical schemas, database and network diagrams); designs technical specifications (e.g., application architecture/infrastructure, database model, interfaces, security, object design and data access methods) to determine best method for meeting end-user needs; writes code for custom computer software using appropriate coding languages and development technologies; documents program development and revisions according to department procedures; develops advanced test scripts and data; conducts unit and/or system tests to ensure that the application or software produces the desired result and that all functionality works as specified; uses source debugger to identify and resolve non-routine processing errors and performance issues; performs post-implementation assessments; adheres to the department's design and coding standards and industry best practices; collaborates and coordinates with network engineering, security, and database administration teams to develop, debug, and architect solutions.

• Creates, maintains, and queries databases; designs and creates new relational database structures that are logical and normalized to support department initiatives; analyzes databases to ensure optimal performance and minimize utilization of server resources; writes stored procedures (database packages and SQL queries) to access data used for reports, applications, and extractions; maintains data integrity in relational databases; troubleshoots and resolves database issues.

• Collaborates with end users to determine business needs and solutions; consults with end users to identify and document business needs (software/system purpose, business workflow, output needs, etc.); identifies and develops alternative solutions; performs cost-benefit, feasibility, and impact analysis of proposed solutions; informs user about solutions that may meet their needs; performs postproduction support of business applications; writes, reviews, and coordinates development of training materials and user-guides for end users; follows up with clients to ensure satisfaction with project.

• Maintains and updates existing software systems, applications, and websites; makes complex updates and/or modifications to existing software to increase operating efficiency, adapt to new requirements, or include new functionality; resolves problems involving server operating systems, networks, applications, websites, third-party integrations, and other programming code; runs tests and debugs software and resolves security or infrastructure issues; consults with technical staff to troubleshoot problems; communicates software test results with end users; communicates with vendors to resolve problems or ask questions regarding third party Application Programming Interfaces (API); writes code for software integration between County applications or third-party API.

• Serves as team/technical lead on projects as assigned; assists IT management with estimating workload requirements; tracks projects via project tracking system; provides guidance to developers and application programmers in program techniques and technology; works with IT management to recommend, implement, and document best practices and standard operating procedures for software development; assists in the development of appropriate standards and criteria for programming and systems development lifecycle activities.

• Keeps current on emerging web and application development technologies; seeks out, studies, and recommends new technologies for future system solutions; performs technology and software assessment; attends trainings and online classes, and read blogs; performs presentations of off-site training received or seminars attended; utilizes a variety of software and programming tools/aids.

Minimum Requirements

• Bachelor's degree in computer science/engineering or a related field with six (6) years of experience in a data processing environment, application development and design, database development and design, or computer information systems; or any equivalent combination of training and experience as defined in the table below.

Highest degree of education attained

Experience required

HS diploma/GED or unrelated associate degree

8 years

Related associate or unrelated bachelor's/graduate degree

7 years

Related bachelor's degree or a relevant certification

6 years

Related master's/doctoral degree

3 years

• Related degree fields: computer science, computer engineering, mechanical or electrical engineering, physics, chemistry, biology, business administration, mathematics, statistics.

• Related certifications equivalent to a related bachelor's degree: Microsoft Developer certifications, AWS Certified Solution Architect, MS Certified Azure Solutions Architect.

• Related work experience: data processing environment, application development and design, database development and design, computer information systems, software development, software configuration, software engineering, programming, programming analysis, development, software/solution architecture, front-/back-end development.

Additional Requirements

• Ability to operate a variety of office machines and equipment including a computer and multifunction printer

• Ability to operate a variety of software and database systems including application Integrated Development Environments (Visual Studio, Visual Studio Code, Eclipse), database management software (SQL Server Management Studio, Oracle SQL Developer), database query languages (T- SQL, PL/SQL), programming languages and extensions (C#, TypeScript, .Net Core, ASP.Net MVC, ASP.Net Web Forms, JavaScript, CSS, HTML, Ruby, Vue.JS, , Java), spreadsheet software (MS Excel), version control system (Git), word processing software (MS Word), application lifecycle management (JIRA), content management system (Sitefinity), enterprise content/document management system (OnBase).

• Ability to assign, review, plan, and coordinate the work of other employees and to maintain standards

• Ability to provide instruction and training to other employees.

• Ability to solve and act on employee problems.

• Ability to add, subtract, multiply, divide, calculate decimals and percentages, and perform routine statistics, geometry, and algebra.

• Requires the ability to perform mid to upper-level data analysis requiring managing of data and people deciding the time, sequence of operations or events within the context of a process, system, or organization. Involves determining the necessity for revising goals, objectives, policies, procedures or functions based on the analysis of data/information and includes performance reviews pertinent to objectives, functions, and requirements.

• Ability to comprehend a variety of informational documents including program specifications, project requirements, termination program execution, source code, service desk tickets, databases, database and data warehouse structure, entity relationship diagrams, technical documentation, and other reports and records.

• Ability to comprehend a variety of reference materials and manuals including departmental policy manual, The Employee Handbook, requirement statements, relational database chart, technical books and websites, computer manuals, and status reports.

• Ability to prepare web applications and sites, statement of work, requirement statements, flow charts and layout design, web applications and sites, databases, files, documentation, status reports, source code, and other job-related documents using prescribed format and conforming to all rules of punctuation, grammar, diction, and style.

• Ability to record and deliver information, to explain procedures, and to follow instructions.

• Ability to use and interpret computer terminology and language.

• Ability to communicate with end-users, co-workers, vendors, technical staff, and department managers.

Application Process

This is a competitive, classified position. The Personnel Review Commission (PRC) will check your application to make sure you meet the minimum qualifications. If you do, the PRC will invite you to take a civil service examination. The exam is specific to this position. Everyone who passes the exam goes on an eligibility list. To fill this opening, the PRC sends the hiring department and Human Resources (HR) a certified eligibility list with the top 25% candidates (or at least the ten highest scoring candidates, whichever is greater). HR helps the hiring department decide who from the certified list to follow up with for interviews and then a job offer.

Most of our communication with candidates is through email. Regularly check the email address you gave us in your job profile. Watch your Spam folder, just in case.

If we offer you a job, you must pass a drug screen and background check before the offer becomes final. Prior criminal convictions do not automatically disqualify you from employment; the County looks at criminal convictions on a case-by-case basis using the guidelines in Chapter 306 of the County Code.

EQUAL OPPORTUNITY EMPLOYER

Cuyahoga County is committed to fostering a diverse and inclusive workforce, which includes building an environment that respects the individual, promotes innovation and offers opportunities for all employees to develop to their full potential. A diverse workforce helps the County realize its full potential. The County benefits from the creativity and innovation that results when people with different experiences, perspectives, and cultural backgrounds work together.

The County is committed to providing equal employment opportunities for all individuals regardless of race, color, ancestry, national origin, language, religion, citizenship status, sex, age, marital status, sexual preference or orientation, gender identity/expression, military/veteran status, disability, genetic information, membership in a collective bargaining unit, status with regard to public assistance, or political affiliation.

If you need assistance applying or participating in any part of the candidate experience, contact Human Resources at 216-443-7190 and ask to speak with a talent acquisition team member.