Monitors, analyzes, troubleshoots, and resolves database, storage, and backup systems issues to ensure a stable, reliable, and continually available database environment.

• Administers and maintains storage systems to maximize efficiency

• Administers development, staging, testing, and production database environments

• Determines database memory requirements, processing power, interfaces, and network connections needed

• Determines appropriate software version to support application(s) and conducts the installation on server(s)

• Creates and configures SQL (Structured Query Language) servers/ Oracle databases

• Conducts database performance tuning, query optimization, index tuning, tables restructuring, and storage optimization

• Applies patches to database and storage systems, and performs database service pack upgrades and release upgrades

• Administers and maintains backup systems, including database recovery, database security, fault tolerance, and scalability

• Assists in establishing processes to ensure data backup

• Assists in establishing and maintaining security and controls access for all databases

• Participates in disaster recovery testing and supports disaster recovery efforts at remote sites

• Troubleshoots and resolves problems in servers, databases, and recovery programs

• Analyzes and resolves issues in Metro′s service management system (a.k.a. HEAT customer service model)

• Creates and updates documentation for applications development and storage requirements

• Establishes and maintains applicable technical standard operating procedures

• Assists in ensuring adequate storage capacity planning for the organization

• Performs data replication

• Supports the Database Administration (DBA) team

• Provides guidance to more junior staff members

• Complies with all Metro safety rules, policies, and procedures

• Contributes to ensuring that the Equal Employment Opportunity (EEO) policies and programs of Metro are carried out

  
  May be required to perform other related job duties

Knowledge of (defined as a learned body of information that is required for and applied in the performance of job tasks)

• Theories, principles, and practices of database administration, storage, backup, and recovery

• Capabilities and functionality of software and hardware

• UNIX/AIX operating systems

• SQL use for managing databases

• Database management systems

• Storage and backup systems

• Applicable business software applications

Skill in (defined as the proficient manual, verbal, or mental utilization of data, people, or things)

• Performing journey-level database management work

• Operating computers and peripherals

• Organizing and maintaining all databases within the information technology network infrastructure

• Determining strategies to achieve goals

• Troubleshooting and resolving issues

• Analyzing situations, identifying complex problems, and recommending solutions

• Implementing policies

• Communicating effectively with others

• Interacting professionally with various levels of Metro employees and outside representatives

Ability to (defined as a present competence to perform an observable behavior or produce an observable result)

• Troubleshoot storage and recovery problems

• Evaluate new products and recommend system improvements

• Recognize problems and implement solutions

• Work well with others

• Share knowledge and train others

• Prepare reports and correspondence

• Travel to offsite locations

• Read, write, speak, and understand English

A combination of education and/or experience that provides the required knowledge, skills, and abilities to perform the essential functions of the position. Additional experience, as outlined below, may be substituted for required education on a year-for-year basis. A typical combination includes:

Education

• Bachelor's Degree in Computer Science, Information Technology, or a related field

Experience

• Five years of relevant experience maintaining a Unix Operating System and administering storage systems and database servers, including three years of experience in the Oracle database administration, architecture, and upgrade process; some positions in this class may require specialized experience in area of assignment

Certifications/Licenses/Special Requirements

• Coursework in UNIX OS administration preferred

• Must be able to support department systems on a 24/7 basis

• After-hours and weekend work are required as necessary

• Occasional out-of-state travel required

The physical demands described are representative of those that must be met by the employee to successfully perform the essential functions of this job. Metro provides reasonable accommodation to enable individuals with disabilities to perform the essential functions.

Working Conditions

• Typical office situation

• Close exposure to computer monitors and video screen

Physical Effort Required

• Sitting at a desk or table

• Operate a telephone or other telecommunications device and communicate through the medium

• Type and use a keyboard and mouse to perform necessary computer-based functions

• Communicating through speech in the English language required