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: Monday, December 4, 2017 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: Monday, December 4, 2017 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.
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.
Application Deadline
12/4/2017 4:30 PM Pacific
Date Posted
11/15/2017
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)
*MDUSD Career Increments:
Applied when appropriate up to $91,040
Supervisor
Joe Estrada, Director Technology & Information Services
Job Location
Technology & Information Services Department