DATABASE ADMINISTRATOR

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

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 general supervision of the Enterprise Applications Manager.

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

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.

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 driver's 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.