The purpose of this classification is to oversee the design, implementation, monitoring, maintenance, and performance of the SCAG Enterprise Geodatabase; and lead data automation and maintenance efforts and contribute to detailed database design, improvement, and maintenance standards related to data entry and updating.

DISTINGUISHING CHARACTERISTICS

The Senior GIS Database Administrator job is the advanced level within the career family. Individuals in this classification are responsible for GIS enterprise-wide database systems and possess specialized and technical expertise. This may be demonstrated by creating management methods and systems and implementing recommendations to improve GIS database management and data automation efforts.

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.

• Supports the administration of ArcGIS Enterprise, including data maintenance, publishing, user setup, user support, security, service registration, and upgrades
• Designs, architects, develops, and manages Geo Datasets
• Monitors relational databases to ensure optimum performance and implements required improvement to database structures and processes
• Troubleshoots data and database problems using well-developed troubleshooting techniques
• Modifies database structures and designs as appropriate
• Develops automation protocols for loading spatial data using data modeling and attribute mapping and manages the defined workflow routines
• Develops and establishes procedures to monitor and maintain Enterprise GIS Architecture, Arc GIS Server and other related databases
• 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 5 years' experience in geodatabase administration and a bachelor’s degree in a relevant field.

KNOWLEDGE OF:

• ArcGIS Enterprise
• Software maintenance
• Various programming languages
• Data design

SKILL IN:

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

ABILITY TO:

• Provide GIS analysis
• 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 level of supervision in the scope of work but may provide occasional direction to interns, temporary employees, and consultants.

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.

• Limited fiscal responsibility.
• Classification has limited fiscal responsibility. Responsibilities may include: (1) assisting in the collection and preparation of data in support of recommendations for budget allocations, typically within an assigned department; (2) monitoring and documenting project budgets and expenditures; (3) supporting purchasing needs through ordering inventory and monitoring spending. Risk at this level is limited as errors can be identified and resolved quickly and may result in loss of incumbent’s time to correct the error or minor financial loss.

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