Database Management Specialist (Senior)

4A Consulting, LLC; Pikesville (MD); On-site; USD 120,000 - 160,000; Full time

Job summary

4A Consulting is seeking a Senior Database Management Specialist to lead advanced database management, design, security, and disaster-recovery for enterprise GIS and public-safety systems. You will work with SQL Server, PostgreSQL, Oracle, ArcGIS Pro and ArcGIS Enterprise, ensuring data integrity and high availability.

Collaboration with GIS professionals, developers and stakeholders is essential. The role is onsite in Pikesville, MD, with potential telework options and occasional travel to

Qualifications

• Bachelor's degree or 3 years related experience.
• 6+ years in DBMS analysis and programming.
• 3+ years specialized experience with DBMS tech and internals.
• Strong knowledge of relational databases, schema, indexing, security.
• Experience with backup, recovery, and security procedures.
• Excellent problem-solving and documentation skills.
• Ability to work with cross-functional teams.

Responsibilities

• Provide advanced DBMS design and maintenance expertise
• Design database structures with robust access controls
• Implement backup, recovery and disaster-recovery procedures
• Ensure data security and compliance with state requirements
• Administer enterprise GIS databases and geospatial systems
• Support ArcGIS Enterprise/ArcGIS Online publishing and services
• Develop GIS automation using Python, ArcPy, SQL, REST APIs, or FME
• Collaborate with GIS analysts, developers, and stakeholders
• Coordinate migrations and upgrades and monitor performance

Skills

DBMS concepts

Relational databases

GIS basics

Data security practices

Education

Bachelor's degree or 3 years related experience

Tools

ArcGIS Pro

ArcGIS Enterprise

SQL Server

PostgreSQL

Oracle

Python

ArcPy

ModelBuilder

REST APIs

FME

Job description

At 4A Consulting, we turn complexity into opportunity. Founded in 2014 and headquartered in Baltimore, MD, we are a women-owned, boutique consulting firm specializing in delivering innovative, data-driven solutions to both the Federal Government and Fortune 500 clients. Our team blends deep industry knowledge with advanced technologies to design tailored strategies that drive measurable and sustainable outcomes. We pride ourselves on an agile, collaborative approach that helps organizations navigate challenges and seize emerging opportunities in a rapidly evolving digital landscape. At 4A, we don’t just deliver projects, we build trusted partnerships that empower our clients to lead with confidence in the digital age.

Position Overview

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.

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.

Why Join 4A

• 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.

Equal Opportunity Statement

4A Consulting is an Equal Opportunity Employer committed to an inclusive hiring process. Applicants requiring a reasonable accommodation due to a disability may contact [e-mail]. This email is intended solely for accommodation requests.

Please note that 4A Consulting participates in the federal E-Verify program. Upon hire, we will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the US. 4A Consulting will only use E-Verify once you have accepted a job offer and completed the Form I-9.