Application and SQL Database Administrator

Application and SQL Database Administrator Applicants must upload a cover letter and resume with their application.

1. Provide application support for various software applications used by the members of the KCPD including: Motorola CAD, Niche, Service Desk, and AlertNet. Provide support for any existing department application that may be added to the oversight of the Application Support Section.
2. Perform analysis related to tracking overall quality and functionality of applications. Interact with end users on a consistent basis to gather feedback in order to assess accessibility, performance, and reliability of applications.
3. Provide accurate quality analysis of new software applications. Identify potential issues related to network compatibility, and functionality. Make recommendations related to feasibility of application deployment.
4. Ability to successfully implement new applications on the KCPD network. Oversee all aspects of application installation and initiation. Provide after-action analysis of implementation, end user satisfaction, and application performance.
5. Ability to thoroughly examine and research software application problems, perform diagnostics, and resolve issues in a timely and efficient manner. Effectively document action steps, results, and solutions.
6. Consider both back-end organization of data and front-end accessibility for end-users.
7. Control database access, permissions and privileges.
8. Develop, manage and back-up recovery plans of databases.
9. Manage the security, High Availability & Disaster recovery aspects of database.
10. Install, configure and upgrade Microsoft SQL Server instances.
11. Database performance, tuning & optimization
12. Proficiency with database languages such as T-SQL
13. Review project requests to identify database needs and estimate project time and work requirements.
14. Provide end user support for issues submitted via Service Desk Tickets. Provide end user training when necessary.
15. Continue advancing relevant skills and knowledge through research and attending educational conferences for continuous proficiency development.
16. The incumbent is required to have strong verbal, time management, writing, analytical and decision‑making skills.
17. Incumbent is required to consistently exercise discretion, sound judgment, and must comply with all accreditation mandates to assure quality of results and analysis.
18. Regular and reliable attendance is required. Incumbent may be required to work flexible hours and/or mandatory overtime for special projects.
19. Perform related duties as required.

Requirements & Qualifications: Must reside within 30 statute miles of Kansas City, Missouri city limits during employment Bachelor's Degree in Computer Science or related field; or equivalent related work experience 5+ years of experience on Windows Server; 2016, 2019, 2022 & 2025 platforms preferred Experience installing and configuring Microsoft SQL Server required Database administration in VM environment/MS SQL (2014-2022) Five+ years of experience in performing advanced software application support as related to the duties listed in this document is preferred and 3-5 years of experience with database administration. Experience with C#, TCP/IP networking, SQL Server Reporting Services, Visual Studio, .Net Programming, and Microsoft Server Support, also preferred. The incumbent must have the ability to work independently, as well as in a team atmosphere. Proficiency within the following areas is preferred but not required: Oracle migration/conversion to SQL Physical, Cognitive, and Psychological Requirements: Position is primarily sedentary and incumbent will work at a computer 70% of the time; may require telephone usage approximately 1 hour per day. Must have the ability to lift up to 50 pounds periodically, bend, crawl, carry equipment, kneel, climb, and work on the floor under counters and desks. #J-18808-Ljbffr Kansas City Police Department