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