Database Administrator - Anesthesiology at UCLA Health

Job description

Join the Department of Anesthesiology and Perioperative Medicine and play a key role in advancing perioperative analytics through the continued growth of our Perioperative Data Warehouse (PDW), a custom SQL data warehouse that supports administrative, quality improvement, research, and predictive analytics initiatives using data from UCLA Health's Epic platform. Reporting to the Director of Operations and Chief Data Architect for the Center of Excellence for Perioperative Analytics, you will provide database development, technical, and analytical expertise while collaborating with faculty, researchers, and operational leaders. As a Database Administrator and SQL Developer, you will design, develop, and maintain the department's SQL-based data warehouse, including queries, stored procedures, functions, and supporting documentation. You will help ensure data security, compliance, and system integrity; partner with faculty and staff to support research, operational, and quality improvement initiatives; collaborate with bioinformatics teams to evaluate and prioritize data requests; support multi-center research databases and data integration efforts; and represent the department in cross-functional discussions related to data governance, system enhancements, and warehouse expansion. This is an excellent opportunity for a data professional who is passionate about building innovative solutions that advance research, improve patient care, and support operational excellence. Note: Skills may be subject to testing. Annual Salary Range: $88,900.00 - $1 90,300.00 Required: • Bachelor’s degree in Computer Science and/or an equivalent combination of education and experience • 2+ years of programming experience in SQL and other languages, tools, and libraries • Business Intelligence (SSRS 2008/2005, SSAS, SSIS, DTS, Tableau) • Relational Databases (SQL Server, Access, MySQL, PL SQL) • Ability to develop reusable and modular code to be shared among development teams. Experience in application development, integration, and support across a variety of relational databases. • SSIS developer skills • Design and create MS SSIS packages. Having experience in using most of the tasks in SSIS. • Defining Variables and Parameters and incorporating them into Expressions within tasks • Deploy packages using Project deployment and Environment by connecting them to Project parameters • Programming experience in multiple languages and tools, including C#, Python, T-SQL, Reporting Services, Data Transformation Services and Integration Services, Visual Studio, Adobe Acrobat, and XML, R. • Proficiency in SQL Server, T-SQL programming, Reporting Services, and SharePoint: design tables and indexes, design and deploy T-SQL queries, functions, store procedures, reports, and SharePoint sites • Expertise in MS Word, Excel, PowerPoint, Access, email communications and protocols, and communication software. • Ability to work independently when/as necessary, including adherence to deadlines and seeking appropriate guidance when issues/roadblocks occur. • Demonstrated written and oral communication skills sufficient to write user manuals, make oral presentations, and train users. • Ability to analyze complex technical and administrative information to identify relevant concerns, to recognize alternatives, to formulate logical and objective conclusions, and to communicate these with users and management. • Ability to analyze complex technical and administrative information to identify relevant concerns, to recognize alternatives, to formulate logical and objective conclusions, and to communicate these with users and management. • Ability to establish and maintain a cooperative working relationship with supervisor and co-workers. • Ability to work independently with minimal supervision, including ability to stay on task and seek appropriate guidance when necessary. • Ability to work with ETL clients to import data into and maintain the data warehouse; • Skills in negotiation – exchanging ideas, information, and opinions with others to formulate procedures and/or arrive jointly at decisions, conclusions, or solutions. • Ability to maintain confidentiality at all times. Preferred: • Master’s degree in Computer Science and/or an equivalent combination of education and experience Note: Skills may be subject to testing As a condition of employment , the final candidate who accepts an offer of employment will be required to disclose if they have been subject to any final administrative or judicial decisions within the last seven years determining that they committed any misconduct; or have filed an appeal of a finding of substantiated misconduct with a previous employer. Current/former UC employees are subject to a personnel file review.

Requirements

Must-haves

Note: Skills may be subject to testing.
Bachelor’s degree in Computer Science and/or an equivalent combination of education and experience
2+ years of programming experience in SQL and other languages, tools, and libraries
Business Intelligence (SSRS 2008/2005, SSAS, SSIS, DTS, Tableau)
Relational Databases (SQL Server, Access, MySQL, PL SQL)
Ability to develop reusable and modular code to be shared among development teams. Experience in application development, integration, and support across a variety of relational databases.
SSIS developer skills
Design and create MS SSIS packages. Having experience in using most of the tasks in SSIS.
Defining Variables and Parameters and incorporating them into Expressions within tasks
Deploy packages using Project deployment and Environment by connecting them to Project parameters
Programming experience in multiple languages and tools, including C#, Python, T-SQL, Reporting Services, Data Transformation Services and Integration Services, Visual Studio, Adobe Acrobat, and XML, R.
Proficiency in SQL Server, T-SQL programming, Reporting Services, and SharePoint: design tables and indexes, design and deploy T-SQL queries, functions, store procedures, reports, and SharePoint sites
Expertise in MS Word, Excel, PowerPoint, Access, email communications and protocols, and communication software.
Ability to work independently when/as necessary, including adherence to deadlines and seeking appropriate guidance when issues/roadblocks occur.
Demonstrated written and oral communication skills sufficient to write user manuals, make oral presentations, and train users.
Ability to establish and maintain a cooperative working relationship with supervisor and co-workers.
Ability to work independently with minimal supervision, including ability to stay on task and seek appropriate guidance when necessary.
Ability to work with ETL clients to import data into and maintain the data warehouse;
Skills in negotiation – exchanging ideas, information, and opinions with others to formulate procedures and/or arrive jointly at decisions, conclusions, or solutions.
Ability to maintain confidentiality at all times.

Nice-to-haves

Master’s degree in Computer Science and/or an equivalent combination of education and experience
Note: Skills may be subject to testing
Current/former UC employees are subject to a personnel file review.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlpython

Platform: avature
Effort: medium

Benefits

Benefits detected in the listing.

Vision