ROCKFORD PUBLIC SCHOOL DISTRICT #205
Job Title: Database Administrator
Job Code: 5425
Department: Technology Services
Supervisor: Information Services Coordinator
FLSA Status: Exempt
PURPOSE OF THE POSITION: The Database Administrator is responsible for designing and maintaining database programs for student records management and business operations; installing, configuring, administering and maintaining district core operations servers; developing data and report requirements with district and school administrators, teachers, and other users; designing, modifying, maintaining, and documenting user reports generated from the student records and business databases; ensuring availability and data integrity of vital systems through planning and implementing comprehensive backup procedures; designing modifying and maintaining processes necessary for the integration of district databases with various 3rd party vendors and entities; and maintaining current database data dictionaries and schemas. This position will research, recommend and guide technological implementations of core district systems.
SUPERVISORY RESPONSIBILITIES: None
DUTIES AND RESPONSIBILITIES: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. In addition to the requirements listed below, regular attendance is an essential function of this position.
- Ensures that all actions are in concert with the Board policies as well as the mission statement, beliefs, objectives and parameters found in the Board’s strategic plan.
- Participates in job training and professional growth opportunities in order to enhance ability to perform the essential functions of the job.
- Performs other related duties as assigned for the purpose of ensuring an efficient and effective work environment.
- Perform real-time system monitoring of various SQL servers using a variety of tools to ensure optimum system performance, respond to and correct issues that have a negative impact on system performance.
- Develops and prepares a variety of written materials (e.g. standards and procedures, training curricula, audit procedures, database structures/objects, disaster recovery, backup procedures, etc.) for the purpose of documenting procedures and required actions, providing written support and/or conveying information to others, both within and outside the department.
- Create, modify, maintain, and document user reports.
- Keep abreast of the latest technological advances in Information Technology so as to evaluate, recommend, and implement new software and hardware solutions including but not limited to district adopted integration framework and Data Warehouse solution.
- Perform regular reviews of various logs to determine potential problems, trends and ensure system health is properly maintained.
- Ensure security and confidentiality of data and critical systems on the network.
- Create, modify, or implement student records and business operations databases and related tracking and reporting programs.
- Create, modify and maintain business workflow models and web forms.
- Performs all database backups and restores for production to test/development platforms.
- Perform regular integrity checks of backup media to ensure effective disaster recovery.
- Aid in planning, beta testing and implementation of new software applications, upgrades and new software solution implementations.
- Interact with various teams within operational departments to support student records management and business operations.
- Interact and communicate on a technical level with contacts from various external vendors for the purpose of developing and maintaining data integration/synchronization systems
- Integrates databases from existing data sources for the purpose of meeting access and reporting needs defined by district and school site staff.
- Maintains development, test, production, report and testing environments for appropriate systems, including data synchronization between environments for the purpose of ensuring the integrity of database applications. This will be accomplished through, among other things, the design and implementation of database maintenance plans.
- Create, modify and maintain custom programming solutions for creating internal business efficiencies and growth.
- Create, modify and maintain system integration with district 3rd party applications to ensure streamlined data integration.
- Performs all database restores, rollbacks and recovery processes for the purpose of coordinating with appropriate operations and programming personnel. This involves routinely restoring production database backups into various test/development databases for the use by support personnel and users.
- Utilizing provided student and financial system tools, design import routines and data import interfaces with the purpose of importing data into various systems. This can involve heavy manipulation of data file format and structure. Detailed knowledge of Microsoft Excel and/or other data manipulation tools are required.
- Bachelor’s degree in computer science or computer-related field preferred or equivalent technical training and/or work experience.
- Minimum of four years practical experience as a Database Administrator is desired. Should also have four years of combined programming experience, in both SQL and any .NET language, should have a minimum of 2 years “advanced” experience with Microsoft Excel
- Preferred experience with programming within a .NET framework using both C# and VB.
- Strong background in the following programming environments including but not limited to: C#, VB, SQL Development, XML, XSL, HTML, CSS.
KNOWLEDGE, SKILLS AND ABILITIES:
- Must have experience creating Stored Procedures and SQL Views.
- Demonstrated competencies should include development/support of Relational databases; query optimization; systems analysis; and troubleshooting program and system problems, and performance issues.
- Candidates should have functional and administrative knowledge of Windows operating systems. Familiarity with Powershell is a plus.
- Must have a working knowledge of SQL Server and SQL Server agent, security, integration services and system administration. Knowledge of server Task Scheduler or VisualCron is a plus.
- Experience with Postgres SQL a plus.
- Must have a working knowledge of ETL tools; Visual Studio preferred.
- Must work well with end-users to determine needed requirements, respond to questions and issues, and promote a high degree of customer satisfaction.
- Must be comfortable with training adults in technology tools and concepts.
WORKING CONDITIONS: Length of work: 12 months.
Moderate in-district travel as well as intermittent in-state and out-of-state travel. Intermittent prolonged and irregular hours of work.
OTHER: This job description describes duties and responsibilities which are representative of the nature and level of work assigned to the position. The identified duties and responsibilities are intended only as illustrations of the various types of work that may be performed. The omission of specific duties does not exclude them from the position.
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed above are representative of the knowledge, skills, and/or ability required.
The job description does not constitute an employment agreement between the school district and employee and is subject to change by the school district as the needs of the school district and requirements of the job change.
Physical Aspects of the Position (Check all that apply)
|1.||N/A||Climbing – Ascending or descending ladders, stairs, scaffolding ramps, poles and the like, using feet and legs and/or hands and arms. Body agility is emphasized.|
|2.||X||Balancing – Maintaining body equilibrium to prevent falling when walking, standing or crouching on narrow, slippery or erratically moving surfaces.|
|3.||X||Stooping – Bending body downward and forward by bending spine at the waist.|
|4.||X||Kneeling – Bending legs at knee to come to a rest on knee or knees.|
|5.||X||Crouching – Bending the body downward and forward by bending leg and spine.|
|6.||N/A||Crawling – Moving about on hands and knees or hands and feet.|
|7.||X||Reaching – Extending hand(s) and arm(s) in any direction.|
|8.||X||Standing – Particularly for sustained periods of time.|
|9.||X||Walking – Moving about on foot to accomplish tasks, particularly for long distances.|
|10.||X||Pushing – using upper extremities to press against something with steady force order to thrust forward, downward or outward.|
|11.||X||Pulling – Using upper extremities to exert force in order to draw, drag, haul or tug objects in a sustained motion.|
|12.||X||Lifting – Raising objects from a lower to a higher position or moving objects horizontally from position to position. This factor is important if it occurs to a considerable degree and required the substantial use of upper extremities and back muscles.|
|13.||X||Finger use – Picking, pinching, typing or otherwise working, primarily with the fingers rather than the whole hand or arm as in handling.|
|14.||X||Grasping – Applying pressure to an object with the fingers or palm.|
|15.||X||Talking - Expressing or exchanging ideas by means of spoken word. Those activities in which you must convey detailed or spoken instructions to other workers accurately, loudly or quickly.|
|16.||X||Hearing – Perceiving the nature of sounds. Ability to receive detailed information through oral communication, and to make fine discriminations in sounds such as when making fine adjustments on machinery.|
|17.||X||Repetitive Motions – Substantial movements (motions) of the wrist, hands, and/or finders.|
The Physical Requirements of the Position (Check one)
|1.||X||Sedentary Work – Exerting up to 10 pounds of force occasionally and/or negligible amount of force frequently or constantly to lift, push, pull or otherwise move objects, including the human body. Sedentary Work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.|
|2.||X||Light Work – Exerting up to 20 pounds of force occasionally, and/or up to 10 pounds of force frequently, and/or a negligible amount of force constantly to move objects. If the use of arm and/or leg controls requires exertion of force greater than that for sedentary work and the worker sits most of the time, the job is rate for Light Work.|
|3.||N/A||Medium Work – Exerting up to 50 pounds of force occasionally, and/or up to 20 pounds of force frequently, and/or up to 10 pounds of force constantly to move objects.|
|4.||N/A||Heavy Work - Exerting up to 100 pounds of force occasionally, and/or up to 50 pounds of force frequently, and/or up to 20 pounds of force constantly to move objects.|
|5.||N/A||Very Heavy Work – Exerting in excess of 100 pounds of force occasionally, and/or in excess of 50 pounds of force frequently, and/or in excess of 20 pounds of force constantly to move objects.|
The visual acuity requirements including color, depth perception and field of vision (Check one)
|1.||X||Machine Operations – inspection, close assembly, clerical, administration. This is a minimum standard for use with those whose work deals largely with preparing and analyzing data and figures, accounting, transcription, computer terminal, extensive reading, or visual inspection.|
|2.||N/A||Mechanics – Skilled tradespeople – This is a minimum standard for use with those whose work deals with machines such as power tools, lathes and drills.|
|3.||N/A||Mobile Equipment – This is a minimum standard for use with those who operate cars, trucks, forklifts, cranes, and high equipment.|
|4.||N/A||Other – This is a minimum standard basis on the criteria of accuracy and neatness of work for janitors, sweepers, etc.|
The Conditions the Worker will be subject to in this position (Check all that apply)
|1.||X||The worker is subject to inside environment conditions.|
|2.||N/A||The worker is subject to outside environment conditions.|
|3.||N/A||The worker is subject to both environmental conditions. (Activity occurs inside and outside)|
|4.||N/A||The worker is subject to extreme heat or cold for periods of greater that one hour.|
|5.||N/A||The worker is subject to noise which would cause them to have to shout.|
|6.||N/A||The worker is subject to hazards: Includes a variety of physical conditions, such as proximity to moving mechanical parts, electrical current, chemicals, etc.|