Database Administrator Harrisburg, PA

Pennsylvania Higher Education Assistance Agency; Harrisburg (Dauphin County); Hybrid; USD 65,000 - 90,000; Full time

Job summary

Join a nonprofit mission-driven organization as a Database Administrator at a leading education assistance agency. This role involves providing technical support across Microsoft SQL Server and PostgreSQL environments, implementing database solutions, and ensuring database performance and security. The position offers a collaborative environment with opportunities for professional growth.

Qualifications

• Bachelor’s degree in computer science or related field.
• 2-5 years of experience in database management.
• Experience with Microsoft SQL Server and PostgreSQL.

Responsibilities

• Maintain existing databases including performance monitoring and troubleshooting.
• Manage database structure, backup, and recovery.
• Collaborate with IT personnel and manage projects.

Skills

Database Management

Troubleshooting

Analytical Skills

Communication

Problem Solving

Education

Bachelor’s degree in computer science or related degree

Tools

Microsoft SQL Server

PostgreSQL

Job description

PHEAA is a nonprofit student aid organization that holds a mission of providing affordable access to higher education.

Give back tomorrow by joining us today!

Salary: Grade 16, Commensurate with experience

Shift: Monday through Friday 8:00 AM -5:00 PM Hybrid 1 day a week

JOB PURPOSE AND SUMMARY

This role provides technical support for database environments Microsoft SQL Server and PostgreSQL and supports the full system life cycle. This position performs at a moderate level of complexity with a high level of proficiency under general supervision. This position is part of a team of Database Administrators supporting multiple database technologies in both on-premises and cloud environments.

PRIMARY DUTIES AND RESPONSIBILITIES

Database and System Administration

• Maintain existing databases by investigating factors such as storage requirements, access time, input/output frequencies, and unusual problems encountered by applications/systems analyst.

• Perform moderately complex database design tasks related to the establishment of the structure of a database including analysis, logical data model review, and physical database design.

• Maintain and manage database structure, backup and recovery, data propagation (replication), and performance monitoring/tuning.

• Research, recommend and implement new technologies, skills, and methods to proactively manage databases.

• Determine table attributes, primary, and alternate keys for multiple databases.

• Install and upgrade software to enhance database performance.

• Monitor database activity and file usage.

• Troubleshoot root cause of database issues and recommend solutions or workaround.

• Implement database monitoring procedures to maximize availability and performance of the database.

• Interact with Agency staff as necessary and appropriate to participate in and/or organize projects that are short/long term.

• Collaborate with third party vendors to review installation prerequisites, database sizing, and support database installation of the product.

• Collaborate with the Infrastructure Administration groups to define and request database servers.

Project Management and Communication

• Database Administrator for projects of varying complexity

• Partner with other Information Technology (IT) personnel within the department units, functional users and vendors to provide guidance, manage project implementation or users’ support.

• Participate and/or take a lead role with the infrastructure and database configurations, changes, and/or upgrades that are moderately complex in nature with a high level of proficiency.

• Test and ensure that systems and databases are developed and implemented according to all published standards.

OTHER DUTIES AND RESPONSIBILITES

• Responsible for documentation, tracking, controlling, & prioritizing open projects.

• Comply with the Agency’s enterprise security and privacy policies and departmental procedures.

• Research, test and install new database related software.

• Other duties as assigned.

Required Skills

Bachelor’s degree in computer science or related degree and two to five years of experience any relevant combination of training, experience, and/or certification(s).

• Experience with Microsoft SQL Server and PostgreSQL.

• Working knowledge and application of database concepts.

• Competent skills to debug and dig deeply into one specific task to uncover root cause and provide solution(s).

• Hands on experience with a Database Management System (DBMS).

• Demonstrated intermediate experience in physical data modeling, database design principals, programming.

• Track record analyzing moderately complex information to draw alternative conclusions.

• Proven ability to learn and support new hardware, software and operating systems and apply innovative business solutions.

• Effective communication skills necessary to make yourself understood when speaking about complex technical subjects.

• Demonstrated knowledge of development of a data strategy and associated policies.

• Ability to plan, organize and work on multiple tasks simultaneously.

ESSENTIAL DUTIES AND RESPONSIBILITIES

PHYSICAL REQUIREMENTS AND WORK ENVIRONMENT

• This position requires participation in a 24x7x365 on-call rotation. The frequency of the rotation depends on the number of members in the team. On-call requires carrying a cellphone and responding to calls within the agreed upon timeframe set within PHEAA’s standards. Internet connectivity from home is required as part of the on-call rotation.

• Perform work required for this position in an office environment and/or via remote or hybrid arrangement.

• Flexible for occasional off-site travel required.

• Sedentary work (office environment).

• Frequently requires – repetitive motions (substantial movements of the wrist, hand, and/or fingers).

• Must be able to use a personal computer.

ADDITIONAL KNOWLEDGE, SKILLS, AND ABILITIES

• Developed problem solving skills and the ability to focus attention on details.

• Demonstrated analytical, critical thinking, and organizational skills.

• Ability to work accurately, efficiently and concentrate for long periods of time in a detailed environment.

• Demonstrated experience working on strategy database projects.

• Ability to influence proper architecture decisions to meet strategic architecture vision.

• Possess strong written and verbal communication skills.

• Ability to work effectively in a team environment.

• Ability to promote and support a consistent, professional, and customer focus.

PHEAA’s environment welcomes and supports our employees, customers, and stakeholders; we seek out and value differing perspectives and contributions.

Required Experience

Bachelor’s degree in computer science or related degree and two to five years of experience any relevant combination of training, experience, and/or certification(s).