Assistant Database Administrator

                                                                                                                                                 

 

 

Epic Charter Schools

 

Job Description

 

Job Title:Assistant Database Administrator 

 

Department: Technology

 

Reports To: Director of KBA and Architecture

 

Compensation Range: $90,000

 

TRS Classification: Non-classified

 

Summary:

 

This position assists the Database Administrator with ensuring the accuracy of schoolwide data, assists with the design of solutions for managing and summarizing information related to school records, and facilitates the timely and accurate production of reports for all departments/school personnel. 

 

Essential Duties and Responsibilities include the following. Other duties may be assigned:

 

• Manage the PowerSchool student information system. Develop custom tables/fields, screens, and system reports.

• Create and maintain student stored grades and attendance/absent records, courses, yearly calendars, bell schedules, terms, and schools.

• Assist with implementing system enhancements and external data integrations.

• Provide documentation and support in the use of system processes and database structure.

• Engage in troubleshooting and problem solving to diagnose problems that users experience with the SIS and integrated software systems.

• Locate, extract, and analyze information as needed from internal and external data sources. Recognize data relationships and pull data together from disparate sources into well-organized and meaningful reports.

• Ensure accuracy of data and identify issues with the database. Perform testing and other quality control measures to ensure integrity of the data and proper functionality of applications.

• Assist with student data audits and help provide instruction on proper methods of making corrections.

• Use of SQL and HTML/CSS to maintain reporting and various assigned modules.

• Update PowerSchool Enrollment annually to meet the needs of District and Board Policies and School Changes.

• Builds and maintains forms, fields, and system updates for the E-Collect Form module. 

• The ADBA can/will perform the critical functions of the DBA in his/her absence.
• Other duties as assigned. 

 

Supervisory Responsibilities:

 

• No supervision in this role

 

Education and/or Experience:

 

• Bachelor's degree required 

 

Qualifications:

 

• Strong proficiency in SQL and knowledge of best practices when dealing with relational database systems.

• Conversant with analyzing and manipulating data in Excel and Access.

• Working knowledge of HTML/CSS and JavaScript in relation to PowerSchool customization.

• Ability to demonstrate common search, export, import, and reporting functions.

• Basic understanding of PowerSchool support resources and in-built help documentation.

• Experience with Google Sheets including basic operations, data import and export, simple formulas, and in-built support resources for learning and working with intermediate operations and formulas.

• Familiarity with Schools Interoperability Framework (SIF) and OK state reporting requirements.

• Solid troubleshooting and researching skills.

• Familiarity with Agile Project Management a plus.

 

Language Skills:

 

• Ability to read, analyze, and interpret internal communications, financial reports, and legal documents.
• Ability to respond to common inquiries or complaints from families or members of the business community.
• Ability to communicate effectively with students, families and coworkers, both verbally and in writing. 

 

Mathematical Skills: 

 

• Basic math skills required 

 

Reasoning Ability:

 

Ability to define problems, collect data, establish facts, and draw valid conclusions. 

 

Computer Skills:

 

• To perform this job successfully, an individual should have computer proficiency in Windows, Microsoft Office and Google Tools.
• Knowledge of Wengage SIS a plus.
• Proficient in SQL; familiarity with Python or Javascript a plus.
• Must have a high aptitude to learn new software as necessary for the business operations of the school. 

 

Certificates, Licenses, Registrations:

 

• Current driver's license and valid car insurance 
• Software specific certifications preferred 

• 2+ years of PowerSchool experience required

• 2+ years of SQL query writing/custom report-building required

 

Other Qualifications: 

 

• Must be able to pass a state-mandated background check after a conditional offer of employment is made 
• Must have favorable employment references

 

Physical Demands: 

 

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. 

 

While performing the duties of this Job, the employee is regularly required to sit and talk or hear. The employee is occasionally required to stand; walk; use hands to finger, handle, or feel and reach with hands and arms. The employee must regularly lift and /or move up to 10 pounds, frequently lift and/or move up to 25 pounds and occasionally lift and/or move up to 50 pounds. Specific vision abilities required by this job include close vision and ability to adjust focus. 

 

Work Environment:

 

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. 

 

The person in this position works remotely from their home. Meetings in public places and at Epic offices are also required. The noise level is usually quiet to moderately loud (when students are present).