Database Administrator

Job Title:                   Database Administrator

Department:             Information Systems        

Pay Grade:                P150

FLSA Status:             Exempt

Reports to:                Manager IV - Information Systems Development

GENERAL PURPOSE

Responsible for overseeing database administration tasks; this role involves monitoring and maintaining database performance, and implementing necessary optimizations. Tasked with maintaining comprehensive documentation of database structures, configurations, and procedures to ensure consistency and accuracy. Strong time management skills are essential.

ESSENTIAL JOB FUNCTIONS

• Oversee and manage all aspects of database administration, including performance tuning, backup and recovery, and security management, to ensure optimal database health and reliability.
• Designs database structures, stored procedures, and database views in collaboration with district application developers ensuring quality data collection for the purpose of ensuring quality data collection.
• Develop data warehouse extract, transform, and load (ETL) processes and reports using industry-standard methodologies for dimensional modeling, supporting the district’s data warehouse initiatives.
• Design and implement SSIS packages for data integration, transformation, and loading (ETL) tasks.
• Monitor database systems to proactively identify and resolve issues, conduct regular performance analysis, and implement enhancements to improve system efficiency.
• Actively participate in projects from inception to completion, collaborating with stakeholders to gather requirements, design database solutions, and oversee implementation and testing phases.
• Supervise and mentor colleagues, offering guidance, training, and support to foster their technical expertise and productivity within the team.
• Demonstrate a high level of expertise and professionalism building relationships with teams, stakeholders and vendors.
• Maintain and prepare a variety of documents, both manual and electronic, to ensure up-to-date references, audit trails, and effective communication of activities and information.
• Research applications, vendors, consultants and emerging technology to recommend products that meet district requirements for capabilities and costs and provide technical assistance to district staff.
• Perform other related duties as required/assigned.

QUALIFICATIONS AND REQUIREMENTS

Education and Experience

• Bachelor’s Degree in job-related area from an accredited college or university or comparable experience preferred.
• Minimum of three (3) years of DBA experience with increasing levels of responsibility preferred.
• K - 12 technology experience preferred.

Certificates, Licenses and Other Special Requirements

• Must pass a Criminal Background Clearance, the results of which must be satisfactory to the District, required.
• Related Microsoft Database Administrative Certification Preferred

Knowledge, Skills, and Abilities

• Knowledge of basic math, including calculations using fractions, percentages, and/or ratios; read a variety of manuals, write documents following prescribed formats, and/or present information to others; and solve practical problems.
• Knowledge based competencies required to satisfactorily perform the functions of the job include current, legacy and emerging operating systems; enterprise computing and equipment; advanced database concepts and best practices; business continuity and disaster recovery best practices; Inter/Intranet applications; application program interfaces (API); data security, processes and methodology.
• Skill to perform multiple, technical tasks with a need to routinely upgrade skills in order to meet changing job conditions.
• Skill based competencies required to perform the functions of the job, including strong customer service skills, pleasant and tactful demeanor and professional appearance and conduct.
• Ability to read technical information, compose a variety of documents, and/or facilitate group discussions or training.
• Ability to analyze situations to define issues and draw conclusions.
• Ability to schedule a number of activities, meetings, and/or events; gather, collate, and/or classify data; and use job-related equipment.
• Ability to work with others under a wide variety of circumstances; working with data utilizing defined but different processes; and operate equipment using defined methods.
• Ability to work with a significant diversity of individuals and/or groups; work with data of widely varied types and/or purposes; and utilize job-related equipment.
• Ability to analyze issues and create action plans.
• Ability to collaborate and communicate effectively with internal and external stakeholders.
• Ability to apply critical thinking/problem solving to improve work processes.
• Ability to convey technical information to non-technical audiences.
• Ability to maintain confidentiality; set priorities; meet deadlines and schedules; work with detailed information; and adapt to changing priorities.
• Ability to work as part of a team; and work with frequent interruptions.
• Ability to set high expectations for self and others; set and monitor progress toward goals; and utilize and offer effective feedback for continuous improvement.

Working Conditions and Physical Requirements

• Work environment is primarily inside, where the noise and temperature levels are moderate.
• The work is light work that requires exerting up to 20 pounds of force occasionally, and/or up to 10 pounds of force to move objects.
• Must possess the physical ability to work primarily with fingers, perceive the nature of sounds, make rational decisions through sound logic and deductive processes, express or exchange ideas by the spoken word, substantial movements (motions) with the hands, wrists, and/or fingers, and discern letters or numbers at a given distance. 
• Additionally, the following physical abilities are required: balancing, climbing, crawling, crouching, feeling, grasping, handling, hearing, kneeling, manual dexterity, mental acuity, reaching, repetitive motion, speaking, standing, stooping, talking, visual acuity, and walking.