Database Administrator

Purpose Statement
Under the general supervision of the Director of Information Technology, serves as a technical database administration expert, responsible for the design, implementation, operation, integrity, and security of the district’s database management systems.

Essential Functions

• Plans, develops, implements, and monitors the district’s database management systems, including the student information system, enterprise resource planning (ERP) system, district portal, and other database systems; develops and applies procedures and standards pertaining to database administration, utilization, and performance in collaboration with other information technology staff.
• Designs, develops, implements, and maintains the data system architecture for the data warehouse, databases, associated systems, and system integration tools at the logical and physical data model levels; defines database items, structure, and relationships; defines and ensures backup of all databases are performed in full and incrementally at all storage locations; develops and maintains database documentation, including data dictionary (metadata) and models, data standards, policies, and procedures.
• Monitors and analyzes database performance and identifies, troubleshoots, diagnoses, and resolves problems; performs database optimization to ensure optimal performance; tests and installs patches and upgrades to database systems, servers, and related peripheral equipment, and other related applications and systems.
• Develops specifications for and designs and implements database queries and customized scripts for reporting and data extract needs; performs data mining and data warehousing; consults with users to assess and meet data needs; defines data elements and structures to be accessed, extracted, and transformed; utilizes data integration tools to execute rules created in the design phase of data warehousing.
• Collaborates with information technology staff and external vendors to design, develop, and implement server infrastructure to support database systems and ensure proper integration of systems; troubleshoots and resolves data integration and reporting problems; provides information and technical direction to staff on activities required to perform upgrades and implement projects and procedures.
• Designs, develops, tests, implements, and maintains database security and disaster prevention and recovery plans to safeguard information against accidental or unauthorized access, damage, modification, or disclosure of data; provides data access permissions in accordance with district policies and state and federal requirements to ensure data security.
• Evaluates, measures, and maximizes system performance, security, availability, and effectiveness; researches and analyzes capacity and growth requirements and proposes database system enhancements to meet future needs.
• Coordinates major releases for the district’s database systems with external vendors and other information technology staff; oversees projects related to the development, enhancement, maintenance, and implementation of databases and related software.
• Collaborates with vendors to support district database needs; participates in the selection of hardware and software products and services.
• Represents the information technology department at various professional meetings, committees, and task forces to convey and obtain information.

Other Functions

• Performs other duties as assigned that support the overall objective of the position.

Education and Experience

An associate degree in database management, computer science, information technology, or a related field AND five years of recent (gained in the past seven years) experience administering modern database technology. Microsoft Certified Database Administrator (MCDBA) certification and experience installing, implementing, and maintaining Microsoft SQL Server in a clustered and highly available environment are preferred. 

OR

A bachelor’s degree in database management, computer science, information technology, or a related field AND three years of recent (gained in the past five years) experience administering modern database technology. Microsoft Certified Database Administrator (MCDBA) certification and experience installing, implementing, and maintaining Microsoft SQL Server in a clustered and highly available environment are preferred. 

Job Requirements:  Minimum Qualifications

Skills, Knowledge and Abilities

Skills to:

• Operate and maintain assigned databases and specialized applications and systems 

Knowledge of:

• Principles and practices of database design, reporting, querying, and administration
• Data warehouse and systems architecture
• Principles and practices of data integration and business intelligence constructs
• Relational database management principles and tools (RDB)
• Assigned database management systems
• Methods and techniques of database documentation, including procedures and definitions for metadata
• Principles, procedures, and methods used in data acquisition, storage, structuring, and retrieval
• Database security tools and practices
• Script languages applicable to the position
• Principles of project management
• Applicable federal, state, and local laws, codes, and regulations governing database administration practices
• District organization, operations, policies, procedures, and objectives
• English grammar, spelling, and composition

Ability to:

• Perform complex database administration in a clustered and highly available environment
• Develop and apply conceptual framwork and technology to the design, development, implementation, and management of data warehouse and data integration
• Learn, interpret, and apply complex technical publications, manuals, and applicable state and federal laws governing database administration practices 
• Design and implement full and incremental database backup 
• Identify, analyze, evaluate, trobelshoot, and solve complex database system problems
• Design and develop database querying and reporting capabilities
• Develop database security solutions 
• Maintain up-to-date technical knowledge and skills and adapt, learn, and apply new information, skills, and technology
• Manage multiple assignments simultaneously
• Plan and organize work to meet changing priorities and deadlines
• Relay technical concepts to non-technical audiences
• Maintain confidential records and information
• Colaborate with others to carry out work
• Communicate clearly and concisely, both orally and in writing
• Exercise initiative and independence of judgment and action
• Provide training, guidance, and work direction to others
• Prepare technical records, reports, and documentation

Working Environment

Work is performed in an indoor environment where minimal safety considerations exist.

Equal Employment Opportunity Statement
The Simi Valley Unified School District is committed to providing equal opportunity for all applicants for employment. The application, examination, and selection process shall be free from unlawful discrimination, including discrimination against an individual or group based on race, color, ancestry, nationality, national origin, ethnic group identification, age, religion, marital, pregnancy, or parental status, physical or mental disability, sex, sexual orientation, gender, gender identity or expression, or genetic information; a perception of one or more of such characteristics; or association with a person or group with one or more of these actual or perceived characteristics.