DBA & Data Analyst

DATABASE ADM 3 (007177)

UCPath Position ID: 40122530

Position Description History/Status

Approved Date:

10/28/2024 5:40:23 PM

Date Last Edited:

10/28/2024 5:40:21 PM

Last Action Effective Date:

Organization Details

Business Unit (Location):

LACMP

Organization Code:

3100O

Organization:

VC RESEARCH                            

Division Code:

3115D

Division:

OFFICE OF RESEARCH ADMINISTRATION      

Department:

309100 - OFFICE FOR RESEARCH INFORMATION SYSTEMS

Position Details

UCPath Position Number:

40122530

Position Description ID

231852

UC Payroll Title:

DATABASE ADM 3 (007177)

Personnel Program

Professional and Support Staff (PSS)

Salary Grade:

Grade 23

Job Code FLSA:

Exempt

Union Code (Collective Bargaining Unit):

99: Non-Represented (PPSM)

Employee Relations Code:

E: All Others - Not Confidential

Employee Class (Appt Type):

1 - Staff: Contract

Full-Time Equivalent (FTE)

1

SUPERVISION

UCPath Reports to Position Number:

40039659

Reports to Payroll Title:

DATA SYS SUPV 2

UCPath Department Head Position Number:

40039659

Department Head Payroll Title:

INFO SYS MGR 3

GENERAL SUPERVISION - Indicates that the incumbent develops procedures for performance of variety of duties; or performs complex duties within established policy guidelines.

POSITION SUMMARY

Under the direction of the Data Architecture Manager at the Office for Research Information Systems (ORIS), the DBA & Data Analyst is responsible for overseeing the operation of database systems for campus-wide applications related to research administration. The DBA & Data Analyst's role is to ensure that application development follows our organizational standards and practices, research and develop improvements to these standards, introduce new technologies to the organization, and manage central resources such as databases and identity management. The DBA & Data Analyst is responsible for working with application developers on ensuring that application architectures and data models are consistent with sound design practices and adhere to internal convention. Incumbent will manage database resources and review database audits and system logs. The DBA & Data Analyst is also responsible for following database policies and procedures to ensure the integrity and availability of databases and their accompanying applications. Other responsibilities may include assisting with application integration of single-sign-on or identity/access management solution, facilitating cloud/PaaS integration of applications, developing reports and business-friendly data "views" or other interpolations of data across multiple sources for business users. Must be able to communicate well with staff at all levels of the organization, work effectively with little supervision in a 24x7 operational environment.

Application Development and Architectural Support

1. Document models for new database development and/or changes to existing ones through data flowcharting. 2. Analyze transactional application data requirements and work with team to design table models and relational data architectures to best meet application needs. 3. Work with application developers and peer architects on data access layer development to facilitate adherence of data access layer to data design requirements. 4. Adjust data models to take advantage of native data access support by adhering to standard naming conventions and best practices. 5. Review application designs to ensure adherence to best/standard practices. 6. Ensure applications are properly leveraging existing services and resources. 7. Assist with configuration and management of central application resources such as application host clusters and single-sign-on. 8. Assist with transitioning applications from local dedicated hosting to service platforms, i.e. cloud implementations.

40%

Data Analysis and Warehousing

1. Facilitate data warehouse development by analyzing application data sources and designing data staging tables to import data into warehouse as directed. 2. Work with business stakeholders and business relationship managers to provide end-user accessible warehouse data, such as in SSAS cubes.

30%

Database Monitoring and Operational Support

1. Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements. 2. Create and document models for new database development and/or changes to existing ones through data flowcharting. 3. Respond to and resolve database access, backup and recovery, and performance issues. 4. Advise on the allocation of physical data storage for database systems. 5. Perform database transaction and security audits.

20%

Reports Development and Data Access Support

1. Analyze user requirements for reports, forms, queries, and data extraction. 2. Develop and deploy end-user practices and tools for data extraction, queries, and data manipulation in accordance with business processes.  3. Provide end-user training as necessary with regards to the effective and efficient use of database tools and resources.

10%

•

Performs other duties as assigned.

•

Complies with all policies and standards.

•

Complies with the University of California, Los Angeles (UCLA) Principles of Community.

•

This position description is not intended to be a complete list of all responsibilities, duties or skills required for the job and is subject to review and change at any time, with or without notice, in accordance with the needs of the organization.

QUALIFICATIONS

Bachelor's Degree

Bachelor's degree in the field of computer science or related field; or equivalent combination of education and work experience.

Required

Five to seven years developing data-driven applications, database modeling, or SQL development.

Required

Good interpersonal, written, and oral communication skills including strong technical documentation skills and the ability to present ideas in user-friendly language.

Required

Able prioritize and execute tasks in a high-pressure environment with minimal direction/input from supervisor.

Required

Able to participate in adjusted shifts for after-hours maintenance on a semi-weekly basis.

Required

Strong customer service focus and experience working directly with non-technical customers and end-users.

Required

Experience working in an IT advisory, design, consulting, or architectural role.

Required

Expert knowledge of database structures, principles, and practices or of data-driven application design.

Required

Functional understanding of reporting and query tools and practices.

Required

Expert knowledge of SQL query development, data modeling tools, and query performance improvement.

Required

Strong understanding of IT security and data privacy principles, including experience working under at least one of the following regulatory or compliance regimes: HIPAA, FERPA, PCI, SOX.

Required

Hands-on database tuning and troubleshooting experience.

Preferred

Experience with the Microsoft Visual Studio IDE or similar and development in object-oriented programming, especially C#.NET CLR 4, strongly preferred.

Preferred

Experience developing web applications and understanding of architectural aspects of modern web applications such as MVC and RESTful services preferred.

Preferred

Strong understanding of data warehousing principles and ETL development and support.

Preferred

Hands-on experience supporting and developing SQL in MS-SQL 2012 or data access layers in .NET 4.0 or newer (e.g. Entity Framework).

Preferred

Working knowledge of identity and access management principles and at least one single-sign-on framework or protocol (e.g. SAML, Shibboleth, ADFS, OpenID).

Preferred

Experience working in higher education or the public sector.

Preferred

SPECIAL REQUIREMENTS AND/OR CONDITIONS OF EMPLOYMENT

Background Check: Continued employment is contingent upon the completion of a satisfactory background investigation.

Live Scan Background Check: A Live Scan background check must be completed prior to the start of employment.

LOCATION AND PHYSICAL, ENVIRONMENTAL, MENTAL (PEM) REQUIREMENTS

Environment and Work Location Information

Environment Type:

Non-Clinical Setting

Location Setting:

Campus

Location:

Los Angeles

Standing/Walking

X

Sitting

X

Bending/Stooping

X

Squatting/Kneeling

X

Climbing

X

Lifting/Carrying/Push/Pull 0-25 lbs

X

Lifting/Carrying/Push/Pull 26-50 lbs

X

Lifting/Carrying/Push/Pull over 50 lbs

X

Physical requirements other

X

Sustained attention and concentration

X

X

Complex problem solving/reasoning

X

X

Ability to organize & prioritize

X

X

Communication skills

X

X

Numerical skills

X

X

Mental demands other

X

X

Classification 3:  Position in which exposure to blood, body fluids or tissues is not part of the position description. The normal routine task involves no exposure to blood, body fluids or tissues and the employee can decline to perform tasks which involve a perceived risk without retribution.