DOS - DATA BASE ADMINISTRATOR

This position serves as the Bureau of Departmental Information Systems (BDIS) Lead Database Administrator and in this capacity maintains all relational databases for the Department, including the Florida Voter Registration System (FVRS) database, the Florida Corporate Registry, and manages the activities of the Department’s database team.

Provides supervisory responsibilities and direction to staff and is responsible for staff training, motivation, evaluation, and effective use of staff resources. Coordinates technical support priorities and determines the allocation of available resources.

Proposes and implement failover strategies. Performs or tasks database patches. Performs or tasks database upgrades and implement new features. Schedules or tasks the monitoring of successful database back-ups. Performs or tasks database restores as required. Creates or assigns new database environments to be created as needed. Performs or tasks data exports and imports as required.

Responsible for tasking staff who conduct low level monitoring, access control, and performance of FDOS data bases and the hardware it resides upon; overall solution configuration; database and related systems architecture, availability planning, including Disaster Recovery; direct reports monitor all database environments for integrity and efficiency; staff also monitor monthly solution capacity planning.

Performs or tasks database tuning as needed to address performance issues; Conducts or tasks proactive maintenance; proposes or tasks issue resolution; Responsible for analysis and query execution plans and index utilization, either tasked or assigned. Assists in the development of new applications, including system design, creation of tables, and setting performance metrics; analyzes and develop stored procedures, if applicable. 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. Provide monthly database performance reports. Generate baseline statistics and analyze database performance over time.

• At least two years of experience in a database technology support environment and at least four (4) demonstrable years of experience as an SQL Server database administrator in a professional environment, college courses do not count toward the SQL Server experience.

PREFERENCES:

• Some familiarity with Oracle database administration.

• Demonstrable experience with database system administration.

• At least four (4) years as a database administration in a State of Florida agency.

• At least four (4) years in a supervisory position in a State of Florida agency.

• Experience with Microsoft Azure and DevOps.

• A bachelor’s degree from an accredited college or university in computer science or management information systems, * Knowledge of data analysis techniques, database structures, and database theories.
• Knowledge of principles, practices and techniques of computer programming and system design.
• Knowledge of SQL Server databases.
• Familiarity of Oracle databases.
• Knowledge of database server administration.
• Ability to process information logically and analytically
• Ability to design systems logic and/or process information logically and analytically
• 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 establish and maintain effective working relationships with others.