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:

– Principal Professional

Base Description:

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

Level Summary:

– Displays mastery of defined skill areas/applications, principles, theories and practices. Evaluates and enhances existing practices. Recognizes emerging trends in area of expertise. Works independently on complex or strategic assignments. Directs and delegates appropriate tasks to others. Implements strategies to ensure achievement of initiatives. Prepares written and/or verbal presentations or proposals on complex issues and deliver to broad audiences. Identifies and implements innovative solutions to important, highly complex 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:

– Validates and pays invoices
– Monitors and tracks budgets and funding
– May plan and forecast budgets

Problem Solving:

– Encounters complex and novel problems
– Applies policies, practices, specialized knowledge, and skills to resolve problems
– Understands benefits, limitations, and impact of potential solutions
– Anticipates potential problems and recommends possible solutions within general guidelines

Independence of Action:

– Works independently on complex or strategic assignments
– Uses existing practices as guidelines as well as working knowledge to determine specific work methods
– Carries out work activities independently, with supervisor available to resolve problems
– Reviews work of others to verify technical soundness

Communication and Collaboration:

– Communicates with both internal and external audiences
– Collaborates closely with team members and area leads across the University
– Prepares written and/or verbal presentations or proposals on complex issues and delivers to a broad variety of audiences
– Establishes and maintains networks to facilitate successful communication among units

• Comp Grade – 14
• Minimum – $97,100.00
• MidPoint – $121,400.00
• Maximum – $145,700.00