Database Administrator

Yavapai College Job Description

Title / Job Family:

Database Administrator

FLSA Status:

Exempt

Role Focus:

Organizes and integrates planning and execution of activities around a specific program or function; may assist to develop and administer budget.

Typical Scope:

Works within a specific area requiring a specialized body of knowledge; requires an understanding of internal and external procedures and policies to produce end results

Typical Education:

Undergraduate degree required; or an equivalent combination of education and experience; masters level degree preferred.

Typical Experience:

Minimum of two years of experience required in the area of specialty; four or more years required at the highest complexity level

Computer Skills:

To perform this job successfully, an individual should have knowledge of current enterprise style database versions of Oracle, Peoplesoft, Sybase, Informix, Structured Query Language (SQL) or MS/SQL; database design and database development tools; relational database structure and data normalization; operating systems (i.e., Windows NT, Unix, VMS); client/server architecture design and implementation; database system installation and maintenance; world wide web (WWW) interfaces to database systems; database security design and implementation.

Typical Level of Interaction:

Requires influencing and project management of others within the same and other departments to accomplish responsibilities; requires moderate external contact and influencing

Supervisory Impact:

May have lead responsibility over other employees. Carries out lead responsibilities in accordance with the organization's policies and applicable laws. Responsibilities may include training employees; planning, assigning, and directing work; addressing complaints and resolving problems.

Representative Duties:

The following are examples of typical duties that may be assigned to positions in this job family. It does not imply that all positions within the job family perform all of the duties listed, nor does it necessarily list all possible duties that may be assigned. Other duties may be assigned.

Develop, implement and maintain database applications and systems.

Administers database systems including monitoring and maintaining database systems and performing tuning and testing; backups and restoration, performance and resource monitoring, troubleshoot technical database problems.

Analyses data requirements from functional specifications.

Analyzes performance of database systems and maintains file structures.

Consults with college departments and IT staff on database design, business requirements, possible solutions, risks and advantages.

Coordinates changes to database architecture.

Coordinates database system performance and space use.

Designs and implements database and operating system security for client and server configurations; set up and maintain security and permissions.

Develops and implements external access to transactions with database systems using application programming interfaces (API) object-oriented language (OO) macros, script/batch language interfaces and electronic commerce solutions.

Develops, installs, monitors, updates and batches custom database applications using enterprise versions of Oracle, Peoplesoft, Sybase, Informix or MS/SQL.

Document database models and data structures.

Interpret documentation and manuals.

Maintains and coordinates data models, dictionaries and other database documentation.

Plans for capacity and growth of new and ongoing systems.

Resolves database problems.

Works with end users to fix bugs.

Install, configure, maintain and support in-house and third party software.

Performs related duties as assigned.

Competencies:

To perform the job successfully, an individual should demonstrate the following competencies:
Contributes Through Expertise

• Ability to adapt in a changing environment - Supports change and influences others to change. Works with other units to affect change. Proactive in identifying obstacles to change.
• Ability to Learn and Further Develop Professionally - Sees learning as a constant evolutionary process. Extends learning activities beyond current job requirements. Creatively uses technology based learning tools and methodologies.
• Project Management Skills - Effectively leverages self through others. Accurately identifies technical/technological and other resource requirements needed to complete project. Works with team members to develop meaningful metrics and measurements.
• Time Management Skills - Establishes priorities, monitors progress and surfaces problems early to avoid delays. Able to adjust own schedule to internal and external dynamics. Effectively and consistently employs time management system to achieve objectives.
• Organizational Skills - Adjusts to multiple demands. Takes on additional responsibilities when necessary. Proactively gathers process feedback about what is working and what is not.
• Financial Management Skills - Skilled in technology based financial planning and control systems. Understands the interdependency of college departments functions, and jobs from a financial perspective. Demonstrates a high skill level in handling broad based business problems.
• Integrity and Credibility - Accepts responsibility for completion of tasks and results. Exhibits pride and ownership for own work. Acts in accordance with own beliefs even when others may disagree.
• Communications Skills - Adept with electronic communication tools and processes. Delivers critical messages by applying appropriate techniques, media, language, etc. Collates and interprets information from within the organization.
• Presentation Skills - Able to make formal presentations that are more broadly based and complex. Can present to all levels of the organization within the scope of expertise. Skilled in the use of various presentation tools including multi-media.
• Written Communication Skills - Can produce clear and strong messages that are understood by diverse audiences. Effectively communicates the issues that are complex in nature verbally and in writing. Reviews and edits written work constructively.
• Leadership Skills - Actively assists with daily allocations of resources and coordinates activities. Takes responsibility for transferring knowledge to others in the workgroup. Overseas individual or multiple functions within a workgroup.
• Analytical Skills - Uses several analytical techniques to identify several solutions and weighs the value of each. Actively uses both technical and cognitive skills. Can conduct gap analysis and identify shortfalls. Uses technology in analysis process.
• Problem Solving Skills - Champions methods, procedures, or systems which reduce time and effort. Utilizes technology to increase efficiency in new ways. Gathers relevant information systematically - considers broad range of issues or factors.

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements and competencies listed are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Certificates, Licenses, Registrations:

N/A

Other Skills and Abilities:

N/A

Other Qualifications:

N/A

Physical Demands:

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to sit and talk or hear. The employee is frequently required to use hands to finger, handle, or feel. The employee is occasionally required to stand; walk and reach with hands and arms. The employee must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision and ability to adjust focus.

Work Environment:

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

The noise level in the work environment is usually quiet.

rev: 10-2006