Database Administrator - Anesthesiology

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

Pay range: $88900.00 - $190300.00 a year

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