SENIOR DATA BASE ANALYST - 76003034

State of Florida•Tallahassee, FL

2d•Onsite

About The Position

The Florida Department of Highway Safety and Motor Vehicles (FLHSMV) provides highway safety and security through excellence in service, education, and enforcement. With a workforce of approximately 4,500 employees throughout the state, the Department is leading the way to A Safer Florida through the efficient and professional execution of its core mission: the issuance of driver licenses, vehicle tags and titles, and operation of the Florida Highway Patrol. As a Senior Database Analyst (SQL) will be responsible for the design, implementation, patching, and ongoing maintenance of all database instances on multiple environments, including the release process for system and schema changes. The Senior Database Analyst will also perform database query analysis, performance, and optimization and coordination of stored procedures and maintaining an appropriate database access layer. In addition, the Senior Database Analyst is responsible for database performance, scalability, replication, and database reporting. The Senior Database Analyst (SQL) reports to the SQL Services Database Administrator. This position requires exceptional technical, analytical and collaboration skills. The successful candidate must have the ability to communicate effectively, precisely, and accurately across all levels of the organization.

Requirements

Knowledge of SQL Server backup/recovery technologies and processes.
Knowledge of SQL Server Replication practices and processes.
Knowledge of SQL Server Clusters and Failover methodologies.
Knowledge of data privacy and protection initiatives.
Knowledge of Windows scripting.
Knowledge of the software development lifecycle process.
Skill in SQL Server database administration.
Skill in working in Windows operating systems.
Skill as a SQL developer.
Skill in creating stored procedures.
Skill in supporting SQL Server data replication and validation.
Skill with SQL Server software installation, patching, and upgrading.
Skill in logical database design and data models.
Ability to work independently and to resolve complex issues.
Ability to effectively diagnose, isolate, and resolve complex problems pertaining to server and data infrastructure.
Ability to write T- SQL, Stored Procedures, Functions, and Database Triggers.
Ability to Tune SQL and T-SQL queries for performance.
Ability to effectively communicate technical data processing information verbally and in writing.
Ability to maintain currency on tools, methodologies, and technologies related to data administration.
Operational support skills, including experience with system installations, migrations and upgrades.
Practical experience in monitoring and tuning a database to provide a high availability service.
Strong interpersonal skills to resolve problems in a professional manner.
System/Application/Database development, design and/or administration.
Developing in T-SQL or PL/SQL languages.
Assisting application/web development teams and business area customers in the design, deployment, and development of solutions.
Must have the ability to communicate effectively, precisely, and accurately across all levels of the organization.

Responsibilities

Design, implementation, patching, and ongoing maintenance of all database instances on multiple environments.
Manage the release process for system and schema changes.
Perform database query analysis, performance, and optimization.
Coordinate stored procedures and maintain an appropriate database access layer.
Manage database performance, scalability, replication, and database reporting.