Senior Database Engineer

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

Job Information

Title:

Senior Database Engineer

Market Range:

IT16

Approved Date:

7/25/2024 12:44:13 PM

FLSA:

Exempt

EEO Code:

PROFESSIONALS

Career Level:

P3

Career Level Description:

Professional Level 3

Job Code:

100824

Job Family:

Information Technology

Sub Family:

IT Business Systems

Primary Purpose

Lead role developing, administering, maintaining and implementing policies and procedures for ensuring the security and integrity of the county's MS SQL Server and/or Oracle environments and databases. Provides technical review, development, testing and implementation of application and database development, upgrade and maintenance projects. Assists in budget preparation and acquisition of technology. Maintains a level of knowledge that is current with new technology. Provides technology training and materials to SQL and/or Oracle teams. Provides consultation and support to other IT and business staff. Defines and supports best practices for development and maintenance of applications and databases. Performs complex data integration and scripting.

•

Lead the design, construction, and management of complex databases. Administers the Microsoft SQL Server and/or Oracle database production and test environments on a day-to-day basis including backups, security, patches, replication and change management. Develops and implements policies and procedures for ensuring the security and integrity of Wake County databases. Implements data models and database designs, data access and table maintenance codes. Designs and builds relational databases using Microsoft SQL Server and/or Oracle. Develops and lead strategies for data acquisitions, archive recovery and implementation of a database. Implements change control procedures. Coordinates production scheduling with other technical staff. Serves as technical lead and consults with business owners and developers during projects and implementation. Manages licenses and upgrades in the Microsoft SQL Server and/or Oracle environments. Performs analysis, planning, and facilitation of data migrations and scripting to manipulate data.

1

45%

•

Resolves database performance issues, database capacity issues, replication and other distributed data issues. Performs platform backups, upgrades, and installs. Provides continuous platform monitoring, maintenance, and fine tuning  of servers, tools, and databases to ensure the highest level of data availability, integrity, and security. Administers security, patches, configures replications, and monitors scheduled jobs and performance.

2

25%

•

Participates in project meetings and dialogs regarding database related project components. Provides realistic estimates of specific project related tasks to the project manager. Provides prompt and clear communication of project task status and any related issues in project meetings and through email and phone dialogs. Mentoring of junior staff and contract DBA's.

3

20%

•

Stays current on SQL and/or Oracle platform environment technology upgrades and changes to ensure a stable and scalable SQL and/or Oracle platform for Wake County.

4

10%

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 -2019 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 SQL Plus

•

2 Years

MS Po or BASH shell scripting experiencewershell

•

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

•

Working knowledge of Cohesity back up and recovery for MS SQL or Oracle

•

Working knowledge of MS SharePoint or Oracle

•

Working knowledge of 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.

Coaching & Mentoring

Works to improve and reinforce performance of others. Facilitates their skill development by providing clear, behaviorally specific performance feedback, and making or eliciting specific suggestions for improvement in a manner that builds confidence and maintains self-esteem.

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 individual work schedule 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