Database Administrator I Job at Canyon County, Caldwell, ID

TkVNOGRQb3BMU0I5bDJrVWFNaUlwY0ZaV3c9PQ==
  • Canyon County
  • Caldwell, ID

Job Description

Job Description

Job Description

wage: $29.00 - $34.51 per hour, DOE

Job Summary

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.

Key Responsibilities

  • 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

Qualifications

Skills and Abilities

  • 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

Special Qualifications

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

Education and Experience

  • 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

Essential Physical Abilities

  • 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

Disclaimer

To perform this job successfully, an individual must be able to perform the primary job responsibilities satisfactorily with or without reasonable accommodation. The above statements are intended to describe the general nature and level of work being assigned to this job. They are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required of individuals in the job. This job description is not an employment agreement and/or an expressed or implied employment contract. Management has the exclusive right to alter this job description at any time without notice.

Canyon County is an 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

Job Tags

Hourly pay, Contract work, Work at office, Flexible hours,

Similar Jobs

Red Rabbit

Head Chef for In-School (No Weekends/Holidays) - Center Philadelphia Area Job at Red Rabbit

 ...team. The position offers most national Holidays as Paid Time Off and No Weekend Work. If you are passionate about...  ...Reimbursement available) Additional Information Job Type: Full Time Typical Hours: Monday - Friday approx- 6:00 AM to 3:00 PM Location: Center City,... 

Assured Nursing

Travel Telemedicine Outpatient Clinic RN Job at Assured Nursing

 ...Job Description Assured Nursing is seeking a travel nurse RN Clinic for a travel nursing job in Oak Bluffs, Massachusetts. Job...  ...Employment Type: Travel RN telemedicine. 10/6 start date. RHC outpatient practice. 40-hour onsite office position. Multi-specialty... 

Schneider

CDL-A - Dedicated Truck Driver Job at Schneider

 ...$1,400 weekly Home Time: Weekly Experience: Open to all CDL holders Join us to haul paper products using dry van trailers...  ...Learner's Permit is required for candidates pursuing company-paid CDL training. Applicants should reside within 85 miles of Green Bay, WI.... 

Emprise Corporation

Marine Engineer Job at Emprise Corporation

Join to apply for the Marine Engineer role at Emprise Corporation1 day ago Be among the first 25 applicantsJoin to apply for the Marine Engineer role at Emprise CorporationGet AI-powered advice on this job and more exclusive features.Emprise Corporation is a fast-growing... 

Rogers Corporation

Technical Sales Engineer-Southeastern US Job at Rogers Corporation

 ...tools* Must be able to communicate fluently in the English language* Travel: Up to 50% Considering remote applicants who reside in the United Sales: DE, FL, GA, MD, NC, NJ, PA, SC, TN, VA. Applicants from other states may not be elgible for consideration. Full-Time