DATABASE ADMINISTRATOR - Technology & Information Services at Mt. Diablo Unified
Job Description / Essential Elements:
Print
-
MT. DIABLO UNIFIED SCHOOL DISTRICT
DATABASE ADMINISTRATOR
Primary Function
Under general supervision, performs work of considerable difficulty in participating as lead database administrator and team leader in the analysis, definition, programming, testing and implementation of new databases and software application systems; assists in the technical direction of programmers, programmer trainees, contract programmers; performs related work as required.
Directly Responsible To
Director of Technology and Information Services
Major Responsibilities
- Upgrades and installs applications systems and database software; converts prior database applications into new database formats; configures database software; writes SQL routines when necessary; maintains production and test databases; establishes and maintains database security; monitors database size and growth and adds space as needed.
- Monitors database engine performance and tunes as needed; monitors database statistics; establishes daily and periodic database backups; establishes daily management of log backups; manages database product support contracts, products, support calls.
- Analyzes problems, proposed systems and modifications to systems outlined by the System Programming and Operations Supervisor.
- Consults with representatives of user departments and analyzes time, resource and technical requirements needed to meet user requirements.
- Designs, codes, tests, documents and implements computer programs for the most complex systems.
- Writes and maintains systems, programming and user documentation of assigned systems, maintains large complex operational systems by monitoring production to assure success.
- Locates causes of unsuccessful runs and corrects problems.
- Conducts meetings with staff and users to ensure soundness of designs and programs and that requirements and standards are being met.
- Supervises and evaluates assigned classified staff as required by Director of Technology Information Services.
Qualifications
Knowledge and Skills
Database structures and database management.
- Principles and techniques of system procedure analysis and development, program planning, computer programming and processing, forms design and control requirements.
- Systems and procedures analysis and design.
- Considerable skill in Structured COBOL programming and SQL.
- Principles and procedures of application and systems software programming.
- Principles and techniques for project planning, scheduling and control.
- Principles and techniques for developing and monitoring goals, objectives and time lines.
- Supervise, coordinate and direct systems analysis, design and programming activities.
- Analyze data and situations, identify problems, reason logically and develop conclusions and effective solutions.
- Communicate clearly and concisely, orally and in writing.
- Establish and maintain effective working relationships with staff and user departments.
- Establish, monitor and control projects priorities and schedules to accomplish work.
- Keep abreast of current changes in developments in the information systems field.
Education, Training and Experience
Any combination equivalent to graduation from college in computer science, accounting, business administration, management information systems or related field and two years work experience in systems analysis and application programming.
Position will be in the Management group, range 7.
Requirements / Qualifications
Requirements / Qualifications
Education, Training and Experience Any combination equivalent to graduation from college in computer science, accounting, business administration, management information systems or related field and two years work experience in systems analysis and application programming. ------------------------------------------------------------------------ All applicants, both internal and external, must submit all required documents online in a complete Edjoin application. ** Note: Applications will not be considered without answering the below supplemental questionnaire:
DATABASE ADMINISTRATOR SUPPLEMENTAL QUESTIONNAIRE Your responses to the following supplemental questions must be included in your online Edjoin application. Final Filing Date: Friday, November 30, 2018 by 4:30 PM 1. Elaborate on your experiences around best practices of database backups and system security. 2. Please describe your knowledge around payroll processing and reporting requirements to the County and State of California. 3. Have you ever implemented a major application or been involved in a database conversion? If so, explain, elaborate. 4. Please describe your involvement and implementation of integrating different data systems such as a financial/payroll, and other applications.
- Answers to Supplemental Questions
- Letter(s) of Recommendation (2 letters - less than one year old)
- Resume (One to two pages in length, recently updated.)
Education, Training and Experience Any combination equivalent to graduation from college in computer science, accounting, business administration, management information systems or related field and two years work experience in systems analysis and application programming. ------------------------------------------------------------------------ All applicants, both internal and external, must submit all required documents online in a complete Edjoin application. ** Note: Applications will not be considered without answering the below supplemental questionnaire:
DATABASE ADMINISTRATOR SUPPLEMENTAL QUESTIONNAIRE Your responses to the following supplemental questions must be included in your online Edjoin application. Final Filing Date: Friday, November 30, 2018 by 4:30 PM 1. Elaborate on your experiences around best practices of database backups and system security. 2. Please describe your knowledge around payroll processing and reporting requirements to the County and State of California. 3. Have you ever implemented a major application or been involved in a database conversion? If so, explain, elaborate. 4. Please describe your involvement and implementation of integrating different data systems such as a financial/payroll, and other applications.
- Answers to Supplemental Questions
- Letter(s) of Recommendation (2 letters - less than one year old)
- Resume (One to two pages in length, recently updated.)
Comments and Other Information
Knowledge and Skills
1. Database structures and database management.
2. Principles and techniques of system procedure analysis and development, program planning, computer programming and processing, forms design and control requirements.
3. Systems and procedures analysis and design.
4. Considerable skill in Structured COBOL programming and SQL.
5. Principles and procedures of application and systems software programming.
6. Principles and techniques for project planning, scheduling and control.
7. Principles and techniques for developing and monitoring goals, objectives and time lines.
8. Supervise, coordinate and direct systems analysis, design and programming activities.
9. Analyze data and situations, identify problems, reason logically and develop conclusions and effective solutions.
10. Communicate clearly and concisely, orally and in writing.
11. Establish and maintain effective working relationships with staff and user departments.
12. Establish, monitor and control projects priorities and schedules to accomplish work.
13. Keep abreast of current changes in developments in the information systems field.
Working Conditions:
* Ability to handle confidential information with dsicretion, to exercise good judgement and tact and to work under pressure.
* Ability to work effectively with all segments of the educational community and general public; design and implement procedure; express oneself clearly and concisely, both orally and in writing.
NONDISCRIMINATION: The Mt. Diablo Unified School District prohibits discrimination, harassment, intimidation, and bullying based on actual or perceived ancestry, age, color, disability, gender, gender identify, gender expression, nationality, race or ethnicity, religion, sex, sexual orientation, actual or potential parental, family, marital status, or association with a person or a group with one or more of these actual or perceived characteristics. Questions, concerns or complaints regarding compliance with Title IX student issues, please contact the Title IX Compliance Officer, Michael Jimenez, Assistant Superintendent High School, at 1936 Carlotta Drive, Concord, CA 94519, by phone (925) 682-8000, or email jimenezma@mdusd.org. Questions, concerns or complaints regarding compliance with Title IX employee issues, please contact the Executive Director of Human Resources, Lisa Murphy Oates, at 1936 Carlotta Drive, Concord, CA 94519, by phone (925) 682-8000, or email at murphyoates@mdusd.org. Questions, concerns or complaints regarding harassment, discrimination, intimidation and bullying, please contact the Equity Compliance Officer, Jennifer Sachs, Executive Director of Instructional Support, at 1936 Carlotta Drive, Concord, CA 94519, by phone (925) 682-8000, or email at sachsj@mdusd.org.
Comments and Other Information
Knowledge and Skills
1. Database structures and database management.
2. Principles and techniques of system procedure analysis and development, program planning, computer programming and processing, forms design and control requirements.
3. Systems and procedures analysis and design.
4. Considerable skill in Structured COBOL programming and SQL.
5. Principles and procedures of application and systems software programming.
6. Principles and techniques for project planning, scheduling and control.
7. Principles and techniques for developing and monitoring goals, objectives and time lines.
8. Supervise, coordinate and direct systems analysis, design and programming activities.
9. Analyze data and situations, identify problems, reason logically and develop conclusions and effective solutions.
10. Communicate clearly and concisely, orally and in writing.
11. Establish and maintain effective working relationships with staff and user departments.
12. Establish, monitor and control projects priorities and schedules to accomplish work.
13. Keep abreast of current changes in developments in the information systems field.
Working Conditions:
* Ability to handle confidential information with dsicretion, to exercise good judgement and tact and to work under pressure.
* Ability to work effectively with all segments of the educational community and general public; design and implement procedure; express oneself clearly and concisely, both orally and in writing.
NONDISCRIMINATION: The Mt. Diablo Unified School District prohibits discrimination, harassment, intimidation, and bullying based on actual or perceived ancestry, age, color, disability, gender, gender identify, gender expression, nationality, race or ethnicity, religion, sex, sexual orientation, actual or potential parental, family, marital status, or association with a person or a group with one or more of these actual or perceived characteristics. Questions, concerns or complaints regarding compliance with Title IX student issues, please contact the Title IX Compliance Officer, Michael Jimenez, Assistant Superintendent High School, at 1936 Carlotta Drive, Concord, CA 94519, by phone (925) 682-8000, or email jimenezma@mdusd.org. Questions, concerns or complaints regarding compliance with Title IX employee issues, please contact the Executive Director of Human Resources, Lisa Murphy Oates, at 1936 Carlotta Drive, Concord, CA 94519, by phone (925) 682-8000, or email at murphyoates@mdusd.org. Questions, concerns or complaints regarding harassment, discrimination, intimidation and bullying, please contact the Equity Compliance Officer, Jennifer Sachs, Executive Director of Instructional Support, at 1936 Carlotta Drive, Concord, CA 94519, by phone (925) 682-8000, or email at sachsj@mdusd.org.
Application Deadline
11/30/2018 4:30 PM Pacific
Date Posted
11/14/2018
Contact
Number of Openings
1
Salary
Add'l Salary Info
$72,622 - $98,460 PER YEAR
Length of Work Year
8 HRS/DAY - 12 MONTHS
Employment Type
Full Time
Stipend
(Masters Degree stipend of $1000 - OR - Doctorate Degree stipend of $2000, only one stipend will be credited)
Supervisor
Joe Estrada, Director Technology & Information Services
Job Location
Technology & Information Services Department