Senior GIS Database Administrator

ArcGIS, ArcGIS Server, DBA, Configuration, Geodatabases, Geographic information system, SQL, Microsoft SQL Server, RDBMS, Amazon RDS, ArcSDE, Amazon Web Services, Python, Microsoft Dynamics, API, Architecture, Business intelligence, Data analysis, Cloud, Database design, Database, Microsoft Great Plains (GP), WorkPlace, OnBase, Microsoft CRM, custom Inter-Government Review (IGR), custom Finance Management Systems (FMS), custom Active Transportation Database (ATDB), Microsoft Dynamics 365, ESRI ArcGIS, ArcGIS Online, ServiceNow, SQL Server Reporting Services (SSRS), and Crystal Reports.
Full Time
$103,000 - $134,596
Work from home available Travel not required

Job Description

Please note, this position will remain open until filled with the initial application review taking place on September 22, 2020.

 

Southern California Association of Governments (SCAG) is seeking a highly technical Senior GIS Database Administrator who excels in problem solving, analysis, and collaboration. If you consider yourself to be a geodatabase subject matter expert and are interested in taking on a lead role, then this opportunity is right for you! When you join SCAG, you can expect a culture where collaboration and teamwork is fostered. SCAG's workforce is highly educated, passionate and committed to innovation that improves the quality of life for all Southern Californians. SCAG is proud to support a work environment that promotes meaningful work while encouraging work/life balance.

The Senior GIS Database Administrator is a key contributor to SCAG’s enterprise wide GIS initiatives and will frequently collaborate with SCAG’s IT and Planning departments. The Senior GIS Database Administrator is responsible for the design, implementation, monitoring, maintenance and performance of the SCAG Enterprise Geodatabase. The Senior GIS Database Administrator will work with staff to analyze the current system, capture future needs, provide guidance, and implement recommendations to improve database management. They will lead data automation and maintenance efforts and contribute to detailed database design and maintenance standards related to data entry and updating.               

Southern California Association of Government's Application Development and Support team is responsible for many of SCAG's core technology systems and involved in multiple SCAG initiatives. The team develops, manages, tests, supports, maintains, and consults on applications including region shaping metropolitan planning systems, operationally focused finance and support systems, and public facing information sharing systems. Some of the current applications and technologies used include Microsoft Great Plains (GP), WorkPlace, OnBase, Microsoft CRM, custom Inter-Government Review (IGR), custom Finance Management Systems (FMS), custom Active Transportation Database (ATDB), Microsoft Dynamics 365, ESRI ArcGIS, ArcGIS Online, ServiceNow, Microsoft SQL Server, SQL Server Reporting Services (SSRS), and Crystal Reports.

 

OUR LOCATION

SCAG headquarters is located in the hub of busy downtown Los Angeles, at Figueroa and 7th streets. SCAG has recently relocated to the 900 Wilshire Building, a new, multi-use hotel and office complex that features state of the art architecture and technology. The downtown area has expanded with LA Live, new restaurants, music, sports, shopping, libraries, museums and theaters. SCAG is in a culturally diverse area near Koreatown, Little Tokyo, Chinatown, Olvera Street and Grand Central Market. Southern California boasts near-perfect weather and close proximity to mountains, beaches and deserts, which encourages physical fitness and year-round activities.

For ease of commuting, the LA office is located across the street from the Metro Red Line 7th St. station and is easily accessible by commuter trains and buses serving surrounding areas. Metro's light rail and subway connect downtown LA to Hollywood, Universal City, Santa Monica, Pasadena, Azusa, Long Beach and many vibrant and up-and-coming neighborhoods. 

WHO WE ARE

Founded in 1965, the Southern California Association of Governments (SCAG) is a Joint Powers Authority under California state law, established as an association of local governments and agencies that voluntarily convene as a forum to address regional issues. Under federal law, The SCAG region encompasses six counties (Imperial, Los Angeles, Orange, Riverside, San Bernardino and Ventura) and 191 cities in an area covering more than 38,000 square miles. The agency develops long-range regional transportation plans including sustainable communities' strategy and growth forecast components, regional transportation improvement programs, regional housing needs allocations and a portion of the South Coast Air Quality management plans. Currently, the Regional Council consists of 86 members.

WHAT WE BELIEVE

MISSION

To foster innovative regional solutions that improve the lives of Southern Californians through inclusive collaboration, visionary planning, regional advocacy, information sharing, and promoting best practices.

VISION

Southern California's Catalyst for a Brighter Future.

 

SCAG CORE VALUES

  • Be Open: Be accessible, candid, collaborative and transparent in the work we do.
  • Lead by Example: Commit to integrity and equity in working to meet the diverse needs of all people and communities in our region.
  • Make an Impact: In all endeavors, effect positive and sustained outcomes that make our region thrive
  • Be Courageous: Have confidence that taking deliberate, bold and purposeful risks can yield new and valuable

 

ESSENTIAL DUTIES AND RESPONSIBILITIES

  • Design, architect, develop, and manage Enterprise GIS Databases in a MS SQL environment
  • Support the Administration of ArcGIS Enterprise, including data maintenance, publishing, user setup, user support, security, service registration, and upgrades
  • Work with a multi-disciplinary team to determine the best storage, service, and distribution methods for SCAG GIS data.
  • Monitor and tune relational databases to ensure optimum performance. Make required improvements to database structures and processes to improve performance. Develop guides and processes to assist other staff in tuning database structures and processes
  • Troubleshoot data and database problems using well-developed troubleshooting techniques. Modify database structures and designs as appropriate. Consult with other team members as necessary to troubleshoot data, connectivity, and related problems.
  • Provide technical assistance and training to users for utilizing data through ArcGIS Enterprise and GIS databases
  • Model data for optimal application support
  • Develop tools to enhance data input/upload and extraction/reporting capabilities, using Python with the ESRI API along with other languages and frameworks as determined.
  • Coordinate with appropriate staff to ensure backup and recovery operations fall in line with policies and procedures. Make recommendations for changes in database backup procedures to increase efficiency and effectiveness.
  • Document database designs, structures, and processes, ensuring all modifications are properly annotated, and adhere to the SCAG Change Review process
  • Develop and establish procedures as well as monitor and maintain Enterprise GIS Architecture, ArcGIS Server, and ArcSDE tuning and performance monitoring.
  • Develop automation protocols for loading spatial data using data modeling and attribute mapping and manage the defined workflow routines.
  • Perform administration and develop procedures for applying services packs and upgrades of ArcSDE, ArcGIS, and SQL Server users, roles, and security models.
  • Work with GIS teams to populate spatial and enterprise databases, provide performance tuning, and automate data loads or scripting while maintaining compliance with the Spatial Data Standards.
  • Manage Geodatabase replication and monitor regular data update cycles.
  • Install and maintain the implementation of ArcGIS Enterprise and Server using SQL Server.
  • Assist in scheduling upgrades and roll-out of patches into various GIS environments.
  • Manage databases hosted on premise and in the cloud.
  • Additional duties as assigned

 

MINIMUM QUALIFICATIONS

 

EDUCATION: Equivalent to a Bachelor's degree from an accredited college or university in

Computer Science, Technology, Geography/GIS, or related fields. Master’s degree is preferred.

 

EXPERIENCE: Seven years of increasing responsibility with database administration and at least 5 years of experience in geodatabase administration.

 

WHO YOU ARE:

The ideal candidate:

  • Has 8-10 years of experience in Geodatabase administration
  • 3 to 5 years of SQL experience
  • Has 8-10 years of experience working with and knowledge of GIS data
  • Is comfortable working with large datasets
  • Has been a member of an IT or GIS team
  • Has experience combining and analyzing datasets
  • Has designed large datasets that were utilized by their organization
  • Has 3-5 years’ experience with ArcGIS Enterprise
  • Is an analytical, problem solver with excellent communication skills
  • ESRI Technical Certification and/or GISP certification is a plus.

 

Knowledge of:  Work products of a Metropolitan Planning Organization (MPO) operations and administration; principles of GIS technology, Agile and GIS applications development methods. SQL architecture and configuration; cloud technologies including AWS and RDS; intermediate computer programming methods and procedures required in developing GIS solutions (e.g. Python, SQL); expertise with ArcGIS Online, ArcGIS Pro, ArcGIS for Desktop, ArcGIS Server, Portal for ArcGIS, ArcGIS Data Store, and ArcGIS Web Adaptor and its system architecture; experience with Postgres, PostGIS, and MS SQL; skillful in core GIS principles such as data structures, georeferencing, data classification, querying, cartography, and spatial data analysis 

Ability to: Maintain multiple GIS databases, ArcGIS server components within a SQL server environment; create and document Enterprise Geodatabase schemas and to communicate changes; maintain RDBMS structures; create views, stored procedures, and Business Intelligence reports for management; configure GIS systems and software; prepare and conduct training sessions as required; work in a agile environment with multi stake holder teams; communicate effectively with non-technical staff and with members of interdisciplinary teams; prepare clear and concise reports, technical documents, and manuals; establish and maintain cooperative-working relationships with internal and external customers; conduct research into software-related issues and products; translate GIS user requirements into detailed technical databases and project designs; conduct research and implement modifications into GIS server and database related services and products as required; prepare clear and concise reports and technical documents.

Dice Id : RTX1d5912
Position Id : 6675999
Originally Posted : 2 weeks ago
Have a Job? Post it

Similar Positions

SNR MS SQL DBA
  • Genesis Global Recruiting Inc
  • Burbank, CA
SQL Server DBA
  • Amplify Resources Group
  • Los Angeles, CA
SQL DBA-W2 ONLY
  • iSpace, Inc
  • Glendale, CA
W2 Only- SQL SERVER Securty DBA
  • s.com
  • Los Angeles, CA
Sr. Database Administrator
  • eNamix
  • Pasadena, CA
Database Architect
  • HCL America Inc.
  • Lake View Terrace, CA
Principal Software Engineer - TS/SCI Clearance
  • Northrop Grumman
  • Redondo Beach, CA
Cloud Data Administrator
  • Irvine Technology Corporation (ITC)
  • Long Beach, CA
SQL Developer | Epic Clarity
  • Onpoint Search Consultants
  • Los Angeles, CA
SQL Developer, Sr (SSIS & DW)
  • Prosum
  • Los Angeles, CA
Data Architect
  • Huntington Hospital
  • Pasadena, CA
Sr Data Warehouse Developer
  • Calance
  • Pasadena, CA
Developer - AWS, Azure, SQL Server, C# .NET, API
  • Software Management Consultants, Inc.
  • Santa Ana, CA