Database Administrator I



Database Administrator I

Salary

$75,814.00 - $113,721.00 Annually

Location

Wake County, NC

Job Type

Time-Limited Full-Time

Job Number

24-04728 65038666 EHRA

Department

Department of Information Technology

Division

DIT Secretary & CIO

Opening Date

04/05/2024

Closing Date

4/19/2024 5:00 PM Eastern

Job Class Title

Database Administrator I

Position Number

65038666

Section

Data

Work Location

Wake County

Salary Grade

DT09

Recruitment Range

Up to $94,768

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

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 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 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:

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. 



NOTE: For temporary, contract or other supplemental staffing appointments:
There are no paid leave, retirement or other benefits associated with these appointment types.





For permanent and time-limited appointments:
Eligible employees have benefits that include employee health insurance options, standard and supplemental retirement plans, NC Flex (a variety of high-quality, low-cost benefits on a pre-tax basis), and paid vacation, sick, and community service leave, to name a few.  Paid parental leave is available for eligible employees.  Some benefits require 30 + hours work/week for participation.
 

01
To qualify for this position, applicants must possess the required "Minimum Education and Experience" AND all "Knowledge, Skills and Abilities" listed on the job posting. I understand that my application MUST include a complete work history in the "Work Experience" section, all education in the "Education" section, and credentials in the "Certificates and Licenses" section. I understand that a resume is NOT a substitute for completing the sections listed above. Also, I understand that Supplemental Questions are considered a part of the application and the answers are used in the screening process, and that all questions must be answered completely and accurately.
  • Yes, I understand
02
Are you aware this position is exempt from the provisions of the State Human Resources Act (EHRA), meaning the position is at-will, however, still eligible for all state employee benefits?
  • Yes, I understand
03
The recruitment range max for this position is $94,768. I am aware that if offered this position, the salary offer will be within the recruitment range.
  • Yes, I understand
04
To receive credit for relevant professional certifications you must attach documented proof of your active certifications to this application in addition to including the information regarding your certifications in the "Certificates and Licenses" section.
  • Yes, I understand
05
We trust our employees to be self-motivated and successful in hybrid roles, thus NCDIT offers robust work from home options and variable work schedule flexibility. This position currently qualifies for a hybrid telework option with routine office and remote workdays, although telework options are subject to change at the discretion of management.
  • Yes, I understand
06
Please select the education and experience level that best reflects your education and related experience:
  • 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
  • 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
  • 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
  • An equivalent combination of education and experience
  • I do not have the minimum number of years of relevant education and/or experience as indicated above
07
Which areas have you demonstrated on your application? (check all that apply)
  • 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 with implementing and administering data and/or database security techniques
  • I do not have knowledge or experience in any of the areas listed
08
Where did you find out about this posting?
  • #TriangleTuesdays
  • #Work4Us Wednesdays
  • Career Fair
  • CollegeCentral
  • Employee Referral
  • Facebook
  • Google
  • Government Jobs (State Jobs website)
  • Handshake
  • Indeed
  • LinkedIn
  • NC Tech
  • NCWorks
  • OSHR Website (Office of State Human Resources)
  • Symplicity
  • Twitter
  • Other
09
If you selected Career Fair, Employee Referral, or Other from above please let us know which Career Fair, Employee, or Other place you found about us! If you did not choose one of the above, please enter N/A

Required Question

Agency
State of North Carolina
Address
NOTE: Apply to the department listed on posting

An Equal Opportunity Employer, North Carolina, State Government