819897-Commerce-SYSTEM PROJECT CONSULTANT - 40000386
Date: Feb 7, 2024
Location:
TALLAHASSEE, FL, US, 32399
The State Personnel System is an E-Verify employer. For more information click on our E-Verify Website (http://www.dms.myflorida.com/workforce_operations/human_resource_management/for_job_applicants/e_verify) .
Requisition No: 819897
Agency: Commerce
Working Title: 819897-Commerce-SYSTEM PROJECT CONSULTANT - 40000386
Pay Plan: Career Service
Position Number: 40000386
Salary: $65,000 - $83,000
Posting Closing Date: 03/08/2024
Total Compensation Estimator Tool (https://compcalculator.myflorida.com/)
Our Organization and Mission:
Florida Commerce 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 Florida Commerce for positions that fit their skill sets.
Florida Commerce 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 administration of Department’s SQL database servers.
The Difference You Will Make:
Florida Commerce 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:
Florida Commerce 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 Florida Commerce’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
O’Reilly
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. Florida Commerce’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!
State Group Insurance coverage options+(health, life, dental, vision, and other supplemental option)
Retirement plan options, including employer contributions (www.myfrs.com)
Nine paid holidays and a Personal Holiday each year
Annual and Sick Leave Benefits
Student Loan Forgiveness Program (Eligibility required)
Flexible Spending Accounts
Tuition Fee Waivers (Accepted by major Florida colleges/universities)
Ongoing comprehensive training provided
Career Growth
Highly skilled, professional environment 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 as replace failed system components and appling 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 managment 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 cloud computing and administration as applicable to database management.
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.
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 clickinghere (http://www.dms.myflorida.com/content/download/97612/566545) . All documentation is due by the close of the vacancy announcement.
Nearest Major Market:Tallahassee