City of Fayetteville, North Carolina
Database Administrator
City of Fayetteville, North Carolina, Fayetteville, North Carolina, United States, 28305
Hiring Range:
$71,409 - $91,047/Year D.O.Q.
Incompleted 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’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.
Responsibilities
Work with application development groups and system administrators to determine the best storage, access, and distribution methods for data.
Monitor and tune 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 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.
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.
Required No licensing or certifications required.
Preferred Microsoft Certified Solutions Associate Certification and/or Microsoft Certified Solutions Engineer Certification.
Background Check Candidates selected for a position within the Information Technology Department will be required to successfully complete a Police Department and fingerprint based background check. Applicants may be subject to a criminal history record check of State and National Repositories of Criminal Histories conducted by the 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.
#J-18808-Ljbffr
$71,409 - $91,047/Year D.O.Q.
Incompleted 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’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.
Responsibilities
Work with application development groups and system administrators to determine the best storage, access, and distribution methods for data.
Monitor and tune 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 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.
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.
Required No licensing or certifications required.
Preferred Microsoft Certified Solutions Associate Certification and/or Microsoft Certified Solutions Engineer Certification.
Background Check Candidates selected for a position within the Information Technology Department will be required to successfully complete a Police Department and fingerprint based background check. Applicants may be subject to a criminal history record check of State and National Repositories of Criminal Histories conducted by the 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.
#J-18808-Ljbffr