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