Database Administrator

- Mid Level

Harrisburg, PA

Credit Intermediation and Related Activities

About the position

PHEAA is a nonprofit student aid organization that holds a mission of providing affordable access to higher education. This role provides technical support for database environments Microsoft SQL Server and PostgreSQL and supports the full system life cycle. This position is part of a team of Database Administrators supporting multiple database technologies.

Responsibilities

• Design, develop, and implement databases to meet business requirements.
• Create and maintain database models, entity relationship diagrams, and data dictionaries.
• Ensure data integrity, consistency, and security.
• Install, configure, and maintain database systems.
• Perform database backups, restores, and recovery activities.
• Monitor database performance and availability.
• Plan, coordinate, and execute database upgrades, migrations, and patching.
• Support data export, load, and transformations (ETL).
• Develop monitoring, reporting, and alerting processes.
• Troubleshoot database issues, including performance problems, data corruption, and connectivity issues.
• Maintain accurate and up-to-date documentation of database designs, configurations, and operating procedures.
• Provide technical support to development, IT staff, and end users.
• Develop and generate reports on database performance, security, and compliance.
• Implement and manage database security measures, including access control, authentication, authorization, and encryption.
• Provide database server vulnerability remediation.
• Research, test and install new database related software.
• Perform scheduled maintenance.
• Comply with the Agency's enterprise security and privacy policies and departmental procedures.
• Responsible for documentation, tracking, controlling, & prioritizing open projects.

Requirements

• Bachelor's degree in computer science or related degree and two to five years of experience or the equivalent combination of training, experience, and/or certification(s).
• Ability to create process automations, e.g., automated backups, proactive monitoring and alerting using tools such as: UNIX/Linux shell scripts, Windows Powershell, Python, Ansible, and/or StoneBranch Workload Automation.
• Familiarity with Linux, Windows Server, and AIX Operating Systems.
• Familiarity with Jira or other issue and project tracking tools.
• Use of ITSM Service Management tooling, including Incident, Problem, Change management.
• Understanding or demonstrated use of Public Cloud deployment and operation stacks.
• Familiarity with enterprise/system monitoring tools.

Benefits

• Salary: Grade 16 69,358.00 Commensurate with experience.
• Shift: Monday through Friday 8:00 AM -5:00 PM Hybrid 1 day a week.
• Location: PHEAA Headquarters 1200 North 7th Street, Harrisburg, PA 17102.