S
UMMIT
C
OUNTY
C
OMMUNICATIONS
C
ENTER
970-668-8600 Fax 970-668-4224 Post Office Box 4188 0227 SC Road 1003 Frisco, Colorado 80443
Summit County Communications Center offers an exciting opportunity for a career in
public safety technology. We are looking for flexible, multi-task oriented, team
members with excellent communications skills, sound judgment and problem solving
skills. Final candidates will be required to satisfactorily pass a criminal background
investigation as determined by the Criminal Justice Information Services Division (CJIS).
DATABASE
ADMINISTRATOR
S
UMMIT
C
OUNTY
C
OMMUNICATIONS
C
ENTER
970-668-8600 Fax 970-668-4224 PO Box 4188 0227 SCR 1003 Frisco, Colorado 80443Database Administrator
Application Instructions
========================================1. Read, sign and date the Job Description.
2. Print neatly or type all sections of the Summit County Employment Application.
3. Submit a resumé with the application packet.
4. Submit your completed application and resumé to:
Summit County Communications Center
Mailing address: PO Box 4188, Frisco, CO 80443
Physical address: Emergency Services Building, 0227 County Shops Road/CR 1003
in Frisco (behind the Summit Stage Bldg.).
SUMMIT COUNTY COMMUNICATIONS CENTER
Position Title: Database AdministratorDepartment: 911 Communications Center FLSA Status: Non-exempt
Pay Grade: $54,400 - $84,400
GENERAL DESCRIPTION
The Database Administrator is responsible for the design, setup, and management of Microsoft SQL databases used by the Summit County 911 dispatch center and supported agencies.
The Database Administrator’s main responsibility is the maintenance of existing databases including: production support, security and auditing, performance tuning, backup and recovery, data replication, disaster recovery and testing,
compliance with CJIS (Criminal Justice Information Service) standards, policies and procedures, and documentation. The Database Administrator must have an in-depth understanding of Microsoft SQL database design and TSQL statements, ODBC data sources, and Microsoft Windows operating systems.
In addition, the Database Administrator will frequently be called upon to complete ad hoc reporting, infrastructure construction and maintenance, cross-training/support of other technical staffers, and other duties as assigned. The position will have a high degree of autonomy and requires ingenuity in the creation of further detailed duties.
SUPERVISION RECEIVED
Works under the direct supervision of the SCCC Director.
SUMMARY OF RESPONSIBILITIES
The following areas will require varying levels of involvement from the Database Administrator, ranging from supervision to assistance.
• Support the existing MS SQL Server environment
• Manage the current MS SQL Server database clusters, and install and configure new instances as required. • Ensure backup strategy is functioning correctly by monitoring and testing database backups.
• Validate disaster recovery strategy and provide recommendations for improvements.
• Monitor database performance and advise database tuning, index/query optimization and on additional hardware if required.
• Verify database change scripts before promotion into production environments.
• Troubleshoot SQL Server unplanned outages, including during evenings and weekends if necessary. • Compliance with CJIS security policies
• Provide input for future projects during the planning, design, implementation and maintenance phases of development.
ADMINISTRATIVE DUTIES
• Create and publish reports based upon SCCC needs
• Assist with development and maintenance of documentation, including policies and routines
• Assure all responsibilities related to user data protection are accomplished as designed and in a timely manner
• Provide support on IT projects as assigned
• Execute all tasks related to inventory of assets, components, and software
• Maintain professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; participating in professional societies
IMPORTANT FUNCTIONS
• Provide tier 2 technical support to users by answering questions, troubleshooting problems, maintaining workstation and server performance
• Develop technology implementation test plans prior to deployment of new technologies • Assist in the preparation of budget documentation and maintain accurate monthly budget • Prioritize and manage ongoing technical projects
• Perform and verify backups on all systems
REQUIRED ABILITIES/CERTIFICATIONS
• Valid driver’s license.
• Bachelor’s degree in Computer Science or related field • Transact SQL experience (3 years)
• SQL Server 2012 R2 knowledge and experience (SQL 2014 knowledge is a plus) • Knowledge of MS SQL Cluster Administration
• Knowledge of storage technologies (NAS, SAN) and familiarity with server virtualization technology (VMware preferred)
• Experience following best practices with SQL servers in a virtual environment (VMware preferred) • Experience with MS SQL Server Management Studio
• Able to satisfactorily pass a criminal background investigation as determined by the Criminal Justice Information Services Division (CJIS).
• Ability to work varying days, hours and shifts as well as occasional on-call
• Ability to establish and maintain effective working relationships with a diverse group of people • Ability to work independently with minimal supervision
• Excellent interpersonal and customer service skills • Ability to maintain confidentiality
• Excellent written and verbal communication skills • Good organizational skills
• Strong understanding of current commonly-used concepts, technologies, practices, and procedures • Basic technical knowledge of servers, networks, mobile devices, applications required.
• Intermediate usage level with Web based systems, and Microsoft Office products including Word, Excel, and PowerPoint required
• Ability to express technical terms in basic language, both verbally and written
PREFERRED ABILITIES
• MCTS, MCITP, or MCDBA certifications • Database engine tuning advisor (DTA) (7 years) • BI Stack (5 years)
• SSMS (3 years)
• SSIS ETL Packages (Extraction, Transformation, Load) • Relational and dimensional data modeling skills
• Experience working with Amazon web services (AWS) or Microsoft Azure is a plus • PowerShell Scripting is a plus
• Experience with Project Management
• Microsoft Technology Associate Certification (MTA)
MATERIALS AND EQUIPMENT DIRECTLY USED
Personal computers; digital and other copy machines; mail machines; computer printers; county vehicles. Personal computer software includes Outlook, Word, Excel, PowerPoint, VmWare VSphere, ticketing software, SQL Server Management Studio, Citrix XenCenter, Remote Desktop, records management software, internet and intranet and others as required.
WORKING ENVIRONMENT/PHYSICAL ACTIVITIES
Work is performed indoors at in the Summit County Communications work area. Generally sedentary at a desk, regularly exerting up to 10 - 20 pounds to lift, carry, push, pull or move objects. Training and other duties infrequently require moderate lifting of 15- 30 pounds. Physical activities include, but are not limited to, moving about the Communications Center building, sitting, standing, bending, stooping, kneeling, squatting, reading, writing, typing, verbal/audible communication, and visually observing situations. A high degree of public contact, including interaction with walk-in customers is required. May need to walk and/or drive a County or personal vehicle.
Environmental factors would include limited exposure to weather conditions; working closely with others in a close office setting; working with office machinery; and exposure to noise.
Interpersonal communications include contact with the public or employees where explanatory or interpretive information is exchanged, gathered or presented.
ACKNOWLEDGEMENT
I acknowledge this document as a detailed description of my responsibilities as the Communications Alarm Database Administrator, knowing public safety is a changing and dynamic field, and policies and procedures will change as needed. I will read, understand and adhere to all Summit County Government and Summit County Communications Policies and Procedures.
Note: This job description is not intended to be an exclusive list of all duties, responsibilities or qualifications associated
with the job. It is the policy of Summit County Government not to discriminate on the basis of race, color, national origin, ancestry, citizenship, religion, age, physical or mental disability, medical condition, sexual orientation, marital status, veteran status or any other protected basis is unlawful under federal and state law
Page 1 of 4 updated 7.30.2014
Summit County Government Employment Application
Summit County is an equal opportunity employer, dedicated to a policy of non-discrimination in employment or the provision of services on any basis including race, color, religion, sex, age, sexual orientation, disability or national origin. Summit County only hires individuals authorized to be employed in the United States.Answer each question fully and accurately. Please print in INK or TYPE, except for signature on application.
Position Applied for: ___________________________________________________________________
Applicant Information
Full Name: _______________________________________________Date:________________________
Last First M.I.
Mailing Address: ______________________________________________________________________
Mailing address City State Zip Code
Phone: _________________________ E-mail address: ________________________________________ Date Available for employment: _____________________________ Desired Salary: ______________ Are you eligible to work in the United States? Yes No
Desired Employment? Full-time Part-time
Hours of work per week desired? __________________
Page 2 of 4 updated 7.30.2014 Applicant Education
High School: _________________________________ Address: _________________________________ Did you graduate? Yes No
College: _____________________________________ Address: _________________________________ Did you graduate? Yes No
Other: _____________________________________ Address: _________________________________ Did you graduate? Yes No
Previous Employment
Company: ___________________________________________________ Phone: __________________ Address: _______________________________________________Supervisor:_____________________ Job Title: _________________________Starting Salary: $____________Ending Salary: $_____________ Responsibilities:
From: __________ to: _____________ Reason for leaving: ____________________________________ May we contact your previous for a reference? Yes No
Company: ___________________________________________________ Phone: ___________________
Address: _______________________________________________Supervisor:_____________________ Job Title: _________________________Starting Salary: $____________Ending Salary: $_____________ Responsibilities:
Page 3 of 4 updated 7.30.2014
Previous Employment (continued)
Company: ___________________________________________________ Phone: __________________ Address: _______________________________________________Supervisor:_____________________ Job Title: _________________________Starting Salary: $____________Ending Salary: $_____________ Responsibilities:
From: __________ to: _____________ Reason for leaving: ____________________________________ May we contact your previous for a reference? Yes No
Military Service
Branch: _______________________________________ From: ______________To: ________________ Rank at Discharge: ___________________________________________
Are you currently in the Armed Forces: Yes No
References
Please list three professional references.
Page 4 of 4 updated 7.30.2014 Disclaimer and Signature
JOB APPLICANT’S AGREEMENT AND VERIFICATION
I certify that the information given by me in the application is true in all respects, and I agree that if the information given is found to be false in any way, it shall be considered sufficient cause for denial of employment or discharge. I authorize the use of any information in the application to verify my statements, and I authorize the past employers, all references, and any other persons to answer all questions asked concerning my ability, character, reputation, and previous employment record. I release all such persons from any liability or damages on account of having furnished such information. I understand that nothing contained in this employment application or in the granting of an interview is intended to create an employment contract between Summit County and myself for either employment or for the provision of any benefit. No promises regarding employment have been made to me, and I understand that no such promise or guarantee is binding upon Summit County unless made in writing. If an employment relationship is established, I understand that I have the right to terminate my employment at any time and that Summit County retains the same right.
In the event that I have a disability as defined under the American with Disability Act (ADA), I may contact Human Resources to request reasonable accommodation in the application or interview process. I understand that prior to being offered employment with Summit County I may be requested to take an employment examination. In the event I have a disability, which will affect my ability to take the test, I will also inform Summit County prior to the administration of the test so that a reasonable accommodation can be made. Summit County reserves the right to require medical documentation concerning the need for the accommodation.
I understand that if employed, policies and rules, which are issued by Summit County, are not conditions of employment and that the employer may revise policies or procedures, in whole or in part, at any time.
I understand that this application will be kept on the active file for 30 days from the date completed, after which time I would have to reapply in accordance with established Summit County procedures.
