Applicants: Please ensure that you upload all necessary documents and include all relevant information related to the position you are applying for. Please make sure that you are reading the job description in its entirety to align your documents and relevant information with the requirements.

 

POSITION SUMMARY:

The Coordinator of Business Information Systems plans directs and coordinates daily activities of the Department of Technology’s Database Administrators, provides leadership and support for District database environment including oversight, development, organization, assessment and implementation of data warehouse.  Ensures the operational efficacy through monitoring, tuning and planning for future expansion data requirements and data modeling with the use of business intelligence tools. Review workflow charts developed by business analyst and programmers. Develop methods for integrating different products, including customization. Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions. Assist in troubleshooting operational and development errors regarding data to ensures user experience is most productive. This position reports to the Director of Enterprise Information Systems.

 

KEY RESPONSIBILITIES:

Design and document database architecture using logical and physical data modeling tools and utilities. Create, test and execute data management languages. Analyze and sustain capacity and performance requirements. Monitor systems and platforms; oversee backup, clustering, mirroring, replication and failover. Train and develop technical staff to better utilize on-line processing databases environment. Design and execute the test scripts and test scenarios.

 

Perform daily system monitoring and back-up operations, verify the integrity and availability of all hardware, server resources, systems and key processes; review system and application log. Collaborate with developers and subject matter experts to establish the technical vision and analyze tradeoffs between usability and performance needs. Act as a liaison between the business units, technology teams and support teams.

 

Develop, design and maintain Extraction Transformation Loading (ETL) solutions to seamlessly integrate District infrastructure. Develop, design, deliver and maintain enterprise-reporting methods utilizing District Data Warehouse. Develop, design and maintain database solutions using SQL, functions, procedures, views and other RDBMS techniques.

 

Investigate, document and recommend new solutions to improve the District Technology. Assist system administrators securing access, with application, data loads; storage and performance strategies and implementations.

 

All other duties, as assigned and required, in order to perform the above services.

 

KEY JOB REQUIREMENTS:

Associates or Technical Degree in related field required. Bachelor's degree in one of the following subject areas: Computer Science, Business Administration, Information Technology or related field preferred.

 

Minimum of five (5) years of experience as a Database Administrator using Microsoft SQL Server in a clustered environment. Strong understanding of database structures, theories, principles and visualization; Microsoft Power BI.

 

Requires district coordination; makes decisions and recommendations, which affect District employees, students, parents and constituents.

 

Microsoft Certified Solution Developer (MCSD) or Microsoft Certified Applications Developer (MCAD) preferred.

 

Analytical: supervisor is available to review established broad objectives; independent judgment is required to review and approve major recommendations.

 

Requires excellent interpersonal skills, regular, frequent contact with internal and external personnel of influence and decision-making responsibility to discuss issues of moderate importance; requires occasional contact with officials at higher levels.

 

Responsible for multiple functions in developing solutions with high-level accountability for effective operation and results.

 

Normal office setting.

 

Moderate travel across the district with occasional travel for off-site training.

 

Light duty - On most occasions sitting at a desk or table; intermittently sitting, standing, or stooping.

 

Light lifting or carrying; twenty (20) lbs. or less.

 

NOTE: This is a Grade 30, 225-day position that pays for experience up to a Step 8.