Database Admin III

Database Admin III - PBC

Health Sciences Core Research Facilities - Pennsylvania-Pittsburgh

Evaluates business requirements, creates data ingestion processes and modeling, and supports databases and relevant services. Ensures the quality of operational data by conducting regular audits and maintaining accurate records. Supports data analysts and scientists with research and consulting by providing inventory reports as requested. Maintaining the PBC website to ensure all information is accurate and up to date. Assists with processing monthly billing through the University's billing system (iLab). Performs additional administrative duties and responsibilities as assigned by the supervisor. Working knowledge of common software tools and databases relevant to biospecimens is preferred. Experience with specialized software programs such as MS SQL Server and RStudio are required for this role. Some knowledge of Microsoft Visual Basic is preferred.

Job Summary

Supports multiple more complex services/databases; designs, develops, manages, and maintains databases. Plans and maintains database architecture and reporting. Optimizes database functions and implements integrated architecture and reporting updates. Trains and guides lower-level staff.

Essential Functions

The Pitt Biospecimen Core (PBC) is an institutional resource for collection, processing, and disbursement of biospecimens dedicated to serving the University of Pittsburgh and UPMC Faculty in meeting their research needs. PBC Labs are located at UPMC Presbyterian, UPMC Magee-Womens, UPMC Shadyside and UPMC Children's Hospitals. The PBC is seeking a full-time Data Base Administrator that would be responsible for supporting multiple moderately complex databases by planning, managing, and maintaining database systems, generating and maintaining reports, and troubleshooting database issues. Completing applicable CITI modules to become an honest broker. Calculates monthly metrics for fresh disbursements, collections, and storage accumulation. Provides monthly collection reports to appropriate investigators.

Physical Effort

Sitting and standing for long periods, walking between buildings. Reading small print.

The University of Pittsburgh is an equal opportunity employer / disability / veteran.

Assignment Category

Full-time regular

Job Classification

Staff.Database Administrator III

Job Family

Information Technology

Job Sub-Family

Database

Campus

Pittsburgh

Minimum Education Level Required

Bachelor's Degree

Minimum Years of Experience Required

3

Will this position accept substitution in lieu of education or experience?

Combination of education and relevant experience will be considered in lieu of education and/ or experience requirement.

Additional details about Required Licensure/Certification

NA

Work Schedule

Monday - Friday, 8:30 a.m. - 5:00 p.m., schedule as set with supervisor

Work Arrangement

On-Campus: Teams that work on campus, in an office, or in a lab.

Hiring Range

TBD Based Upon Qualifications

Relocation Offered

No

Visa Sponsorship Provided

No

Background Check

For position finalists, employment with the University will require successful completion of a background check

Child Protection Clearances

Not Applicable

Required Documents

Resume, Cover Letter

Optional Documents

Not Applicable