Skip to main content

Application and SQL Database Administrator

STARTING MONTHLY SALARY: $5,262

Listing Expiration Date: 

January 28, 2025

Applicants must upload a cover letter and resume with their application.

APPLY NOW

Job Description Summary

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

  • 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

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

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

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

  • Consider both back-end organization of data and front-end accessibility for end-users.

  • Control database access, permissions and privileges.

  • Develop, manage and back-up and recovery plans of databases.

  • Review project requests to identify database needs and estimate

  • Provide end user support for issues submitted via Service Desk Tickets. Provide end user training when necessary.

  • Continue advancing relevant skills and knowledge through research and attending educational conferences for continuous proficiency development

  • Regular and reliable attendance is required. Incumbent may be required to work flexible hours and/or mandatory overtime for special projects.

  • Other related duties...see full job description for more detail.

Requirements & Qualifications:

  • Must reside within 30 statute miles of Kansas City, Missouri city limits during employment

  • Successful completion of medical, physical fitness, psychological evaluations, and CVSA test

  • Bachelor's Degree in Computer Science or related field; or equivalent related work experience

  • 5+ years of experience on Windows Server; 2003, 2008 & 2012 platforms preferred

  • Experience installing and configuring Microsoft SQL Server required

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

    • Database administration in VM environment/MS SQL (2014-2022)
    • Oracle migration/conversion to SQL
    • UNIX 

Physical, Cognitive, and Psychological Requirements:

  • Must meet department-established physical, cognitive, and psychological health standards

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