Senior Database Engineer (Payroll)

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.

Job Description / Essential Elements

LODI UNIFIED SCHOOL DISTRICT

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

• 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

Environment:

WORKING CONDITIONS:

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

Requirements / Qualifications

BRIEF DESCRIPTION:

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.

DESIRABLE QUALIFICATIONS:

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 Service
• 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

EQUAL OPPORTUNITY EMPLOYER

We do not discriminate against or tolerate the harassment of employees or job applicants on the basis of their actual or perceived sex, race, color, religion, national origin, ancestry, age, marital status, pregnancy, physical or mental disability, medical condition, veteran status, or sexual orientation. Physically or mentally disabled employees or applicants may request reasonable accommodation.

Lodi Unified School District Maintains a Tobacco Free Workplace.

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