Under direction, to design, implement, and maintain countywide computer databases, and to perform other duties as required.
Example of Duties
CHARACTERISTIC DUTIES AND RESPONSIBILITIES
Maintains and ensures the overall performance and availability of the County's computer databases.
Installs, customizes, upgrades, and migrates databases and database software tools.
Plans, designs, configures, tests, and modifies the physical structure of the databases to ensure efficient and accurate storage and retrieval of data.
Working with Senior Data Analysts, analyzes, evaluates, and resolves problems with the databases and database software tools.
Establishes, maintains, and implements database backup and recovery procedures.
Provides technical guidance and support to other information technology staff on database design, application design methodologies, system resources, application tuning and response times.
Plans, designs, and develops specifications for future database requirements including enhancements, upgrades, and capacity projections; evaluates alternatives; and makes appropriate recommendations.
Administers data base security, and controls and monitors user access to database information.
Prepares and maintains detailed documentation such as database configuration and content, security and user authorizations, problem resolution, data base size and usage reports, and other standards and procedures.
Provides training to professional computer staff in database design and structure and in the use of data base application development tools.
Researches and evaluates new releases and products; analyzes the impact on existing systems.
Establishes and maintains effective working relationships with employees at all levels of the County, staff, and vendors.
Performs other duties as required.
Essential Knowledge and Abilities
Comprehensive knowledge of the principles of relational data base design and operation.
Comprehensive knowledge of the use of data base application development tools.
Comprehensive knowledge of the principles, practices and techniques of application design and development.
Comprehensive knowledge of vendor support centers for resolving problems.
Ability to analyze, follow through, and resolve complex problems.
Ability to plan and organize projects and workload.
Ability to research and evaluate information and make appropriate recommendations.
Ability to prepare and maintain detailed and accurate records and reports.
Ability to communicate effectively, both orally and in writing.
Ability to establish and maintain effective working relationships