The purpose of this classification is to support the overall administration, maintenance, monitoring, and operations of database systems; oversee assigned database processes and programs; and perform technical and analytical support duties for SCAG databases.

DISTINGUISHING CHARACTERISTICS

The Database Administrator job is the full performance level within the career family. Individuals in this classification possess comprehensive skills and perform assignments of moderate complexity using defined guidelines and policies. This may be demonstrated by developing, managing, and supporting databases and systems to provide applications and database support for effective operations and service delivery.

The intent of this job description is to provide a representative summary of the major duties and responsibilities performed by employees in this job. Employees may be requested to perform job-related tasks other than those specifically presented in this description.

• Creates and maintains enterprise databases and system documentation
• Designs and documents schemas for application databases and creates data structures and indexes
• Administers database, including backup, recovery, monitoring, optimization, installation, configuration, and upgrading
• Performs SQL Server software upgrade, installation, and configuration
• Supports financial system, including performing system enhancements, fixes, and maintenance
• Migrates data from the database to the format required by the application
• Creates database reports
• Reviews processes, identify areas of improvement, and resolves issues in the system
• Performs reasonably related duties within the scope of the classification as assigned

• Any combination of training, education, and experience that would provide the required skills, knowledge, and abilities is qualifying. A typical way to obtain the required qualifications would be with 3 years' experience with database management including SQL Server administration and a bachelor’s degree in a relevant field.

KNOWLEDGE OF:

• Microsoft SQL Server
• Software maintenance
• Database administration
• Various programming languages such as GIS, VB.NET, and C#
• Data design
• Project management principles

SKILL IN:

• Providing user support and troubleshooting
• Written and oral communications
• Attention to detail
• Organization and time management

ABILITY TO:

• Plan data flows for new and revised databases
• Provide analysis and support
• Configure related software applications
• Develop and/or review clear, concise communications and reports
• Use basic to intermediate features of Microsoft Office Suite
• Contribute to a culture of diversity, equity, inclusion, and belonging

• Classification has no responsibility for the direction or supervision of others.

This area describes the personal interaction with others outside direct reporting relationships as well as the impact the job has on organization, the division, the department, and business unit objectives including the output of services, or employee or public satisfaction.

• Classifications at this level may influence policy implementation decisions through interactions. Communication may involve support of controversial positions or the negotiation of sensitive issues or important presentations. Contacts may involve stressful, negative interactions with internal stakeholders and/or external stakeholders requiring high levels of tact, humility, and the ability to respond to challenging interpersonal interactions.

This section describes the accountability and participation if any, as it relates to the fiscal accountability, level of risk, and impact of financial/budgetary errors within department or assigned area(s) of responsibility.

• No fiscal responsibility.
• Classification has no fiscal responsibility, except for the responsibilities associated with monitoring and accurately reporting incurred employment expenses. Risk at this level is low as errors may result in minimal financial loss through loss of incumbent’s time to correct the error.

WORK ENVIRONMENT/CONDITIONS

The work environment and exposures described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable people with disabilities to perform the essential functions.

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

• This position is relative free from unpleasant environmental conditions or hazards and is generally sedentary. Incumbents may be required to exert up to 10 pounds of force occasionally, a negligible amount of force frequently, and/or constantly having to lift, carry, push, pull or otherwise move objects, including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally, and all other sedentary criteria are met.

TRAVEL

May require transit or car trips exceeding 45 minutes and/or air travel outside of the region, as needed for business purposes.

EEO STATEMENT