About this role
Title: Database Management Specialist (Senior)
Rate: $45/hr.
Location: Pikesville, MD
Key Responsibilities
• 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.
Required Qualifications
• 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.
Preferred Qualifications
• 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.
EOE