At UPMC, we are committed to keeping our community safe and healthy as the COVID-19 pandemic unfolds. As our team continues to provide Life Changing Medicine to our patients, our recruiters will continue to fill positions throughout this time. 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.

UPMC Life Changing Medicine
Search Our Jobs

   Current UPMC employees must apply in HR Direct

Database Administrator - Senior

  • Job ID: 054753093
  • Status: Full-Time
  • Regular/Temporary: Regular
  • Hours:
  • Shift: Day Job
  • Facility: Corporate Information Services
  • Department: HCMS IT
  • Location: 415 West 17th Street, Cheyenne WY 82001
  • Union Position: No
  • Salary Range: $38.70 to $62.83 / hour

Description

UPMC's HCMS Group, based in Cheyenne, Wyoming, is seeking a DBA/Database Administrator with database development expertise who will be responsible for designing, developing and maintaining OLAP and OLTP databases and data models.  DBA work will include designing, optimizing and maintenance of Oracle databases. Development work includes analysis, design, test and development of data extract, transform, and load processes within the enterprise data warehouse environment. Additional responsibilities include scripting for database modifications, builds/refresh processes, query tuning and assisting application developers in data manipulation. Requirements include knowledge of Oracle databases, SQL Server or similar RDBMS, PL/SQL or similar scripting language and proficient in SQL. Proficiencies in multiple platforms is a plus.

This is currently a remote position with the option of candidate relocating in the distant future.

Responsibilities:

 

  • Customer Service - Maintains 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 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

  • Bachelor’s degree in Computer Science, Management Information Systems/Computer Information Systems, or closely related field
  • 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.
  • Driven to continually self-learn, learning new features of the RDBM software and understand DBA role and expectations of 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.
Requirements: 
  • OLTP and DSS Data Models
  • Oracle Database Administration
  • SQL Server or similar RDBMS, PL/SQL or similar scripting language and proficient in SQL, analysis, design, test
  • Linux
  • Data Modeling/Development
  • Structured and Non-Structured Data

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) and 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 &emdash; 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

Talent Network