Network Administrator/Programmer Analyst

$5,534 - $5,960 monthly
  • Wasco County
  • The Dalles, OR, USA
  • Aug 14, 2020
Full time Government Information Technology

Job Description

General Position Summary:

To provide a variety of professional data analysis and programming support for County business functions, develop specifications and procedures for programming, testing, installing and maintaining new or modified applications; to develop SQL queries, scripts and reports using tools provided; to perform database administration, including developing and using procedures for normal maintenance and recovery of databases and their current data. To include development and design, program testing and debugging, designing and implementing web pages for Internet/Intranet/Extranet, enhancing existing systems, evaluating the performance of systems and identifying and implementing improvements.

Essential Functions (in a typical work week):

—             Data analysis and programming support.
—             Modify client/server application programs due to legislative changes and business process changes.
—             Create custom reports for the client/server applications from user & public requests.
—             Install, configure and implement new third party vendor database and application program products.
—             Monitoring of day to day operations, performance and space requirements of Microsoft SQL Server enterprise wide databases that operate on County servers.
—             Assist in the planning of future development of the County database requirements; assist IS Director in implementation of required upgrades or replacement of current hardware or database version releases.
—             Develops applications using HTML, JavaScript, CS5, SQL, and/or current programming languages.
—             Setup and maintain web servers/ services including Apache, IIS, and other systems
—             Designs, enhances, modifies and updates web sites as appropriate.
—             Maintenance of data integrity with backup, archive and recovery processes; help implement and maintain procedures of disaster recovery, perform database file restoration.
—             Project management
—             Manage other IS staff and contractors when performing Database & programming functions.
—             Any employee may be required by their manager to perform any of the duties described in his/her position description, and other duties which may be necessary or desirable and for which the employee is qualified.

Secondary Functions (in a typical work week):

  • Backup help-desk support when needed, including answering calls and completing support tickets.
  • Any employee may be required by their manager to perform other duties which may be necessary or desirable and for which the employee is qualified.

Responsibility/Accountability: This section of the job description describes the amount and breadth of responsibility and accountability that rests with the position, including the expected results of the position, the impact on County operations and activities, and the responsibility for budget.

Moderate, but distinct impact on organization operations, program outcomes, revenue, and expense or budgetary outcomes.  Responsibility for the prudent use of assets, including assigned equipment, material, or labor, is moderate and often includes responsibility for others' use of organization assets.  Some program or policy development affecting the organization and its offerings is part of the job responsibility.  “Customer” service is an important part of the job and actions would likely impact user's sense of satisfaction. 

Supervision of Employees:  This section of the job description describes the supervisory responsibility assigned including the range and types of supervisory functions performed, from directing work activities and delegating assignments to coaching, counseling, making disciplinary decisions, hiring, firing, salary actions, performance appraisal, training, etc. as well as the types of employees supervised.   

Positions at this level are responsible for daily work or special project direction that is provided to personnel in similar job functions at comparable or subordinate levels.  This work is usually limited in time and to only a few individuals.  Position may participate in the hiring process.   However, positions are not responsible for hiring, firing, disciplinary actions, etc.

Interpersonal Skills/Contacts:  This section of the job description describes the characteristics of personal interaction with others including the frequency of contacts with others, the breadth of interactions (within the County, outside the County, with vendors/contractors, dealing directly with the public, etc.), and the level of persons interacted with.  Also, included in this section is the reason for contact such as gaining cooperation; use negotiation, tact, teamwork, and sensitivity; or the likelihood of dealing with disagreeable or hostile individuals. 

Positions at this level have responsibility for contact with wide range of individuals including County employees, the public, and those with contractual or other relationships with County operations and programs.  Internally, the primary contacts are made equally with the individual's own work group and other departments.  The contacts are both of a routine and non-routine nature and require some discussion or explanation.  Some adverse or positive consequences may result from these interactions.  Contacts can be in both one-on-one situations or group settings.  Communication and interpersonal skills are fairly important and require some refinement for the successful completion of job responsibilities.  Positions that have substantial contact with a wide range of individuals, but the contact is limited in scope, should also be placed at this level.

Working Conditions:  This section of the job descriptions outlines the work environment, conditions, and hazards that are encountered in the course of assigned work.  This includes the personal risk, hazard, varying work schedules, level of interruptions, job pressure, and the need to frequently juggle priorities and work assignments.  Also, exposure to unpleasant working conditions such as high noise levels, heat or cold, inside or outside work, exposure to electricity, chemicals, poor lighting, confinements, machinery, interactions with disturbed or dangerous individuals, personal attacks, contact with contagious disease, or situations where personal safely cannot be assured.

This level has a work environment with only occasional hazards or obstacles.  There is a moderately low level of personal risk encountered while performing assigned work.  Job conditions may be occasionally uncomfortable relative to noise, temperature, inside/outside work, or dirty conditions.  Interactions with angry or hostile individuals, exposure to contagious disease, interruptions that make meeting deadlines more difficult, and some job pressures to successfully complete work assignments can exist.

Physical Requirements:  This section of the job description describes the physical effort and manual labor, such as sitting, standing, lifting, carrying, digging, operating equipment, performing with speed, etc., as well as the dexterity required to complete the job functions.  The need for travel, extended hours, and situations of physical discomfort are also outlined here.

Positions at this level require some physical efforts or guide labor, such as lifting and carrying of items weighing 15-25 pounds on a regular basis as part of the work assignments, or constant movement is necessary to complete tasks.  Some regular stooping, bending, and pushing/pulling may also be required.  This level also includes job situations where speed, guide dexterity, and equipment operation are a continual requirement.  Positions with regular responsibility for driving are to be placed at least at this level.

Education, Experience, and Certification/Licensure:  This section of the job description outlines the education, previous experience, professional licenses, certifications, and specific skills necessary to perform the assigned work. 

Positions at this level require abilities, skills, training, and/or a knowledge base equivalent to a seasoned level professional.  Education will typically include a four year degree and positions will typically require 3-6 years of directly related experience.  Knowledge of multiple business areas and skills are required by the positions.  Work may be in a more generalized professional role, or specialized in one particular function where in-depth understanding is required.  Capabilities include reasoning, exercise of sound judgment, ability to draw conclusions with limited information, and to forecast or envision future needs and opportunities.

Below is an outline of the specific Education type, Experience type or licensure/certification that is required for this role.  The County will also consider any equivalent combinations of the qualifying criteria.

  • Bachelor’s degree in Computer Science or Engineering OR equivalent work experience in related field preferred.
  • Three to six years of experience in the following areas:
  • MS SQL, SQL stored procedures, SQL reporting services, SQL scripting
  • Experience working with:
  • Visual Studio .NET, C#, Cold Fusion, ADO, ODBC, OLE DB, COM+/DCOM.
  • HTML/DHTML, XML, Active Server Pages, VBScript, JavaScript or other web based programing
    • Experience deploying client/server applications in a network environment
    • Experience with OpenSource
    • Strong technical, planning/organizational and execution skills. 

Additionally, an individual in this position models Wasco County’s core values and cultural initiatives.