Description
UPMC is looking for a Senior Database administrator to join their team. This position will be fully remote with the option to work on-site if preferred.
Description
Under the general direction of the team lead and management, this senior level position is responsible for day to support of database systems. This individual works 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. This position will assume On-Call support responsibilities on a rotational basis. DBA administration, tuning and support of large analytics databases. You will also participate in deployment of new cloud data platform and migration from on-prem infrastructure.
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
Qualifications
- Typically has strong IT background with several years of practical experience.
- Proven track record with database supported with typically 5 years of practical experience within the DBA role for the supported platform.
- 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.
Preferred Qualifications
- Experience administering and tuning large data warehouse and complex database application environments.
- Demonstrated experience with data replication and Change Data Capture tools (GoldenGate, HVR).
- Hands on experience with cloud-based data platforms; Snowflake is a huge plus.
Licensure, Certifications, and Clearances:
Act 34
UPMC is an Equal Opportunity Employer/Disability/Veteran
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.