About this opportunity
Lodi Unified School District lists this Senior Database Engineer (Payroll) opportunity in lodi, California. Review the employer’s description below for duties, qualifications and application requirements.
Job description
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.
#J-18808-Ljbffr
Worksite address
lodi, CA, 95240, US
Who can apply
Review the original listing for work authorization, qualifications and employer requirements.