Under the direction of the Assistant Superintendent of School Support Services and Manager of the Department of Mental Health, performs a variety of specialized functions to maintain and facilitate the computerized collection, management, manipulation and distribution of data used for analysis; coordinates various data submissions to local, regional, state, and federal agencies; establishes database procedures; performs hardware and software studies related to database file structure and volume requirements; provides technical assistance to users and data processing personnel regarding database design; conducts training and workshops; troubleshoots and diagnoses service problems; ensures accuracy of data and compliance with reporting requirements; generates routine and customized reports; and maintains security access.
The primary responsibility of an employee in this class is to oversee the hardware, software and data base to ensure its effective use. Such duties entail an understanding of systems, programming, hardware, software, user needs, etc. Therefore, an employee in this class must have good knowledge of technical concepts of computers, systems and the entire data processing field and be able to relate to the needs and problems of users, programming, systems and management personnel. Additionally, employee must work with State and Federal data reporting requirements and timelines; reporting, querying, and data evaluation tools; legal requirements, organizations; correct English usage, vocabulary, grammar, spelling, and punctuation; general specifically pertaining to student records confidentiality and reporting; technology related to electronic submission of data to the California Department of Education (CDE) and other CALPADS/SIS office functions, practices and procedures; and be proficient in the use of spreadsheets, database, word processing and/or office record keeping; data entry and correction on large database systems compiling complex reports.The class of Database Analyst is distinguished from the class of Systems Analyst in that the latter is a specialist in systems and is required to have expertise in a limited area.
Must attach the following documents to the online application or your application will be disqualified:
Transcripts showing the completion of a Bachelor's Degree degree in Computer Science, information systems management or related field. (MUST ATTACH TRANSCRIPTS).
If substituting additional experience for all or part of the required education, transcripts showing completion of 60 semester units or 90 quarter units in coursework in Computer Science or Information Systems Management, must be attached to the online application.
Valid California Class C Driver License
Proof of current automobile insurance
*Unit/Degree verification (including equivalency of foreign degrees) must be submitted with the online application as an attachment in the form of unofficial transcripts. Equivalence of foreign degrees must have been reviewed and verified by a regionally accredited foreign degrees review agency.
Please note: Resumes are not required and are not reviewed in lieu of your application; therefore, ensure your application is complete.
*All required documents MUST be submitted electronically at the time your application is submitted.
MINIMUM QUALIFICATIONS AND SPECIAL LICENSE OR LANGUAGE SKILLS
Graduation with a Bachelor's Degree from an accredited college or university with a major in computer science, information systems management or related fields is required. Additional experience beyond that required may be substituted for two (2) years of the required educational requirement of sixty (60) semester units on the basis of one year of full-time experience being equal to thirty (30) semester units of college coursework in computer science or related field. A Master's degree from an accredited institution in computer science, information systems management or related fields is desirable.
Five (5) years of experience in business system analysis, technical analysis and/or educational applications. Two (2) years of the five must be in design, development and implementation of business applications data base. Experience in educational applications is desirable.
Additional experience in business system analysis, technical analysis and/or educational applications may substitute for up to two (2) years of the education requirement on a year for year basis.
SPECIAL LICENSE OR LANGUAGE SKILLS
A valid Class C California Drivers' license and use of private or alternative means of transportation is required. Proof of automobile insurance is required.
Employees must be physically and mentally able to perform the essential duties of the position with or without reasonable accommodation and without hazard to themselves or others; must be able to lift equipment and materials up to fifty (fifty) pounds, crawl under buildings and under/around furniture, and use/climb ladders to reach high places.
ESSENTIAL DUTIES AND RESPONSIBILITIES
Essential duties and responsibilities of position in this class include but are not limited to:
Meeting federal, state, and local data requirements by monitoring, maintaining and updating various databases and associated programs
Researches, designs, and implements procedures to audit, certify, and publish student and staff information to local, regional, state, and federal agencies.
Plans, designs, orders, installs, configures, maintains and supports workstation hardware and software, system utilities, program development and data management tools including generation application generators.
Supports implementation and management of the district Learning Management System
Configures, installs, maintains and administers data communications network
Installs and maintains work-station hardware and software at remote sites
Establishes basic concepts and procedures for database including design, production schedules, program interface, security levels, programming standards, back-up, restart and recovery
Produces application and system software as needed
Codes Data Definition Language statements for structuring the database
Prepares operation manuals for use of database; provides telephone and on-site support to users on decentralized database problems
Assists personnel to ensure maximum utilization of system resources
Responds to user inquiries concerning operation and maintenance of computer equipment
Documents and reports problems to appropriate vendors;
Meets with management, vendors and user divisions to discuss needs, timelines, problems, changes and solutions
Works with employees in data center obtaining information and jointly developing solutions to mainframe software problem areas
Identifies problems in database usage and develops solutions
Develops methods to maintain statistics on database usage
Studies trends and changes in database to determine impact on hardware and software
Provides hardware and software utilization reports
Reviews trends in data processing field to maintain currency and cost effectiveness
Makes budget recommendations
Determines product specifications for bid preparation
Supervises employees responsible for processing computer input and output
Provides work direction and guidance to Data Processing Specialists or other personnel as assigned
Attends various meetings, conferences, and workshops to receive current information regarding technology, program compliance, and reporting requirements
Performs other related duties as required
Analysis and Problem Solving / Fact Finding / Decision Making / Math Skills / Reading Comprehension / Continuous Learning / Professional/Technical Expertise / Using Technology / Action & Result Focus / Dependability / Attention to Detail / Flexibility / Handling Stress / Initiative and Innovativeness / Integrity / Self- Management / Listening / Oral Communication / Presentation Skill / Writing / Informing / Handling Conflict / Relationship Building / Customer Focus / Professional Impact / Delegating / Developing Others / Assessing Talent / Group Facilitation / Involving Others / Leadership / Managing Performance / Teamwork / Valuing Diversity / Organizational Savvy / Planning and Organizing / Process Improvement / Project Management / Strategic View
EMPLOYMENT STANDARDS AND WORKING CONDITIONS
Components, capabilities and uses of modern computers and related equipment
Principles and theories of database design techniques, characteristics, capabilities, operation and control
Methods used in database management to organize, test and access data
software systems and techniques including procedural, non-procedural and Job Control Language (JCL) including operating and teleprocessing systems
Data systems analysis and design techniques
Training methods in data processing field
General principles of data processing, retrieval, analysis, and statistical reporting as related to student information systems
Supervisory principles and practices
Provisions of employee agreements
Rules of the Personnel Commission; district personnel procedures, and other rules and regulations
Properly operate computer related hardware and safely operate a motor vehicle
Prepare in writing, clear and logical Electronic Data Processing (EDP) systems designs
Plan, organize and supervise work unit operations
Supervise assigned personnel effectively
Orally express difficult and highly technical concepts clearly and concisely so that technician and generalist will understand
Analyze the informational needs, problems and procedures
Evaluate and adapt new developments in database technology and techniques
Develop solutions to complex technical problems
Program in languages appropriate to the task
Program and debug
Provide support to users
Write clear and logical systems designs
Prioritize and respond to multiples requests
Work with a minimum of supervision
Conduct surveys and studies
Establish and maintain cooperative working relationships with the public and district personnel, users and management
Maintain sensitivity to ethnic, religious, cultural and sexual differences