Database Administrator I

Description Of Work

Looking to take the next step in your IT career?

We currently have an opening for a Database Administrator I

The position is designated Statutory Exempt and is exempt from the State Human Resources Act.

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) queriesResolving 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

Resumes/CVs are intended to be used as a complement to an application. Generally resumes/CVs are lacking the detail and breadth of an applicant’s full education and work history so applicants should complete the application with more detail than what their resume contains to show that they meet both the Education Requirements and ALL Knowledge, Skills and Abilities (KSAs) listed below in order to qualify. Click these links for additional information: Introduction to the Job Application and Addressing Knowledge, Skills and Abilities .

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 systemDemonstrated experience with applications analysis and/or programming techniquesExperience with the development of data automation routines and/or administration for large datasetsExperience working with underlying OS level technology that supports the database environmentExperience 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 North Carolina Department of Information Technology (DIT) is an Equal Opportunity Employer who embraces an Employment First philosophy which consists of complying with all federal laws, state laws and Executive Orders.

NCDIT uses the Merit-Based Recruitment and Selection Plan to fill posted positions. Hiring salary will be based on relevant qualifications, internal equity, and budgetary considerations pertinent to the advertised position.

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

To apply for this position, please click the "Apply" link above (on the Government Jobs website) or visit https://www.governmentjobs.com/Applications/Index/northcarolina to complete an on-line application.

Due to the volume of applications received, we are unable to provide information regarding the status of your application over the phone. To check the status of your application, please log in to your account and click "Application Status." If you are selected for an interview, you will be contacted by management. If you are no longer under consideration, you will receive an email notification. If there are any questions about this posting other than your application status, please contact:

NCDIT Human Resources

Samika Lewis

samika.lewis@nc.gov

For technical issues with your application, please call the GovernmentJobs.com Applicant Support Help Line at 855-524-5627.