At UPMC, we are committed to keeping our communities safe and healthy as the COVID-19 pandemic unfolds.

Our recruiters will continue to fill positions throughout this time, but interviews and other processes may be modified to protect the safety of our candidates and employees. Thank you for your patience.

For more information about UPMC's response to COVID-19, please visit upmc.com/coronavirus.

Search Our Jobs

   Current UPMC employees must apply in HR Direct

Database Administrator (Oracle) - Senior

  • Job ID: 993523062
  • Status: Full-Time
  • Regular/Temporary: Regular
  • Hours:
  • Shift: Day Job
  • Facility: Corporate Information Services
  • Department: Database Admin IT
  • Location: 3600 Forbes Ave, Pittsburgh PA 15213
  • Union Position: No
  • Salary Range: $38.70 to $62.83 / hour

Description

UPMC's Enterprise Technology Services Division is hiring a Senior Database Administrator for their Oracle DBA team. The Oracle DBA team provides day-to-day management of the Oracle database management system for critical enterprise applications.

This individual will work independently with minimal supervision to maintain systems to supported levels, identifies and resolves complex issues that may arise with the database software, and aids junior staff as needed. Responsibilities include but not limited to installing and configuring, performance tuning, refresh/recovery of databases, and partnering with application owners and managers across multiple groups within UPMC. This position will assume on-call support responsibilities on a rotational basis.

If you are looking to join a dynamic team with great career progression, we encourage you to apply today!

Responsibilities:

  • Customer Service - Maintains a professional relationship with application owner/teams, provide support as needed. Facilitate a productive dialogue relative to the success of the services provided.
  • Auditing - Respond to requests from Internal Audit, external auditors as directed and SOX requirements.
  • Scripting - strong understanding of OS-based scripting, writes, enhances & debugs scripts that automate and orchestrate DBA-related tasks.
  • Project Management - Complete DBA-related tasks as they are associated with the application team and initiatives of the project.
  • Self-Development - Continual self-learning to master most all administrative tasks.Strong understanding of the architecture of the RDBMS platform and how various components can impact the system from availability to performance.
  • Database Management - Support multiple implementations at various support levels. Install, configure and provide day-to-day support after implementation, including off-hours as needed. Strong understanding of database design and query strategy to provide suggestions for optimal performance. Quickly learns the new features of RDBMS and becomes proficient at implementing those options or features as they become available with minimal direction. Involved with review, analysis and implementation of additional 3rd party software solutions and database add-on solutions when required.
  • Maintenance - Works closely with the application team to maintain systems with routine maintenance and patching as outlined by the RDBMS vendor through major and minor upgrades in a timely fashion as they are released.
  • Performance Tuning - Performs performance/Health Checks on systems as needed or as requested by Management.Strong understanding of database design and query strategy to advise customers on optimal database performance.
  • Expertise - Go To resource or resident expert on at least one component of the database platform or infrastructure the RDBMS is hosted on.
  • Mentoring - Mentors junior members of the team.
  • Infrastructure - strong understanding of the operating system, networking and other underlying components of the infrastructure as it relates to the RDBMS supported.
  • Troubleshooting - Respond to tickets and other notifications of issues. Resolves the more complex issues that arise, determining the cause of the database problem, determine a solution and implement the appropriate actions to correct.
  • Recovery - strong understanding of advanced business continuity and disaster recovery options for supported RDBMS. Clearly communicates available options to application teams with minimal supervision.

Qualifications

  • Proven track record with database supported with typically 5 years of practical experience within the DBA role for the supported platform.
  • Typically has strong IT background with several years of practical experience.
  • Strong understanding of security principles and implements roles appropriately.
  • Supports the mission-critical systems effectively & efficiently.
  • Strong knowledge of query language.
  • Takes initiative frequently and driven to continually self-learn, learning new features of the RDBM software, and understand the DBA role and expectations of the position.
  • Works independently with application teams, understands application requirements in turn uses sound judgment and provides direction to the application team in support of those requirements, contributes to team efforts regularly.
  • Proficient in communication with customers, peers, and management.
Preferred Qualifications:
  • Candidates should have experience with the following: 
    • Oracle Versions – 12.1, 12.2, 18c, 19c 
    • AIX and Red Hat (RHEL) Operating Systems including OS Scripting 
    • Oracle Enterprise Manager 
    • RMAN, RAC, Active Data Guard 
Nice To Have Skills:
  • Multi-tenant 
  • Performance Tuning/Diagnostics 
  • VMWare understanding and knowledge 
  • Python 
  • Ansible 
  • Power Bi 
This is a remote position with workspace available if needed in Pittsburgh, PA

Licensure, Certifications, and Clearances:

UPMC is an Equal Opportunity Employer/Disability/Veteran
UPMC has a Center for Engagement and Inclusion that is charged with executing leading-edge and next-generation diversity strategies to advance the organization’s diversity management capability and its national presence as a diversity leader. This includes having Employee Resource Groups, such as Women in Information Technology (WIT), Female Leadership Innovation and Growth in Health Care & Technology (FLIGHT), or PRIDE Health, that support the implementation of our diversity strategy.

Total Rewards

More than just competitive pay and benefits, UPMC’s Total Rewards package cares for you in all areas of life — because we believe that you’re at your best when receiving the support you need: professional, personal, financial, and more.

Our Values

At UPMC, we’re driven by shared values that guide our work and keep us accountable to one another. Our Values of Quality & Safety, Dignity & Respect, Caring & Listening, Responsibility & Integrity, Excellence & Innovation play a vital role in creating a cohesive, positive experience for our employees, patients, health plan members, and community. Ready to join us? Apply today.

   Current UPMC employees must apply in HR Direct