Database Administrator

Other Jobs To Apply

<p><strong>ADVERTISE TO</strong></p><p>Fri. 11/14/25</p><p><strong>HIRING RANGE</strong></p><p>$71,409.00 - $91,047.00 D.O.Q.</p><p><br></p><p>Interested in being part of an All-America City? The City of Fayetteville was awarded the All-America City distinction for the 4th time in 2023. We are the sixth largest City in North Carolina and leverage collaboration and inclusiveness to make decisions and solve problems. Beyond this distinction, to see what Fayetteville has to offer visit DistiNCtly Fayetteville (distinctlyfayettevillenc.com).</p><p><br></p><p>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</p><p><br></p><p><strong>ESSENTIAL DUTIES & RESPONSIBILITIES:</strong></p><ol><li>Work with application development groups and system administrators to determine the best storage, access, and distribution methods for data.</li><li>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.</li><li>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.</li><li>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.</li><li>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.</li><li>Assist with the following administrative procedures, including but not limited to: backup, clustering, mirroring, replication, and failover of CoF databases.</li><li>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.</li><li>Develop automation protocols for loading spatial data using data modeling and attribute mapping, and manage the defined workflow routines.</li><li>Perform administration and develop procedures for applying service packs and upgrades of ArcSDE, ArcGIS, and SQL Server users, roles, and security models.</li><li>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.</li></ol><p><br></p><p><strong>MINIMUM QUALIFICATIONS:</strong></p><p>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:</p><p><br></p><p><u>Experience:</u></p><p>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.</p><p><br></p><p><u>Training:</u></p><p>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.</p><p><br></p><p><strong>LICENSING & CERTIFICATIONS:</strong></p><p><u>Required</u>:</p><p>None.</p><p><br></p><p><u>Preferred</u>:</p><p>Microsoft Certified Solutions Associate Certification and/or Microsoft Certified Solutions Engineer Certification.</p><p><br></p><p><strong>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.</strong></p><p><br></p><ul><li><strong><u>SBI/Fingerprinting Criminal History Record Check Requirement</u>: 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 <u>G.S. 143B-1209.26</u>. The City may consider the results of these criminal history record checks in its hiring decisions.</strong></li></ul><p><br></p><p><strong>BENEFITS INCLUDE:</strong></p><ul><li>Health & Dental</li><li>Paid Vacation, Sick Leave and Holidays</li><li>Retirement</li><li>Supplemental Benefits</li></ul><p><br></p><p>To apply or for more information, please visit the City's career page at: https://www.governmentjobs.com/careers/fayetteville</p><p><br></p><p>The City is an Equal Opportunity Employer and values diversity at all levels of its workforce.</p>

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...