DATABASE ANALYST - ITS

Salary Schedule

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.

QUALIFICATIONS:

1. Bachelor's degree in a computer science or a technology-related field from an accredited institution or an equivalent combination of education and experience.
2. 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.
3. Two (2) years of experience with a Business Intelligence application. PowerBI 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 - ITS

SUPERVISES: None

MACHINES, TOOLS, EQUIPMENT:
Machines, tools, equipment, electronic devices, vehicles, etc., used in this position. Telephone, Computer, (Personal Computer and Mainframe), Automobile, Copier

PHYSICAL 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.

Percentage
70 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.

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, based on and related to user or system design specifications.
* Analyze and determine the effects of software and database revisions on existing production systems, systems design, programming standards and operating procedures.
* Ensure security, availability and integrity of all databases as well as enforce all standards.
* Keep programming staff advised of known software and database errors and their effects.
* Maintain current knowledge of computer technology, including hardware, software, database and communications.
* Provide schools and departments with technical assistance and support services helping them achieve desired priorities in response to needs and disparities in the implementation of technical support.
* Keep the Director Data Management, ITS informed about critical issues and incidents about which they should be aware.
* Follow the district’s policies and procedures as related to all HRMD guidelines and the district’s instructional initiatives.
* Follow the district’s policies and procedures as related to fixed assets.
* Develop leadership in subordinates.
* Responsible for keeping up to date on current technology being used by OCPS. With the support of the district, attend training to ensure skill level in various technologies is at the level required to perform in current position.
* Responsible for maintaining timely and accurate information and accountable for the quality of information maintained by those they supervise.
* Responsible for self-development and keeping up to date on current research, trends and best practices relevant to the area of responsibility.

Perform other duties and responsibilities as assigned by the supervisor.

* Essential Performance Responsibilities

TERMS OF EMPLOYMENT:
Non-bargaining unit compensation plan, twelve months, 8.0 hours per day.

EVALUATION:
Performance of this job will be evaluated in accordance with provisions of the Board’s policy on evaluation of personnel.

07/29/2025