Job description

LCSO-7640 Essential duties: • 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 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 as needed 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 and resource use, safeguard backup and recovery, and ensure health and availability. • Design, create, and implement analytical reports and provide general support using SQL Server Reporting Services (SSRS) and PowerBI. • Write and maintain clear and accurate technical documentation to describe procedures and processes. • Provide training documentation and/or training as needed to transition to support to areas within and beyond the IT section. • Support activities and initiatives concerning the Sheriff's Office Strategic goals and objectives. • Perform other duties of similar nature and level. • Ability to work closely with others as a team. • Ability to effectively communicate both orally and in writing. • Ability to provide professional customer service skills to both the public and agency members. • Ability to prepare and present clear, accurate, concise, and objective written and oral reports. • Ability to meet requirements and maintain required licensures and certifications as well as agency required in-service training. • Ability to adhere to the standards and principles of the agency's core values and professionally represent the agency. • Ability to report to work timely, consistently, and as scheduled. Business Analyst: Key Knowledge, Skills: • Minimum two years of experience in business analysis, project management, or other technical role designing, testing, deploying and supporting applications and their related databases in current technologies OR • Possession of any equivalent combination of education, training, certification, and experience which provides the requisite knowledge, skills, and abilities for this position. • The ideal resource will have (and preference will be given to those with experience with): Active Directory, Group Policy, Windows Server, PowerShell scripting, Microsoft SQL Server, SQL Server Reporting Services (SSRS), Microsoft PowerBI, SmartSheet, Excel, ASP.NET, Visual Studio, HTML5, Internet Information Server, DNN Content Management System (CMS), Laserfiche Document Imaging, and NeoGov HRM. • Exposure to common Project Management (PM) practices also preferred. #J-18808-Ljbffr

Requirements