Database Administrator I

• Database Administration

• Administers a database environment, managing database servers, relational databases, and instances; manages databases through their lifecycle, including upgrades, migrations, and retirement
• Maintains a knowledge of database technologies and follows Database Administration team standards used in planning within development, test, and production environments
• Collaborates and implements emerging database technologies

• System Monitoring and Maintenance

• Monitors notifications and alerts, diagnoses, and troubleshoots database errors and performance concerns
• Performs patch management to ensure database systems are current with security patches and updates
• Creates and coordinates automation for repetitive database tasks

• Data Protection and Security

• Protects county data following county policy and procedure
• Ensures data integrity and security through appropriate access controls and encryption, including controlling access with external County partners
• Audits daily reports of the County backup system, and performs scheduled recovery testing

• Data Reporting and Analysis

• Administers and manages the reporting environment and associated services
• Participates in evaluating new technologies to ensure the advancement of technology architecture and data within the organization

• Other Duties

• Contribute to project planning, tracking, and management
• Train continuously to stay current with industry changes
• Performs all work duties and activities following County policies, procedures, and safety practices
• Performs all other duties as assigned

• Working knowledge and experience with relational database architecture and optimization techniques, including normalization and indexing
• Working knowledge and experience with Microsoft SQL Server (2016, 2017, 2019, 2022); SSRS and SSIS knowledge a plus
• Knowledge of Structured Query Language (SQL), T-SQL, PL/SQL, and other database programming languages. MySQL knowledge a plus
• Knowledge of database security protocols, access control, and user management
• Familiar with Windows server and server applications
• Experience implementing database backup and recovery methods
• Understanding of data analysis, data modeling, and data warehousing is a plus
• Develop and maintain database-related documentation and guidelines
• Participate in meetings and discussions to promote effective enterprise database design and security practices
• Strong verbal and written communication; effective collator with internal teams and vendors
• Committed to providing excellent service; flexible work after hours for maintenance and security

• Must possess a valid Driver’s License
• Must successfully complete a background check through the National Crime Information Center (NCIC)

• High School diploma or GED equivalent is required
• Associates or Bachelor’s degree in Computer Science, Information Systems, or Software Engineering
• Microsoft DP-900, CompTIA Data+, or equivalent formal training; Microsoft Azure Database Administrator Associate a plus
• Minimum two-year database administration experience
• Additional relevant education and experience required for the position

• Clear speech with or without an accommodation, to effectively convey detailed or important instructions or ideas accurately, loudly, and/or quickly
• Sufficient clarity of hearing with or without reasonable accommodation to enable the employee to hear average or normal conversations and receive ordinary information
• Visual acuity, with or without an accommodation, to read instructions, review, and organize documents
• Requires sufficient personal mobility and physical reflexes, which permits the employee to function in a general office environment to accomplish tasks
• Ability to lift up to 50 pounds

Canyon County