Requisition No: 482761
Agency: Department of State
Working Title: DOS - DATA BASE ANALYST - 45001014
Position Number: 45001014
Salary: $38, 659.92
Posting Closing Date: 11/29/2021
Department of State
Database Analyst
Division of Administrative Services
Bureau of Departmental Information Systems
Open Competitive
Minimum Qualifications:
Responses to qualifying questions must be clearly supported in your employment history.
Duties and Responsibilities:
Performs SQL Server and Oracle database administration on premise and in cloud environments. Performs requirements gathering and analysis, business procedure analysis and recommendation, data dictionary creation, development of conceptual and logical data models, database design and creation, database migrations, database schema object creation and modification, testing and deployment of applications, and functions in support of the Database and DevOps teams as part of the Software Development Life Cycle for each system under the direction of senior database staff. Completes documentation of existing and new database designs as directed by senior database staff. Completes as directed, or assists senior database staff in maintaining requisite documentation on database systems and processes as well as project engagements. Develop, modify, and tune PL/SQL packages, and T-SQL queries. Work closely with the Systems, DevOps, and Project teams to continuously improve the design, performance, reliability, scalability, security and architecture of the SQL and Oracle databases.
Assists senior database staff, or, if possible, functions autonomously for the following: performing database monitoring and tuning; diagnosing database performance issues; researching, proposing and implementing solutions; analyzing query execution plans and index utilization to optimize performance; performing database backup validations and restores as required; performing data exports and imports as required; cloning production databases for refresh of development environments as requested; managing jobs and job schedulers as needed; automating common management tasks using scripting or programming language; enforcing database security and confidentiality policies for user and data administration.
Supports database and server team peers: assists with maintaining change logs for SQL, database configuration updates, and changes for all database servers. Maintains change logs for user accounts and ensures security standards are implemented. Assists, or if possible operates autonomously, in providing monthly database performance reports and generating baseline statistics. Analyzes database systems performance, capacity trends, and availability to ensure SLA compliance. Performs scheduled maintenance and support release deployment activities after hours. Provides 24x7 team support for critical production systems. Receives basic cross-training to serve as backup to the Oracle and SQL Server systems administrators.
Performs other related duties as assigned.
Knowledge/Skills/Abilities:
Knowledge and skill in data analysis techniques, routine database administration, requirements gathering and analysis, documentation, data modelling, logical and physical database design, software development fundamentals and the software development life cycle, database security management, database performance tuning, query performance tuning and optimization, backup and restore scenarios, database upgrade and patching, diagnostics and troubleshooting, PL/SQL packages and T-SQL query, utilizing Oracle, SQL Server and Azure SQL databases.
Critical thinker with strong time-management, interpersonal, and communication skills.
This position is designated to serve in an on-call status. When activated, the incumbent must respond to the call within 15 minutes and if necessary, arrive on-site within 1 hr.
CRIMINAL BACKGROUND CHECKS: A Level 2 criminal background check is a condition of employment. If selected for this position, you must provide your fingerprints. We will send your fingerprints to the Florida Department of Law Enforcement and the Federal Bureau of Investigation for a criminal background check.
IMPORTANT NOTICES:
We are committed to enhancing our workforce through the employment of Veterans, individuals with disabilities and seek qualified candidates from diverse cultures and backgrounds, abilities, skills, and talents to join our inclusive workforce.
Male applicants born on or after January 1, 1960, will not be eligible for hire or promotion unless they are registered with the Selective Services System (SSS) before their 26th birthday, or have a Letter of Registration Exemption from the SSS. For more information, please visit the SSS website:
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 . All documentation is due by the close of the vacancy announcement.
Agency: Department of State
Working Title: DOS - DATA BASE ANALYST - 45001014
Position Number: 45001014
Salary: $38, 659.92
Posting Closing Date: 11/29/2021
Department of State
Database Analyst
Division of Administrative Services
Bureau of Departmental Information Systems
Open Competitive
Minimum Qualifications:
- A high school diploma or equivalent
- Two (2) years’ experience as a database administrator
- Two (2) years’ experience PL/SQL programming
Responses to qualifying questions must be clearly supported in your employment history.
Duties and Responsibilities:
Performs SQL Server and Oracle database administration on premise and in cloud environments. Performs requirements gathering and analysis, business procedure analysis and recommendation, data dictionary creation, development of conceptual and logical data models, database design and creation, database migrations, database schema object creation and modification, testing and deployment of applications, and functions in support of the Database and DevOps teams as part of the Software Development Life Cycle for each system under the direction of senior database staff. Completes documentation of existing and new database designs as directed by senior database staff. Completes as directed, or assists senior database staff in maintaining requisite documentation on database systems and processes as well as project engagements. Develop, modify, and tune PL/SQL packages, and T-SQL queries. Work closely with the Systems, DevOps, and Project teams to continuously improve the design, performance, reliability, scalability, security and architecture of the SQL and Oracle databases.
Assists senior database staff, or, if possible, functions autonomously for the following: performing database monitoring and tuning; diagnosing database performance issues; researching, proposing and implementing solutions; analyzing query execution plans and index utilization to optimize performance; performing database backup validations and restores as required; performing data exports and imports as required; cloning production databases for refresh of development environments as requested; managing jobs and job schedulers as needed; automating common management tasks using scripting or programming language; enforcing database security and confidentiality policies for user and data administration.
Supports database and server team peers: assists with maintaining change logs for SQL, database configuration updates, and changes for all database servers. Maintains change logs for user accounts and ensures security standards are implemented. Assists, or if possible operates autonomously, in providing monthly database performance reports and generating baseline statistics. Analyzes database systems performance, capacity trends, and availability to ensure SLA compliance. Performs scheduled maintenance and support release deployment activities after hours. Provides 24x7 team support for critical production systems. Receives basic cross-training to serve as backup to the Oracle and SQL Server systems administrators.
Performs other related duties as assigned.
Knowledge/Skills/Abilities:
Knowledge and skill in data analysis techniques, routine database administration, requirements gathering and analysis, documentation, data modelling, logical and physical database design, software development fundamentals and the software development life cycle, database security management, database performance tuning, query performance tuning and optimization, backup and restore scenarios, database upgrade and patching, diagnostics and troubleshooting, PL/SQL packages and T-SQL query, utilizing Oracle, SQL Server and Azure SQL databases.
Critical thinker with strong time-management, interpersonal, and communication skills.
This position is designated to serve in an on-call status. When activated, the incumbent must respond to the call within 15 minutes and if necessary, arrive on-site within 1 hr.
CRIMINAL BACKGROUND CHECKS: A Level 2 criminal background check is a condition of employment. If selected for this position, you must provide your fingerprints. We will send your fingerprints to the Florida Department of Law Enforcement and the Federal Bureau of Investigation for a criminal background check.
IMPORTANT NOTICES:
We are committed to enhancing our workforce through the employment of Veterans, individuals with disabilities and seek qualified candidates from diverse cultures and backgrounds, abilities, skills, and talents to join our inclusive workforce.
Male applicants born on or after January 1, 1960, will not be eligible for hire or promotion unless they are registered with the Selective Services System (SSS) before their 26th birthday, or have a Letter of Registration Exemption from the SSS. For more information, please visit the SSS website:
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 . All documentation is due by the close of the vacancy announcement.