Computer Systems Analyst - Database



Computer Systems Analyst - Database

Salary

$55,000.00 - $66,000.00 Annually

Location

Silver-Bow County, MT

Job Type

Full-time Regular

Job Number

2018-008

Department

Management Information Services

Opening Date

02/14/2018

Closing Date

8/16/2018 12:00 AM Mountain

FLSA

Exempt

Bargaining Unit

N/A

Description

 
                                                    General Statement of Duties
 
Maintains the City-County database systems and critical applications; performs related work as required.
 
 
                                              Distinguishing Features of the Class
 
This position is responsible for the performance, data integrity, and security of the City-County's MS SQL Server databases and critical applications.  Key responsibilities include: 1) Provides database backup and recovery strategies, and provide guidance to appropriate personnel when problems arise; 2) Installs, configures, and tests software packages and installs new software releases; 3) Monitors database performance and statistics and conducts maintenance to ensure efficient operation of the system;  4) Administration of critical applications including Tyler applications such as Infinite Visions, TaxWise and Munis, as well as custom open-source applications.

Duties/Responsibilities

 
                                    Examples of Essential Work (Illustrative Only)
 

  • Assume responsibility for services and activities that directly relate to the relational databases (RDBMS) and systems residing on the City-County's servers.
  • Install, upgrade and administer the most current MS SQL Database software deployed on MS Windows.
  • Apply patches and major releases for MS SQL Database software and Tyler applications.  Manage changes to the environment using existing change management best practices and automation tools.
  • Assist in establishing data integrity and security policies and procedures for user accounts, data creation, data manipulation and data storage.
  • Perform a key role in the establishment of effective RDBMS and systems backup, recovery and re-start procedures.
  • Participate in the development of RDBMS standards and database connectivity strategies to support an open database architecture; participate in the development of operating systems and programming standards to meet the needs of the City-County.
  • Monitor and tune the databases for optimal performance; recommend hardware and system configuration changes to optimize database and systems performance.
  • Provide and support application development utilizing database architecture and design techniques; review proposed changes to the database structures; review data security, data validation and data integrity controls.
  • Participate in the development and implementation of department goals, objectives, policies and priorities for assigned programs.
  • Perform related duties and responsibilities as required.

Qualifications

 
                                         Required Knowledge, Skills and Abilities
 

  • MS SQL Database architecture and features.
  • Comprehensive knowledge of common application development platforms (Java, .Net) methods and techniques utilized in applications development and common program and development languages;
  • Knowledge of MS Windows Server operating systems and VMWare virtualization platform;
  • Relational database management systems such as MS SQL Server;
  • Database administration and management techniques in a client-server environment;
    Structured Query Language (SQL);
  • Report writing and query tools;
  • Principles of relational database design, development and administration;
  • Windows operating systems, networking concepts and computer security;
  • Physical database design, backup and recovery strategies, performance monitoring and tuning;
  • Good working knowledge of public sector information system policies, practices, and procedures, such as HIPAA, FIPS140-2 and CJIS;
  • Knowledge of City-County departmental functions, procedures, policies and organization;
  • Good knowledge of accounting and mathematical equations for end-user application assistance as well as budget development;
  • Manage enterprise-class applications and services;
  • Develop, tune and troubleshoot applications;
    Perform performance tuning and optimization activities of MS SQL Databases;
  • Analyze programs, policies and operational needs;
  • Assess problems, identify alternative solutions, project consequences of proposed actions and implement recommendations in support of goals;
  • Research, analyze and evaluate new administration methods and techniques;
  • Communicate clearly and concisely, both orally and in writing;
  • Establish and maintain effective working relationships with Butte-Silver Bow personnel as well as contractors and vendors;
  • Ability to establish and maintain mutually beneficial working relationships with department and division heads, City-County employees, as well as outside organizations and vendors/service providers;
  • Ability to prepare accurate and reliable reports containing findings and recommendations for current and future City-County information systems;
  • Professionalism – Demonstrates core values by being honest, respectful and positive;
  • Effective Communication – Expresses verbal and written thought in a clear and understandable manner;
  • Customer Focus – Demonstrates genuine concern and satisfies external and/or internal customers;
  • Adaptability – Able to effectively modify behavior to suit changing workforce demands;
  • Problem Solving – Solves problems by considering all causes, solutions and outcomes;
  • Productive Partnerships – Develops, maintains and strengthens partnerships with others;
  • Technical and Safety Expertise – Possesses a depth of knowledge, skill and ability in a technical (job) area;
  • Ability to quickly learn and adapt to new technology as it relates to the ever-changing business requirements of the City-County and its citizens;
  • Ability to maintain strict confidentiality of City-County business and information.
 
 
                                   Acceptable Education, Experience and Training
 
  • Graduation from a college or university of recognized standing with a Bachelor's Degree in Computer Science, or closely related field; and
  • Three to five years of increasingly responsible relational database administration experience, including two years of direct administration of MS-SQL databases in a client-server environment or
  • Any equivalent combination of experience and training which provides the knowledge, skills and abilities necessary to perform the work.
 
 
                                                 Required Special Qualifications
 
  • Valid State of Montana Driver's License
  • Current automobile insurance
  • Completion of background check; will be fingerprinted upon employment.
  • Must be a resident of Butte-Silver Bow during employment according to Butte-Silver Bow Ordinance.  See below.
"2.08.010 Residence during employment.
From and after October 1, 1979, all employees of the local government of Butte-Silver Bow shall be bona fide residents within the boundaries of Butte-Silver Bow during the period of their employment by the government of Butte-Silver Bow. (Ord. 85 § 1, 1979)"
 
 
                                                      Essential Physical Abilities
                                                                             
  • Clarity of speech and hearing, with or without reasonable accommodation, which permits the employee to communicate well with other City-County department and division heads, employees, and representatives of other organizations to determine computer information systems related needs and problems and to discuss potential solutions;
  • Sufficient vision, with or without reasonable accommodation, which permits the employee to perform hardware maintenance procedures, and to produce and review a wide variety of documents, correspondence, reports and related materials in both electronic and printed form;
  • Sufficient manual dexterity, with or without reasonable accommodation, which permits the employee to operate a keyboard, perform hardware maintenance procedures, produce hand-written materials and notations and transport computer equipment from one location to another;
  • Sufficient personal mobility, with or without reasonable accommodation, which permits the employee to visit various other work stations in the City-County.

Unless otherwise noticed, benefits include the following: optional group health, life and dental insurance for employee and dependents; vacation leave accrual at one and one-quarter days per month; sick leave accrual at one day per month; ten paid holidays per year (plus Election Day every other year); Public Employees Retirement (Employer matched contribution); Flexible Spending Account; Deferred Compensation Plan; Employee Assistance Program; and credit union availability. NOTE: In some instances, benefit eligibility may be determined by length of service and/or employment status.

Agency
City and County of Butte-Silver Bow, MT
Address
155 W Granite
Suite 209
Butte, Montana, 59701
Phone
406-497-6430