''443702'',''true'',''443702'',''false'',''Submission for the position: DBA/Data Warehouse & Pipeline Architect - (Job Number: 26002465)'',''false'',''443702'',''false'',''true'',''DBA/Data Warehouse & Pipeline Architect'',''SVC HS Information Technology'',''Pennsylvania-Pittsburgh'',''26002465'',''!*!
Health Sciences Research IT is seeking a DBA/Data Warehouse & Pipeline Architect to join our team serving the schools of the health sciences. The candidate will work with other team members and research groups to design pipelines for data ingestion/transformation and implement the designs and execute them. This will be for ingesting thousands of files and others single large files in various formats. They will help support a large number of different research groups on many projects. The candidate will support work with the project teams to understand the data query requirements to optimize query performance with indices/views/functions etc. and be able to create analytic files based on specifications provided. The candidate must understand data warehousing concepts. The candidate will be responsible for DBA functions as well such as permissions, optimization, query optimization, performance monitoring, etc. Our team has a great mix of junior and experienced people.
Required Qualifications
'',''!*!
Required Qualifications Cont
Preferred Qualifications
'',''!*!
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.
'',''!*!
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.
'','''',''!*!
Required skills include experience as a SQL server Database Administrator, strong SQL Server skills with the ability to write advanced queries and stored procedures. Traditional DBA tasks such as performance monitoring and query optimization, security and access management, database maintenance and health management, and database availability and stability are required. Experience with some of the following tools is required: Python, C#, PowerShell, Power BI, SAS, Stata, and web technologies. When working in the cloud, tools such as Azure Synapse, Azure Data Factory, and Microsoft Fabric are used, and an understanding of Spark is desired. Excellent organizational, documentation and communication skills with proficiency in Microsoft Office.
'',''!*!
Required skills include experience as a SQL server Database Administrator, strong SQL Server skills with the ability to write advanced queries and stored procedures. Traditional DBA tasks such as performance monitoring and query optimization, security and access management, database maintenance and health management, and database availability and stability are required. Experience with some of the following tools is required: Python, C#, PowerShell, Power BI, SAS, Stata, and web technologies. When working in the cloud, tools such as Azure Synapse, Azure Data Factory, and Microsoft Fabric are used, and an understanding of Spark is desired. Excellent organizational, documentation and communication skills with proficiency in Microsoft Office.
'',''!*!
Light, Little physical effort. Duties are primarily Sedentary. May be required to move objects up to 25 pounds occasionally.
'',''!*!
Light, Little physical effort. Duties are primarily Sedentary. May be required to move objects up to 25 pounds occasionally.
'',''!*!
The University of Pittsburgh is an equal opportunity employer / disability / veteran.
'',''Full-time regular'',''Full-time regular'',''Staff.Database Administrator III'',''Staff.Database Administrator III'',''Information Technology'',''Information Technology'',''Database'',''Database'',''Pittsburgh'',''Pittsburgh'','''','''',''Bachelor''s Degree'',''Bachelor''s Degree'','''','''',''3'',''3'',''Combination of education and relevant experience will be considered in lieu of education and/ or experience requirement.'',''Combination of education and relevant experience will be considered in lieu of education and/ or experience requirement.'','''','''',''Experience with health datasets is ideal but not required. A bachelor's degree in computer science, Data Science or related area is preferred, or extensive experience as a SQL server Database Administrator including experience writing advanced stored procedures and SQL queries. Bachelor's degree or equivalent experience in a related field (e.g., computer science, information systems, data science, or similar) Three or more years of experience as a SQL Server DBA'',''Experience with health datasets is ideal but not required. A bachelor's degree in computer science, Data Science or related area is preferred, or extensive experience as a SQL server Database Administrator including experience writing advanced stored procedures and SQL queries. Bachelor's degree or equivalent experience in a related field (e.g., computer science, information systems, data science, or similar) Three or more years of experience as a SQL Server DBA'',''2 Days on Campus, 3 Days Remote, On campus for all required meetings'',''2 Days on Campus, 3 Days Remote, On campus for all required meetings'',''Hybrid: Combination of On-Campus and Remote work as determined by the department.'',''Hybrid: Combination of On-Campus and Remote work as determined by the department.'',''TBD Based Upon Qualifications'',''TBD Based Upon Qualifications'',''No'',''No'',''No'',''No'',''For position finalists, employment with the University will require successful completion of a background check'',''For position finalists, employment with the University will require successful completion of a background check'',''Not Applicable'',''Not Applicable'',''Resume'',''Resume'',''Not Applicable'',''Not Applicable'',''false'',''443702'',''443702'',''true'',''443702'',''false'',''Submission for the position: DBA/Data Warehouse & Pipeline Architect - (Job Number: 26002465)'',''false'',''443702'',''false'',''true''