Job Standard for Database Administrator 3
How to use this Job Standard:
- The Purpose, Scope, Qualifications and Job Functions are specific to this job title and can not be edited.
- Click “View in Google Docs/Download” and download to Word.
- Under Essential Functions you may add an additional 35%, specific to your department needs.
- Complete this standard before creating the job announcement and posting the position.
- This standard will be used as the new Job Description for the prospective employee.
- After hire is complete, insert Employee Name and PCN#
Database Administrator 3 Overview
- Person Group: Professional
- Job Code: 75772
- Pay Grade: P12
- FLSA Status: Exempt
- Career Level: Senior
- Family: Information Technology
- Function: Cloud Infrastructure Service
Implement and manage vendor or open source database software. Code, monitor and tune database objects for optimal performance. Perform capacity planning, usage forecasting and in-depth technical review. Provide future-looking and day-to-day database administration support as needed. Make recommendations on technical direction. Act as escalation contact for database admin 1 and 2. Serve as a technical resource for other teams as needed.
Recognized subject matter expert who knows how to apply theory and put it into practice with in-depth understanding of the professional field with limited oversight from managers. Independently performs the full range of responsibilities within the function; requires deep job knowledge of area typically obtained through higher education combined with experience. Manages large projects or processes and problems faced are difficult and often complex; analyzes problems/issues of diverse scope and determines solutions. May manage programs that include formulating strategies and administering policies, processes, and resources; functions with a high degree of autonomy. Influences others regarding policies, practices and procedures.
Bachelor’s degree or equivalent in Computer Information Systems, Management Information Systems or Computer Science plus 8 years of relevant professional experience.
Knowledge, Skills, and Abilities
- Strong working knowledge of the following software, languages and tools:
- PL/SQL, T-SQL and/or ANSI SQL
- SQL Management Studio, OEM Grid
- Visual Studio/BI Development studio
- MS Analysis Services, Integration Services, Reporting Services
- SQL Developer or similar
- Familiarity with Linux/Unix and/or windows server administration. Working knowledge of various office related software such as MS Word, Excel, PowerPoint and Visio. Strong experience administering multiple relational databases such as Oracle, MS SQL, MySQL and PostgreSQL.
- Ability to set priorities and follow project schedules. Understanding of execution/explain plans.
- Scripting skills (PowerShell, php, python, ruby, Perl, etc.). Knowledge of TCP/IP connectivity over an Ethernet based network.
- Strong analytical and troubleshooting skills. Strong organizational, written, verbal and interpersonal communication skills. Must be able to work with and communicate with people of various knowledge levels from the very technical to the casual user.
- Must be very detail oriented.
- Experience with any of the following technologies is preferred:
- Clustering and/or HA database configurations and management.
- Database Schema architecture.
60% of Time the Database Administrator 3 must:
- Act as a point of contact for various database vendors whose applications the University has licensed.
- Install database software on servers as needed. Monitor for, download and apply upgrades, updates and fixes for supported databases. Monitor databases for performance and issues using monitoring tools.
- Configure backup processes. Restore data when needed. Design, implement and integrate database and database systems as needed.
- Provide before, after hours and weekend support for migrations, updates, fixes and issues as needed. Address database or performance issues that are forwarded from Customer Care. Respond to Customer Care with end-user information related to any issues as well as updating status during ongoing issues.
- Provide technical assistance and consulting to functional areas and other teams around the University on problems that may be database related.
- Optimize and secure data related services that are integrated with the database systems managed. Modify entity relationship diagrams as needed.
- Design, develop and maintain database solutions for new projects and product upgrades, ETL solutions for data interfaces.
- Design, develop and maintain and test disaster recovery plans for production service databases.
- Support, troubleshoot and resolve database and data related issues.
- Administer database-level security as needed.
- Maintain installation documentation. Maintain documentation on any modifications to default installation of various databases.
- Adhere to published standards and procedures, such as naming conventions, security, programming conventions, code walkthroughs, testing conventions and migration processes.
- Propose and/or establish new procedures and policies as needed. Generate/validate system performance statistics for reporting to management. Update operations and user documentation as needed.
- Script or create simple programs to automate daily operational tasks
- Improve Database administration team internal standards and processes to promote increased quality, performance and customer service.
- Provide technical assistance to team members as needed.
- Representative of the University when interacting with various application Support Centers.
- Setup database installations as needed.
35% of Time the Database Administrator 3
- Determined by department needs
5% of Time the Database Administrator 3
- Perform other duties as assigned
Work Environment and Physical Demands
General Office – Exerting up to 10 pounds of force occasionally (Occasionally: activity or condition exists up to 1/3 of the time) and/or a negligible amount of force frequently (Frequently: activity or condition exists from 1/3 to 2/3 of the time) to lift, carry, push, pull or otherwise move objects, including the human body. General office work involves sitting most of the time, but may involve walking or standing for brief periods of time.
May be required to travel with overnight stays.
Database Administrator 4
Additional training/education or equivalent experience, as well as business need, are required for movement into higher level jobs.
Incumbent must perform the essential duties and responsibilities with or without reasonable accommodation. The above statements are intended to describe the general nature and level of work. Final employment offers are contingent upon a Final Candidate’s successful completion of a Background Verification, and a determination by the University that the information derived from the Background Verification does not disqualify the individual. In addition, a Financial History Check and Motor Vehicle Record (MVR) Check may be required.