Application Administrator

Laramie County; Cheyenne (WY); On-site; USD 65,000 - 105,000; Full time

Job summary

Laramie County is seeking a Database Administrator to coordinate and enhance its database environments under general supervision. The role focuses on maintaining data integrity, uptime, security, and supporting agency IT needs.

Responsibilities include diagnosing issues, applying patches, performing backups, and generating reports while collaborating with development teams and users to ensure reliable data services for county operations.

Qualifications

• Bachelor's degree in Computer Science or related field, or four years of related experience.
• Experience in database and network administration, preferably.
• Successful completion of a criminal history and background check.

Responsibilities

• Manage and maintain databases and applications; provide technical support to government agencies.
• Monitor system environment for security, access, functionality and uptime; resolve issues.
• Perform backup and recovery planning; test patches and upgrades.
• Develop and run custom queries and reports; distribute data to agencies and users.
• Provide technical support to application development teams; train staff as needed.
• Maintain documentation and ensure security guidelines are followed.

Skills

Relational databases

SQL troubleshooting

Analytical thinking

Time management

Team collaboration

Education

Bachelor's degree in Computer Science or related field

Tools

MS Windows

AS400

SQL Server

Database backup tools

Job description

Under general supervision, coordinates the use of database systems; resolves problems, upgrades applications, and assures the security and integrity of the database. This essential function, as defined under the Americans with Disabilities Act, may include the following tasks, knowledge, skills and other characteristics. This list of tasks is ILLUSTRATIVE ONLY, and is not a comprehensive listing of all functions and tasks performed by positions in this class.

• Manages and maintains databases and applications. Provides technical support services for various government agencies.
• Monitors system environment, access, security, functionality, and utilization; resolves traffic, security, and access problems; assures optimum performance and system integrity.
• Maintains system stability, data integrity, and maximum uptime; provides referral to supervisor when problems occur that are beyond the skills of the Information Technology Department, and tracks the problem until it has been resolved.
• Monitors databases and applications; troubleshoots and resolves software and hardware problems.
• Monitors utilization trends to enhance performance and assure maximum uptime; performs ongoing technical tuning of the database systems to improve performance.
• Consults with users to identify concerns and implements changes to improve content and service; provides recommendations for technical corrections to prevent disruption to the database.
• Installs and tests patches and upgrades of the databases and applications; plans and implements backup and recovery of the databases as needed; prepares and updates technical documentation.
• Compiles and analyzes various reports and user statistics; creates custom queries and reports as needed; coordinates the distribution of data to other government agencies, clients and users.
• Provides technical support and training as needed.
• Manages local and remote access; creates user accounts and resource access lists.
• Provides technical support to application development teams; resolves database and application problems with the IT staff and user groups.
• Keeps up to date on trends in government technology and makes recommendations to supervisor or other government agencies.
• Performs other duties as assigned or required.

Minimum Qualifications: Bachelor's Degree in Computer Science or related field; OR four (4) year’s experience in database and network administration, preferably; OR equivalent combination of education, training and experience; AND successful completion of a criminal history and background check.

Knowledge and Skills:

• Knowledge of County organization, policies and procedures.
• Knowledge of MS Windows, AS400, SQL, data servers and storage devices.
• Knowledge of relational database administration principles including communications protocols, SQL applications, computer components and peripherals.
• Knowledge of system access and security guidelines and procedures.
• Knowledge of computer programming languages, technologies and protocols.
• Knowledge of hardware and software troubleshooting techniques in a networked environment.
• Knowledge of database backup and recovery procedures and techniques.
• Knowledge of current trends and information sources for managing database systems.
• Knowledge of records management and retention best practices, and other governmental technologies..
• Ability to foster a workplace culture focused on excellent customer service.
• Ability to effectively manage time and resources.
• Ability to work independently and collaboratively within a team.
• Ability to maintain a professional and positive work attitude.
• Skill in analyzing database issues, evaluating alternatives, and making logical recommendations based on findings.
• Skill in installing, maintaining, modifying, and upgrading database software.
• Skill in managing database changes through all the stages of the development lifecycle.
• Skill in the use of computer hardware, software, and peripheral devices.
• Skill in assessing and prioritizing multiple tasks, projects and demands.
• Skill in project management.
• Skill in establishing and maintaining effective working relationships with public officials, outside agencies, County staff and the general public.
• Skill in effectively communicating verbally and inwriting.