RECRUITMENT DETAILS:

• The current opening is 40 hours per week, 12 months per year in the Technology and Information Systems department.

• The recruitment will be run as Dual Certification - open to current employees, employees on the reemployment list, and the public. This will result in the creation of 1 eligibility list for both successful internal and external candidates.

• Only online applications will be accepted:https://www.governmentjobs.com/careers/downey

EDUCATION AND EXPERIENCE:

Any combination of education and experience equivalent to:

• Bachelor's Degree in information systems, computer science, or related field.

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

LICENSES AND OTHER REQUIREMENTS:

Possession of a valid State of California class C driver's license. Must be, and remain, insurable under the District's vehicle driver's insurance policy at the standard rate.

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.

• Web application 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.

• School district organization and organizational relationships.

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

BASIC FUNCTION:

Under direction of an 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.

REPRESENTATIVE DUTIES:

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

ALL COMMUNICATIONS FROM DUSD REGARDING TESTING AND/OR INTERVIEWS WILL BE SENT VIA EMAIL.

Examination process may include any part or combination of the following: evaluation of training and experience, written exam, performance exam, and/or oral exam.

First review of applications will be 6/18/2019.

ENVIRONMENT:

Office environment; subject to driving to conduct work; subject to noise from equipment operation.

PHYSICAL ABILITIES:

Hearing and speaking to exchange information; seeing to perform assigned duties; sitting and standing for extended periods of time; dexterity of hands and fingers to operate a keyboard and other office equipment; kneeling, bending at the waist, reaching overhead, above shoulders and horizontally to retrieve and store files and supplies; moderate lifting up to 30 pounds.

HAZARDS:

Extended viewing of computer monitor; traveling to locations within the district; repetitive hand motion.