Job Standard for Database Administrator 2
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 2 Overview
- Person Group: Professional
- Job Code: 75771
- Pay Grade: P10
- FLSA Status: Exempt
- Career Level: Intermediate
- Family: Information Technology
- Function: Cloud Infrastructure Services
Implement and manage vendor or open source database software. Design, monitor, evaluate integrity and placement of data and data files for the coordination of University data requirements. Code, monitor and tune database objects for optimal performance. Provide support for the design, development and implementation of application development projects. Provide day-to-day database administration support as needed, keeping an eye on trends and considering future direction. Apply updates and fixes to various database services which may include, but are not limited to Oracle, Microsoft SQL and MySQL. Migrate data and code from one environment to another. Manage database level user and group security settings and ensure secure operations of database servers. Troubleshoot and resolve issues with the database at the server level. File and escalate trouble tickets with various support organizations for a database. Act as escalation contact for database admin 1. Escalate issues within the team as needed.
Fully competent and productive professional contributor who applies acquired job skills, policies, and procedures to complete substantive assignments/projects/tasks of moderate scope and complexity. Works independently with general supervision; exercises judgment within defined guidelines and practices to determine appropriate action. May provide guidance and assistance to entry level professionals and/or support employees.
Bachelor’s degree or equivalent in Computer Information Systems, Management Information Systems or Computer Science plus 5 years of relevant professional experience.
Knowledge, Skills, and Abilities
- 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
- Various office related software
- Strong knowledge of data structures and experience administering relational databases
- Ability to set priorities and follow project schedules and be detail oriented
- Knowledge of database connectivity issues.
- Strong customer service, 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.
- Experience with any of the following technologies is preferred:
- Scripting/Programming (PowerShell, php, python, ruby, Perl, etc.).
- Familiarity with Linux/Unix and/or windows server administration.
60% of Time the Database Administrator 2 must:
- Install, monitor for, download and apply upgrades, updates and fixes database software on servers as needed. Monitor databases for performance and issues using monitoring tools.
- Provide before, after hours and weekend support for migrations, updates, fixes and issues as needed. Provide technical assistance and consulting to functional areas and other teams around the University on problems that may be database related.
- 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 advice on database and application software interface issues. Administer database-level security as needed.
- Optimize and secure data related services that are integrated with the database systems managed. Design, implement and integrate database and database systems as needed.
- Propose and/or establish new procedures and policies as needed. Adhere to published standards and procedures, such as naming conventions, security, programming conventions, code walkthroughs, testing conventions and migration processes
- Work with system engineers to insure 24×7 production architecture availability and recoverability. Participate in 24×7 on-call support rotation with an expectation to work during mission critical events.
- Work with TSS area to assist in deploying desktop applications or configurations to end-users, as needed. Generate/validate system performance statistics for reporting to management. Improve Database administration team internal standards and processes to promote increased quality, performance and customer service.
35% of Time the Database Administrator 2
- Determined by department needs
5% of Time the Database Administrator 2
- 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 3
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