Database Administrator

This is a PROMOTIONAL ONLY recruitment to establish an eligibility list and fill a  vacancy. The eligibility list will be used to fill permanent vacancies which may occur during the life of the eligibility list.  Promotional examinations shall be restricted to permanent employees of the District who meet the qualifications of the class.

Positions in this classification are full-time (40 hours per week), 12 months per year.
 
The recruitment process will consist of an oral technical interview, which is tentatively scheduled during the weeks of November 27, 2023-December 4, 2023. Qualified applicants will be notified by email.

EQUAL OPPORTUNITY, TITLE IX, AFFIRMATIVE ACTION EMPLOYER

The Downey Unified School District does not engage in any employment practice that discriminates against an employee or applicant for employment on the basis of actual or perceived race, color, ancestry, national origin, religion, creed, age, disability (mental or physical), sex, gender (including pregnancy and childbirth), sexual orientation, gender identity, gender expression, medical condition, genetic information (including family and medical history), marital status, political affiliation, military and veteran status, or retaliation; or on any other basis as protected by state, federal or local law, ordinance or regulation, in its educational program(s) or employment. No person shall be denied employment solely because of any impairment which is unrelated to the ability to engage in activities involved in the position(s) or program for which application has been made. If you need a reasonable accommodation to participate in the hiring process, Downey Unified School District  will provide you with one upon notice.

BASIC FUNCTION: Under direction of the assigned administrator, perform a variety of specialized duties in the configuration, maintenance, support, and documentation of District's database driven applications. Monitor and maintain database servers, client applications, Web Servers, and Web applications. Perform security auditing, and maintain security permissions on databases and applications. Generate reports using reporting tools. 

Maintain and administer current and future versions of Microsoft SQL Server, or other Database Management Systems used by the District. E

Maintain and administer Web servers, including software applications, frameworks, software stacks, authentication, and security. E

Utilize SQL-based tools to build complex, highly focused queries, stored procedures, views, pivot tables, etc., enabling users to sort data and generate reports in both electronic and printed formats. E

Design, build, maintain and publish reports required by schools, departments, county, state and federal agencies using products such as Active Reports, Crystal Reports and Microsoft Reporting Services. E

Design, build, maintain and publish data extracts required by schools, departments, county, state and federal agencies. E

Coordinate with users, software vendors, and District staff to troubleshoot software and hardware problems and implement new versions or features. E

Utilize expertise in database, web technology and associated infrastructure to resolve user application and data problems. Provide end-user support, documentation, and training as required. E

Make recommendations, develop processes, and implement other procedures that will guarantee data quality and integrity. E

Develops and maintains audit standards, security standards, and access control on database and web servers. E

Assist in the definition and development of databases; act as the technical lead for database driven projects; and act as a resource to other district staff for database driven applications. E

Conduct system level, unit, and interface testing of applications and upgrades and assist end users with acceptance level testing; maintain a continuing liaison with users to ensure implementation and maintenance of systems. E

Audits, modifies, and amends data in systems using SQL commands, hand- editing, bulk import, or applications. Coordinate the data cleansing, data mapping, and data conversion efforts for District software systems including coding queries and scripts to move data between disparate systems. E

Write, review and document database driven applications as required;
Review technical designs, reports, documentation, manuals, help files and instructions, and other materials produced by staff; edit content throughout the development process. E

Schedule and perform database and web server updates and backups using server management tools or back up software; configure and monitor database replication, database mirroring and log shipping on database servers at local and remote sites. E

Analyze database and web server performance and resource usage and make recommendations or implement other mechanisms that will improve performance, reliability, security and availability. E

Must demonstrate attendance sufficient to complete the duties of the position as required. E

Perform other related duties as assigned.

Note: At the end of some of the duty statements there is an "E" which identifies essential duties required of the classification.KNOWLEDGE OF:
Client/Server, relational database, web data warehouse, and portal technologies. Microsoft Server 2012 R2 and later, MS SQL Server 2012 and later, and Microsoft Structured Query Language.
Transact-SQL language, stored procedures, triggers, user-defined functions and views.
Webapplication development tools, database security including access control, backup and recovery techniques.
Information transfer, sharing and communications among differing computer systems.
Microcomputer Client/Server and web-based data management systems. Client/Server, multi-tiered architecture and technologies.
Methods used in compiling complex reports.
Adult learning principles, project management and curriculum development.
Correct English language usage, spelling, grammar, and punctuation.
Principles and processes for providing customer and personal services. This includes meeting quality standards for services and evaluation of customer satisfaction.
Principles and techniques of systems analysis.
Methods for effective oral and written communication skills.
Applicable laws, codes, regulations, policies and procedures.
Appropriate safety precautions and procedures.

ABILITY TO:
Work confidentially with discretion.
Communicate effectively both orally and in writing.
Understand and carry out oral and written directions with minimal supervision.
Establish and maintain cooperative and effective working relationships.
Use tact, patience, and diplomacy in dealing with others.
Plan and lay-out work including accurately estimating time and materials.
Perform duties effectively with many demands on time and constant interruptions.
Learn and adapt to changing technologies and job responsibilities.
Analytically and logically evaluate complex technical information, issues or problems to generate solutions.
Detect errors in software systems, data extracts, reports or equipment operation.
Implement computer systems for inputting, retrieving and reporting data.
Analyze and assess operational systems and process and make recommendations to enhance program function and activities.
Communicate technical information clearly to users/clients. Prepare clear, complete and accurate reports.
Meet schedules and time lines.
Establish and maintain cooperative and effective working relationships with others.
Utilize a variety of technical and non-technical resources to achieve directives, goals and objectives.
Work efficiently on multiple tasks and projects simultaneously.
Work independently with little direction.
Operate motor vehicle safely within California Vehicle Code parameters.
Demonstrate behavior that is professional and responsible.
Be motivated to produce high quality work product. Work effectively in stressful situations.
Maintain a work pace appropriate to a given workload.Any combination of education and experience equivalent to: Bachelor's Degree in information systems, computer science, or related field, and three years' experience scripting queries using Microsoft T-SQL, including experience with reporting services such as Crystal Reports and Microsoft Query Reporting Service, and training and/or experience in project management, web technology, development tools, and microcomputer relational database management systems. Experience with C#, Visual Basic, Microsoft Access programming, Object Oriented Programming, and Q Student Information System are highly desirable.

Salary : $8,818 - $10,730