Job: Computer Database Systems Coordinator

The position of Database Administrator will serve the role 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 lead the process in the design, development and implementation of a data warehouse system for the purpose of supporting improved student achievement

Functions:
* Serve as the District’s data administrator for all district 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 all district-supported information systems and databases
* Create, maintain, and tune system database structures
* Coordinates support and development with software and hardware providers to effectively integrate, support and secure data systems
* Perform research on database features, technologies, and tools
* Provides training to personnel as appropriate for the purpose of ensuring the safe and secure use of district data
* Develops reports and queries for the purpose of assisting others in the effective and efficient completion of their activities and in achieving district goals
* Oversees and coordinates the development interface programs for the purpose of automating data transfers between information systems
* Oversees and coordinates the development of client/server and web-based applications for the purpose of meeting district, department and school data requirements
* Perform the installation, configuration and upgrading migration of MSSQL server software and related products
* Evaluate MSSQL new features and MSSQL related products
* Develop, establish and maintain sound data backup recovery policies and procedures ensuring that appropriate storage, archiving, backup and recovery processes are performed
* 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
* Coordinate software upgrades and maintenance pertinent to the student information system for the purpose of satisfying compliance with vendor and state requirements and specifications
* Function as the primary problem-solving resource for the purpose of assisting and supporting the student information system and SAlS data reporting operations
* Certifies student information system status and functionality for the purpose of guaranteeing budgetary relief for the district from the vendor
* Facilitates 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 and other data
Manages and secures data systems against data corruption and intrusion for the purpose of protecting student data
* Coordinates 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
* Responds to user inquiries for the purpose of answering questions, providing data, problem-solving, and/or managing database systems
* Provides training to school site personnel with regard to the student information and SAlS reporting and data management modules, software and hardware for the purpose of employee competency
* Upgrades and increases knowledge of current software systems by attending training or requesting additional support from administration for the purpose of professional development
* Visits school sites for the purpose of support and training on the student information system
* Works 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
* Extensive knowledge of Microsoft SQL 2000, 2005 and 2008
* Works with minimal supervision and is responsive to budgets and timelines
* Other tasks as assigned by the Executive Director for Technology and Information Systems
Other Functions: Assists other personnel as may be required for the purpose of supporting them in the completion of their work activities.

SKILLS
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 2000 and 2003 servers, and proficiency in working with SQL databases.

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

ABILITY
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
Microsoft Certified Database Administrator (MCDBA) preferred.