Database Administrator

City of Fayetteville NC

  • Fayetteville, NC
  • 21 days ago
  • $71,409–$91,047 Per Year

Highlights

Monitor and tune relational database management system (RDBMS) databases to ensure optimum performance; document database designs, structures, and processes; ensure all modifications to database structures and processes are properly documented and annotated; make modifications to database structures and processes to improve performance. Example: Office Assistant 1/2011 - present The Company 123 Hay Street Fayetteville, NC 28301 (910) 555-5555 Unemployed 6/2004 - 12/2010 Unemployed Student 12/2000 - 6/2004 My High School Fayetteville, NC 28301 Applications without a 10-year history and all the required information will be considered incomplete and will not be processed.

Numbers & Facts

LocationFayetteville, NC
Salary$71,409–$91,047 Per Year

Description

Database Administrator

Salary

$71,409.00 - $91,047.00 Annually

Location

433 Hay Street, Fayetteville, NC 28301, NC

Job Type

Regular Full-Time

Job Number

04338-02

Department

Information Technology

Opening Date

08/30/2026

Closing Date

9/4/2026 11:59 PM Eastern

  • Description
  • Benefits
  • Questions

Description

Click here to meet some of the City's "CAN DO" employees.

Hiring Range: $71,409 - $91,047/Year D.O.Q.

INCOMPLETE APPLICATIONS WILL NOT BE PROCESSED.

A RESUME WILL NOT BE CONSIDERED IN DETERMINING YOUR QUALIFICATIONS FOR THIS POSITION.

The City of Fayetteville is currently recruiting for a Database Administrator (DBA) to be responsible for the design, implementation, maintenance, and repair of the City of Fayetteville's Enterprise databases. The role includes the development and design of Enterprise database strategies, monitoring, and improving database performance and capacity, and planning for future expansion requirements. The DBA may also plan, coordinate, and implement Enterprise database security measures. This role focuses on database management specific to the City of Fayetteville (CoF) database servers.

ESSENTIAL DUTIES & RESPONSIBILITIES

  • Work with application development groups and system administrators to determine the best storage, access, and distribution methods for data.
  • Monitor and tune relational database management system (RDBMS) databases to ensure optimum performance; document database designs, structures, and processes; ensure all modifications to database structures and processes are properly documented and annotated; make modifications to database structures and processes to improve performance. Develop guides and processes to assist other staff in tuning RDBMS database structures and processes.
  • Conduct troubleshooting of RDBMS database problems using well-developed troubleshooting techniques, modifying database structures and designs as appropriate. Consult with others as necessary to troubleshoot database, connectivity, and related problems.
  • Develop and refine RDBMS user tools to enhance data input/upload and extraction/reporting capabilities. Instruct users in use and provide advice and counsel regarding user-developed tools; provide technical and training assistance to users on RDBMS database utilization.
  • Develop and test database backup and recovery plans and ensure an adequate level of protection in case of database problems or errors; coordinate with appropriate staff to ensure backup and recovery operations fall in line with City policies and procedures; make recommendations for changes in database backup procedures to increase efficiency and effectiveness.
  • Assist with the following administrative procedures, including but not limited to: backup, clustering, mirroring, replication, and failover of CoF databases.
  • Develop and establish procedures as well as monitor and maintain Enterprise GIS Architecture, ArcGIS Server, and ArcSDE tuning and performance monitoring; design, document, and build GIS database architecture and schema, including tables, views, procedures, and permissions.
  • Develop automation protocols for loading spatial data using data modeling and attribute mapping, and manage the defined workflow routines.
  • Perform administration and develop procedures for applying service packs and upgrades of ArcSDE, ArcGIS, and SQL Server users, roles, and security models.
  • Work with GIS and Business Intelligence teams to populate spatial and enterprise databases, provide performance tuning, and automate data loads or scripting; provide assistance to maintain compliance with the Spatial Data Standards.

For a complete job description, click here.

MINIMUM QUALIFICATIONS

Any combination of experience and training that would likely provide the required knowledge and abilities is qualifying. A typical way to obtain the knowledge and abilities would be:

Experience:

Two years of increasingly responsible experience in administering, supporting and optimizing relational database systems including demonstrated proficiency in database performance tuning, backup and recovery strategies and implementation of security best practices.

Training:

Equivalent to an Associates degree in computer science, database administration, data management systems, information systems, or a related field, or equivalent combination of education and/or experience.

LICENSING AND CERTIFICATIONS:

Required:

None.

Preferred:

Microsoft Certified Solutions Associate Certification and/or Microsoft Certified Solutions Engineer Certification.

Please Note: Candidates selected for a position within the Information Technology Department will be required to successfully complete a Police Department and fingerprint based background check.

  • SBI/Fingerprinting Criminal History Record Check Requirement: To comply with Sessions Law 2025-16, applicants offered a position with the City may be subject to a criminal history record check of State and National Repositories of Criminal Histories conducted by the State Bureau of Investigation (SBI) in accordance with G.S. 143B-1209.26. The City may consider the results of these criminal history record checks in its hiring decisions.

From the time of closing, the selection process is anticipated to last approximately 4 - 6 weeks. The process will consist of a panel interview with the selected candidate being subject to a pre-employment drug screen, background check and driving history check.

An Equal Opportunity Employer

Health and Dental Insurance:

The City of Fayetteville Employee Healthcare Benefit Plan provides comprehensive and affordable health and dental coverage while maintaining reasonable costs to employees. Coverage is available for all regular status employees scheduled to work 30 hours or more per week. Employees may also choose to cover eligible dependents. The premium is deducted on a pre-tax basis, with the City paying a portion of the premium. Qualifying employees are eligible for benefits on the 1st day of the month following 30 days of service.

Employer Paid Leave

Vacation Leave:

Regular employees begin accruing vacation leave the first day of employment. Accruals are based on years of service

and the number of hours an employee is scheduled to work.

Sick Leave:

Regular employees begin accruing sick leave the first day of employment. Accruals are based on the number of hours

scheduled to work; regular full-time employees accrue eight (8) hours per month. Sick leave hours accumulate without

limits and may be used toward creditable service upon retirement from the NC Local Governmental Retirement System.

Holidays:

The City of Fayetteville observes 12 paid holidays per calendar year. When Christmas day is on a Wednesday, an

additional holiday is provided making for 13 paid holidays.

Bereavement:

Regular employees are eligible for bereavement leave. The City will authorize 24 hours per calendar year to mourn or

attend a funeral or memorial service of a family member.

Retirement:

The City of Fayetteville assists employees in securing their financial future during retirement by participating in the NC

Local Governmental Employees' Retirement System, administered by the State of North Carolina. Regular employees

scheduled to work 20 hours or more per week become members in the retirement system upon employment. As a member

of this system, employees are required to contribute 6% of their gross salary on a tax-deferred basis.

Deferred Compensation Plans:

To further assist employees in saving for retirement, the City offers two supplemental retirement savings programs. These

programs enable regular full-time, and part-time employees working at least 20 hours per week, an opportunity to save a

portion of their salary on a tax-deferred basis to supplement their retirement benefits. These programs are the NC 401(k)

plan and NC 457 plan; both administered by Empower. The City currently contributes 4% of base salary to an eligible

employee's NC 401(k) account.

Cafeteria Plan / Supplemental Benefits:

Realizing that each employee may have different insurance needs, the City offers its employees the opportunity to supplement City-provided benefits by selecting from the benefits listed below. These benefits are offered at employees expense through payroll deduction:

  • > Flexible Spending Accounts (FSAs) - Healthcare and Dependent Care Reimbursement Accounts (pre-tax)
  • > Short-Term and Long-Term Disability Insurance
  • > Optional Life & Accidental Death & Dismemberment

Death Benefit:

The first year an employee contributes to the retirement system, the City provides a death benefit of $3,000 once the

employee is benefits eligible. After one year as a contributing member of the Retirement System, a death benefit is provided

by the NC Retirement System that is equal to the highest 12 months' salary in a row during the 24 months before death, no

less than $25,000 and no more than $50,000. There is no cost to the employee for this benefit.

Pay Periods / Deduction for Benefits / Direct Deposit:

City employees are paid bi-weekly (every other Friday). Benefit deductions are taken for 24 pay periods of the year. As an added convenience and safety measure, the City requires all new employees to sign up for direct deposit.

Employee Assistance Program:

The EAP is available at no cost to all employees and their household members. The EAP provides confidential guidance

on legal, financial and personal issues affecting your health, relationships and job.

01

Responses to the supplemental questions must reflect the information provided under the "Work Experience" section of the application. Your responses will be used to determine whether or not you possess the minimum qualifications required for this position at the time of application.

  • I have read and complied with the above statement.

02

Are you a current City of Fayetteville employee?

  • Yes
  • No

03

Have you held an out-of-state drivers license (other than NC) in the past 3 years?

  • Yes
  • No

04

Please indicate the highest degree you currently possess.

  • Masters Degree or higher
  • Bachelors Degree
  • Associates Degree
  • None of the Above

05

From the list below, please indicate the major coursework of your highest degree.

  • Computer Science
  • Database Administration
  • Data Management Systems
  • Information Systems
  • Other Related Field
  • None

06

If you selected "Other Related Field" in the previous question, please list below the major coursework for your degree. (If this question does not apply, please type N/A in the space provided below.)

07

How many years of increasingly responsible experience do you have in administering, supporting and optimizing relational database systems including demonstrated proficiency in database performance tuning, backup and recovery strategies and implementation of security best practices?

  • 4+ years
  • 2 - 3 years
  • One year or less
  • None

08

Briefly describe your experience in administering, supporting and optimizing relational database systems including demonstrated proficiency in database performance tuning, backup and recovery strategies and implementation of security best practices. (If this question does not apply, please type N/A in the space provided below.)

09

Briefly describe your approach to designing, maintaining, and optimizing enterprise relational and database systems to ensure high performance, scalability, and reliability. Include your experience with database performance tuning, backup and recovery strategies, and security best practices. (If this question does not apply, please type N/A in the space provided below.)

10

Please explain your understanding of database governance, data integrity, and compliance standards (e.g., role-based security, HIPAA, GDPR) and how you apply these principles in enterprise database administration. (If this question does not apply, please type N/A in the space provided below.)

11

Briefly describe your experience in collaborating with application developers, system administrators, and business stakeholders to implement database solutions that meet both technical and organizational objectives. (If this question does not apply, please type N/A in the space provided below.)

12

Please describe your experience with database automation, scripting (e.g., Python, PowerShell), and workflow optimization to streamline data management, including spatial and non-spatial datasets. Include your level of expertise and types of processes automated. (If this question does not apply, please type N/A in the space provided below.)

13

Briefly describe your experience in evaluating and implementing emerging database technologies, cloud platforms, or GIS enterprise solutions, and how you determine which innovations are appropriate for an organization. (If this question does not apply, please type N/A in the space provided below.)

14

Briefly describe your experience with different relational database management systems (RDBMS), including SQL Server, Oracle, MySQL, PostgreSQL, or others. Please specify the versions you have worked with and your level of expertise with each. (If this question does not apply, please type N/A in the space provided below.)

15

Briefly describe your experience working with structured, semi-structured, and unstructured data. Please include the types of data, the systems or platforms used, and the nature of your work with each. (If this question does not apply, please type N/A in the space provided below.)

16

From the list below, please select the certifications you currently possess.

  • Academic Geospatial Information Science and Technology Certificate
  • Certified Geographic Information Systems Professional (GISP)
  • Microsoft Certified Solutions Associate Certification
  • Microsoft Certified Solutions Engineer Certification
  • None of the above

17

Briefly describe any additional experience or training you feel is relevant including, but not limited to, data management, any GIS-related field work performed, experience, managing SQL databases, SQL reporting, etc. (If this question does not apply, please type N/A in the space provided below.).

18

INCOMPLETE APPLICATIONS WILL NOT BE PROCESSED! You may attach a resume; however, the application MUST include a 10-year history. Please answer all questions on the application in their entirety and your application MUST include the following: • Drivers License Number • Employer information including salary, address, phone number, supervisor name, and reason for leaving for each employer • Complete Education History (including High School) • A complete 10-year history to include gaps you have had between employment and/or school attendance. Example: Office Assistant 1/2011 - present The Company 123 Hay Street Fayetteville, NC 28301 (910) 555-5555 Unemployed 6/2004 - 12/2010 Unemployed Student 12/2000 - 6/2004 My High School Fayetteville, NC 28301 Applications without a 10-year history and all the required information will be considered incomplete and will not be processed. Please take a moment to review your application for completeness.

  • I have read and understand the above statement

Required Question

Employer City of Fayetteville

Address City Hall

433 Hay Street

Fayetteville, North Carolina, 28301

Phone 910-433-1635

Website https://fayettevillenc.gov/jobs

Similar Jobs