City of Camarillo
Information Systems Analyst
City of Camarillo, Camarillo, California, United States, 93012
The ideal candidate for this position is a highly skilled and adaptable individual with a strong background in SQL Server database administration and development, particularly with versions 2014 and above. They should have at least 3+ years of experience as an MS SQL Server Database Administrator and 5+ years as an MS SQL Developer. A strong candidate will have expertise in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and performance tuning techniques. Additionally, experience with supporting web and eCommerce applications, as well as familiarity with GIS and geospatial databases, will be highly valued.
Successful candidates will possess strong communication and collaboration skills, enabling them to work effectively within a team and across various city departments. They should have a proven ability to manage and monitor databases, ensure system security, and integrate new technologies into existing systems. The ability to handle multiple projects, such as supporting the City’s AMI for the water system, OpenGov permitting system, and LaserFiche RMS, as well as implementing a new resident identity management solution, is essential. A commitment to continuous learning, adaptability to changing technologies, and a proactive approach to problem-solving will help ensure success in this role.The following duties are typical for this classification. Incumbents may not perform all of the listed duties and/or may be required to perform additional or different duties from those set forth below to address business needs and changing business practices.Provides ongoing software design, development, testing, and maintenance for online software applications for City departments.Maintains the City intranet for City employees; creates new web pages and expands functionality.Create and maintain geospatial databases; perform basic geo-processing and analytical tasks such as spatial queries and comparisons.Creates and maintains SQL Server Reporting Services reports for users.Performs database administration tasks for SQL Server databases; sets-up job; monitors re-indexing, backups, data import, and statistical reporting; provides user management and security.Maintains eCommerce website; prepares reports; provides user support for online transactions including utility payments; integrates eCommerce website with City website; maintains credit card processing server; secures certificates maintenance for City eCommerce applications.Coordinates with HTE vendor in resolving support cases addressing user problems.Coordinates with other information technology staff in resolving software application issues, server, and account configurations.Assists in developing training or conducts training in computer systems and software as needed.Researches new computer technologies for City application and recommends purchase of systems, hardware, software, and peripherals.Maintains a variety of records and prepares special reports; creates and updates written procedures and related documentation.Maintains current knowledge of information technology trends and innovations; attends and participates in job-related seminars and professional group meetings.Performs related duties as required.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:
Operational characteristics of information services systems, hardware, and software.
Principles and practices of computer science and information systems.
SQL (Structured Query Language) database design, management, and administration.
SQL server technology; SQL Server Reporting Services.
Principles and practices of computer programming and systems analysis.
Web server applications.
Project management principles and practices.
Architect software solutions; client/server technology.
Methods and techniques of training and instruction.
Office procedures, methods, and equipment including computers and various commercially packaged software including word processing, spreadsheet, database, and graphics applications.
GIS (Geographic Information System) software and technical applications.
Characteristics and limitations of computer systems and related equipment.
Ability to:
Analyze, design, program, install, and maintain computer systems and software.
Read, understand, and follow technical instructions and manuals.
Diagnose and resolve network and mid-range computer operational problems.
Diagnose common user problems and identify appropriate corrective action.
Plan system upgrades and communicate schedules.
Monitor network and application security.
Create complex queries and ad-hoc reports.
Manage and monitor databases.
Assemble, install, and maintain computer equipment and peripherals.
Conduct research and prepare reports, documents, and correspondence.
Analyze data and develop logical solutions to complex computer application problems.
Make recommendations in information system selection and software application packages.
Operate office equipment including computers and supporting word processing, spreadsheet, and database applications.
Adapt to changing technologies and learn functionality of new equipment and systems.
Communicate clearly and concisely, both orally and in writing.
Establish and maintain effective professional working relationships with those contacted in the course of work.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:
A Bachelor's degree from an accredited college or university with major course work in computer science, information systems, or a related field.Experience:
Five years of progressively responsible experience in systems or business analysis and design.
The conditions herein are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions.Environment :
Work is performed primarily in a standard office setting.
Physical :
Primary functions require sufficient physical ability and mobility to work in an office setting; to stand or sit for prolonged periods of time; to occasionally stoop, bend, kneel, crouch, reach, and twist; to lift, carry, push, and/or pull moderate to heavy amounts of weight; to operate office equipment requiring repetitive hand movement and fine coordination including use of a computer keyboard; and to verbally communicate to exchange information.#J-18808-Ljbffr
Successful candidates will possess strong communication and collaboration skills, enabling them to work effectively within a team and across various city departments. They should have a proven ability to manage and monitor databases, ensure system security, and integrate new technologies into existing systems. The ability to handle multiple projects, such as supporting the City’s AMI for the water system, OpenGov permitting system, and LaserFiche RMS, as well as implementing a new resident identity management solution, is essential. A commitment to continuous learning, adaptability to changing technologies, and a proactive approach to problem-solving will help ensure success in this role.The following duties are typical for this classification. Incumbents may not perform all of the listed duties and/or may be required to perform additional or different duties from those set forth below to address business needs and changing business practices.Provides ongoing software design, development, testing, and maintenance for online software applications for City departments.Maintains the City intranet for City employees; creates new web pages and expands functionality.Create and maintain geospatial databases; perform basic geo-processing and analytical tasks such as spatial queries and comparisons.Creates and maintains SQL Server Reporting Services reports for users.Performs database administration tasks for SQL Server databases; sets-up job; monitors re-indexing, backups, data import, and statistical reporting; provides user management and security.Maintains eCommerce website; prepares reports; provides user support for online transactions including utility payments; integrates eCommerce website with City website; maintains credit card processing server; secures certificates maintenance for City eCommerce applications.Coordinates with HTE vendor in resolving support cases addressing user problems.Coordinates with other information technology staff in resolving software application issues, server, and account configurations.Assists in developing training or conducts training in computer systems and software as needed.Researches new computer technologies for City application and recommends purchase of systems, hardware, software, and peripherals.Maintains a variety of records and prepares special reports; creates and updates written procedures and related documentation.Maintains current knowledge of information technology trends and innovations; attends and participates in job-related seminars and professional group meetings.Performs related duties as required.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:
Operational characteristics of information services systems, hardware, and software.
Principles and practices of computer science and information systems.
SQL (Structured Query Language) database design, management, and administration.
SQL server technology; SQL Server Reporting Services.
Principles and practices of computer programming and systems analysis.
Web server applications.
Project management principles and practices.
Architect software solutions; client/server technology.
Methods and techniques of training and instruction.
Office procedures, methods, and equipment including computers and various commercially packaged software including word processing, spreadsheet, database, and graphics applications.
GIS (Geographic Information System) software and technical applications.
Characteristics and limitations of computer systems and related equipment.
Ability to:
Analyze, design, program, install, and maintain computer systems and software.
Read, understand, and follow technical instructions and manuals.
Diagnose and resolve network and mid-range computer operational problems.
Diagnose common user problems and identify appropriate corrective action.
Plan system upgrades and communicate schedules.
Monitor network and application security.
Create complex queries and ad-hoc reports.
Manage and monitor databases.
Assemble, install, and maintain computer equipment and peripherals.
Conduct research and prepare reports, documents, and correspondence.
Analyze data and develop logical solutions to complex computer application problems.
Make recommendations in information system selection and software application packages.
Operate office equipment including computers and supporting word processing, spreadsheet, and database applications.
Adapt to changing technologies and learn functionality of new equipment and systems.
Communicate clearly and concisely, both orally and in writing.
Establish and maintain effective professional working relationships with those contacted in the course of work.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:
A Bachelor's degree from an accredited college or university with major course work in computer science, information systems, or a related field.Experience:
Five years of progressively responsible experience in systems or business analysis and design.
The conditions herein are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions.Environment :
Work is performed primarily in a standard office setting.
Physical :
Primary functions require sufficient physical ability and mobility to work in an office setting; to stand or sit for prolonged periods of time; to occasionally stoop, bend, kneel, crouch, reach, and twist; to lift, carry, push, and/or pull moderate to heavy amounts of weight; to operate office equipment requiring repetitive hand movement and fine coordination including use of a computer keyboard; and to verbally communicate to exchange information.#J-18808-Ljbffr