Database Administrator I

Canyon County (ID) • Caldwell, ID

186d • $29 - $34

About The Position

County Database Administrators monitor, maintain, and ensure the availability, recoverability, security, and integrity of County databases. Working closely with the Database Administrator III and other members of the Information Technology team, they are involved in implementing & supporting database infrastructure relating to County Business.

Requirements

• 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

Nice To Haves

• Microsoft DP-900, CompTIA Data+, or equivalent formal training; Microsoft Azure Database Administrator Associate a plus
• Additional relevant education and experience required for the position

Responsibilities

• 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
• 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
• 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
• 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
• 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

Benefits

• Equal Opportunity Employer
• Employment decisions related to recruitment and selection are made without regard to race, color, religion, sex, national origin, age, disability or genetic

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Industry: Executive, Legislative, and Other General Government Support
• Education Level: Associate degree