POSITION: Database Administrator POSTING #: 2965-0120
REQUIRED ATTACHMENTS TO APPLICATION:
College transcripts and/or diploma if related to position – internet printouts & photocopies are acceptable
STARTING SALARY: Step A: $3,332.80 - Step G: $3,831.20 Bi Weekly
Salary will be determined upon experience and or education
Plus benefits package – Step increase available after completing probation and annually thereafter
OPENING DATE: January 28, 2020 CLOSING DATE: Open until filled
*All applications received by February 11, 2020 will be screened by the Human Resources Office. Those applicants meeting the specified qualifications and additional screening criteria will be referred for a hiring interview. The Human Resource Office will continue to consider qualified candidates as needed until the position is filled.
Under the guidance of the Director and the direct supervision of the Assistant Director – Information Systems, develops, implements, administers, and maintains policies and procedures for ensuring the security and integrity of databases. Implements data models, database designs, data access, and table maintenance. Resolves database performance and capacity issues, replication, and other distributed data issues. Performs mission critical database administration work in Oracle and potentially other platforms.
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
- Recommend solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.
- Identify database requirements by analyzing county applications, programming, and operations; evaluate existing systems and design proposed systems.
- Maintain database performance by calculating optimum values for database parameters; implement new releases; complete maintenance requirements.
- Evaluate computer operating systems and hardware products.
- Maintain quality service by establishing and enforcing organization standards.
- Perform data queries; coordinate testing, train users, and provide documentation.
- Work with other IT groups to ensure security procedures are maintained and adhered to.
- Ensure adequate system resources (disk space, memory, etc.); develop strategies for improving system performance.
- Participate in regular security audits.
- Program database functions, procedures, packages, and triggers.
- Develop database utilities and automated reporting.
- Document database standards, policies, and procedures.
- Other related duties, as assigned.
Knowledge, Skills, and Abilities
Knowledge of Oracle Enterprise Edition
Knowledge of Microsoft SQL Server
Knowledge of security procedures and technologies and an understanding of audit processes
Skilled in monitoring and tuning a database to provide a high availability service and optimum storage capability
Skilled in query optimization and initialization parameters
Skilled in Oracle backup and recovery procedures
Skilled in programming in a procedural format using PL/SQL
Intermediate knowledge of hardware and networking
Skilled in various scripting languages
Skilled in data modeling and design
Skilled in problem-solving
Ability to work with application developers to ensure that the necessary changes to the database meet the required deliverables
Ability to provide excellent customer service and public relations outreach
Ability to effectively manage multiple priorities and meet deadlines
Ability to adapt to varied roles and job responsibilities
Ability to use a life cycle management process for implementation of changes in technology
Ability to excel both independently and as a team member
Ability to communicate effectively verbally and in writing
Ability to communicate difficult concepts and make them easy to understand
This position has no direct supervisory responsibility but does serve as a coach and mentor for other positions in the department.
This job operates in a professional office environment but occasionally exposes incumbent to electrical hazards during systems installation and maintenance. Work may expose the incumbent to high stress situations including contact with the public and others in confrontational, emotionally charged, or uncomfortable circumstances. This role routinely uses standard office equipment such as a laptop, desktop, smartphone, photocopiers, shredders, and filing cabinets. The noise level in the work environment is usually moderate. The incumbent may be required to drive Utah County owned vehicles in the course of conducting County business and must abide by the Utah County Vehicle Policy.
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.
While performing the duties of this job, the employee is required to use manual dexterity to handle, feel, and operate objects, tools and controls, and reach with hands and arms. This employee is frequently required to stand, talk, and hear. Specific vision abilities by this job include close vision and ability to adjust focus. The employee is required to type, file and lift supplies up fifty (50) pounds. The employee occasionally drives a motor vehicle.
Position Type / Expected Hours of Work
Incumbent must work eighty (80) hours each pay period to maintain full-time status. There may be availability to work out a flex schedule ahead of time that works for both the County and the employee. Occasional evening and weekend work may be required as job duties demand.
Travel is primarily local during the business day, although some out-of-area and overnight travel may be expected, up to five (5) percent.
Required Education and Experience
1. Bachelor’s degree in a related area or equivalent.
2. Two (2) years conducting general database administration tasks, such as database implementations, backups, and account maintenance.
3. Equivalent combinations of education and experience may also be considered.
Preferred Education and Experience
1. Master’s degree in Information Systems or related.
2. Certifications such as MCSE DBA, Oracle Associate, or equivalent.
Additional Eligibility Qualifications
1. Applicants must possess a valid driver’s license and obtain a valid State of Utah driver’s license within sixty (60) days of employment.
2. Selected applicants will be required to submit to a pre-employment drug screen and background check.
It is the policy of Utah County Government to assure equal employment opportunity to its employees and applicants for employment without regard to race, color, religion, national origin, disability, age, sex, sexual orientation, genetic status or gender identity.
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee of this job. Duties, responsibilities, and activities may change at any time.
Utah County Government is a drug-free workplace.
Effective Date: 1/17/2020
UTAH COUNTY IS AN EQUAL OPPORTUNITY EMPLOYER