DOS - DATA BASE CONSULTANT - 45001074

Requisition No: 796757

Agency: Department of State

Working Title: DOS - DATA BASE CONSULTANT - 45001074

Position Number: 45001074

Salary: $65,000 - $80,000

Posting Closing Date: 03/20/2023

Department of State

Database Consultant

Information Technology

Office of Election Crimes & Security

Open Competitive

Minimum Qualifications:

• High school diploma or equivalent.
• Three (3) years-experience as a database analyst or database administrator, to include database performance tuning, database management, requirements analysis, software development fundamentals, documentation skills, database security, PL/SQL packages and T-SQL-P-SQL query and SQL Server databases and Azure SQL database.

Preferences:

• Ability to coordinate with team members in various technical initiatives and work assignments.
• Ability to communicate technical data effectively verbally and in writing.
• Ability to work well in a team environment and work effectively under pressure.

Special Note:

Responses to qualifying questions must be clearly supported in your employment history.

Duties and Responsibilities:

• Maintain SQL database data storage and access by designing and physical data databases. Complete life cycle data generation and outline critical information for projects. Analyze business procedures and recommend specific types of data that can be used to improve upon them. Confirm project requirements by studying user requirements conferring with others on project team. Develop conceptual and logical data models, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality. Develop and maintain data dictionary by creating and revising definitions. Identify and implement data migrations. Analyze and develop PL/SQL packages, and T-SQL-P-SQL query.
• Participate in performing database and case management system tuning as needed: diagnose database performance issues; purpose and implement resolutions; analyze query execution plans and index utilization. Perform database restores as required. Perform data exports and imports as required. Identify, analyze and interpret trends or patterns in complex data sets.
• Serves as the data processing administrator for all OECS intake data from various entities and complainants.
• Provides staff the relevant data resources from elections related databases needed for OECS case intake, investigation, and management.
• Assists in the development and maintenance of a comprehensive long-range plan to effectively meet departmental systems requirements.
• Evaluates new or upgraded operating systems and other systems support software.
• Enhances and further develops the growing OECS case management system, where necessary, and manages all operational infrastructure needs as they arise.
• Performs other work-related duties as required.

Knowledge/Skills/Abilities:

• Utilization of equipment, required for the position.
• Proficiency in Microsoft 365, including SharePoint, Teams, and Power Platform.
• Must be proficient in SQL Server databases.

CRIMINAL BACKGROUND CHECKS: A Level 2 criminal background check is a condition of employment. If selected for this position, you must provide your fingerprints. We will send your fingerprints to the Florida Department of Law Enforcement and the Federal Bureau of Investigation for a criminal background check.

IMPORTANT NOTICES:

We are committed to enhancing our workforce through the employment of Veterans, individuals with disabilities and seek qualified candidates with from diverse backgrounds, abilities, skills, and talents to join our workforce.

Male applicants born on or after January 1, 1960, will not be eligible for hire or promotion unless they are registered with the Selective Services System (SSS) before their 26th birthday, or have a Letter of Registration Exemption from the SSS. For more information, please visit the SSS website: https://www.sss.gov

The State of Florida is an Equal Opportunity Employer/Affirmative Action Employer, and does not tolerate discrimination or violence in the workplace.

Candidates requiring a reasonable accommodation, as defined by the Americans with Disabilities Act, must notify the agency hiring authority and/or People First Service Center (1-866-663-4735). Notification to the hiring authority must be made in advance to allow sufficient time to provide the accommodation.

The State of Florida supports a Drug-Free workplace. All employees are subject to reasonable suspicion drug testing in accordance with Section 112.0455, F.S., Drug-Free Workplace Act.

VETERANS’ PREFERENCE. Pursuant to Chapter 295, Florida Statutes, candidates eligible for Veterans’ Preference will receive preference in employment for Career Service vacancies and are encouraged to apply. Certain service members may be eligible to receive waivers for postsecondary educational requirements. Candidates claiming Veterans’ Preference must attach supporting documentation with each submission that includes character of service (for example, DD Form 214 Member Copy #4) along with any other documentation as required by Rule 55A-7, Florida Administrative Code. Veterans’ Preference documentation requirements are available by clicking here. All documentation is due by the close of the vacancy announcement.