FirstBank Jobs

Primary Purpose

: - Performs detailed technical, professional and administrative work to support and maintain numerous SQL databases and servers being used for the enterprise resource planning (ERP) systems and the Tax system. - ERP systems include finance, payroll, central permitting and water utilities. - Tax system includes listing, billing, collections and reappraisal. - These are vendor provided solutions. - Duties may include, but not be limited to, SQL programming, creating and maintaining reports, server and database maintenance, database creation and database analysis. - The position will contribute to the IT team decision-making process related to data and database management while staying current with technology and best practices. - This position will work closely with the Systems Administrator, Network Analyst, Assistant IT Director and various Department Heads and supervisors. - The position will report to the IT Director, or their designee.

Essential Functions

: - Possessthe ability to understand county applications and modules and how they integrate. - Possessthe ability to install and configure new instances of SQL Server and associated databases. - Performs updates and/or hot fixes to SQL server/database environments. - Possessthe ability to tune SQL parameters which affect data access, response times and integrity. - Performs the design, programming, implementation and maintenance of new and existing reports in an MS SQL server environment. - Creates and maintains SQL, T-SQL and SSRS code to produce electronic or printed reports. - Reads and understands data dictionaries and complex database structures. - Possessthe ability to design, create, maintain and support new SQL databases as needed. - Must be able to work with team members and work independently. - Possessgood verbal and written communication skills. - Be part of the IT 24/7 On-Call Team for problem resolution. - Assists with the Emergency Operations Center (EOC) as needed.

Minimum Education and Experience

: - Bachelor's degree in computer information systems, computer science, business administration with major course work involving SQL databases and related programs associated with such, or related field and considerable systems analysis experience utilizing SQL databases and the programs and tools to maintain SQL databases. - Preferred candidates would have training and experience involving Microsoft SQL and SSRS, along with a knowledge of Crystal Reports. - Tyler ERP systems experience would be beneficial. - Possession of a valid North Carolina driver's license. - Satisfactory background checks through local, state and federal agencies, as this position will be part of the IT Group which is exposed to CJIS, HIPPA, PHI and confidential data. - This will also involve being fingerprinted through our County Sheriff's Office.