Senior Database Management Specialist - Esri GIS and geodatabase


Triwave Solutions Inc
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- Geoprocessing
- Disaster Recovery
- Documentation
- Editing
- Esri
- Database Administration
- Database Architecture
- FME
- Geocoding
- Data Quality
- Data Security
- Database Security
- Geodatabases
- Data Conversion
- Data Governance
- Data Integrity
- Collaboration
- Computer Science
- Conflict Resolution
- Access Control
- Analytical Skill
- ArcGIS
- Law Enforcement
- Geospatial Analysis
- Information Systems
- Interfaces
- Backup
- Database
- Geographic Information System
- System Integration
- Systems Analysis
- Regulatory Compliance
- Routing
- Storage
- Technical Writing
- RDBMS
- RMS
- Records Management
- Recovery
- Publishing
- Python
- Quality Assurance
- Query Optimization
- Performance Monitoring
- PostgreSQL
- Problem Solving
- Migration
- Mobile Computing
- Optimization
- Oracle
- Management
- Mapping
- Microsoft SQL Server
- SQL
- Workflow
Summary
Job Title: Senior Database Management Specialist
Location: Pikesville, MD
Work Arrangement: Onsite – 5 Days a Week
Pay Rate: $60/hr. C2C
Experience Level: Senior
Important Submission Requirements
Local candidates only. Candidates must currently reside within a reasonable commuting distance of Pikesville, MD. Relocation candidates will not be considered.
In-person interview is mandatory. Candidates must be available to attend an onsite interview.
A valid and up-to-date LinkedIn profile is required.
This is a fully onsite position. Remote or hybrid arrangements are not available.
Job Summary
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.
Key Responsibilities
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.
Public-Safety Systems Integration and Support
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.
Required Qualifications
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.
Preferred Qualifications
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.
Ideal Candidate Profile
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.
- Dice Id: 91125814
- Position Id: 9145227
- Posted 6 hours ago
Company Info
Garnering Accolades for Health and Human Services in Maryland
Based in Columbia, Maryland, Triwave is a Certified Small Business as designated by the Federal government, demonstrating its commitment to contributing to the community and promoting the safety, security, and well-being of citizens. Triwave specializes in innovative services and solutions utilizing cloud, analytics, artificial intelligence, and data management that enhance governance while reducing costs for state and local agencies such as the Department of Human Services (DHS) at Maryland and Department of Child Services (DCS) at Indiana. Triwave recently delivered agency-wide modernization programs for the State of Maryland as a Master Contractor that transformed the technology landscape and garnered award and recognition for the team. Triwave has also received the prestigious honor of being named a top IT Consulting Firm for the years 2022 and 2023.


