Database Administrator in Fayetteville, North Carolina at City of Fayetteville

1. Work with application development groups and system administrators to determine the best storage, access, and distribution methods for data.
2. 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.
3. 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.
4. 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.
5. 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.
6. Assist with the following administrative procedures, including but not limited to: backup, clustering, mirroring, replication, and failover of CoF databases.
7. 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.
8. Develop automation protocols for loading spatial data using data modeling and attribute mapping, and manage the defined workflow routines.
9. Perform administration and develop procedures for applying service packs and upgrades of ArcSDE, ArcGIS, and SQL Server users, roles, and security models.
10. 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.
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 Associate's 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.