DOS - SYSTEMS PROGRAMMING CONSULTANT - 45000854

State of Florida • Tallahassee, FL

6d • $65,000 - $85,000

About The Position

Department of State
Systems Programming Consultant
Division of Administrative Services
Bureau of Departmental Information Systems
45000854
Open Competitive

Requirements

• At least two (2) years of equivalent work experience in the field of database administration OR an Associates degree with concentration in data processing, data analysis, data science
• Advanced knowledge of data analysis techniques, database structures, and database theories.
• Knowledge of principles, practices and techniques of computer programming and system design.
• Knowledge of Oracle and SQL Server databases.
• Knowledge of Unix/Linux server administration.
• Ability to process information logically and analytically.
• Ability to design systems logic.
• Ability to analyze and interpret computer program data.
• Ability to work on multiple projects simultaneously.
• Ability to communicate technical data processing information effectively both verbally and in writing.
• Ability to work well in a team environment and perform effectively under pressure.
• Ability to establish and maintain effective working relationships with others.

Nice To Haves

• Certification in one or more of the following: Oracle Certified Professional. Microsoft Certified DBA, Microsoft Azure Administration, CompTIA A+, CompTIA Data+, CompTIA Server+.
• Experience with PL/SQL, T-SQL, P-SQL and MS SQL.
• Experience with database administration at a State of Florida agency.

Responsibilities

• Analyze and understand the workflow of the Florida Voter Registration System and its ancillary applications, websites and sub systems.
• Create queries and accurately interpret multiple data sets; write shell scripts to automate repetitive tasks in order to streamline workflow; analyze and develop PL/SQL packages and execute T-SQL and P-SQL queries; analyze business procedures and recommend specific types of data to improve processes.
• Develop conceptual and logical data models, data collection systems, data analytics and other strategies to optimize statistical efficiency; provide BDIS staff with data resources from election related databases needed for case intake, investigation and management; transform specialized data into formatted reports.
• Proposes and implements failover strategies. Performs or tasks database patches. Performs or tasks database upgrades and implements new features. Schedules the monitoring of successful database back-ups. Performs database restores as required.
• Responsible for conducting low level monitoring, access control, and performance of BDIS databases; overall solution configuration; database and related systems architecture, availability planning, including Disaster Recovery; monitor all database environments for capacity, integrity, and efficiency.
• Performs database tuning as needed to address performance issues; conducts proactive maintenance. Responsible for analysis and query execution plans and index utilization. Assists in the development of new applications, including system design, creation of tables, and setting performance metrics. Implement database schema modifications as required.
• Maintain change logs for all database configuration updates and changes for all database servers. Maintain change logs for user accounts and ensure security standards are implemented.
• Other work-related duties as assigned.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree