Description of Work

This is a time-limited position. It is full-time with State Benefits for a limited time. Although the length of time this position will be active cannot be determined, we anticipate that this position will be in place through December 31, 2026. If you have questions concerning the time-limited status of this position, you may inquire at the interview.

The Database Administrator I is responsible for the design, implementation, backup, and management of geospatial databases, and the data contained in them that becomes part of the NC Division of Broadband and Digital Equity (DBDE) work. The position is statewide in scope. The NC DBDE has a formal agreement with the Center for Geographic Information & Analysis (CGIA) to manage PostgreSQL enterprise databases related to broadband availability for over four million locations in the state, as well as tracking broadband grant locations throughout all 100 counties.

Management and administration of the Geographic Information Systems (GIS) data and databases includes the following tasks:

• Seeking and receiving regular updates to GIS data layers
• Performing quality control checks (e.g. projection, metadata, completeness) on the data before making it available to CGIA and DBDE customers

• Provides technical advice and direction to CGIA and the Division of Broadband and Digital Equity
• Responsible for data modeling, database optimization, implementation of schemas, and interpreting and writing complex Structured Query Language (SQL) queries

• Resolving any technical issues that may surface with any GIS data
• Developing and implementing GIS data archival, recovery, and access strategies
• Maintaining a GIS data inventory and clearinghouse through NC OneMap to facilitate discovery and access of GIS data resources
• Assessing technical requirements and implement technology enhancements and solutions based on customer feedback, technology trends, etc. (e.g. implementation and automation of relational database management system (PostgreSQL with the PostGIS extension) running in the Amazon Web Services (AWS) cloud)
• Resolving technical issues related to data delivery and availability and install and maintain patches for database and geospatial software
• Providing leadership in the long-term planning of the broadband location database
• Providing consultation to staff that are performing data creation and implementation activities related to database and enterprise activities

Availability of the DBDE databases and the geospatial data in them is critical to understanding the broadband landscape in North Carolina. The Database Administrator will need to:

• Administer a database to support the tracking of currently funded locations and identifying locations that are eligible for future funding programs
• Oversee data and database functions for tracking the progress of these programs and the overall progress of connecting all citizens in the state to this critical infrastructure
• Maintain a reliable database with reliable geospatial information that is continuously available to support essential stakeholder workflows and the transparency and success of the funding programs implemented by the DBDE
• Serve as a key technical resource in solving highly complex problems related to relational database management systems and Geographic Information Systems
• Track changes within Federal Communications Commission (FCC) datasets related to location-level availability of broadband
• Investigate, research, and implement new technical approaches and technologies associated with relational database management systems and Geographic Information Systems

About the Organization

The N.C. Department of Information Technology (NCDIT) serves as the Technology Center for the State of NC. Services that NCDIT provides reach a client base of state and local government agencies, as well as schools, colleges and universities. NCDIT’s mission is to enable trusted business-driven solutions that meet the needs of North Carolinians. NCDIT provides technology services to state agencies and is charged with closing the digital divide by expanding availability of broadband services and promoting the adoption of affordable, high-speed internet.

As NCDIT’s services reach North Carolina residents from all backgrounds, we believe that a diverse workforce is our most valuable asset to recognize, understand and meet the IT needs of our constituents across the state. Our agency culture intentionally values diversity, equity and inclusion through the implementation of thoughtful, practical, innovative and data-driven strategies. We are an Employment First state, ensuring that people with disabilities have equal opportunities to succeed in the state government workplace (Executive Order 92). NCDIT supports recent executive orders to address pay equity for women (Executive Order 93), establish paid parental leave for birth, adoption, and foster care (Executive Order 95), and implement fair chance policies (Executive Order 158). Join a team that welcomes, values, respects and supports all members of our work community.

If you have student loans, becoming a state employee includes eligibility for the Public Service Loan Forgiveness Program. Visit www.studentaid.gov to learn more.

Knowledge, Skills and Abilities / Competencies

To qualify for this position, applicants must document on the application that they possess ALL of the following:

• Demonstrated experience with administration and/or structuring of an integrated database system
• Demonstrated experience with applications analysis and/or programming techniques
• Experience with the development of data automation routines and/or administration for large datasets
• Experience working with underlying OS level technology that supports the database environment
• Experience with implementing and administering data and/or database security techniques

Minimum Education and Experience Requirements

Bachelor's degree in Computer Science or an IT related field or a related curriculum from an appropriately accredited institution and one year of experience in programming and applications analysis including the design and maintenance of an integrated database system
OR
Associate degree in Computer Science or an IT related field or a related curriculum from an appropriately accredited institution and two years of experience in programming and applications analysis including the design and maintenance of an integrated database system
OR
High School or General Educational Development (GED) diploma and five years of experience in programming and applications analysis including the design and maintenance of an integrated database system; or an equivalent combination of education and experience.

Supplemental and Contact Information

• The Department of Information Technology will not accept "See Resume" or inserted text resumes in lieu of all work experience and education completed on the application.
• Employment at NCDIT is contingent upon a satisfactory background check.
• Applicants seeking Veteran's Preference must attach a DD form 214, Certificate of Release or Discharge from Active Duty, along with your application.
• Applicants seeking National Guard Preference must attach a NGB 23A (RPAS) if you are a current member of the NC National Guard in good standing. If you are a former member of the NC National Guard who served for at least 6 years and was discharged under honorable conditions, you must attach either a DD256 or NGB 22.
• Applicants applying for positions that require specific coursework, must upload and attach a copy of the transcript with their application.
• Applicants with relevant professional certifications to the posted job must attach proof of active certification along with the information in the “Certificates and Licenses” section.
• If applicants earned college credit hours but did not complete a degree program, they must attach an official transcript to each application to receive credit for this education.
• If applicants earned a foreign degree, foreign degrees require an official evaluation for U.S. equivalency, and must be submitted to Human Resources for verification. There are several organizations that perform this specialized service, feel free to use any service of your choosing. The National Association of Credential Evaluation Services (NACES) has several options on their website that can provide credential verification: https://www.naces.org/members

REMOTE WORK:

We trust our employees to be self-motivated and successful in hybrid/remote roles, thus NCDIT offers robust work from home options and variable work schedule flexibility.

COMPENSATION & BENEFITS:
The state of North Carolina offers excellent comprehensive benefits. Employees can participate in health insurance options, standard and supplemental retirement plans, and the NCFlex program (numerous high-quality, low-cost benefits on a pre-tax basis). Employees also receive paid vacation, sick, and community service leave. In addition, paid parental leave is available to eligible employees.

Some highlights include:

• The best funded pension plan/retirement system in the nation according to Moody’s Investor’s Service
• Twelve (12) holidays/year
• Fourteen (14) vacation days/year which increase as length of service increases and accumulate year-to-year
• Twelve (12) sick days/year which are cumulative indefinitely
• Longevity pay lump sum payout yearly based on length of service
• 401K, 457, and 403(b) plans

Learn more about employee perks/benefits:

• Why Work For NC?
• NC OSHR: Benefits
• NC OSHR: Total Compensation Calculator