DATA BASE ADMINISTRATOR - SES - 42000576

DATA BASE ADMINISTRATOR - SES - 42000576 Date: Mar 29, 2024 Location: TALLAHASSEE, FL, US, 32302 TALLAHASSEE, FL, US, 32301 TALLAHASSEE, FL, US, 32303 TALLAHASSEE, FL, US, 32304 TALLAHASSEE, FL, US, 32305 TALLAHASSEE, FL, US, 32308 TALLAHASSEE, FL, US, 32309 TALLAHASSEE, FL, US, 32310 TALLAHASSEE, FL, US, 32311 TALLAHASSEE, FL, US, 32312 TALLAHASSEE, FL, US, 32316 TALLAHASSEE, FL, US, 32317 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/workforceoperations/humanresourcemanagement/forjobapplicants/everify) .Requisition No: 826337 Agency: Agriculture and Consumer ServicesWorking Title: DATA BASE ADMINISTRATOR - SES - 42000576Pay Plan: SESPosition Number: 42000576 Salary: $51,320.27 - $93,000.18 Posting Closing Date: 04/08/2024 Total Compensation Estimator Tool (https://compcalculator.myflorida.com/) DATA BASE ADMINISTRATOR-SES FLORIDA DEPARTMENT OF AGRICULTURE AND CONSUMER SERVICES OFFICE OF AGRICULTURE TECHNOLOGY SERVICES OPEN COMPETITIVE OPPORTUNITY CONTACT: Shelley Harden, 850-245-1096 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. Qualifiedindividuals 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.

Assess 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 assess 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 PowerPoint.

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 www.myfrs.com;)

Flexible Spending Accounts;

Tuition waivers;

And more!

For a complete list of benefits, visitwww.mybenefits.myflorida.com.

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 (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.Nearest Major Market:Tallahassee