SENIOR DATA BASE ANALYST

Company: State of Florida
Location: Tallahassee
Posted on: March 16, 2023

Job Description:

Requisition No:796827Agency: Department of Law EnforcementWorking Title: SENIOR DATA BASE ANALYST - 71002310Position Number:71002310Salary: $45,848.06Posting Closing Date: 03/20/2023SENIOR DATABASE ANALYSTINFORMATION TECHNOLOGY SERVICESPRODUCTION SYSTEMS SERVICES/DATABASE & CONTENT**Open-Competitive Opportunity**POSITION SUMMARY: This position is located in the Bureau of Production Systems Services Database & Content section. This is a full-time position that works closely with Linux Administrator and Windows Administrator to ensure the availability, integrity, and security of the Department mission critical database systems. This position requires the ability to develop and maintain utility programs, scripts and routines for management of database systems on Red Hat Linux and Windows server systems. The position also requires excellent facilitation and customer service skills.DUTIES & RESPONSIBILITIES:Specific duties include:Management and administration of Oracle, Microsoft SQL Server and MySQL database software and databases;Installing, configuring, patching and maintaining Oracle, Microsoft SQL Server and MySQL database software and databases;Ensuring the availability, integrity and security of database data; Providing database backup and recovery services;Developing and maintaining utility programs, scripts and routines for management of database systems on Red Hat LINUX and Windows server systems;Providing network support services for database-related network technologies and adapters such as TNS, ODBC, JDBC, OLEDB and .Net; andAssisting in the establishment and enforcement of database administration policies, standards and procedures.To be considered as a potential candidate, you must meet the minimum qualifications(s) listed below. Degrees must be from an accredited college or university as recognized by the U.S. Department of Education.MINIMUM QUALIFICATIONS:A bachelor's degree from an accredited college or university and two years of experience in computer systems analysis or computer programming; or A bachelor s degree from an accredited college or university in management information systems or in one of the computer sciences and one year of experience in computer systems analysis or computer programming; or A master's degree from an accredited college or university in management information systems or in one of the computer sciences; orA high school diploma or its equivalent and six years of experience in computer systems analysis or computer programming; orAny combination of education or experience, as described above, for a total of six years.Completion of a 720-classroom hour program of study from a vocational/technical school or accredited community college in an area of data processing* can substitute for oneyear of the required education or experience.Completion of a one-year program of study from a vocational/technical school in an area of data processing* can substitute for one year of the required education or experience. Note: 30 semester hours, or equivalent, of course work from an accredited college or university is equivalent to one year of experience.*Data entry excluded in data processing experience.KNOWLEDGE, SKILLS & ABILITIES:Knowledge of Oracle and MySQL data base management technologies in UNIX/LINUX operating system environment;Knowledge of Microsoft SQL Server in a Windows operating system environment;Knowledge of Oracle, Microsoft SQL Server and MySQL internals, data structures, and memory management;Knowledge of Oracle network connectivity; Knowledge of SQL and PL/SQL languages;Knowledge of UNIX/LINUX operating system and commands;Knowledge of Microsoft Server operating system and commands;Knowledge of computer programming, systems analysis and systems design principles and practices; Knowledge of problem-solving techniques;Knowledge of operational procedures forinstalling and maintaining Oracle, Microsoft SQL Server and MySQL software and databases;Knowledge of designing, developing, testing, documenting and implementing database backup and recovery procedures;Knowledge of performing database backup and recovery processes for Oracle using RMAN; Knowledge of performing database backup and recovery processes for Microsoft SQL Server; Knowledgeconfiguring data base parameters for performance tuning; Knowledge ofdeveloping, testing, documenting and implementing SQL, Oracle PL/SQL, UNIX/LINUX shell scripts and Windows operating system BAT or CMD shell scripts;Ability to work independently;Ability to create logical, well-written standards and procedures related to database design and database administration; Ability to write, code, test, debug, and review computer programs and stored procedures;Ability to process information logically and solve problems;Ability to identify and define user requirements;Ability to communicate effectively verbally and in writing;Ability to establish and maintain effective working relationships with others;Ability to plan, organize and coordinate multiple concurrent projects and work assignments; andAbility to write technical data processing reports.BASE SALARY: $45,848.06Salary for the position will be commensurate with experience and training. HOW YOU WILL GROW:FDLE recognizes the importance of growth and success while fostering a family-oriented work environment. We encourage our members to seek opportunities for professional growth through training, team building, and mentoring. Our four Fundamental Values of Service, Integrity, Respect and Quality will guide you as you embark on a lifelong career at FDLE.OUR SALARY & BENEFITS:Starting salary will be the minimum of the class pay range, unless otherwise dictated by FDLE's pay policy. FDLE is a State of Florida Employer and offers a comprehensive benefits package, including:State of Florida Tuition Waiver Program;Paid holidays, vacation and sick leave;HMO and PPO health insurance options with premiums starting as low as $50 per month;$25,000 in automatic life insurance coverage;Multiple supplemental insurance options including: dental, vision, disability and more;Pension and investment retirement plan options; andTax deferred medical and child care reimbursement accounts.ABOUT OUR AGENCY:The Florida Department of Law Enforcement (FDLE) employs more than 1,900 members statewide - either at headquarters in Tallahassee or in one of seven regional operations centers (ROCs). Our mission is to promote public safety and strengthen domestic security by providing services in partnership with local, state, and federal criminal justice agencies to prevent, investigate, and solve crimes while protecting Florida's citizens and visitors. Click herefor additional information about FDLE.HIRING PROCESS:You will be evaluated for this job based on your previous knowledge and experience. Additional reviews may be performed to screen for preferred qualifications, experience and education. Your qualifications will be based on knowledge, skills, and abilities and other elements relevant to this position supported by the information in your application. Qualifying questions will only be credited if verifiable by the information provided on your application including specifically required software/computer skills. You may be contacted to participate in a selection process which may consist of written exercises, work samples, skills tests, and interviews. You may be notified by email to participate in a selection process. Failure to reply within a designated timeframe may exclude you from further consideration.Future vacancies may be filled from this position advertisement.BACKGROUND:FDLE requires an extensive background process of all recommended applicants. The elements of a background include: financial credit check, criminal history of applicant and applicant's immediate family or roommates, personal references, employment and education verifications (which includes official transcript(s)), drug screen and fingerprinting. This information will be utilized to make the final hiring decision.NOTES:Preference will be given to current FDLE members who have satisfactorily completed at least six months of the probationary period for their current position.REMINDERS:Male applicants born on or after October 1, 1962, 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:you are a retiree of the Florida Retirement System (FRS), please check with the FRS on how your current benefits will be affected if you are re-employed with the State of Florida. Your current retirement benefits may be cancelled, suspended, or deemed ineligible depending upon the date of your retirement. The State of Florida hires only U.S. citizens and lawfully authorized alien workers.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 here. All documentation is due by the close of the vacancy announcement.

Keywords: State of Florida, Tallahassee , SENIOR DATA BASE ANALYST, Professions , Tallahassee, Florida