Database Administrator

POSITION: Database Administrator

POSTING #: 2965-0122sr

To apply for this position, please use the View Openings button at the Utah County Government website www.utahcounty.gov/jobs

REQUIRED ATTACHMENTS TO APPLICATION

College transcripts and/or diploma if related to position – internet printouts & photocopies are acceptable

GRADE: 518

STARTING SALARY: Step A: $86,652.80 - Step G: $99,611.20 annually / $3,332.80 - $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: March 18, 2022 CLOSING DATE: April 8, 2022 (11:59 p.m. MST)

Job Summary
Under general guidance and direction of the Database Administration Supervisor, develops, implements, administers, and maintains policies and procedures for ensuring the security and integrity of databases. Executes 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.

Essential Functions
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Recommend improvements to database physical structure, database security, data back-up, and recovery systems and procedures.

• Identify database requirements; analyze county applications, programming, and operations; evaluate existing systems and design proposed systems.

• Maintain database performance; calculate optimal 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.

• Ensure security procedures are maintained and adhered to; work with other IT teams, as needed.

• Ensure adequate system resources (disk space, memory, etc.); develop strategies to improve system performance; implement approved strategies, as directed.

• Participate in regular security audits.

• Program database functions, procedures, packages, and triggers.

• Develop database utilities and automated reporting.

• Document database standards, policies, and procedures.

• Programmatically interact with Oracle, Microsoft and other relational database tables.

• Design and create database tables, functions, triggers and procedures using PL/SQL.

• Actively promote a culture of innovation and productivity; consistently participate as a leader in personal and staff training, code reviews, and mentoring activities.

• Maintain overall integrity of assigned databases; coordinate and conduct regular database design and code reviews.

• Perform additional responsibilities as assigned by leadership; track and control activities for assigned projects; report status updates accurately and assure that management and team leaders are made aware of all problems or potential problems in a timely and professional manner.

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
Intermediate knowledge of hardware and networking
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
Skilled in various scripting languages
Skilled in data modeling and design
Skilled in communicating technically complex information both verbally and in writing
Skilled in problem-solving
Ability to work with application developers to ensure that the necessary changes to databases 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 work effectively and positively independently and within a team environment while maintaining cooperative relationships with users, key stake holders, team members, and management
Ability to foster and encourage a culture of innovation as a role model and mentor by personally seeking out innovative solutions and methods and sharing those with the team

Supervisory Responsibility
This position has no direct supervisory responsibility but does serve as a coach and mentor for other positions in the department.

Work Environment
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.

Physical Demands
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
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. Demonstratable work competence in database administration or a similar field.
4. Equivalent combinations of education, experience, and demonstrated work competence may also be considered.

Preferred Education and Experience

1. Preference may be given to applicants with a master’s degree in Information Systems or a related field.

2. Preference may be given to applicants with relevant and valid 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.

AAP/EEO Statement
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.

Other Duties
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.

Job Type: Full-time

Pay: $86,652.80 - $99,611.20 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Employee assistance program
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Parental leave
• Retirement plan
• Vision insurance

Schedule:

• 8 hour shift
• Monday to Friday

Work Location: One location