Database Administrator

Database Administrator

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 and responsibilities include:

• 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.

Minimum qualifications include any combination of experience and training that would likely provide the required knowledge and abilities. 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: None required. 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.

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.