The State of Florida
SENIOR DATA BASE ANALYST
The State of Florida, Tallahassee, Florida, us, 32318
Requisition No: 839954
Agency: Highway Safety and Motor Vehicle
Working Title: SENIOR DATA BASE ANALYST - 76000209
Pay Plan: Career Service
Position Number: 76000209
Salary: $72,000.00-$80,000.00 Annually
Posting Closing Date: 11/05/2024
Total Compensation Estimator Tool
Division of Information Systems Administration
Bureau of Enterprise Database Services
Career Service (CS) Opportunity
*Open Competitive Advertisement*
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
Paid Parental Leave
Annual and Sick Leave Package
Nine Paid Holidays
State Health and Life Insurance
Educational Benefits
Contributory Retirement Plan
Duties and Responsibilities
The Florida Department of Highway Safety and Motor Vehicles is seeking a Senior Data Base Analyst (Couchbase/SQL Server/Oracle) to join our Technology team! This position will also be the team lead over our new Couch Base database system, as well as UNIX and Linux systems. As a Senior Data Base Analyst, you will be responsible for the design, implementation, and ongoing maintenance of all database instances and objects on multiple platform environments, including the release process for system and schema changes. You will also perform database query analysis, performance optimization, and coordination of stored procedures while maintaining an appropriate database access layer. Additionally, you will be responsible for database performance, scalability, auditing, replication, and database reporting. 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
Knowledge of the software development lifecycle process.
Knowledge of Windows scripting.
Knowledge of UNIX scripting.
Knowledge of LINUX systems.
Knowledge of Couchbase systems.
Knowledge of data privacy and protection initiatives.
Skills in MS SQL Server database administration.
Skills in Oracle 10g/11g/12c/19c database administration.
Skills in working in Windows operating systems.
Skills as a MS SQL developer.
Skills in creating procedures.
Skills in supporting SQL Server data replication and validation.
Skills with MS SQL software installation, patching, and upgrading.
Skills in logical database design and data models.
Ability to work independently to resolve complex issues.
Ability to effectively diagnose, isolate, and resolve complex problems pertaining to data infrastructure.
Ability to write SQL, Stored Procedures, Functions, and Database Triggers.
Ability to tune SQL and TSQL performance.
Ability to maintain currency on tools, methodologies, and technologies related to data administration.
Ability to effectively communicate technical data processing information verbally and in writing.
Ability to work well in a team environment, and to establish and maintain effective working relationships with others.
Ability to receive and give constructive criticism and maintain effective working relationships with others.
Strong interpersonal skills to resolve problems in a professional manner.
Operational support skills, including experience with system installations, migrations, and upgrades.
Practical experience in monitoring and tuning a database to provide a high availability service.
Preferred Qualifications
Preference will be given to applicants with the following:
Professional work experience in database development, design, and administration.
Professional experience developing in T-SQL, PL/SQL, Linux, and UNIX languages.
Professional work experience assisting application/web development teams and business area customers in the design and development of solutions.
Experience with Data Warehousing and concepts.
Job Related Requirements
This position includes a regularly assigned (approximately one week a month) 24-7 on-call requirement.
The position you are applying for is subject to a Level 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.
General Information
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.
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).
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.
#J-18808-Ljbffr
Agency: Highway Safety and Motor Vehicle
Working Title: SENIOR DATA BASE ANALYST - 76000209
Pay Plan: Career Service
Position Number: 76000209
Salary: $72,000.00-$80,000.00 Annually
Posting Closing Date: 11/05/2024
Total Compensation Estimator Tool
Division of Information Systems Administration
Bureau of Enterprise Database Services
Career Service (CS) Opportunity
*Open Competitive Advertisement*
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
Paid Parental Leave
Annual and Sick Leave Package
Nine Paid Holidays
State Health and Life Insurance
Educational Benefits
Contributory Retirement Plan
Duties and Responsibilities
The Florida Department of Highway Safety and Motor Vehicles is seeking a Senior Data Base Analyst (Couchbase/SQL Server/Oracle) to join our Technology team! This position will also be the team lead over our new Couch Base database system, as well as UNIX and Linux systems. As a Senior Data Base Analyst, you will be responsible for the design, implementation, and ongoing maintenance of all database instances and objects on multiple platform environments, including the release process for system and schema changes. You will also perform database query analysis, performance optimization, and coordination of stored procedures while maintaining an appropriate database access layer. Additionally, you will be responsible for database performance, scalability, auditing, replication, and database reporting. 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
Knowledge of the software development lifecycle process.
Knowledge of Windows scripting.
Knowledge of UNIX scripting.
Knowledge of LINUX systems.
Knowledge of Couchbase systems.
Knowledge of data privacy and protection initiatives.
Skills in MS SQL Server database administration.
Skills in Oracle 10g/11g/12c/19c database administration.
Skills in working in Windows operating systems.
Skills as a MS SQL developer.
Skills in creating procedures.
Skills in supporting SQL Server data replication and validation.
Skills with MS SQL software installation, patching, and upgrading.
Skills in logical database design and data models.
Ability to work independently to resolve complex issues.
Ability to effectively diagnose, isolate, and resolve complex problems pertaining to data infrastructure.
Ability to write SQL, Stored Procedures, Functions, and Database Triggers.
Ability to tune SQL and TSQL performance.
Ability to maintain currency on tools, methodologies, and technologies related to data administration.
Ability to effectively communicate technical data processing information verbally and in writing.
Ability to work well in a team environment, and to establish and maintain effective working relationships with others.
Ability to receive and give constructive criticism and maintain effective working relationships with others.
Strong interpersonal skills to resolve problems in a professional manner.
Operational support skills, including experience with system installations, migrations, and upgrades.
Practical experience in monitoring and tuning a database to provide a high availability service.
Preferred Qualifications
Preference will be given to applicants with the following:
Professional work experience in database development, design, and administration.
Professional experience developing in T-SQL, PL/SQL, Linux, and UNIX languages.
Professional work experience assisting application/web development teams and business area customers in the design and development of solutions.
Experience with Data Warehousing and concepts.
Job Related Requirements
This position includes a regularly assigned (approximately one week a month) 24-7 on-call requirement.
The position you are applying for is subject to a Level 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.
General Information
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.
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).
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.
#J-18808-Ljbffr