The essential elements of the job duties:
Develop and advise on standards, guidelines, policies, and procedures designed to ensure the integrity of the database environment.
Evaluate technology and products to determine the feasibility of adding to agency standards.
Develop work plans for assigned projects and manage the execution.
Design and implement logical and physical databases of a moderately to large complex nature.
Determine aggregation, partitioning and indexing strategies for physical data.
Monitor and tune database performance, including SQL scripts, hints, execution plans, and materialized views.
Administer end-user access and security at the database level.
Ensure that data is appropriately protected via database backup and related strategies.
The job profile is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee. Other duties, responsibilities and activities may change or be assigned at any time with or without notice.