Database Analyst

General Statement

Under supervision, directs, evaluates, reviews, and manages database resources and services across the District while ensuring high levels of data quality; and develops, implements, and oversees database policies and procedures to ensure the integrity and availability of databases and their accompanying software.

Essential Job Functions

Essential job functions are fundamental, core functions common to positions in a classification. They are not intended to be an exhaustive list of all job duties for any one position in the class. Since class specifications are designed to be descriptive and not restrictive, incumbents may complete one or all of the job duties listed or tasks of similar kind not specifically listed here.

• Participates in the design and development of new databases; assists with the installation and testing of new databases.
• Modifies existing databases and database management systems; tests programs or databases and corrects errors; performs system upgrades as needed.
• Develops, tests and implements SQL program code and application code for use with databases.
• Defines, reviews and implements database backup and recovery strategies.
• Plans, coordinates and implements appropriate security, indexes, access controls, constraints, triggers and other database-related features to safeguard database against accidental or unauthorized damage, modification or disclosure.
• Monitors performance of application programs with respect to associated databases and performs required performance tuning actions to ensure database stability and efficiency; recommends changes to data storage practices to optimize efficient use of space and prevent unnecessary database growth.
• Works with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures.
• Develops long-term goals for production databases in conjunction with data owners and department managers.
• Conducts research and makes recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
• Analyzes user requirements for reports, forms, queries, and data extraction.
• Develops and deploys end-user practices and tools for data extraction, queries, and data manipulation in accordance with business processes.
• Creates and documents models for new database development and / or changes to existing ones through data flowcharting and entity relationship diagrams.

Other Job Functions

Environmental Conditions

Work is performed in a typical office environment and requires the use of standard office equipment including computers.

Desirable Knowledge, Skills and Abilities

Minimum Qualification Requirements

Graduation with an associate's degree from an accredited college or university majoring in information technology, computer science or a closely related field and two years of experience in database development and / or administration.

Substitution

Graduation from a four-year accredited college or university majoring in information technology, computer science or a closely related field may be substituted for the minimum qualifications in their entirety. Additional professional experience in database development and / or administration may be substituted for the required education on a year-for-year basis. A Microsoft MCITP SQL Server certification may be substituted for one year of the required education.

Promotional Requirement