Prescott, Arizona
Database Administrator Job Opening in Prescott, Arizona - SUMMARY:
Administer and oversee the usage, activity, performance, integrity and availability of multiple databases over distributed development, test and production SQL Server environments.
Employment with Yavapai County Government is contingent upon successfully passing a criminal background check and verification of work history, academic credentials, licenses and certifications, as applicable.
MAJOR DUTIES AND RESPONSIBILITIES:
Work with programmers regarding data definition, manipulation and data management. (30%)
Monitor and support databases including tuning and disaster/recovery. (25%)
Identify the causes, troubleshoot and resolve production support issues. (20%)
Plan, install, integrate and provide limited support for purchased database applications.(10%)
Monitor and maintain jobs, scripts, databases and servers. (10%)
Performs other job related duties as assigned. (5%)
QUALIFICATIONS: Experience: Three years of experience as a Database Administrator. Education: Bachelor's Degree from an accredited college or university, with a major in Computer Science, Engineering, or related field. KNOWLEDGE AND SKILLS: Interpersonal Skills: Courtesy, tact and diplomacy are essential elements of the job. Work involves personal contact with others inside and/or outside the county for the purposes of giving or obtaining information, building relationships, making reports or soliciting cooperation. Other Skills: Extensive relational database knowledge and design skills using SQL preferably with MS SQL Server. Client/Server software development, proficiency in the use of SQL Server tools and utilities from version 2008 R2 to the present including: SSIS, T-SQL (DDL, DML, stored procedures, user defined functions, triggers, and views), DBCC, Maintenance Plans, Native SQL backup and restore, system procedures and tables, Execution Plans, Profiler, Traces, Job Scheduling, SSIS Package Development and Deployment, Alerts and Notifications, Indexes (tuning, rebuilding, and reorganizing), SMO, Service Broker, Web Services, etc.. Knowledge of business and management principles involved in strategic planning, resource allocation, leadership techniques and communication skills, production implementation and coordination of resources, reporting tools such as SSRS and Crystal Reports, and security as applies to database and application design.
APPLICATIONS ARE REQUIRED TO BE FILED ONLINE AT:
1015 Fair Street Room 338
Prescott, AZ 86305
Position #2017_00113 DATABASE ADMINISTRATOR (PRESCOTT) CS
Job Type: Full-time
Required education:
Bachelor's
Required experience:
database administation: 3 years
|
