SENIOR PROGRAMMER ANALYST
(Application Development and Support)
$43.57 - $55.61 Hourly
$3,485.84 - $4,448.91 Biweekly
$7,552.65 - $9,639.31 Monthly
$90,631.84 - $115,671.71 Annually
(Please note: typical placement is made at the first step of the salary range)
REGULAR FULL-TIME EMPLOYMENT OPPORTUNITY
Under general supervision, is responsible for systems analysis, design and programming in close cooperation with user departments and project development teams; revises, improves, tests and maintains existing automated systems; provides training and technical support to users regarding computer systems and business applications software; and performs other duties as assigned.
Senior Programmer Analyst is the journey-level position in the programmer analyst series. Incumbents work under direction and are expected to demonstrate full working knowledge of software design, state-of-the art programming techniques, and systems analysis. Incumbents perform programming, analysis and/or data base administration assignments on a wide range of moderately complex municipal projects. This classification differs from the next lower classification of Programmer Analyst in that the latter is responsible for programming and analysis assignments of limited scope and complexity. Incumbents in the Senior Programmer Analyst may provide lead direction and training to the Programmer Analyst. This is an alternatively staffed position.
This Senior Programmer Analyst is further distinguished from the next higher level classification of Principal Programmer Analyst in that the latter is an advanced journey-level classification performing programming, analysis and/or data base administration assignments on a wide range of highly complex municipal projects. The Principal Programmer Analyst may also provide lead direction and training to the Senior Programmer Analyst.
Essential Job Functions:
(May include, but are not limited to, the following: ) Analyzes program specifications to develop logic and requirements for detailed programming.
Writes programs using structured programming techniques, standard languages, and third-party software packages.
Extracts data from business systems and prepares custom and routine reports in requested format.
Maintains existing systems by making necessary application updates, changes or enhancements.
Designs, creates and tests new systems of varying scope and complexity.
Perform system administration duties, including, database maintenance, verifying system back-ups, updating anti-virus software, resetting log files, and managing disk space.
Develops detailed application test cases and debugs all aspects of applications assigned.
Develops and implements comprehensive system test cases to ensure accurate and viable results.
Prepares documentation for systems and applications, and other associated documentation according to standards.
Performs routine recurring processes related to major computer software applications, related system software and database management systems.
Assists in the development of operations procedures manuals and trains staff in the use of new or enhanced systems.
Analyzes user needs and requests to determine appropriate program, system, report, or procedure changes.
Responds to City staff service requests related to major computer software applications, related system software and database management systems.
Develops and conducts in-house training for City staff in the use of new or enhanced software applications.
Provides system support for users, using various in-house and third-party applications, as needed.
Analyzes and evaluates new software packages and provides detailed recommendations concerning acquisition.
Designs, develops, and maintain systems and applications for the City's internet website.
Performs other related duties as assigned.
Position requires prolonged sitting, standing, walking, kneeling, squatting and stooping in the performance of daily activities. The position also requires repetitive hand movement and fine motor coordination in using a computer keyboard. Additionally, the position requires both near and far vision in using a computer monitor and conducting training sessions, color vision is required to accurately interpret visual displays. Acute hearing is required when communicating by phone and in person. The need to lift, drag and push equipment and materials weighing up to 25 pounds is also required. Some of these requirements may be accommodated for otherwise qualified individuals requiring and requesting such accommodation
Education and Experience:
The minimum qualifications for education and experience can be met in the following way:
Senior Programmer Analyst:
A Bachelor of Science degree in Computer Science or related field and four (4) years experience in business systems programming, database maintenance, and/or programming using computer software tools.
A Masters of Science degree in Computer Science or related field may be substituted for one year of experience.
Knowledge, Skills and Abilities:
Working Knowledge of: Industry standard computer programming languages.
Structured programming methods.
Computer database software tools.
Standard program documentation formats such as code and decision tables, input and output layouts, screen formats and data dictionaries.
User interface and relational database designs.
Network applications and system analysis.
Uses and limitations of software applications. Senior Programmer Analyst:
Thorough knowledge of the above, plus working knowledge of: Programming languages used by the City, such as: Microsoft Visual Basic, Oracle database, and Windows SQL.
The programming of integrated database, relational database management systems and web-based systems.
Computer reporting tools.
Programmer Analyst/Senior Programmer Analyst:
Ability to: Effectively analyze available data and program code, and develop logical solutions to programming problems.
Develop and implement new systems of varying scope and complexity.
Learn and recall programming details and appropriately apply these details to new programming needs.
Develop effective test and debugging procedures.
Develop clear and concise layout for output reports.
Effectively explain computer procedures to system users both orally and in writing.
Coordinate a wide-variety of information technology projects.
Interpret a variety of instructions provided in written, oral, diagrammatic or schedule form.
Maintain the security of confidential data.
Establish and maintain cooperative and effective relationships with those contacted in the course of work.
Ensure that the City's philosophy of customer service is understood and carried out in all forms of communication.
Observe safety principles and work in a safe manner.
Prepare clear and concise written reports.
Follow written and oral instructions.
Learn programming languages, reporting tools, integrated database, relational database management systems and web-based systems, used by the City, as related to assignment.
Perform related duties, as required. Licenses/Certificates:
Possession at time of hire and continued maintenance of a valid California driver's license and a safe driving record, or the ability to provide alternate transportation which is approved by the appointing authority.
Willingness to: Work irregular hours on short notice. DESIRABLE QUALIFICATIONS Work experience in the public sector
Knowledge of municipal computer applications including Finance System, Permit, Processing systems, Public Safety systems, and Geographic Information systems (GIS).
Working knowledge of Unix, Unix Shell, Microsoft ASP.Net, C, SQL Server.
Working knowledge of reporting tools, such as Crystal Reports and Crystal Enterprise Server.
Application and Selection Process:
If you are interested in this opportunity, please submit a City of Sunnyvale employment application, a resume, and responses to the supplemental questions to the Department of Human Resources no later than 5:00 p.m. on Monday, December 3, 2012 (postmarks or faxes are not accepted).
City application forms, completed in full are required, as well as a resume and the responses to the required supplemental questions. Candidates are asked to fully describe any training, education, experience or skills relevant to this position. Electronic applications may be submitted on-line through the City's employment page at jobs.inSunnyvale.com or application materials may be submitted to: Department of Human Resources, 505 West Olive Avenue, Suite 200, Sunnyvale, CA 94086. Late or incomplete applications will not be accepted.
Applications will be competitively screened based on the minimum qualifications of this position. Based upon a review of the application materials, the most qualified candidates will be invited to participate in the examination process, which may consist of an oral examination and a writing exercise scheduled for the week of January 7, 2013. (Note: The examination process may be changed as deemed necessary by the Director of Human Resources).
Those candidates that receive a passing score on the examination will be placed on an eligibility list for up to one year, in accordance with the City’s Civil Service Rules and Administrative Policies.
Any candidate that is selected by the hiring department will be required to successfully complete a pre-employment process, which may consist of a background history check, as well as medical exam(s) administered by a City-selected physician(s) before hire. Prior to starting work, all newly-hired employees will be fingerprinted to check conviction history. A conviction history will not necessarily disqualify an applicant from appointment; however, failure to disclose conviction history will result in refusal of employment or termination. Positions which are covered by the Department of Transportation regulations are required to submit to a pre-employment drug test and to random drug and alcohol testing.
INFORMATION ABOUT PROOF OF EDUCATION
Please note: Any successful candidate, selected by the hiring department will be required to submit proof of education (i.e. original copy of the diploma or college/university transcripts).
Positions in this job classification are represented by the Sunnyvale Employees Association (SEA).
The information contained within this announcement may be modified or revoked without notice and does not constitute either an expressed or implied contract.
The City of Sunnyvale is an Equal Opportunity Employer. It is the policy of the City of Sunnyvale not to discriminate against all qualified applicants or employees on the basis of race, religion, color, sex (including gender, gender identity, and gender expression), sexual orientation (including heterosexuality, homosexuality, and bisexuality), national origin, ancestry, citizenship status, marital status, pregnancy, age, medical condition, genetic characteristics or information, and physical or mental disability. Applicants needing special accommodations for testing should submit a request to the Department of Human Resources at time of application.