JOB DESCRIPTION AND POSITION REQUIREMENTS:
The Penn State Office of Budget and Finance, Financial Information Systems team is seeking a Database Specialist 2 to establish and maintain best database design and maintenance practices.
The location of this position is at our University Park Campus. The position can be f ully in-person at our University Park Campus, or in a hybrid model of both in-person and remote. Questions related to the work arrangement should be directed to the hiring manager during the interview process.
The successful candidate will be responsible for the following:
- 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
- Ensure database optimization, database integrity (relational integrity), and integrity of the transaction profile
- Prepare test plans
- Write and maintain documentation
- Work with users and application developers to analyze database requirements and provide recommendations on industry standards and normalization principles
- Investigate data and/or program problems; determine source of problem; take corrective action
- Create database maintenance procedures and backup/restore methods to protect the enterprise data
- Maintain database dictionaries and system level databases, tables, and objects
Typically requires an Associate's Degree or higher plus 2 years of related experience, or an equivalent combination of education and experience.
This position requires:
- Experience with Microsoft SQL Server
- Experience with T- SQL and ability to develop database views, packages and procedures
- Strong interpersonal, communication and collaboration skills
Preferred skills:
- Collaboration with system administration / infrastructure team to ensure platforms are maintained
- Familiarity with the Microsoft Suite of applications
- Experience with SSIS (SQL Server Integration Services)
- Knowledge of programming languages such as DAX and Python
Finance and Business is a values driven organization that supports thousands of university faculty, staff, and students, while also providing services to the broader community and society. The Office of Budget and Finance is part of the Finance and Business team and has a vision to recruit, develop and retain outstanding people who efficiently provide exceptional service in support of Penn State’s teaching, research and public service missions. Our values model those of Penn State's and we firmly believe in the value of Respect, which encourages us to "respect and honor the dignity of each person, embrace civil discourse, and foster a diverse and inclusive community." As an incoming team member in the Office of the Corporate Controller, it will be expected that all employees embody and model Penn State's and Finance and Business's commitment to diversity, equity, and inclusion.
The Pennsylvania State University is committed to and accountable for advancing diversity, equity, inclusion, and sustainability in all of its forms. We embrace individual uniqueness, foster a culture of inclusion that supports both broad and specific diversity initiatives, leverage the educational and institutional benefits of diversity in society and nature, and engage all individuals to help them thrive. We value inclusion as a core strength and an essential element of our public service mission.
CAMPUS SECURITY CRIME STATISTICS:
Pursuant to the Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act and the Pennsylvania Act of 1988, Penn State publishes a combined Annual Security and Annual Fire Safety Report (ASR). The ASR includes crime statistics and institutional policies concerning campus security, such as those concerning alcohol and drug use, crime prevention, the reporting of crimes, sexual assault, and other matters. The ASR is available for review here .
Employment with the University will require successful completion of background check(s) in accordance with University policies.
EEO IS THE LAW
Penn State is an equal opportunity, affirmative action employer, and is committed to providing employment opportunities to all qualified applications without regards to race, color, religion, age, sex, sexual orientation, gender identify, national origin, disability or protected veteran status. If you are unable to use our online application process due to an impairment or disability, please contact 814-865-1473.
Penn State Covid-19 Vaccination or Testing Requirements
Penn State is committed to the health of our local and global communities. As a condition of employment, all employees are required to comply with COVID-19 vaccination or testing requirements. Click on Penn State Covid-19 Vaccination or Testing Requirements to learn about the requirements as well as general COVID-19 information at Penn State.
