Database Administrator – SQL, Azure & ArcGIS (On-Site)

Town of Cary; Cary (NC); On-site; USD 110,000 - 140,000; Full time

Job summary

Town of Cary seeks an experienced Database Administrator to design, implement, monitor, and secure on-premise and cloud databases. You will support critical systems across Public Safety, Smart Community, Water resources, and AMI initiatives, ensuring data availability and security.

You will work with IT teams to set long-term goals, create maintenance plans, perform upgrades, and automate tasks. Excellent communication and detail-oriented skills are essential.

Qualifications

• Requires a bachelor's degree in computer science or closely related field and 3+ years SQL Server experience.
• Experience with SQL Server on-premises and Azure cloud solutions.
• Experience with ArcGIS Enterprise administration and ESRI geodatabases.
• Strong SQL performance tuning, security, and disaster recovery knowledge.

Responsibilities

• Design, create, test, migrate, monitor and troubleshoot databases.
• Administer SQL Server and Azure SQL databases; ensure security and backups.
• Administer ArcGIS Enterprise environment and Esri geodatabases.
• Develop monitoring and maintenance plans; implement change control.
• Manage ETL/ELT data pipelines and data integration.
• Ensure CJIS/NIST compliance and data retention policies.
• Support emergency response and on-site operations.

Skills

SQL Server administration

Cloud database design

Data modeling

ETL/ELT processes

PowerShell scripting

Python scripting

CJIS compliance knowledge

Communication skills

Education

Bachelor's degree in Computer Science or related field

Tools

SQL Server

Azure SQL / Synapse

ArcGIS Enterprise

Power BI

SSIS

SSRS

Azure Data Factory

Data Lake

Job description

Town of Cary seeks an experienced Database Administrator to design, implement, monitor, and secure on-premise and cloud databases. You will support critical systems across Public Safety, Smart Community, Water resources, and AMI initiatives, ensuring data availability and security.

You will work with IT teams to set long-term goals, create maintenance plans, perform upgrades, and automate tasks. Excellent communication and detail-oriented skills are essential.