DATABASE ADMINISTRATOR

DATABASE ADMINISTRATOR

Salary

$92,664.00 - $152,921.60 Annually

Location

Cary, NC

Job Type

Regular, Full-Time

Job Number

27-02721

Department

Information Technology

Opening Date

10/30/2026

Closing Date

11/4/2026 11:59 PM Eastern

FLSA

Exempt

Bargaining Unit

N/A

• Description
• Benefits
• Questions

Description

We are seeking a skilled, experienced Database Administrator to join our growing organization. In this position, you will design, create, test, migrate, monitor, troubleshoot, backup/recovery, security, manage and decommission various Town of Cary on premise and cloud based computer and application databases; ensuring data are available to users and kept secure from unauthorized access or accidental loss or corruption. This position will work closely in supporting IT Integration Development and Operations teams by supporting our critical database systems and architecture including but, not limited to our Public Safety, Smart and Connected Community, Water and Waste Water Resources, and AMI initiatives. An organized, detail-oriented work ethic is a must.

Work is performed under the general supervision of the Enterprise Applications Manager.

Typical Tasks

• Design, create, test, migrate, monitor and troubleshoot databases for the Town of Cary overall database environment and initiatives;
• Install, configure, and administer SQL Server (including SQL Server DW/Synapse), databases and other Azure Cloud-based data solutions while adhering to best practices;
• Design logical and physical data models for relational and dimensional solutions; develop and enforce standards;
• Administer Esri enterprise geodatabases hosted in SQL Server, including configuration, performance tuning, compress, and index and statistics maintenance;
• Administer and maintain the ArcGIS Enterprise environment, including ArcGIS Server, Portal for ArcGIS, and ArcGIS Data Store, along with the database connections and related data sources behind published services;
• Work with stakeholders to develop long-term strategic goals for production databases; providing technical knowledge to the business units in identifying, evaluating, research of products and services in support of the Town's needs and goals with scalable solutions to process current and expected future loads;
• Create custom monitoring and maintenance plans for root cause analysis and corrective action;
• Test and Install, patches and upgrades;
• Manage resources including long-term capacity planning for resources and storage; Use tools and scripting to efficiently manage and automate tasks;
• Develop, implement and maintain change control and testing processes for modifications to databases ensuring audit trails are maintained and documented;
• Work with end users to facilitate best practices for database use; create or assist in writing of user documentation, instructions, and procedures;
• Manage the ingestion and usability of our near real-time data, eliminate bottlenecks on specific databases and properly federate data throughout our IoT initiatives;
• Develop and maintain ELT/ETL processes that import and export data from various sources in a variety of formats; Identify interdependencies in system and application components;
• Setup, test and maintain backup and disaster recovery processes and procedures; including SQL Server high-availability technologies (replication, mirroring, log shipping, AGs, etc...);
• Manage and implement database security and report incidents; while adhering to CJIS requirements and NIST standards; Decommission various databases that are no longer used, following requirements for data retention;
• Perform other job-related tasks as assigned.

Knowledge, Skills and Abilities

Experience with database migration, performance tuning, and optimization, and setting up and managing database connections; experience with the following: Microsoft SQL Server; Microsoft Windows Server 2016 virtual environment; SQL Server Database Administration 2012 thru 2017; demonstrate strong technical skills in the area of enterprise application integrations, Microsoft Azure technologies and SQL Server including creating, maintaining and versioning API's; experience with SQL Server Integration Services (SSIS), SQL reporting services (SSRS) and PowerBI including creating, modifying, and managing custom reports; experience developing SQL database policies and standards; experience across the Microsoft Azure Data Stack; including Azure Data Lake, Data Factory and Data Warehouse; experience in PowerShell and Python scripting; maintain a commitment to professionally grow and share knowledge within the team; must be able to multitask, prioritize, and manage time efficiently; have precise attention to detail, strong written and verbal communication skills; and have excellent analytical, quantitative, and organizational skills.

Minimum and Preferred Qualifications

Requires any combination of education and experience equivalent to graduation from a four-year college or university with a degree in computer science or closely related field and a minimum of three years of SQL server database experience or database administration experience in a commercial environment or equivalent work experience.

Preferred qualifications include:

• Experience upgrading ArcGIS Enterprise and supporting multi-machine or highly available deployments;
• 4 years experience supporting GIS and enterprise databases in a local government environment.
• 2 years experience with Python scripting in an integration environment

Physical Requirements

Work in this class is generally inside and sedentary however, frequent movement is required in the process of observing system and database operations. An employee must have such visual acuity as to be able to read and write handwritten and typewritten material and to install/repair equipment. An employee in this class must be able to talk and hear in order to be able to respond to the public, vendors and other employees.

Special Requirements

• Requires a valid drivers license with an acceptable driving record.
• Requires drug testing and background check (which may include criminal history check, SBI finger-printing, motor vehicle records check, education verification and credit history review) and satisfactory reference checks prior to employment
• Must be eligible for and able to maintain CJIS access and certification.
• Participation in emergency response activities is required.
• This is a full-time, on-site position.

Cary ensures equal employment opportunities (EEO) are provided to all employees and applicants for employment without regard to age, sex, race, color, religion, national origin, disability, political affiliation, marital status, veteran status, or genetic information.

Regular Full-Time Employees

Learn more about our benefits.

Cary is pleased to provide excellent, competitive, and comprehensive benefits to serve the needs of our employees and their families.

Because Cary believes that employees are one of our most important resources, significant dollars (averaging about 40% of annual salary per employee) are spent each year on employee benefits.

All regular full-time employees of Cary are eligible, and benefits coverage for new employees and family members is effective upon an employees hire date.

01

1. Which best describes your highest level of education?

• High School Graduate/GED
• Associates Degree
• Bachelors Degree
• Masters Degree

02

2. Do you have a valid drivers license with an acceptable driving record?

• Yes
• No

03

3. How many years of experience do you have with SQL server database, database administration in a commercial environment, or equivalent work experience? Details must be included in the work experience section of your application.

• None
• Less than 3 years
• 3-4 Years
• 5+ Years

04

4. Do you have (or can you obtain) certification under Criminal Justice Information Services (CJIS) requirements?

• I currently hold a valid CJIS certification
• I can obtain
• I cannot obtain it
• Unsure

05

5. This is a full-time, on-site position. Are you able to meet this requirement?

• Yes
• No

06

6. Are you able and willing to participate in emergency response activities?

• Yes
• No

07

7. What level of experience do you have with upgrading ArcGIS Enterprise and supporting multi-machine or highly available deployments?

• None
• Some
• Considerable
• Extensive

08

8. How many years of experience do you have supporting GIS and enterprise databases in a local government environment?

• None
• 1-3 Years
• 4-5 Years
• 6+ Years

09

9. How many years of experience do you have with Python scripting in an integration environment?

• None
• Less than 2 Years
• 2-4 Years
• 5+ Years

Required Question

Employer Town of Cary

Address 316 N. Academy Street, Human Resources

Cary, North Carolina, 27513

Phone 919-469-4070

Website http://www.carync.gov