Systems and Database Analyst

City of Marysville   Marysville, WA   Full-time     Information Services / Technology (IT)
Posted on June 14, 2022
Apply Now

Systems and Database Analyst

Salary $89,065.60 - $109,553.60 Annually

Location Marysville, WA
Job Type Full-time regular
 
Department Information Services
Job Number 00550

Closing Continuous

 

Position Summary

 

Apply by 7/8/2022 for first consideration.

This position is responsible for the development, design, documentation, deployment, and maintenance of the city’s database and application systems.  This is highly responsible technical work in the analysis of problems related to databases, application systems; installs, maintains, and modifies databases and system software; provides support for complex and inter-departmental systems.

 The work performed requires the application of professional knowledge and expertise as well as established guidelines and alternatives to determine facts, analyze problems, and make decisions without immediate supervisory review.  Incumbents operate independently and select appropriate methods to accomplish project assignments.

 

Examples of Job Duties

 

Other duties may be assigned as needed.

  1. Works closely with system stakeholders to ensure information system strategies are aligned with departmental and city needs. 
  2. Coordinates and aligns information systems with user objectives; expands or modifies current systems to serve new purposes or improve work flow.
  3. Performs advanced server administration including SQL, Active Directory, Group Policy Objects, Exchange, and server OS functions such as updates, folder permissions and disk space management.
  4. Installs, maintains, tests, analyzes, evaluates, and monitors databases and security settings; performs database administration including managing access permissions; and creates backups and maintenance plans. 
  5. Creates customized reports from various databases and applications using multiple delivery methods including legacy databases.
  6. Creates and/or modifies complex data interfaces between multiple systems.
  7. Provide support, troubleshooting and updates to legacy databases including Access databases with SQL back-ends.
  8. Coordinates and acts a project lead for multiple concurrent projects.  
  9. Provides technical direction to users; formulates, assists, and supports users with application training and technical support.
  10. Develops, documents, and revises system and database design procedures, test procedures, and quality standards.
  11. Conducts tests and inspections of products, services, or processes to evaluate quality or performance to assist product selection teams; recommends new equipment or software packages.
  12. Makes recommendations to management regarding policies and procedures based on field observations and user interactions.
  13. Performs special projects as needed.

 

Qualifications

 

A combination of the experience, education, and training listed below which provides an equivalent background to perform the work of this position.

Experience:

  • Five years of progressively responsible experience in an information services support position, including three years’ experience supporting, administering, and deploying Microsoft SQL databases and enterprise client/server software systems; and experience in project management or leading deployment teams.  
  • Municipal government experience preferred.

 Education and Training:

  • Bachelor’s degree in computer science or an equivalent combination of college course work, certifications, training, and experience.

 Licenses or Certificates:

  • One or more of the following certifications preferred:

    a).  Information Systems Analysis (ISA)

    b).  Microsoft Certified Solution Developer (MCSD)

    c).  Microsoft Certified Application Developer (MCAD)

    d).  Microsoft Certified Solutions Associate SQL (MCSA)

  • Must be able to pass an extensive fingerprint background check.

  • Must possess, or have the ability to possess within one month of hire date, a Washington State Driver’s license.

 

Work Environment

 

The physical demands and characteristics of the work environment described here are representative of those occurring in the performance of the essential functions of this job.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

 While performing the essential functions of this job, the employee is frequently required to stand; walk; sit; use hands to finger, handle, or feel objects, tools, or controls; and talk or hear.  The employee is occasionally required to reach with hands and arms and stoop, kneel, crouch, or crawl.  The employee must frequently lift up to 10 pounds; occasionally lift 10 to 20 pounds; and rarely lift and/or move 20 to 50 pounds (employee may ask for assistance).  

 Specific vision abilities required by this job include close vision, distance vision, peripheral vision, depth perception, and the ability to adjust focus.   This position works in an office, and the noise level in the work environment is usually low to moderate.

 This position works a regular schedule, however, incumbents will be required to work some holiday, evening and/or weekend hours to respond to emergencies and/or to implement specific projects.  This position will also be required to carry a rotating on-call phone.

This position description generally describes the principle functions of the position and the level of knowledge and skills typically required.  It does not constitute an employment agreement between the employer and employee, and it is subject to change as the needs of the employer and the requirements of the job change.

 

Non-union