827461 - SYSTEM PROJECT CONSULTANT - 40000386

Requisition No: 827461 

Agency: Commerce

Working Title: 827461 - SYSTEM PROJECT CONSULTANT - 40000386

 Pay Plan: Career Service

Position Number: 40000386 

Salary:  $65,000 - $83,000 

Posting Closing Date: 05/03/2024 

Total Compensation Estimator Tool

Our Organization and Mission:

FloridaCommerce works across the state to support Florida’s economy, robust and talented workforce, and our local communities. We are dedicated to making a stronger and more resilient Florida, so our businesses, communities, and workforce are better prepared to withstand future economic slowdowns and natural disasters.

In collaboration with our partners, we salute our nation's veterans and are honored to have the opportunity to support them and their family members by encouraging them to apply at FloridaCommerce for positions that fit their sill sets.

FloridaCommerce is an Equal Opportunity Employer/Program. Auxiliary aids and services are available upon request to individuals with disabilities.  (TTY/TDD 1-800-955-8771 or the Florida Relay Service – 711.)

Let our mission become yours. To find out more about us, click on the link: http://www.floridajobs.org/

The Work You Will Do:

This position serves as a System Project Consultant in the Division of Information Technology (IT). This position is responsible for the administration of the Department’s SQL database servers.

The Difference You Will Make:

FloridaCommerce is a fast-paced work environment in which critical thinking and commitment to serving the citizens of Florida is vital to the Agency’s vision. As a member of the Division of Information Technology, you will help to support the Agency goals through providing affordable, reliable, effective, and secure technology services.

How You Will Grow:

FloridaCommerce encourages its employees to constantly innovate and seek efficiencies.  Trainings are made available throughout the year and on request with the Office of Training and Development within the Bureau of Human Resource Management. In accordance with our Vision and Mission, the employee:

• Furthers Florida’s economic vision by providing support that enhances the economy and develops, safe, and healthy communities.
• Meets customer/client expectations with an emphasis on responsiveness, quality, quantity, and timeliness of work.
• Provides information clearly, accurately, and succinctly; and exhibits good listening skills.
• Works collaboratively to optimize the effectiveness of FloridaCommerce’s available resources and tools.
• Uses knowledge acquired through education, training, or experience to complete tasks.

The Division of Information Technology provides its staff with access to resources and trainings provided by the following:

• Pluralsight
• CBT Nuggets
• Gartner
• Microsoft

These expectations are for all our employees, and you will be expected to model these as a leader.  We believe in supporting and encouraging you as you take on important and often complex projects while offering you the opportunity to gain valuable experience.  

Where You Will Work:   

This position requires both remote and onsite work or if preferred 100% onsite work.

Tallahassee is Florida’s Capital City and continues to grow by attracting development and new businesses. Tallahassee is a mid-sized city in the heart of Florida’s Big Bend.  FloridaCommerce’s main office is in Downtown Tallahassee, the political epicenter that draws in visitors each year to visit the state’s Capitol. Each spring, the legislative session opens, and people pour in to see the Florida Legislature perform business and approve the state’s annual budget. Being in Tallahassee will guarantee you a unique experience, professional growth, entertainment, and culture. Tallahassee is:

• Known for its beautiful parks, rolling hills and oak trees, canopied roads, hotels, dining, museums, arts, music, and natural resources (https://talgov.com/ )
• Home to major college campuses, Florida State University (FSU), Florida A & M University (FAMU) and Tallahassee Community College (TCC).
• Approximately 22 miles from the nearest beach ( https://choosetallahassee.com/beaches-near-tallahassee/ )

• Within a state having no state income tax for residents of Florida

WORKING FOR THE STATE OF FLORIDA HAS BENEFITS!

For a more complete list of benefits, visit www.mybenefits.myflorida.com.

* We care about the success of our employees.

* We are always improving our technology, our tools, our customer’s experiences, and ourselves.

*A rewarding experience for reliable, compassionate, and professional employees.

Pay: $65,000 - $83,000

Your Specific Responsibilities:

Manages the Department's SQL database servers primarily in Azure Cloud environment, that involves: Installing and configuring SQL server.  Monitoring and performance tuning; database back-up and recovery; data storage capacity planning; data security management; data transferring and converting; system hardware and software maintenance (such a replace failed system components and applying the latest service pack or patch); provide technical support to the application developers; provide secondary tier support to the end users.  Assist database designers by providing information on how different design features can benefit both system and users.  Analyze the data in the database and how that data can be accessed optimally.

• Responsible for the efficiency and effectiveness of delivering the services mentioned above.
• Responsible for the timely maintenance and/or replacement of the hardware, software, processes and procedures, including coordination through the state datacenter provider, required to deliver these services. 
• Advises and guides the Information Technology Division toward best practices of database management in order to maximize customer satisfaction.
• Coordinates/assists the analysis, design, development, and implementation of the comprehensive IT systems.  Provides technical support, troubleshoots the Department's Internet/Intranet database backends.
• Assists in the planning, design/modification and enhancement of new and existing database systems in the Department, maintaining the systems up to the latest version release.
• Researches and evaluates new information technologies (hardware/software), including training on new database and operating systems. Provides technical advice to upper management to enhance performance and stability of existing database systems.
• Performs related work as assigned.

Required Knowledge, Skills, and Abilities:

• Knowledge of performance tuning including code review, ability to perform monitoring, analysis and troubleshooting of the database environment and the applications that connect to it.
• Knowledge of cloud computing and administration as applicable to database management.
• Skill with using Microsoft SQL monitoring tools.
• Skill in administering Microsoft SQL 2016, 2017, 2019 and 2022.
• Skill with Microsoft SQL reporting services.
• Skill with Microsoft SQL server integration service.
• Knowledge of ITIL concepts.

Qualifications:

As a condition of pre-employment eligibility, a Level 2 security background screening is required, which consists of fingerprinting and a check of local, state, and national law enforcement records. 

Minimum:

• Must be available for on-call as required.

Preferred:

• Experience with Azure SQL database administration.
• Experience with SQL Server Cloud Migration
• Possess Cloud certifications in areas of database management and infrastructure administration.
• Experience with copying, backing up, and restoring databases.
• Experience with a Windows clustered SQL environment
• Experience with SQL performance tuning
• Experience with SQL Reporting Services
• Experience in the administration of Windows Server 2016 or higher.

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.