FUNCTION:       Under general supervision, analyze and maintain and provide necessary reports to individual departments or organizations based on their needs, and to perform related duties as required.

RESPONSIBLE TO:  Enterprise System Manager, Information Technology Services

QUALIFICATIONS:

¨       Bachelors Degree in Business Computer Information Systems or Computer Science.

¨       A minimum of 2 years of SQL Server Database and Application development

¨       A minimum of 2 years of creating reports using Reporting Services, Access and Crystal.

¨       Ability to write advanced stored procedure and SQL Query.

¨       Ability to maintain applications and database servers to ensure stable environments for database applications.

¨       Ability to interface external database systems with MPS current database systems.

¨       Ability to create clear, concise and complete documentation.

¨       Experience with Data Analysis and Data mining.

¨       Solid understand of database structures & fundamentals.

¨       Ability to write high quality reports for analysis performed.

¨       Strong interpersonal and communication skills are highly desired.

¨       Experience with Student Information System

¨       Experience with Visual Studio and Visual SourceSafe.

ESSENTIAL FUNCTIONS AND RESPONSIBILITIES:

¨       Create reports for multiple business users for all aspects of the business utilizing statistical facts and figures.

¨       Administrate SQL Server Database.

¨       Create advanced SQL query to import and export data.

¨       Use reporting services to create reports for schools and departments.

¨       Provide data to various organizations as instructed.

¨       Assist Enterprise System Manager to create database policies and procedures.

¨       Schedule, run and reconcile data transmissions and provide excellent customer service to District departments. 

¨       Perform routine maintenance and bug fixes to existing applications.

¨       Maintain application and database servers to ensure stable environments for web and database applications.

¨       Maintain various applications for process improvement and collaboration by users within a department, using various tools.

¨       Administer complex database systems for all data users to ensure efficient and timely flow of information throughout the district.

¨       Create and maintain data marts in SQL Server to service the data requirements of various departments with in the District.

¨       Understand web-based development concepts and web-based applications.

¨       Create reports using reporting services.

¨       Create and maintain database development guidelines and follow those guidelines for any database development.

¨       Contribute to development of new processes and continuous improvement of existing processes.

¨       Provide technical analysis to determine appropriate solutions to meet business requirements.

¨       Prepare and analyze specifications for new applications and enhancements/upgrades per business requirements.

¨       Conduct and coordinate all aspects of software testing including unit testing, system testing, and integration testing.

¨       Ensures all required documentation is created and maintained as per standards.

Data Protection:

As part of you duties, you will be required to obtain, process and use highly confidential information stored in variety of databases. You may not use or disclose data for any other purpose. You must only disclose data to authorized persons or departments as instructed.