CLASS TITLE: SENIOR DATABASE ENGINEER

BASIC FUNCTION:
Design and develop database and support systems including access methods, device allocations, organization, security, documentation, guidelines and standards; serve as technical expert responsible for management and security of District-wide enterprise data; may serve as project leader providing training, work direction and guidance to staff in planning, developing and implementing major database projects.

REPRESENTATIVE DUTIES: E=Essential Duty

Individual positions may not perform all of the duties listed nor do these examples include all responsibilities of positions in this class.

Lead and manage various projects related to central system installations and other system-related activities; work with outside organizations and vendors to convert information to new systems. E

Recognize and coordinate the resolution of synchronization issues between databases, operating systems, applications and clients; advise and participate in resolving design and performance issues associated with distributed work in a multiple database environment. E

Perform database capacity management and resource optimization activities. E

Recommend and implement security permissions, privileges, standards, policies and guidelines. E

Create database access systems including tables, indexes, views, stored procedures and triggers. E

Research and correct database integrity problems of considerable difficulty. E

Define backup, restoration and disaster recovery procedures. E

Review existing software architecture and identify areas for improvement in stability, scalability, maintainability and performance. E

Advise Information Services staff concerning the design and use of database interfacing, structure and commands, as necessary. E

Train and provide work direction to other Database Engineers as necessary. E

Perform related duties as assigned.

KNOWLEDGE AND ABILITIES:
KNOWLEDGE OF:
Capabilities of mainframe, micro-computer and communication hardware utilized by the District
Database design techniques and host computer logical and physical database structures and relationships
SQL programming language at expert level
MS SQL Server and Business Intelligence Tools
Principles and techniques of data analysis, systems analysis, design, programming and implementation of large projects
Principles of data systems design, object-oriented design, relational and multidimensional databases, data warehouses, normalization, storage and retrieval
Complex designing, optimizing, troubleshooting and maintaining security on database servers
Client/server application development using various tools
Technical aspects of field of specialty
District organization, operations, policies and objectives

ABILITY TO:
Analyze existing procedures and develop improvements for optimum use by Technology Services
analyze and solve user needs and develop effective systems and programs
Operate computers, operating systems, peripherals and other District equipment for information retrieval, storage, analysis and reporting
Evaluate and interpret technical material; follow current trends and direction of database management systems
Test, troubleshoot, debug and document programs; resolve complex technical problems
Communicate effectively both orally and in writing
Understand and follow oral and written directions
Prepare clear, complete, concise reports and records
Work independently and collaboratively
Train and direct the work of others; establish and maintain cooperative and effective working relationships
Meet schedules and timelines

EDUCATION AND EXPERIENCE: Any combination equivalent to Bachelor's degree in computer science, programming, management information systems or related field; and five years of increasing experience in programming and analysis including three years database management of 100-plus databases on multiple platforms, at least one year experience performing the duties of a Database Engineer II and competency in the design and administration of databases for business, enterprise and student information projects. Experience in a K-12 educational environment is desirable.

LICENSES AND OTHER REQUIREMENTS:
Microsoft Certified Database Administrator (MCDBA), Microsoft Certified Solution Developer (MCSD), Microsoft.NET or equivalents are desirable
Valid California driver's license

WORKING CONDITIONS:
ENVIRONMENT:
Office environment

PHYSICAL DEMANDS:
Dexterity of hands and fingers to operate a variety of computer equipment
Sitting for extended periods of time
Seeing computer monitor
Hearing and speaking to exchange information
Bending, pushing, lifting and moving moderately heavy objects

Developed 7/07

Requirements / Qualifications

Comments and Other Information

Interested candidates may submit their completed application package (including all required documents) electronically through EdJoin or may print a completed EdJoin application and bring the completed application package (including all required documents) to the Personnel Office by 4:30PM on the final filing date. (click below).

Candidates selected for interview will be notified by phone. Applicants not chosen for an interview will be notified by mail.