Database Manager

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

Job Information

Title:

Database Manager

Market Range:

IT17

Approved Date:

2/12/2021 1:37:13 PM

FLSA:

Exempt

EEO Code:

PROFESSIONALS

Career Level:

M2

Career Level Description:

Management Level 2

Job Code:

100178

Job Family:

Information Technology

Sub Family:

Database Administration and Development

Primary Purpose

Manage the activities, projects and staff members in the Oracle and SQL Database Administration area.  Support business users in their functional area, troubleshoot problems and directs the implementation and completion of special projects.  Prepare recommendations for hardware and software acquisitions, staffing and special projects.  Contribute to the budget preparation process.  Monitor the database regularly to manage memory, CPU and storage resources and to gather statistics to tune the databases for best performance.  Architect system changes to generate additional capacity required for growth and/or stability.  Defines and implements disaster recovery strategies and plans as needed.  Document and enforce standards for creating databases and database objects, accessing databases, managing backups and promoting applications from test to production environments.  Ensure database service practices meet the changing needs of the applications and infrastructure environments.  Manage vendor relations and researches new technologies in the database and infrastructure area.

•

Lead, manage, and direct Database Operations staff.

1

40%

•

Work with vendors and application developers to provide required database architecture design, development, and support. Provide oversight on performance and accuracy monitoring and improvements of  applications under development or in the upgrade/implementation process.

2

30%

•

Lead partnership of DBAs and business units to implement and modify new or current operational applications.

3

20%

•

Monitor hardware and license requirements and assist with annual budget preparation.

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:

M2

Career Level Description:

Management Level 2

•

Fully accountable for implementing operational plans for a Work Group with measurable contribution on Division results.

•

May have budget accountability.

•

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

•

Supports and utilizes the innovations of others to improve on solutions, approaches and technologies.

•

Communicates within and outside the Work Group, and may communicate with other parties within the Division.

•

Sometimes requires ability to influence others outside of own job area on policies, practices and procedures.

•

Manages professionals. Leads, directs and reviews the work of team members in order to accomplish operational plans and results.

•

Has hiring, firing, promotion, performance and reward authority for direct reports.

•

Requires practical knowledge in leading and managing the execution of processes, projects and tactics within one job area. Typically has advanced knowledge and skills within a specific technical or professional discipline with understanding of the impact of work on other areas of the organization.

Qualifications

•

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

•

Four years of experience in database management and administration

•

Equivalent education and experience are accepted

•

4 Years

MS SQL Server mirroring and Availability Groups or VMware clustering technology

•

5 Years

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

•

3 Years

Understanding of MS software or Oracle licensing

•

3 Years

Cohesity backup and recovery for MS SQL Server or Oracle

•

3 Years

MS SharePoint or Oracle

•

3 Years

VMware configuration for MS SQL Server or Oracle

•

3 Years

Storage Array Network (SAN) technology

•

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

•

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

•

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

•

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

•

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

•

MS PowerShell or BASH shell scripting experience

•

Experience supporting both hosted and on-premise applications

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

Adaptability & Flexibility

Changes behavioral style or method of approach when necessary to achieve a goal; adjusts style as appropriate to the needs of the situation. Responds to change with a positive attitude and a willingness to learn new ways to accomplish work activities and objectives.

Organizational Understanding

Understands agendas and perspectives of others, recognizing and effectively balancing the interests and needs of one's own group with those of the broader organization.

Project or Program Management

Structures and directs others’ work on projects or programs.

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.

Cooperative Leadership

Promotes and generates cooperation among one's peers in leadership to achieve a collective outcome; fosters the development of a common vision and fully participates in creating a unified leadership team that gets results.

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.

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