Senior Database Management Specialist - Esri GIS and geodatabase
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+29 more
Job description
We are seeking an experienced Senior Database Management Specialist to support the administration, design, implementation, maintenance, and optimization of enterprise database management systems and GIS environments.
The ideal candidate will have strong database administration and systems analysis experience, along with hands-on expertise in enterprise GIS technologies, particularly Esri ArcGIS Pro, enterprise geodatabases, and relational database platforms such as Microsoft SQL Server, PostgreSQL, and Oracle.
This role will support mission-critical geospatial systems used by public-safety and law-enforcement organizations, ensuring database performance, data integrity, security, availability, and seamless integration with Computer-Aided Dispatch (CAD), Records Management Systems (RMS), and mobile computing environments., Database Administration and Management
- Design, implement, administer, and maintain enterprise database management systems.
- Evaluate and recommend DBMS products and technologies based on business and technical requirements.
- Design and maintain database schemas, structures, indexing strategies, relationships, file organization, and access controls.
- Develop and maintain database backup, recovery, and disaster recovery procedures.
- Implement database security controls to protect sensitive information and ensure compliance with applicable state requirements.
- Monitor database performance, troubleshoot issues, and optimize queries, indexing, storage, and system capacity.
- Coordinate database upgrades, migrations, configuration changes, and maintenance activities.
- Ensure data integrity, consistency, availability, and recoverability across database environments.
GIS and Enterprise Geodatabase Administration
- Administer and support enterprise GIS databases and geospatial systems.
- Use Esri ArcGIS Pro for spatial data editing, analysis, geoprocessing, cartographic production, data conversion, and quality assurance.
- Administer enterprise geodatabases using Microsoft SQL Server, PostgreSQL, Oracle, or comparable relational database platforms.
- Design and maintain geodatabase schemas, feature classes, domains, subtypes, topology, versioned editing workflows, and user permissions.
- Support ArcGIS Enterprise and/or ArcGIS Online, including publishing and maintaining map services, feature services, web maps, applications, and organizational GIS content.
- Manage GIS user roles, sharing permissions, coordinate systems, and geospatial data quality.
- Develop GIS automation, integration, and data-transformation processes using Python, ArcPy, ModelBuilder, SQL, REST APIs, FME, or similar technologies.
- Maintain public-safety GIS datasets, including address points, street centerlines, jurisdictional boundaries, response areas, common-place locations, geocoding, and routing data., * Support GIS integrations with Computer-Aided Dispatch (CAD), Records Management Systems (RMS), and mobile computing environments.
- Troubleshoot dispatch mapping, geocoding, routing, mobile map delivery, and GIS data-interface issues.
- Validate geospatial data accuracy, completeness, consistency, and compatibility with enterprise applications.
- Investigate and resolve database, GIS application, integration, and data-quality incidents in coordination with technical teams and vendors.
- Maintain technical documentation, data dictionaries, database schemas, security configurations, operational procedures, and recovery plans.
- Collaborate with database administrators, GIS analysts, application developers, technical teams, and end users to deliver effective database and geospatial solutions.
- Recommend improvements to database architecture, automation, data governance, security, performance, and operational reliability.
Requirements
- Bachelorβs degree from an accredited college or university in Computer Science, Information Systems, Engineering, Business, or a related scientific or technical discipline; alternatively, three (3) years of equivalent experience in a related field.
- Minimum of six (6) years of experience in database management systems (DBMS) systems analysis and programming.
- Minimum of three (3) years of specialized experience working with current DBMS technologies, designing database-driven applications, and understanding DBMS internals.
- Strong knowledge of relational database concepts, database architecture, schema design, indexing, query optimization, data security, and data integrity.
- Experience developing and maintaining database backup, recovery, and security procedures.
- Strong analytical, troubleshooting, documentation, and problem-solving skills.
- Ability to work effectively with technical teams, application developers, GIS professionals, stakeholders, and end users., * At least three (3) years of recent experience administering enterprise GIS databases and geospatial systems within a public-safety organization.
- Hands-on experience with supported versions of Esri ArcGIS Pro, including spatial data editing, analysis, geoprocessing, cartographic production, data conversion, coordinate-system management, and quality assurance.
- Experience administering enterprise geodatabases using Microsoft SQL Server, PostgreSQL, Oracle, or similar relational database platforms.
- Experience with geodatabase schema design, feature classes, domains, subtypes, topology, versioned editing, user permissions, performance monitoring, migrations, and backup/recovery.
- Experience supporting ArcGIS Enterprise and/or ArcGIS Online, including map services, feature services, web maps, applications, user roles, and sharing permissions.
- Experience with GIS automation and integration tools such as Python, ArcPy, ModelBuilder, SQL, REST APIs, and FME.
- Experience maintaining mission-critical public-safety GIS datasets, including address points, street centerlines, common-place locations, jurisdictional boundaries, response areas, geocoding, and routing information.
- At least one (1) year of direct experience supporting GIS components and integrations within law-enforcement or public-safety CAD, RMS, and mobile computing environments.
- Experience troubleshooting dispatch mapping, geocoding, routing, mobile map delivery, data interfaces, application incidents, and vendor-related issues., The ideal candidate will combine strong enterprise database management experience with hands-on Esri GIS and geodatabase administration expertise. Experience supporting public-safety or law-enforcement applications, particularly CAD, RMS, and mobile GIS integrations, will be highly desirable.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦