Penn State Job Catalog

Additional levels that exist for this job profile can be seen below.

The defined natural career progression within or between job profiles.

Database Administration

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.

• 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:

– Advanced Professional

Base Description:

– Completes activities, tasks, and/or projects of a functional nature.

Level Summary:

– Demonstrates proficient and comprehensive knowledge of defined skill areas/applications. Applies knowledge of principles, practices, and procedures of a particular field to decision-making and problem–solving. Works under minimum supervision on varied and sometimes difficult work assignments, conferring with supervisor or subject matter experts on unusual matters. May lead others or a team in completion of complex assignments. Interprets and communicates information clearly, accurately, and persuasively. Researches and tries new approaches when solving difficult or novel problems.

Supervisory Responsibilities:

– Indirect supervisor or mentor 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
– May monitor/track budgets and funding

Problem Solving:

– Encounters generally routine problems with progressively more complex and/or varied problems
– Typically follows recommended course of action and procedures to resolve problems
– May apply specialized knowledge and skills to resolve complex and/or varied problems, with supervisor oversight
– Researches and tries new approaches when solving problems

Independence of Action:

– Works with minimal supervision on more difficult work assignments, conferring with supervisor on unusual matters
– Follows precedents and procedures
– May set priorities and organize work within general guidelines established by supervisor

Communication and Collaboration:

– Communicates internally and externally within working unit and the University
– May communicate with external audiences for business purposes
– Promotes open communication in a manner that builds relationships among team members
– Applies appropriate strategies for managing conflict; negotiate reasonable compromises; propose and evaluate possible solutions
– Interprets and communicates information, ideas and instructions clearly, accurately and persuasively both verbally and in written materials intended for distribution

• Comp Grade – 12
• Minimum – $76,700.00
• MidPoint – $95,900.00
• Maximum – $115,100.00