Programmer/Analyst 5, IT

Job Duties

• Responsible for data analysis and SQL database management.
• Responsible for backups, maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning.
• Configure and monitor batch job and interfacing processes to county, state, or vendor.
• Support the Application Development Team by creating and maintaining SQL databases, tables, views, stored procedures, and SSIS packages.
• Support agency through the understanding of the databases for enterprise wide consumer applications, including OnBase.
• Responsible for application security at the database and stored procedure level by assigning permissions by active directory groups and enforcing best practice standards with regard to data delivery and storage.
• Frequently audits data layer to ensure that all security practices are being followed.
• Update processes and procedures based on current standards.
• Write and maintain database documentation, including data standards, procedures and definitions.
• Use data standards documentation to enforce consistency (naming conventions, table, and column structures, and data access) across all databases.
• Perform research in aid in troubleshooting software production errors.
• Maintain regular and predictable attendance.

Major Worker Characteristics

• Knowledge of agency policy and procedures; electronic data processing.
• Skill in equipment operation.
• Ability to interpret extensive variety of technical materials; calculate fractions, decimals and percentages; prepare meaningful, concise and accurate reports; gather, collate and classify information about data, people or things; cooperate with co-workers on group projects.

Minimum Class Qualifications for Employment

• Any equivalent combination of relevant training and experience including but not limited to: Bachelor’s degree in computer science, information technology or related field with five (5) years application and database development experience.

Additional Requirements

• Must meet background check requirements.