Location: Tallahassee, FL
Company: State Of Florida
OF AGRICULTURE TECHNOLOGY SERVICES OPEN COMPETITIVE OPPORTUNITY CONTACT: Shelley Harden, 850-245-xyz X MINIMUM REQUIREMENTS: A bachelor's degree from an accredited college or university and five (5) years of experience in computer systems analysis and/or computer programming, three (3) years of which must have been in data base design or data base administration; or A master's degree from an accredited college or university in management information systems or in one of the computer sciences and four (4) years of experience in computer systems analysis and/or computer programming, three (3) years of which must have been in data base design or data base administration; or A doctorate from an
accredited college or university in management information systems or in one of the computer sciences and three (3) years of experience in data base design or data base administration; or Seven years of experience in computer systems and analysis and/or computer programming, three years of which must have been in data base design and either (1) completion of a 720 classroom hour program of study from a vocational/technical school or accredited community college in an area of data processing (excluding data entry), or (2) 60 semester or 90 quarter hours of college course work from an accredited institution which includes four courses in computer science or management information systems.
Experience in computer systems analysis and/or computer programming can substitute on a year-for-year basis for the required college education.
Completion of a one-year program of study from a vocational/technical school in an area of data processing (excluding data entry) can substitute for one year of computer systems analysis and/or computer programming experience. Requires possession of a valid Class E driver license. ATTENTION CANDIDATES To be considered for a position with the Florida Department of Agriculture and Consumer Services: All fields in the Candidate Profile must be completed (an attached resume is not a substitution for the information required on the candidate profile).
Work history, duties and responsibilities, hours worked, supervisor, and formal education fields, etc. must be filled out to determine qualifications for this position. Responses to Qualifying Questions must be verifiable in the Candidate Profile. The Florida Department of Agriculture and Consumer Services values and supports employment of individuals with disabilities. Qualified individuals with disabilities are encouraged to apply. ADDITIONAL REQUIREMENTS: The position may be activated to support the Emergency Support Function (ESF) and respond to emergencies, including natural disasters or other types of incidents, as needed.
NOTES: Successful applicant must pass a background screening, including fingerprinting, as a condition of employment. The incumbent of this position will have access to Criminal Justice Information and must meet the requirements of the FBI Criminal Justice Information Services (CJIS) Security Policy. JOB DUTIES: This position is responsible for the management of the Florida Department of Agriculture and Consumer Services (FDACS) Oracle and SQL Server enterprise database environment. This position is also responsible for leading a team that supports the development, administration, testing, and installation of database software and hardware.
Responsibilities also include information assurance, maintaining database policies and procedures, and ensuring data confidentiality, integrity, and availability. Database Development, Management, and Maintenance Maintain the overall integrity and quality of the FDACS databases, including regular data improvement and hygiene, enforcement of database business processes and management of code values, business rules and other logical/physical functions of the databases.
Optimize the use of the databases across the organization by staying current on upcoming enhancements to functionality and guiding staff in the appropriate use of the existing functionality. Provide support and training in the use of the database environment, including orientation for all new staff and specialized training in response to changing roles, business processes and database functionality. Work with technical teams and help desk to provide technical assistance to users and troubleshoot and resolve application and database-related problems. Manage the relationship with software vendors, escalate issues that require immediate resolution, and advocating for fixes/patches to the applications and software when appropriate.
Conduct diagnostic tests and evaluate performance metrics Oversee deployments to production databases to ensure industry best practices, agency policies, and procedures are adhered to. Develop and ensure Extraction, Transformation and Loading (ETL) standards including tools, methods, and documentation. Develop data and metadata policies and procedures for structural design and development to build, maintain and leverage the data model, ensuring integration with agency data standards.
Ensuring that data continues to be managed as a critical asset to the agency along with ensuring data quality so that it is reliable, re-usable, and defendable. Data Management Strategy and Planning Responsible for Logical and Physical Enterprise Data Models, Enterprise Data Dictionary, and Enterprise Metadata. Oversees the design, evaluation, selection, implementation, and support of major databases and metadata structures. Provides extensive technical, and strategic advice and guidance at the highest level to senior managers and technical resources in the creation and implementation of new data architecture, standards, and databases.
Provides a strategic level of technical leadership to the database administration and programming groups, Information Technology teams, and the enterprise. Engage FDACS Business and Technology teams and Business Analytic stakeholders to understand business and operational data needs. Implement and maintain a data warehousing architecture strategy and design an incremental roadmap that overcomes current challenges and appropriately meets current and future analytic needs. Plan and align current and future data warehousing capabilities to support enterprise and business priorities and initiatives and address the resulting capability gaps/needs.
Evaluate backup procedures and ensure that they are performed daily. Make recommendations to management on the selection of database management systems and related software. backss future information requirements to develop long-range, comprehensive database plans. Perform related work as required including, but not limited to, adherence to the policies and procedures of the department’s Information Resource Security Program and allocates time as requested for Disaster Recovery activities.
Perform and document performance measurement activities and recommend system re-configuration to effect improved database performance. Works with the Business users and Business Analysts to understand and document data requirements. Communicate Data Architecture to Business users and management. Facilitate communication and teamwork related to data architecture and data models. Directs personnel activities for assigned sections. Develop and maintain technical standards, policies and procedures, and techniques for guidance of data center personnel Develops, reviews, and approves position descriptions.
Conducts interviews and makes hiring recommendations. Develop and monitor training plans. Develops, reviews, and communicates work performance expectations. Monitor and evaluate member performance and maintain working files of subordinate performance. Prepares, communicates, and reviews formal performance evaluations. Recommends approval of overtime Meets with management to provide status updates regarding team and projects. Contract Management Manages contracts and agreements with state, private agencies, and other organizations of any assigned programs in an efficient and accountable manner.
Evaluates data processing project proposals and backss project feasibility. Monitors expenditures of the department for information technology. Assists in developing, planning, organizing, and administering policies and procedures for the department to ensure strategic data processing objectives are met. Responsible for performing other related duties as required. Responsible and accountable for managing budget/dollars/resources (staff, vehicles, computers, cell phones, etc. ) of any assigned programs in an efficient and accountable manner. Responsible for ensuring that assigned program areas have operational procedures and processes which result in accountability and compliance with division and department policies and procedures.
KNOWLEDGE, SKILLS, AND ABILITIES: Experience in Microsoft SQL Server 2016 or higher database administration, or Oracle 12c or higher database administration Ability to work independently and collaboratively to accomplish responsibilities, goals, and projects. Ability to manage multiple projects simultaneously with a high degree of accuracy and attention to detail. Ability to troubleshoot hardware and software problems is highly desirable.
Ability to work with both technical and non-technical users. Ability to deliver excellent written and oral communication skills with the Knowledge of the principles of database management and business process workflow. Knowledge of database backup, recovery, upgrades, and patching. Knowledge of data/information security, privacy, and protection initiatives Knowledge of ETL, data warehousing, reporting and analytics Knowledge of data encryption techniques and industry standards. Strong analytical and problem-solving skills. Skill in schema creation, schema migration, data conversion, performance monitoring/tuning, SQL/PL-SQL, T-SQL, Functions, packages and triggers, and stored procedures.
Skill in database administration, design, deployment, and management Skill in the use of Microsoft Office Professional with advanced skills in Word, Excel, and Power Point. Skill in the use of data modeling tools such as Erwin Data Modeler, Oracle SQL Developer, TOAD Data Modeler, and SQL Server Management Studio to name a few. The Benefits of Working for the State of Florida Working for the State of Florida is more than a paycheck. The State’s total compensation package for employees features a highly competitive set of employee benefits including: Annual and Sick Leave benefits; Nine paid holidays and one Personal holiday each year; State Group Insurance coverage options, including health, life, dental, vision and other supplemental insurance options; Retirement plan options, including employer contributions (For more information, please visit ; ) Flexible Spending Accounts; Tuition waivers; And more!
For a complete list of benefits, visit www. mybenefits.. For an estimate of the total compensation package for this position, please visit the “Total Compensation Estimator Tool” located above under the “Posting Closing Date.
” SPECIAL NOTES: 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 -xyz X). 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.
IT jobs refer to positions within the Information Technology sector, where professionals focus on computer-based systems. These roles can range from software development, network administration, and cybersecurity to data analysis and IT support. IT jobs often feature continuous learning due to the fast-paced nature of tech advancements. Additionally, they may offer flexibility with options for remote work and have a significant emphasis on problem-solving and innovation. As technology becomes increasingly integral to all industries, IT jobs are in high demand and often offer competitive salaries.
IT jobs refer to positions within the Information Technology sector, which encompasses a broad range of roles focused on the development, implementation, and maintenance of technology systems. These positions often require skills in programming, network administration, cybersecurity, and data analysis. IT professionals work with computer hardware, software applications, and algorithms. Key characteristics of IT jobs include a focus on problem-solving, continuous learning to keep up with technological advancements, and the ability to adapt to the evolving digital landscape. Many IT roles also support remote work, given the digital nature of the tasks.
IT jobs refer to employment within the field of information technology, an industry centered on the creation, maintenance, and support of computer systems and networks. Characteristically, these roles demand technical expertise in areas such as software development, cybersecurity, and data analysis. IT professionals are typically required to quickly adapt to new technologies and solve complex problems, often working in dynamic, fast-paced environments. The sector is known for its diverse career opportunities and has become essential across virtually all business sectors, reflecting the critical role technology plays in modern society.
IT jobs refer to employment within the field of information technology, an industry centered on the creation, maintenance, and support of computer systems and networks. Characteristically, these roles demand technical expertise in areas such as software development, cybersecurity, and data analysis. IT professionals are typically required to quickly adapt to new technologies and solve complex problems, often working in dynamic, fast-paced environments. The sector is known for its diverse career opportunities and has become essential across virtually all business sectors, reflecting the critical role technology plays in modern society.
