Systems Software Programmer

Position Overview

Seeking an Intermediate-level Systems Software Programmer to work within the Systems, Servers, and Security Support Unit of the Information Technology Division. In this role, you will work closely with the unit’s lead application developer and data management professional to provide installation, support, and troubleshooting of applications, systems, databases, and servers used in the agency. Your responsibilities include supporting existing applications, upgrading/transitioning/deploying new systems, assisting with interfaces and data exchanges, querying/analyzing/presenting data, developing and automating reports, monitoring and managing SQL Server databases, producing documentation, and supporting the agency’s websites and content management system (CMS). The role is remote eligible following an onsite acclimation period and management approval. You will be expected to analyze alternative approaches to implementing software solutions, considering system interrelationships, stakeholder requirements, and the most appropriate software/equipment configuration, all while adhering to the agency's core values of honesty, integrity, accountability, teamwork, trust, respect, and commitment to excellence.

Key Responsibilities

• Provide first and second-tier technical support for applications, systems, and servers.
• Work with vendors and stakeholders on the selection, implementation, and integration of new applications and infrastructure.
• Participate in testing and user acceptance of applications and upgrades.
• Assist with software updates, upgrades, patching, license inventory, and monitoring of various applications and databases.
• Develop workflow and processes for querying, editing, reporting, and mapping of application data.
• Design and implement processes or process improvements to aid in the development and support of applications.
• Design, develop, and implement internal data feeds, data reporting extracts, and ETL processes between disparate systems.
• Create and maintain custom views and stored procedures to support automation and data integrations.
• Leverage API and author interfaces to facilitate and enhance business processes.
• Document data flows and application specifications from a database perspective.
• Configure and monitor relational databases to optimize performance, safeguard backup and recovery, and ensure overall health and availability.
• Design, create, and implement analytical reports using SQL Server Reporting Services (SSRS) and PowerBI.
• Write and maintain clear technical documentation describing procedures and processes.
• Provide training documentation and/or training to facilitate the transition of support to other areas within and beyond the IT section.
• Support initiatives aligned with the Sheriff’s Office Strategic goals and objectives.
• Perform other duties of similar nature and level, maintaining a team-oriented approach.
• Effectively communicate both orally and in writing while delivering professional customer service.
• Prepare and present clear, concise, and objective written and oral reports.
• Adhere to required licensures, certifications, and agency in-service training standards.
• Consistently report to work on time and respond to after-hour issues when required.

Required Qualifications

• High School Diploma or GED
• Bachelor's Degree in Computer Science or a related technical field
• Minimum two years of experience creating, managing, maintaining, and querying SQL databases
• Minimum two years in a technical or business analysis role designing, testing, deploying, and supporting applications and related databases OR an equivalent combination of education, training, certification, and experience

Preferred Qualifications

• Experience with Microsoft SQL Server, SQL Server Reporting Services (SSRS), Internet Information Server, ASP.NET, Visual Studio, and HTML5
• Familiarity with DNN Content Management System (CMS), SmartSheet, Excel, Microsoft PowerBI, Active Directory, Group Policy, Windows Server, PowerShell scripting, Laserfiche Document Imaging, Banner, and NeoGov HRM
• Exposure to common Project Management (PM) practices