Database Engineer

J  o  b    D  e  s  c  r  i  p  t  i  o  n

Job Information

Title:

Database Engineer

Market Range:

IT15

Approved Date:

2/12/2021 12:41:53 PM

FLSA:

Exempt

EEO Code:

PROFESSIONALS

Career Level:

P3

Career Level Description:

Professional Level 3

Job Code:

100177

Job Family:

Information Technology

Sub Family:

Database Administration and Development

Primary Purpose

Develop, administer, implement, and  maintain  policies and procedures for ensuring the security and integrity of the County's MS SQL Server and Oracle databases.  Provide technical review, development, testing and implementation of application databases. Perform upgrade and maintenance projects. Assist in budget preparation and acquisition of technology. Maintain a level of knowledge that is current with new technology. Provide technology consultation and support. Define and support best practices for development and maintenance of applications and databases.

•

Define requirements and design solutions featuring MS SQL Server and Oracle Design and write program code for database access, modifications and constructions including stored procedures, SQL Server and Oracle Integration Services ,SQL Server and Oracle Reporting Services. Automate functions to load and replicate data. Ensure proper documentation and adherence to development best practices. Consult with IS Staff and business users to provide expert options on database deployment and performance.

1

40%

•

Perform SQL Server and Oracle system administration functions, including back ups, configuration changes, reporting, scripting, upgrades, and reporting.

2

25%

•

Develops strategies for database deployment and configuration.

3

20%

•

Partner with the Database Manager and Server Team personnel to devise optimum configurations for database, including backup and recovery, and data mirroring strategies.

4

10%

•

Stay current on emerging database technologies and best practices.

5

5%

Position(s) may perform other duties in addition to the above as assigned by management.

*IMPORTANT* In the event of an emergency, as determined by the County Manager or designee, participation in preparedness and response operations should be expected. Employee may be required to fill a temporary assignment in a role different from standard duties, work hours and/or work location in preparation for, during and after the emergency. Employee may also be required to participate in relevant exercises and regular preparedness training.

Career Level Dimensions

Career Level:

P3

Career Level Description:

Professional Level 3

•

Plans and manages projects that have significant impact on Work Group and Division results OR works as a technical expert within a Medical or Scientific Discipline.

•

Shares insights and analyses that inform new processes, and/or operational plans.

•

Responsible for making improvements in processes, systems, or standards to enhance performance of the Work Group.

•

Works to influence parties within and outside of the Work Group and Division regarding projects and procedures.

•

May be responsible for providing guidance, coaching and training to other employees within the Work Group.

•

Requires advanced knowledge of the Work Group and Division typically obtained through advanced education combined with experience. May have practical knowledge of project management.

•

Within Medical or Scientific Disciplines, typically requires a doctoral degree.

Qualifications

•

Bachelor's degree in Computer Science, Information Systems, Computer Engineering or related field

•

Four years of experience in network or database design and administration

•

Equivalent education and experience are accepted

•

3 Years

Experience installing and supporting MS SQL Server 2008 – 2014 or Oracle versions 11.2 through Oracle 19C

•

3 Years

Extensive experience using SQL Server Integration Services (SSIS) or writing and reviewing Oracle PL/SQL

•

3 Years

Advanced SQL coding skills for both adhoc usage and creation of stored procedures and functions

•

3 Years

Experience using SQL Server Reporting Services (SSRS) or Oracle SQL*Plus

•

2 Years

MS PowerShell or BASH shell scripting experience

•

2 Years

Experience supporting both hosted and on-premise applications

•

Knowledge of the principles and practices of customer service to develop and maintain a high level of customer satisfaction with the services delivered by the department

•

Ability to work cooperatively in a team environment

•

Excellent verbal and written communication skills

•

MS SQL Server mirroring and Availability Groups or VMware clustering technology

•

Experience writing programs and scripts using the C# programming language/VB.Net or BASH

•

Understanding of MS software or Oracle licensing

•

Cohesity backup and recovery for MS SQL Server or Oracle

•

MS SharePoint or Oracle

•

VMware configuration for MS SQL Server or Oracle

•

Storage Array Network (SAN) technology

An individual must be able to perform each essential duty satisfactorily to perform this job successfully. The requirements listed above are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Competencies

Analysis

Examines data to grasp issues, draw conclusions, and solve problems.

Attention to Detail

Thoroughness in accomplishing a task through concern for all the areas involved, no matter how small. Monitors and checks work or information and plans and organizes time and resources efficiently.

Customer Service

Balances interests of a variety of clients, and readily readjusts priorities to respond effectively to pressing and changing demands for information, advice and assistance.  Anticipates and meets the needs of clients; achieves quality end products; and commits to continuous improvement of services.

Technical Expertise

Applies and improves extensive or in-depth specialized knowledge, skills, and judgment to accomplish a result or to accomplish one's job effectively.

Technology Management

Keeps up-to-date on technological developments. Makes effective use of technology to achieve results. Ensures access to and security of technology systems.

Relationship Building

Builds constructive working relationships characterized by a high level of acceptance, cooperation, and mutual respect.

Integrity

Act with honesty, transparency and respect in our interactions with co-workers and those we serve. Adhere, without exception, to laws, policies, procedures and professional standards.

Accountability

Establish high-quality standards for work. Add value. Measure results and hold self and others accountable for making progress toward desired outcomes. Take a logical and data-driven approach to decision-making.

Diversity

Believe that different backgrounds and experiences strengthen the organization and produce better results. Value inclusion across race, gender, age, religion, identity and experience, and strive to reflect in our workforce the diversity of our community.

Collaboration

Foster a work culture in which different ideas and opinions are encouraged and expected. Listen carefully and speak thoughtfully. Work together toward shared goals with mutual respect and cooperation.

Continuous Improvement

Continuously improve work processes and products. Provide a safe environment to be innovative and creative and try new things. When things don't go as planned, use it as an opportunity to learn, regroup and begin again. Provide time and resources for individuals to grow and develop both personally and professionally.

Wellness

Take proactive steps to be physically fit and healthy, emotionally strong, financially secure and socially fulfilled, while inspiring and empowering others to do the same.

Service Orientation

Commit to making a difference within the community. Actively engage in and enjoy our work. Deliver services that exceed expectations, with courtesy, politeness and sensitivity to the experiences, concerns and feelings of all co-workers and customers.

ADA Checklist

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. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions

Standard ADA Selection:

Office Environment

Standing

X

Walking

X

Sitting

X

Lifting/Carrying 0-10 pounds

X

Lifting/Carrying 10-20 pounds

X

Lifting/Carrying 20-50 pounds

X

Lifting/Carrying 50-100 pounds

X

Pushing

X

Pulling

X

Climbing

X

Balancing

X

Stooping

X

Kneeling

X

Crouching

X

Crawling

X

Reaching

X

Handling

X

Grasping

X

Fingering

X

Feeling

X

Talking

X

Hearing

X

Visual Perception

X

Repetitive Motions

X

Eye/Hand/Foot Coordination

X

Memorization/Concentration

X

Learning/Knowledge Retention

X

Preparing/Analyzing Numerical Figures

X

Use of Interfaced Commmunication Devices (Phone, Computer, Radio etc.)

X

Analyzing/Examining/Testing Data

X

Emotional/Behavioral Self-Regulation

X

Interacting with Others

X

Comprehension

X

Organization

X

Decision Making

X

Comprehension

Understand complex problems and collaborate to explore alternative solutions

Organization

Organize and prioritize the work schedules of others to manage multiple tasks and/or projects

Decision Making

Make decisions that have significant impact on a department's credibility, operations and/or services

Communication

Communicate and explain a variety of information

Extreme cold

X

Extreme heat

X

Humid

X

Wet

X

Noise

X

Hazards

X

Temperature Change

X

Atmospheric Conditions

X

Vibration

X

Computers/Monitors

X