All Jobs
Information Technology
Information Security Project and Service Management Software and Applications Systems and Infrastructure Teaching and Learning Technology User Success
Management Professional Supervisory
Information Security Project and Service Management Software and Applications Systems and Infrastructure Teaching and Learning Technology User Success
Management Professional Supervisory
Penn State Job Catalog
Database Administrator – Senior Professional (PSU0990)
Job Summary
Database Administrators design, manage, and maintain University databases of medium to high complexity; evaluate and optimize database configuration and access; resolve database performance and capacity issues; perform database recovery and back-up; collaborates in the establishment of policies and procedures pertaining to database management, security, maintenance, and utilization.
Representative Duties
- Administer, design, analyze, implement, and maintain database structures with respect to access methods, access time, device allocation, validation checks, organization, protection and security, and statistical methods
- Develop and implement administrative, automation, and data integration scripts utilizing various programming languages
- Ensure database optimization, database integrity (relational integrity), and integrity of the transaction profile
- Install, configure, and upgrade database management software (DBMS) and related products
- Optimize physical designs of databases to a given hardware platform; proactively monitor systems for performance and capacity constraints
- Create database maintenance procedures and backup/restore methods to protect the enterprise data
- Lead the database portion of projects to migrate databases to new hardware and operating system platforms and to use DBMS advancements to improve processes
- Maintain database dictionaries and system level databases, tables, and objects
- Integrate systems through database design
- Investigate data and/or program problems; determine source of problem; take corrective action
- Monitor and administer DBMS security
- Support developers with database design and coding problems and provide technical guidance to other staff
Level Matrix
- Level:
- – Senior Professional
- Base Description:
- – Completes activities, tasks, and/or projects of a functional nature.
- Level Summary:
- – Demonstrates advanced knowledge of principles, practices, and procedures of a particular field. Works independently on moderately complex work assignments under limited oversight, reviews progress, and evaluates results. Monitors work and projects ensuring timeliness, quality, and efficiency. Identifies and mobilizes resources to achieve outcomes. Trains others and reviews progress with management. Presents ideas, concepts, and instructions in a clear and persuasive manner. Develops new techniques, concepts, and approaches and applies them to moderately complex and strategic and/or operational issues.
- Supervisory Responsibilities:
-
– Indirect supervisor for other full–time employees
– May serve as direct supervisor for part–time, student, and/or temporary workers, volunteers, or a full–time employee
- Fiscal Responsibilities:
-
– May validate and pay invoices
– Monitors and tracks budgets and funding
- Problem Solving:
-
– Encounters moderately complex problems
– Applies specialized knowledge and skills to resolve problems
– Understands benefits, limitations, and impact of potential solutions
- Independence of Action:
-
– Works independently on moderately complex work assignments, reviews progress, and evaluates results
– May set priorities and organize work within general guidelines established by supervisor
– May review the work of others to verify accuracy and conformance to required procedures and special instructions
- Communication and Collaboration:
-
– Communicates internally within working unit and the University
– Communicates with external audiences for scheduling/coordination
– May communicate with external audiences for business purposes
– Coaches others in using appropriate strategies for resolving conflict; negotiating reasonable compromises; and proposing and evaluating possible solutions
– Give candid and constructive feedback to others to influence and persuade managers and employees to accept and implement findings and recommendations
Salary Structure
- Comp Grade – 13
- Minimum – $86,300.00
- MidPoint – $107,900.00
- Maximum – $129,500.00
FLSA Exemption Status
Exempt
Minimum Education
Bachelor's Degree
Minimum Experience
6+ years of relevant experience
Equivalency
Or an equivalent combination of education and experience