Apply on Employer Site

N.C. Department of Information Technology · 4 hours ago

Database Administrator

Wake County, NC

Full-time

Onsite

Mid Level

$84K/yr - $105K/yr

3+ years exp

The N.C. Department of Information Technology is responsible for overseeing elections administration in North Carolina. The Database Administrator II position involves technical and analytical work in the design, development, and support of SQL Server database solutions to ensure secure and efficient election-related processes.

Information Technology & Services

Work & Life Balance

Responsibilities

Designing logical and physical database structures

Ensuring data security, integrity, and access control

Consulting with application developers to align database architecture with system requirements

Leading complex database projects and providing technical guidance to junior DBAs

Performing database maintenance, including backups, recovery, and performance tuning

Coordinating with infrastructure teams to manage underlying operating system and network technologies that support database environments

Provides technical leadership and guidance to junior DBA

Data Analytics and Auditing

Managing Data Dashboards and Visualizations

Overseeing Manual and Automated Election Data Processes

Administer and maintain integrated SQL Server database systems supporting statewide and departmental election-related applications

Collaborate with infrastructure and systems teams to ensure optimal data storage, access, backup/recovery, and archival processes

Develop and maintain advanced T-SQL and PowerShell scripts and procedures to automate administrative tasks, monitor system performance, and generate operational alerts

Support and monitor replication, scheduled jobs, and service availability across distributed environments

Assist in establishing and enforcing database design, coding, and management standards in alignment with agency, state-wide, and industry best practices

Maintain comprehensive technical documentation and procedural guides

Ensure database compliance with state and federal regulations, including audit trail maintenance and reporting

Design and model logical and physical database structures to support application development and reporting needs

Communicate database-related issues and resolutions with developers, testers, business analysts, and management

Evaluate and implement third-party database tools to enhance performance, diagnostics, and support capabilities

Maintain and monitor database Security & Access Controls

Design and implement database monitoring, alerting, and data transformation processes to support operational efficiency

Recommend and employ third party database tools to enhance efficiency and support capabilities

Assist with the management of GIS spatial databases and associated election applications and processes

Deploy developer fixes using Red Gate tools and agency specific processes

Collaborate with application developers during the conceptual and design phases to ensure database architecture aligns with system requirements

Advise developers on database coding standards, query optimization, and best practices for performance and maintainability

Develop and maintain business logic and administrative tasks for data restoration for testing

Assist in the design and support of data warehouse structures and ETL processes that align with agency business requirements and state IT standards

Collaborate with agency business units to define reporting requirements and deliver actionable insights through data visualization tools such as Power BI, Tableau, SSRS, and Report Builder

Perform source system analysis and assist in modeling data structures to support reporting and analytics

Implement and manage business intelligence tools to facilitate secure, role-based access to operational and strategic data

Support pre- and post-election audit processes by preparing and validating data for contest, candidate, ballot, and voter registration audits

Serve as an internal consultant, promoting data-driven decision-making and cross-functional collaboration through modern reporting and analytics practices

Develop and maintain SQL-based reports and dashboards to support internal operations, public transparency, and external data requests

Maintain and enhance reporting infrastructure, including intranet-based reporting portals and automated data refresh processes

Support the design and enhancement of predictive analytics, statistical reporting, and visualization methods to support decision-making

Assist in managing GIS data workflows and shapefiles related to redistricting and precinct changes

Qualification

SQL Server administrationT-SQLDatabase designData modelingETL processesPower BITableauPerformance tuningData visualizationAzure Cloud servicesPowerShell scriptingInterpersonal skillsTechnical leadershipCollaboration

Required

Bachelor's degree in computer science or an IT related field or a related curriculum from an appropriately accredited institution and three years of progressive experience in programming and applications analysis including the design and maintenance of an integrated database system

Associate degree in computer science or an IT related field or a related curriculum from an appropriately accredited institution and four years of progressive experience in programming and applications analysis including the design and maintenance of an integrated database system

High School or General Educational Development (GED) diploma and seven years of relevant experience in programming and applications analysis including the design and maintenance of an integrated database system

Thorough knowledge of integrated database systems and database programming techniques

Demonstrated experience with Microsoft SQL Server administration in Windows environments

High proficiency in T-SQL for querying, scripting, and procedural logic

Demonstrated knowledge proficiency of SQL replication, backup/recovery strategies, performance tuning, and SQL Server Reporting Services (SSRS)

Familiarity with data modeling and ETL processes

Plan and manage complex database projects with varied timeframes and enterprise or statewide scope

Strong interpersonal skills with the ability to collaborate across divisions and teams

Ability to train and guide junior DBAs