Microsoft Cloud Engineer Position Available In Dauphin, Pennsylvania

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
• Location
• : PHEAA Headquarters 1200 North 7th Street, Harrisburg, PA 17102
• Department
• : Enterprise Infrastructure Services 

• 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.
• Perform scheduled 
• Other duties as assigned.

Required SkillsBachelor’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 conclu ions.
• 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

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