SENIOR DATA BASE ANALYST - 76000155

State of Florida; Tallahassee (FL); Remote; USD 72,000 - 78,000; Full time

Job summary

The State of Florida is seeking a Senior Database Analyst to manage and optimize database environments, ensuring efficient operation and security of systems. This telework-eligible position involves responsibilities like designing database architecture and enhancing performance through analysis and tuning. The ideal candidate will have strong SQL skills and communication abilities to work collaboratively within the Florida Department of Highway Safety and Motor Vehicles.

Benefits

Annual and Sick Leave Package

Nine Paid Holidays

State Health and Life Insurance

Educational Benefits

Contributory Retirement Plan

Qualifications

• Exceptional technical and analytical skills are necessary.
• Effective communication across all organizational levels is required.
• Ability to work independently and address complex issues.

Responsibilities

• Design, implement, and maintain database instances in multiple environments.
• Perform database query analysis and optimization for performance.
• Coordinate stored procedures and maintain database access layers.

Skills

SQL Server database administration

Windows operating systems

T-SQL

Database performance tuning

Stored Procedures

Data replication

Logical database design

Data privacy and protection

Database monitoring

Interpersonal skills

Job description

Press Tab to Move to Skip to Content Link

Select how often (in days) to receive an alert:

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

Requisition No:846507

Agency: Highway Safety and Motor Vehicle

Working Title: SENIOR DATA BASE ANALYST - 76000155

Position Number:76000155

Salary: $72,000.00 - $78,000.00 annually

Division Of Information Systems Administration

Borough Of Enterprise Database Services

*Open Competitive Advertisement*

***This opportunity is telework eligible in the continental United States***

To be considered for this position, applicant responses to qualifying questions must be clearly stated within the employment history. Software systems, actual work experience, and years of employment must be clearly defined, or the application may not be considered for the position.

Contact Person: Coretha Gaymon, 850-617-2225

The Organization

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.

Our Benefits include

• Annual and Sick Leave Package
• Nine Paid Holidays
• State Health and Life Insurance
• Educational Benefits
• Contributory Retirement Plan

To learn more about FLHSMV and why it’s a great place to work, visit our website at:flhsmv.gov/careers .

Duties and Responsibilities

As a Senior Database Analyst (SQL)you 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. 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 and 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.

Knowledge, Skills, and Abilities

• 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.
• 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.
• Operational support skills, including experience with system installations, migrations and upgrades.
• Knowledge of Windows scripting.
• Skill in logical database design and data models.
• Knowledge of the software development lifecycle process.
• Practical experience in monitoring and tuning a database to provide a high availability service.
• Ability to maintain currency on tools, methodologies, and technologies related to data administration.
• Knowledge of data privacy and protection initiatives.
• Strong interpersonal skills to resolve problems in a professional manner.
• An ability to effectively communicate technical data processing information verbally and in writing.
• 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.

Preferred Qualifications

Preference will be given to applicants who have experience:

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

Job Related Requirements

• Normal work hours are Monday through Friday, 8:00 a.m. – 5:00 p.m., although being on-call and working after hours and on weekends may occasionally be required.
• The position you are applying is subject to aLevel 2 background check, along with Criminal Justice Information System (CJIS) clearance, to include a fingerprint-based check of the criminal records of the FBI, as a condition of employment pursuant to Chapter 110.1127, 435 and 943, Florida Statutes. Please note that, since this position requires CJIS clearance, the Department will have access to all an applicant’s criminal and juvenile delinquency records, even those that have been sealed or expunged.
• The elements of the selection process may include a skill assessment and/or oral interview.
• Applicants being considered for employment will be required to submit to a fingerprint-based background investigation, which will include a check of the criminal history records of the FBI.Fingerprints and associated information/biometrics will be retained in the FBI’s Next Generation Identification (NGI) system and fingerprints may continue to be compared against fingerprints submitted to or retained by NGI.
• FLHSMV employees are paid once a month on the last workday of each month. All state employees are required to participate in the direct deposit program pursuant to s. 110.113 Florida Statutes.

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.

Location:

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

For assistance, call the People First Service Center at [phone] Monday - Friday, 8:00 a.m. to 6:00 p.m., Eastern time