DOS - DATA BASE CONSULTANT - 45001074

State of Florida; Tallahassee (FL); On-site; USD 95,000 - 125,000; Full time

Job summary

The State of Florida seeks a Senior Database Administrator for the Office of Election Crimes and Security in the Florida Department of State. This role maintains OECS databases, supports case intake and document requests, and ensures data integrity and security in a high-stakes environment.

You will develop PL/SQL and T-SQL queries, implement failover strategies, perform patches and upgrades, and provide data resources to staff for investigations.

Qualifications

• Requires at least 2 years of related DB admin work or an associate degree.
• Preferred certifications in Oracle/SQL/Cloud tech are listed in job preferences.
• Experience with Oracle and SQL Server databases.
• Knowledge of Unix/Linux server administration.

Responsibilities

• Serve as senior DBA for OECS databases and data workflows.
• Create queries, shell scripts, and PL/SQL packages; run T-SQL/P-SQL queries.
• Develop data models, analytics, and reports for case intake and investigations.
• Propose and implement failover strategies; perform patches/upgrades and backups.
• Monitor performance, access, security, and capacity; assist app development.
• Maintain change logs and enforce security standards.

Skills

SQL proficiency

Data analysis

Unix/Linux administration

Analytical thinking

Teamwork

Communication

Education

Associate degree in CS/IT/MIS

Tools

Oracle Certified Professional

Microsoft Certified DBA

Microsoft Azure Administration

CompTIA A+

CompTIA Data+

CompTIA Server+

PL/SQL

T-SQL

P-SQL

MS SQL

Job description

The State Personnel System is an E-Verify employer. For more information click on ourE-Verify Website .

• At least two (2) years of equivalent work experience in the field of database administration or a n associate’s degree from an accredited college or university in computer science, information technology, management information systems .

Preferences:

• 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.

Special Note:

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

Duties and Responsibilities:

This position serves as the senior database administrator for the Office of Election Crimes and Security (OECS) at the Florida Department of State (Department). Responsible for maintaining OECS database resources for tracking electronic records, case files and outgoing document requests.

• 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 OECS 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 OECS 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.

Knowledge/Skills/Abilities:

• 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.

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 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

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.

Location:TALLAHASSEE, FL, US, 32301 TALLAHASSEE, FL, US, 32302 TALLAHASSEE, FL, US, 32303 TALLAHASSEE, FL, US, 32304 TALLAHASSEE, FL, US, 32305 TALLAHASSEE, FL, US, 32307 TALLAHASSEE, FL, US, 32308 TALLAHASSEE, FL, US, 32309 TALLAHASSEE, FL, US, 32310 TALLAHASSEE, FL, US, 32311 TALLAHASSEE, FL, US, 32312 TALLAHASSEE, FL, US, 32316 TALLAHASSEE, FL, US, 32317 TALLAHASSEE, FL, US, 32399

For assistance, call the People First Service Center at [phone] Monday - Friday, 8:00 a.m. to 6:00 p.m., Eastern time. Pursuant to Florida Law, 110.211 F. S., the State of Florida is an EEO employer.