Under general supervision, creates, implements, and/or maintains databases for storage, manipulation, and retrieval of information that is a critical organizational resource in an integrated business environment, evaluates vendor technology solutions, design and recommends appropriate industry standard database solutions, develops and enforces industry and/or citywide standards within this technology discipline.
Examples of duties may include, but are not limited to, the following:
- Defines database information, access, and file structure requirements through discussions with users and colleagues;
- Designs and implements database management system by creating models, designing relationship, structuring tables, establishing referential integrity & preparing documentation;
- Performs database backup and recovery processes including off-site storage for disaster recovery;
- Maintains database efficiencies and performance by monitoring data integrity, modifying structures, providing security, and resolving database conflicts;
- Solves problems through detection-and-prevention regimes
- Applies rules of relational database technology between multiple business systems and be able to accurately communicate those relationships to end users;
- Clones, stages, or provisions databases for testing and development;
- Manipulates data through normalization, transfer, tuning, cleansing/scrubbing processes and database population;
- Creates and maintains data warehousing and data mining systems for data and metadata;
- Designs and maintains database libraries, specifications, documents, and operating procedures;
- Develops database quality standards based on industry standards and evaluates existing technology & resources for compliance with those standards;
- Plans and implements database installations, upgrades, and conversions;
- Analyzes database systems for capacity planning, fault tolerance and disaster recovery;
- Coordinates designs, installation and support activities with business stakeholders and application vendors;
- Creates and modifies operating system and database scripts for process automation
- Researches, evaluates and tests proposed databases and supporting products, product versions and solutions;
- Supports system security requirements based on industry standards & management preferences;
- Researches, selects, and recommends database training services to meet business needs;
- Supports database applications and end user support with applications;
- Recommends information technology strategic goals and objectives;
- Assists in the development and implementation of departmental policies and procedures;
- Oversees support to applicable database and database-related technology helpdesk responses;
- Coordinates assigned services and activities with city staff and outside vendors;
- Diagnoses and troubleshoots the nature and effects of database failures and other problems;
- Prepares and presents staff reports and other correspondence;
- Works with internal committees and outside consultants to analyze and assess departmental and citywide databases needs and capabilities; and
- Performs related duties as assigned.
Education
- A Bachelor's degree from an accredited college or university in Information Technology, Computer Science, or related field.
- A Master's degree is desirable.
- For degrees obtained outside of the U.S., an official equivalency evaluation is required.
Experience
- A minimum of five year's experience in database administration, preferably in a municipality or public sector.
- High proficiency in Microsoft SQL Server.
Licenses and Certificates
- Possession of, or the ability to obtain, a valid California driver's license at the time of appointment.
- Microsoft database certifications are desirable.
Special Requirements
Essential functions and duties require the following physical abilities and work environment
- Ability to work in a standard office environment; ability to travel to different sites and locations;
- Regularly required to talk or hear. Â Required to stand; walk; use hands to finger, handle or feel; and reach with hands and arms.
- Occasionally required to sit; climb or balance; and stoop, kneel, crouch or crawl.
- The employee must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds.
Ability to successfully complete a full police background investigation.
