DATABASE ANALYST - ITS

Compensation

Salary Schedule

Overview

To develop, install, maintain and support database and system software programs and procedures to provide an efficient, secured and reliable database environment in achieving district priorities.

Responsibilities and Qualifications

QUALIFICATIONS:

Bachelor's degree in a computer science or a technology-related field from an accredited institution or an equivalent combination of education and experience.

Three (3) years of recent experience utilizing SQL programming concepts using SQL languages like PL/SQL (preferred), T-SQL, MySQL, or other SQL based programming language in a large distributed computer environment, including hands-on experience in ETL (Extract, Transform, Load) development for data integration and transformation processes.

Two (2) years of development experience with a Business Intelligence application. PowerBI preferred.

Two (2) years of K-12 data management experience preferred.

KNOWLEDGE, SKILLS AND ABILITIES:Knowledge and commitment to decentralized decision-making and accountability for results. Ability to use effective public relations skills. Ability to interpret State Board Rules and School Board policy. Ability to work as part of a team with the staff or other departments. Ability to analyze data and effectively use problem solving skills. Ability to identify important issues or problems in area of responsibility. Ability to share ideas with others in a clear and informative manner. Knowledge of current technologies and research. Must have good written and oral communication skills. Knowledge of computer hardware operation and architecture (UNIX and Windows server). Knowledge of database management (Oracle or MS/SQL server) and data communication. Knowledge of application programming and system design. Knowledge of distributed processing. Knowledge of web and portal technologies.REPORTS TO: Director Data Management - ITSSUPERVISES: NoneMACHINES, TOOLS, EQUIPMENT:Machines, tools, equipment, electronic devices, vehicles, etc., used in this position. Telephone, Computer, (Personal Computer and Mainframe), Automobile, CopierPHYSICAL REQUIREMENTS:Describes physical conditions of this position.Light Work: Exerting up to 20 pounds of force occasionally and/or up to 10 pounds of force frequently. If the use of arm and/or leg controls requires exertion of forces greater than that for sedentary work and the worker sits most of the time, the job is rated as Light Work.PHYSICAL ACTIVITY:Physical activities of this position. Percent of a typical day involved in each applicable activity is noted.Percentage70 Sitting: Resting with the body supported by the buttocks or thighs.10 Standing: Assuming an upright position on the feet, particularly for sustained periods of time.10 Walking: Moving about on foot to accomplish tasks, particularly for long distances.5 Bending: Lowering the body forward from the waist.5 Reaching: Extending hand(s) and arm(s) in any direction.5 Lifting: Raising objects from a lower to a higher position or moving objects horizontally from position-to-position through the use of the upper extremities and back muscles exerting up to 10 pounds of force.80 Finger Dexterity: Picking, pinching, typing or otherwise working primarily with fingers rather than with the whole hand or arm.70 Grasping: Applying pressure to an object with the fingers and palm.90 Talking: Expressing or exchanging ideas by means of the spoken word. Those activities in which detailed or important spoken instructions must be conveyed accurately, loudly or quickly.90 Hearing Acuity: The ability to perceive speech and other environmental sounds at normal loudness levels.90 Visual Acuity: The power to see at a level which allows reading of numbers and text, operation of equipment, inspection of machines, etc.Note: Will total more than 100 percent as several activities may be performed at one time.WORKING CONDITIONS:Conditions the worker will be subject to in this position.Indoors and Outdoors: The worker is subject to both environmental conditions. Activities occur inside and outside. On demand attendance at the district office is required. Currently piloting a hybrid work schedule with some days remote. Must be a Florida resident.PERFORMANCE RESPONSIBILITIES:* Manifest a professional code of ethics and values.* Respond to internal and external customers in a timely, accurate, courteous and empathetic manner representing OCPS in a positive light.* Model the routine, intentional and effective use of technology in daily work, including communications, organization and management tasks.* Design, develop, document, analyze, create, test or modify computer systems, programs or databases, including prototypes, b