1.0 FTE Coordinator of Technical Systems

PAY GRADE: Support Exempt L

FLSA STATUS: Exempt

POSITION OBJECTIVE:

The job of Coordinator of Technical Systems is done for the purpose/s of designing, writing and supporting, computer database systems for district information systems, including the computerized student administration system at the district and site levels; meeting compliancy with regard to SAlS (School Accountability Information System); supporting the school sites in the management of school site data; and providing technical support, training, data oversight, and compliance with state accountability expectations. The position will also support the process in the design, development and implementation and maintenance of a data warehouse system for the purpose of supporting improved student achievement.

DUTIES & RESPONSIBILITIES: (These duties are a representative sample; position assignments may vary.)

• Coordinates integration of District data information systems, including student information systems and accounting systems
• Design, implement and support database solutions that will improve the use of a data-driven decision making model in support of improved student achievement
• Administer the control, integrity and accessibility of District-supported applications and databases
• Create, maintain, and tune system database structures
• Perform research on database features, technologies, and tools
• Provide training to personnel as appropriate for the purpose of ensuring the safe and secure use of District data
• Develop reports and queries for the purpose of assisting others in the effective and efficient completion of their activities and in achieving District goals, State and Federal reports.
• Evaluate MSSQL new features and MSSQL related products
• Maintain established data backup recovery policies and procedures to ensure the appropriate storage backup and recovery processes are performed
• Perform software upgrades and maintenance pertinent to the student information system for the purpose of satisfying compliance with vendor and state requirements and specifications
• Provide support and solutions for the student information system, SAIS data reporting operations and other applications
• Maintain the data integration between the student information system and other information systems and databases (District and external vendors) for the purpose of uploading, merging, downloading, extracting, and/or importing student information, student assessment and other data
• Upgrade and increase knowledge of current software systems by attending training or requesting additional support from administration for the purpose of professional development
• Perform the installation, configuration and upgrading migration of MSSQL server software and related products
• Design, implement and maintain database security policies for users and roles, assign privileges and data access
• Maintain control of user accounts and database access according to District policies and guidelines
• Perform data audits to ensure accuracy and validation
• Manage and secure data systems against data corruption and intrusion for the purpose of protecting student data
• Support the daily operation of the student information system with regard to each District module used by District and site users for the purpose of compiling accurate data and analyzing data outputs
• Respond to user inquiries for the purpose of answering questions, providing data, problem-solving, and/or managing database systems
• Work collaboratively and cooperatively with all district student information system and SAlS users for the purpose of supporting the student information system
• Knowledgeable of SQL server farms, replication, scale-up and scale-out technologies and how to implement, add-to, and maintain
• Be able to implement/perform load balancing/tuning
• Other duties as assigned
• Extensive knowledge of Microsoft SQL 2008/2012 and other systems as appropriate
• Works with minimal supervision and is responsive to budgets and timelines
• Other tasks as assigned

EDUCATION & EXPERIENCE (positions in this class typically require):

• B.S. in Computer Science or related field required
• Masters Degree preferred

LICENSING REQUIREMENTS (positions in this class typically require):

• None

KNOWLEDGE (position requirements at entry):

Required to perform algebra and/or geometry; read technical information, compose a variety of documents, and/or facilitate group discussions; and analyze situations to define issues and draw conclusions. Specific knowledge required to satisfactorily perform the functions of the job includes: pertinent codes, policies, regulations and/or laws; computer hardware and software.

SKILLS (position requirements at entry):

Required to perform multiple, technical tasks with a need to routinely upgrade skills in order to meet changing job conditions. Specific skills required to satisfactorily perform the functions of the job include: operate equipment utilized in position; operate standard office equipment; utilize pertinent software applications (Microsoft Office, especially Excel, Access); plan and manage projects, operating and supporting Windows servers, and proficiency in working with SQL databases.

ABILITY (position requirements at entry):

Required to schedule activities, meetings, and/or events; routinely gather, collate, and/or classify data; and consider a number of factors when using equipment. Flexibility is required to independently work with others in a wide variety of circumstances; analyze data utilizing a variety of complex processes; and operate equipment using a variety of standardized methods. Ability is also required to work with a significant diversity of individuals and/or groups; work with data of varied types and/or purposes; and utilize a variety of job-related equipment. In working with others, problem solving is required to analyze issues and create action plans. Problem solving with data requires analysis based on organizational objectives; and problem solving with equipment is moderate. Specific abilities required to satisfactorily perform the functions of the job include: communication ability with diverse groups; meet deadlines and schedules, recordkeeping.

PHYSICAL REQUIREMENTS:

Positions in this class typically require: stooping, kneeling, crouching, reaching, standing, walking, pushing, pulling, lifting, finger dexterity, grasping, talking, hearing, seeing, and repetitive motions.

Sedentary Work: Exerting up to 10 pounds of force occasionally and/or a negligible amount of force frequently or constantly to lift, carry, 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.

Incumbents may be subjected to moving mechanical parts, odors, chemicals, extreme temperatures, inadequate lighting, workspace restrictions, and intense noises.

NOTE:

The above job description is intended to represent only the key areas of responsibilities; specific position assignments will vary depending on the business needs of the department.