Systems Coordinator - Database Administrator

Job Summary Designs, installs and configures database servers, logs and backups, using high availability technologies. Maintains the integrity, resiliency, and security of the County’s databases. Gathers and documents application requirements, systems design, application development & maintenance of information systems. Works closely with County staff, outside agencies and software vendors to ensure systems meet the long-term goals and business strategies of the County. Responsible for designing, installing, configuring, and migrating data, as well as monitoring performance, troubleshooting issues, and fine-tuning databases for optimal performance. Responsible for the control, security, accessibility of county documents and data. Essential Job Functions Essential functions may include any of the following tasks, knowledge, skills and other characteristics. The list that follows is not intended as a comprehensive list; it is intended to provide a representative summary of the major duties and responsibilities. Incumbent(s) may not be required to perform all duties listed, and may be required to perform additional, position-specific tasks. Reasonable accommodations, as defined under the American with Disabilities Act, will be made when possible.

Defines and develops repeatable and/or customized solutions in the County’s enterprise-wide document management systems including database and data architecture, system design and architecture and workflow analysis to ensure that organizational needs are met.

Serves as the lead on assigned application and databases to architect, implement, enhance, and test database servers, using high availability technologies to ensure minimal downtime for production environments.

Coordinates information systems activities within the County and with outside agencies.

Performs complex configuration analyses, change management and testing activities to support applications, which includes installing new software, new software releases and system upgrades, evaluating and installing patches, and performing data conversions ensuring accuracy and quality. Performs on-going support and integration between applications.

Programs, installs, configures, upgrades, administers, supports and manages various application systems and databases; ensures compatibility and integration for software systems utilized throughout the county; provide appropriate system and user documentation for new and existing software applications.

Plans and implements strict security measures to safeguard data from unauthorized access, loss, or corruption. Manages user permissions and maintain access logs.

Develops and executes robust backup, archiving, and disaster recovery plans for databases and database servers to prevent data loss.

Performs capacity planning by evaluating storage requirements and scaling database infrastructure to accommodate business growth.

Monitors database health, identify bottlenecks, and optimize query performance to ensure systems run efficiently.

Assists County staff regarding software, hardware, and technical problems as requested; educates users and other IT staff to forestall reoccurrence of situation; evaluates and establishes effective user interface; enlists outside support or services as needed.

Creates and contributes detailed documentation (streamline workflows, escalation model, support model, diagrams, application product support run books and FAQ updates as needed).

Manages outages and incidents of assigned technologies (handling, notification/client communication, troubleshooting, tracking, resolution, root cause analysis “post mortem” documentation).

Prepares and publishes Requests for Proposals or Bids for hardware/software packages and/or vendors; analyzes proposals and bids received; makes recommendations for award.

Performs all phases of project management, such as identifying project milestones, phases and elements. Creates and maintains project schedules by developing project plans and specifications, estimating time and resources, monitoring milestone completion and resolving conflicts. Creates and maintains meeting minutes, meeting schedules, project summaries and updates.

Assesses business process and system inefficiencies. Identifies improvement opportunities (proactive and reactive).

Ability to understand and negotiate needs and expectations of multiple stakeholders; analyzes and synthesizes business requirements and identify ways to increase adoption and customer satisfaction.

Assists IT Leadership Team with budget by obtaining quotes and completing audits for license counts and application systems costs.

Provides assistance to County staff/customers regarding software questions and technical problems as needed; educates customers and IT staff to prevent reoccurrence of problem situations; evaluates and establishes effective user interface; enlists outside support or services as needed.

Maintains and upgrades professional knowledge, skills, and development by attending seminars and training programs and reading trade and professional journals and publications in order to maintain highest level of information, services and equipment for the County.

Cross-train with other IT teams to develop proficiency in other technologies, applications, and support processes.

Performs other related duties as assigned.

Regular and predictable attendance is required.

MATERIALS AND EQUIPMENT USED:

Computers, Servers, General Office Equipment, Personal Computers and peripherals, Telecommunications equipment, Scanners Minimum Qualifications Required

Education and Experience:

Bachelor's degree from an accredited four-year college or university or technical degree/certification in electronics, telecommunications, management information systems, computer science or a related field; and Three to four years of progressively responsible related experience, or any combination of education, training and experience which provides the required knowledge, skills, and abilities to perform the essential functions of the job.

Licenses and Certifications:

Valid Driver’s License Knowledge, Skills and Abilities

Knowledge of:

• 3-tiered application architecture
• Application administration
• Networking
• Active Directory/AzureAD/LDAP authentication
• SharePoint Online (Preferred)
• Experience with Laserfiche EDM (Preferred)
• Project Management
• Software development - At least two (2) years of programming experience with web development technologies, such as PHP, HTML, CSS, JavaScript, and JQuery.
• Database proficiency - Ability to create and maintain SQL databases (SQL tables, SQL scripts, stored procedures and SQL Server agent jobs). Preference will be given to candidates who have experience with MS SQL Server database, MS SQL Reporting Services.
• Application software with experience in server and client interface.
• Generally accepted business practices and principles.

Skill in:

Using tact, discretion, initiative and independent judgment within established guidelines. Teamwork, Collaboration, and Management of co-worker, customer and client relationships. Organizing work, setting priorities, meeting critical deadlines, and following up assignments with a minimum of direction. Applying logical thinking to solve problems or accomplish tasks; to understand, interpret and communicate complicated policies, procedures and protocols. Communicating clearly and effectively, both orally and in written communications.

Ability to:

Ability to establish and maintain effective working relationships with a variety of individuals. Ability to comprehend, diagnose and resolve software applications issues and problems. Ability to analyze complex problems and develop appropriate solutions. Ability to act with discretion and maintain confidentiality. Ability to read, analyze and interpret professional periodicals and journals, technical procedures, operation and maintenance instructions, and so forth. Ability to communicate highly technical information to non-technical users. Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Non-Discrimination and EEO Statement La Plata County prohibits discrimination against or harassment of any person employed or seeking employment with La Plata County on the basis of race, color, religion, sex (including pregnancy), age, national origin, disability, veteran status, political affiliation, sexual orientation, gender identity, marital status or genetic information.

La Plata County is an equal opportunity employer and assures equal employment opportunities for protected classes, persons with disabilities and for covered veterans. Covered veterans include: special disabled veterans, recently separated veterans, Vietnam era veterans, or any other veterans who served on active duty during a war or in a campaign or expedition for which a campaign badge was authorized.

Inquiries regarding La Plata County's equal employment opportunity policies may be directed to:

Director of Human Resources 1101 E 2nd Avenue Durango, CO 81301 Tel: (970)382-6361 Fax: (970)375-7985 Email: HRHelpdesk@lpcgov.org

Benefits

La Plata County offers an extensive comprehensive package including medical, dental, vision, retirement, long term disability, life insurance, annual, sick and paid parental leave.

For a complete description of our benefits, please view our Summary of Benefits.

Important Notices

This job description is not intended to be a comprehensive list of activities, duties or responsibilities for this job. The duties, expectations and actions listed for this role may change at any time with or without notice.

Job Application Fairness Act

In accordance with CO SB23-058, applicants understand that La Plata County will not request or require the applicant to include their age, date of birth, or date of attendance/graduation date on the initial application. Applicants understand that La Plata County can request or require an individual to provide documentation including copies of certification, transcripts, and other materials created by a third party. The applicant understands that the applicant can redact, if they so choose, information that identifies age, date of birth, or dates of attendance/graduation from an educational institution on those requested/required certification, transcripts and other materials created by a third party.

Equal Employment Opportunity

La Plata County is proud to be an Equal Opportunity Employer and is committed to the full inclusion of all qualified individuals. As part of this commitment, our agency will assist individuals who have a disability with any reasonable accommodation requests related to employment, including completing the application process and/or to perform essential job functions where the requested accommodation does not impose an undue hardship. If you have a disability and require a reasonable accommodation to ensure you have a positive experience applying or interviewing for this position, please direct your request to HRHelpDesk@lpcgov.org.