Database Administrator - Anesthesiology

University of California - Los Angeles Health; Los Angeles (CA); On-site; USD 89,000 - 190,000; Full time

Job summary

The University of California, Los Angeles Health Department of Anesthesiology and Perioperative Medicine seeks a Database Administrator and SQL Developer to design, develop, and maintain the Perioperative Data Warehouse (PDW), a SQL-based data warehouse supporting administrative, quality improvement, research, and predictive analytics from UCLA Health's Epic platform.

You will ensure data security and governance, collaborate with faculty and operational leaders, and provide reusable code and ETL

Qualifications

• Bachelor's degree in Computer Science or equivalent combination of education and experience
• 2+ years programming in SQL and related tools and libraries
• Experience with BI tools (SSRS/SSAS/SSIS, Tableau) and relational databases
• Ability to develop reusable and modular code for multiple teams
• Proficient in SSIS package design, deployment, and parameterization
• Experience in programming languages and tools including C#, Python, T-SQL, Reporting Services, XML, and R
• Strong SQL Server, T-SQL, Reporting Services, and SharePoint skills
• Excellent written and oral communication; ability to train users and write manuals
• Ability to work independently and meet deadlines
• Experience with ETL processes and data warehouse concepts
• Strong negotiation and confidentiality skills

Responsibilities

• Design, develop, and maintain the department's SQL-based data warehouse and related documentation
• Ensure data security, governance, and system integrity
• Collaborate with faculty, researchers, and operational leaders on data projects
• Support data integration efforts for multi-center research databases
• Partner with bioinformatics teams to prioritize data requests
• Represent the department in cross-functional discussions on data warehousing
• Provide reusable code and batch processing solutions to support analytics
• Assist with ETL clients and data loading into the warehouse

Skills

SQL development

SSIS

SSRS

Tableau

C# programming

Python

T-SQL

ETL

SharePoint design

Reporting Services

Microsoft Office

Data governance

Communication skills

Education

Bachelor's degree in Computer Science

Master's degree in Computer Science

Tools

SSIS

SSRS

Tableau

SharePoint

SQL Server

MySQL

PL/SQL

Job description

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 - $190,300.00

Qualifications

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