Database Management Specialist (Senior)

KMJJ Enterprise LLC
Pikesville, MD, United States
1 day ago
Apply on www.careerjet.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
1 year minimum
Working hours
Regular working hours

Tech stack

Computer-Aided Design Geographic Information Systems Computing Platforms ArcGIS (Software) Backup Devices Information Systems Computer Programming Databases Data Auditing Data Conversion Data Dictionary Data Governance
+30 more
Data Integrity Data Migration Data Security Database Applications Relational Databases Database Security Database Storage Structures Document Management Systems Geocoding GIS Applications Systems Analysis Python (Programming Language) PostgreSQL Microsoft SQL Server Operational Data Store Oracle (Applications) Performance Tuning Query Optimization SQL Databases Data Server Interface Enterprise Software Applications Database Optimization Database Performance Indexer Database Migration Information Technology Performance Monitor Data Management Database Backup Restful APIs

Job description

We are seeking an experienced Database Management Specialist (Senior) to provide advanced database management, administration, and technical expertise in support of the contract. The ideal candidate will have extensive experience with database management systems (DBMS), relational database technologies, database application design, performance optimization, data integrity, and security. The successful candidate will support enterprise GIS databases and geospatial systems used in public-safety environments. This role requires expertise in enterprise geodatabase administration, ArcGIS technologies, spatial-data management, database backup and recovery, and the integration of GIS data with mission-critical applications, including Computer-Aided Dispatch (CAD), Records Management Systems (RMS), and mobile-computing solutions. The Database Management Specialist (Senior) will evaluate database technologies, design and maintain database structures, implement security and recovery procedures, and ensure the availability, accuracy, integrity, and recoverability of critical data. The position will collaborate with GIS professionals, application developers, database administrators, public-safety stakeholders, and software vendors to support reliable and efficient geospatial data services. Work Location: The primary place of performance is onsite in Pikesville, MD. Travel to other offices may be required as needed. Some teleworking may be permitted. Interview: An in-person interview may be required., * Provide advanced technical expertise and support in the administration, design, implementation, and maintenance of database management systems.

  • Evaluate and recommend appropriate DBMS products and technologies to meet validated user requirements, application needs, and organizational objectives.
  • Design and maintain database structures, including file organization, indexing methods, schemas, relationships, and access controls.
  • Develop, implement, and maintain database backup, recovery, and disaster-recovery procedures to ensure data availability and recoverability.
  • Establish and maintain database security procedures and controls to protect sensitive information and ensure compliance with applicable State requirements.
  • Ensure data integrity, consistency, security, and recoverability are incorporated into database applications and processing environments.
  • Administer and support enterprise GIS databases and geospatial systems used by public-safety organizations.
  • Use ArcGIS Pro to perform spatial-data editing, analysis, geoprocessing, cartographic production, data conversion, coordinate-system management, and data quality assurance.
  • Administer enterprise geodatabases supported by Microsoft SQL Server, PostgreSQL, Oracle, or comparable relational database platforms.
  • Design, configure, and maintain geodatabase schemas, feature classes, domains, subtypes, topology, versioned editing workflows, user permissions, and data-integrity controls.
  • Monitor database performance and capacity, troubleshoot database issues, and implement improvements to optimize query execution, indexing, storage, and overall system performance.
  • Coordinate database migrations, upgrades, backup and recovery activities, and changes to database structures and configurations.
  • Support ArcGIS Enterprise and/or ArcGIS Online, including publishing and maintaining map services, feature services, web maps, applications, organizational GIS content, user roles, and sharing permissions.
  • Develop and maintain GIS automation, integration, and data-transformation processes using Python, ArcPy, ModelBuilder, SQL, REST APIs, FME, or comparable technologies.
  • Maintain mission-critical public-safety GIS datasets, including address points, street centerlines, common-place locations, jurisdictional boundaries, response areas, map layers, geocoding, routing, and location-validation data.
  • Validate geospatial data accuracy, consistency, completeness, and compatibility with enterprise applications and operational requirements.
  • Support GIS integrations with CAD, RMS, and mobile-computing environments, including dispatch mapping, geocoding, routing, mobile map delivery, and data-interface troubleshooting.
  • Investigate and resolve database, GIS application, integration, and data-quality incidents in coordination with technical teams and software vendors.
  • Maintain database documentation, data dictionaries, schema definitions, security configurations, operational procedures, and recovery plans.
  • Collaborate with application developers, GIS analysts, database administrators, and end users to translate business requirements into effective database and geospatial solutions.
  • Recommend improvements to database architecture, automation, data governance, security, performance, and operational reliability., * Contribute to critical public-sector technology initiatives that support law enforcement and public-safety operations.
  • Apply advanced database management and GIS expertise to mission-critical enterprise systems.
  • Help ensure the accuracy, integrity, security, and availability of essential geospatial and operational data.
  • Collaborate with multidisciplinary teams to develop and maintain reliable, scalable, and data-driven solutions.
  • Support continuous improvement through database optimization, GIS automation, and modern geospatial technologies.

Requirements

  • A Bachelor’s degree from an accredited college or university with a major in Computer Science, Information Systems, Engineering, Business, or a related scientific or technical discipline; or three (3) years of equivalent experience in a related field.
  • At least six (6) years of experience in database management system (DBMS) systems analysis and programming.
  • At least three (3) years of specialized experience using current DBMS technologies, designing applications utilizing various database management systems, and working with DBMS internals.
  • Strong knowledge of relational database concepts, database architecture, schema design, indexing, query optimization, data security, and data-integrity principles.
  • Experience developing and maintaining database backup, recovery, and security procedures.
  • Demonstrated analytical, troubleshooting, documentation, and problem-solving skills.
  • Ability to work collaboratively with technical teams, application developers, GIS professionals, business stakeholders, and end users., * At least three (3) years of recent experience administering and supporting enterprise GIS databases and geospatial systems for a public-safety organization.
  • Hands-on experience using currently supported versions of ArcGIS Pro for spatial-data editing, analysis, geoprocessing, cartographic production, data conversion, coordinate-system management, and quality assurance.
  • Experience administering enterprise geodatabases supported by Microsoft SQL Server, PostgreSQL, Oracle, or a comparable relational database platform. Experience should include schema design, feature classes, domains, subtypes, topology, versioned editing, user permissions, performance monitoring, data migration, backup and recovery coordination, and data-integrity controls.
  • Experience supporting ArcGIS Enterprise and/or ArcGIS Online, including publishing and maintaining map and feature services, web maps, applications, user roles, sharing permissions, and organizational GIS content.
  • Experience with modern GIS automation, integration, or data-transformation tools such as Python, ArcPy, ModelBuilder, SQL, REST APIs, FME, or comparable technologies.
  • Experience maintaining mission-critical public-safety GIS data, including address points, street centerlines, common-place locations, jurisdictional boundaries, response areas, map layers, geocoding, routing, and location-validation data.
  • At least one (1) year of direct experience supporting the GIS components and integrations of a law-enforcement or public-safety Computer-Aided Dispatch (CAD), Records Management System (RMS), and mobile-computing environment. This experience should include troubleshooting data interfaces, dispatch mapping, geocoding, routing, mobile map delivery, application incidents, and vendor-related issues.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerjet.com
Prepare application

Good distractions

Loading talks and stories from around this role…