Software Developer

at  Delta Diablo

ESSENTIAL FUNCTION

Under general supervision, perform software application development and maintenance, database architecture and administration, software administration and provide consultation to user groups; recommends business applications to leverage available computer technology and systems.

KNOWLEDGE, SKILLS, AND ABILITIES

Knowledge of:

• Principles, practices, methods, and techniques utilized in the operation, maintenance, and administration of designated software applications, deployment tools, and performance monitoring applications.
• Troubleshooting methodologies, including, but not limited to, the Open Systems Interconnection (OSI) model.
• Principles, practices, and techniques of application development within a virtualized environment.
• Microsoft’s enterprise products and services, including, but not limited to, Office365 Suite, .NET Framework, PowerShell, MSSQL services, and SSRS.
• Cloud architecture and cloud-based solutions, including, but not limited to, Azure, Amazon Web Services (AWS), and Google Cloud.
• Providing scripting automation solutions using the current best practices within the automation industry via the Command-line interface (CLI), or similar applications.
• Working knowledge of commonly used debugging tools.
• Advanced understanding of Microsoft’s coding conventions.
• Applicable federal, state, and local laws, codes, and regulations related to the work.
• Training and presentation techniques for technical and non-technical audiences.
• Codes, regulations, specifications, ordinances, and enforcement procedures applicable to the area of assigned functions.
• Modern office practices, methods, common computer equipment, and applications related to the work.

Skills and Abilities to:

• Analyze, identify, interpret, know, observe, problem-solve, remember, understand, and explain designated computer programming, hardware, and software applications; analyze plans; interpret project proposals, plans, and specifications; design solutions; understand and explain procedures and terminology; and perform mathematical calculations.
• Prepare clear and concise procedures, reports, records, correspondence, and other documents.
• Develop and maintain project specifications, and design requirements based on business requirements and analysis; work with management to set project timelines and milestones and coordinate work with cross-functional team members; and monitor and report on project status.
• Methodically apply scientific principles, while performing analyses to determine if any alternative courses of action are available to be taken.
• Diagnose, troubleshoot, and resolve technical issues related to software, hardware, networks, and human-machine interface systems.
• Review and confirm specifications with advising engineer, IT Division staff, clients, and vendors.
• Read, interpret, draft, and illustrate electronic schematic drawings.
• Read, interpret, and apply complex technical information from various operational and instructional manuals.
• Establish and maintain designated documentation and records in an accurate and timely manner.
• Perform a variety of mathematical and statistical calculations in an accurate and timely manner.
• Organize own work, set priorities, and meet critical time deadlines.
• Establish, maintain, and foster positive and effective working relationships with those contacted in the course of work.

QUALIFICATIONS

A combination of training and experience that demonstrates an individual has obtained the required knowledge and is able to perform the required work (with reasonable accommodation if needed). A person with the following combined training and experience would most likely qualify to compete in a selection process:

• Education: Possession of a bachelor’s degree from a college or university with major coursework in computer science, software development, information technology, or a related field.
• Experience: Four (4) years of full-time progressively more responsible work experience with software development, and software installation and repair, including database design and administration, scripting, and report writing.

PRIMARY DUTIES

• Development and maintenance of robust, scalable, and maintainable applications utilizing coding languages such as, but not limited to, Microsoft’s .NET framework and C#.
• Design, develop, and manage MSSQL databases including subroutines such as but not limited to, schemas, stored procedures, functions, queries, Structured Query Language (SQL) jobs, maintenance plans, and other database subroutines.
• Developing software solutions that integrate multiple software platforms.
• Design and develop dynamic and static Structured Query Language (SQL) reports within SQL Server Reporting Services (SSRS) environments or similar, to provide actionable insights to stakeholders.
• Set up and manage continuous integration/continuous deployment (CI/CD) pipelines using Jenkins or similar applications.
• Write and maintain PowerShell scripts for the automation of build, test, and deployment processes.
• Ensure automated processes are reliable and efficient, minimizing downtime and manual intervention.
• Administer the Software Development Life Cycle (SDLC) by gathering user requirements, leading architectural design, planning software projects, user interface (UI)/user experience (UX) design, integration testing, supporting user acceptance testing (UAT), deploying applications to production environments, and providing ongoing support and maintenance.
• Use tools and techniques to identify and resolve software performance issues, bugs, and other defects.
• Implement logging and monitoring solutions to proactively detect and address issues.
• Perform data extractions and system integrations; and maintain database and system integrity.
• Research and learn about new technologies, tools, and best practices in software development.
• Develop and maintain user manuals; and participate in the design of user training courses/modules, as required.
• Attend industry conferences, workshops, and training sessions.
• Perform cybersecurity duties including, but not limited to: On/off-boarding of new accounts, group management, software patching, incident reporting, and design reviews.
• Perform technical duties in computerized databases, information systems, and software applications to maximize efficiency and effectiveness.
• Serve as initial resource and interface for District users, applications, programmers, and cloud-service providers.
• Analyze vendor proposals for conformity to specifications, and cost estimates, and assist in the selection and monitoring of vendors during the installation and implementation of modified or new systems.
• Tactfully respond to inquiries, requests, and complaints; interpret standards, policies, and procedures; prepare letters and other forms of correspondence.
• Perform business continuity tasks including, but not limited to, conducting/restoring backups, snapshots, and disaster recovery testing.
• Participate in regular audits of applications, permissions, systems, and procedures.
• Prepare presentations for various meetings to various stakeholders.
• Provide technical orientation to newly hired employees regarding the use of District systems, including the creation, coordination, and distribution of employee training materials.
• Perform other work duties and responsibilities consistent with the position on an as-needed and assigned basis.

General Organizational Duties

• Support the development and implementation of the District’s Strategic Plan and associated Strategic Initiatives.
• Promote the District’s focus on effective and respectful communications to build better work relationships at all levels in the organization.
• Establish and maintain effective relationships with other staff members, staff at other agencies, and professional organizations.
• Participate in teams engaged in District projects and organizational activities.
• Participate in District related civic events, meetings, committees, and staff functions.
• Provide appropriate, timely, and customer-service-focused responses to inquiries from the public.
• Understand and conform with the District’s Policies and Procedures, including the Safety Program.
• When qualified to do so, assume responsibility for covering a part of the work assignments of other staff during absences.

The work environment characteristics are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

• Typically works in a normal office environment with controlled lighting and ventilation, and moderate noise levels.
• Periodic travel may be required for training, meetings, and other business purposes.
• Noise levels in the field work environment are usually moderate with occasional exposure to loud equipment. This position may enter locations that require personal protective equipment (PPE). The specific PPE required for the exposure will be provided and worn in accordance with current District, state, and federal regulations.
• Employee may interact with the public or private representatives while conducting job duties