Senior Programmer/Analyst

at  Orange County Water District

DESCRIPTION

The Senior Programmer/Analyst is the second level in a three-level programmer series and is responsible for programming and analyzing related information. Under general direction:

• provides highly advanced professional support and maintenance of a wide variety of complex systems and programs;
• provides highly advanced professional system analysis
• troubleshoots and resolves highly complex systems and network hardware and software problems;
• performs both routine and complex technical and administrative tasks related to the development and operation of District systems;
• performs database management duties;
• evaluates and recommends current and third-party systems and applications;
• provides highly technical support, expertise, and training to end users;
• performs related work as required.
• serves as a project manager on assigned projects;

TYPICAL QUALIFICATIONS

The following generally describes the knowledge and ability required to enter the job and/or be learned within a short period of time in order to successfully perform the assigned duties.

KNOWLEDGE OF:

• Applicable programming languages.
• Advanced Relational database design.
• Advanced database administration techniques.
• Advanced system administration techniques and methods.
• Advanced system analysis, design, development, testing, and security methods.
• Network design and operations concepts.
• Internet technologies.
• Handheld computers, tablets, and smartphone technologies.
• Common office applications.
• Project management principles.
• Customer service principles.

Ability and Skills in:

• Performing complex programming.
• Using computers and related software applications.
• Designing complex relational databases.
• Managing projects.
• Configuring networks.
• Performing complex database management functions.
• Developing and managing websites.
• Creating technical documentation.
• Troubleshooting complex database and database integration problems.
• Troubleshooting computer and network problems.
• Administering enterprise computer systems.
• Designing software.
• Evaluating technology products.
• Conducting research.
• Working independently.
• Prioritizing and managing a variety of projects and multiple tasks.
• Maintaining confidentiality of sensitive information and records.
• Providing customer service.
• Communication, and interpersonal skills as applied to interaction with coworkers, supervisor, the general public, etc. sufficient to exchange or convey information and to receive work direction.

EDUCATION AND EXPERIENCE GUIDELINES

Any combination of education and experience that would likely provide the required knowledge and abilities is qualifying. A typical way to obtain the knowledge and abilities would be:

EDUCATION/TRAINING:

Bachelor’s degree from a college or university accredited by the U.S. Department of Education, with major coursework in computer science, information systems, or a related field
Experience: Five years’ work experience in programming and analysis; or an equivalent combination of education and experience sufficient to successfully perform the essential duties of the job such as those listed above.
Desirable experience includes Oracle and/or SQL Server databases, C#, .Net, HTML, JavaScript, and applicable programming languages, database design, SQL development, SSRS, and web development.
License: A valid California Class “C” Driver’s License and proof of automobile insurance are required.

EXAMPLES OF DUTIES

The following essential job functions are typical for this classification. Incumbents may not perform all of the listed job functions and/or may be required to perform additional or different job functions from those set forth below to address business needs and changing business practices. Management reserves the right to add, modify, change, or rescind the work assignments of different positions and to make reasonable accommodations so that qualified employees can perform the essential functions of the job.

The Senior Programmer/Analyst is the second level in a three-level programmer series and is responsible for programming and analyzing related information. Under general direction:

• provides highly advanced professional support and maintenance of a wide variety of complex systems and programs;
• provides highly advanced professional system analysis
• troubleshoots and resolves highly complex systems and network hardware and software problems;
• performs both routine and complex technical and administrative tasks related to the development and operation of District systems;
• performs database management duties;
• evaluates and recommends current and third-party systems and applications;
• provides highly technical support, expertise, and training to end users;
• performs related work as required.
• serves as a project manager on assigned projects