General Information
| Job Description | DATABASE ADM 3 | Working Title | Database Design Engineer |
|---|---|---|---|
| Job Code | 007177 | Grade | 23 |
| Department Name | Undergrad Medical Ed - D02005 | Department Head | Simon Linwood |
| Supervisor | Armando Gauna | Effective Date | 02/21/2023 |
Position(s) Directly Supervised
| Job Code | Title | FTE |
|---|
Generic Scope
| Experienced professional who knows how to apply theory and put it into practice with in-depth understanding of the professional field; independently performs the full range of responsibilities within the function; possesses broad job knowledge; analyzes problems/issues of diverse scope and determines solutions. |
Custom Scope
| Applies database skills as a seasoned, experienced professional with a full understanding of database administration functions. Applies professional concepts, industry standards and best practices in maintaining databases. Demonstrates functional proficiency/fluency. Demonstrates competency in selecting methods and techniques to obtain solutions. |
Department Custom Scope
| Reporting to the Chief Technology Officer (CTO) and the UME and SA leadership, The Database Design Engineer will be responsible for laying down the foundation of all data and its architecture for all Undergraduate Medical Education (UME) and Student Affairs (SA) applications. This position will work closely with the Undergraduate Medical Education and Student Affairs departments, Office of Information Technology, and other departments to maximize the reporting for the Banner (student information system) system and other curriculum applications. The main focus is data design, data integration, and data reporting. Assesses a wide range of data requirements and applies relevant database techniques to create a robust architecture. After periodic intervals, they will also test to identify bugs or performance issues. Responsible for maintaining the database and ensuring it works smoothly without causing any disruption. |
Education & Experience Requirements
Education Requirements
| Degree | Requirement |
|---|---|
| Bachelor's degree in related area and/or equivalent experience/training. | Required |
Experience Requirements
| Experience | Requirement |
|---|---|
| 4 - 7 years of related experience. | Required |
License Requirements
Certification Requirements
| Certification | Requirement |
|---|---|
| Microsoft Certified Database Administrator (MCDBA) | Preferred |
| Developing Microsoft SQL Server 2012/2014 Databases | Preferred |
| Google Looker Business Analyst Certificate | Preferred |
| Google Certified Professional Data Engineer | Preferred |
| Azure Data Engineer Certification | Preferred |
| AWS Certified Big Data - Specialty | Preferred |
Educational Condition Requirements
| Condition | Requirement |
|---|
Key Responsibilities
| Description | % Time |
|---|---|
Works on moderately complex databases with appropriately normalized data structures using intermediate level database design and software techniques such as views, triggers and stored procedures. Resolves procedural and technical issues in the context of department policies and procedures. Works on database-related issues and projects of diverse scope, taking into account business practice and technical considerations and applying defined IT procedures and practices to database projects.
|
50 |
Implements performance tuning techniques including indexes and advanced SQL syntax. Proposes and implements enhancements that will improve the performance and reliability of the system. Applies database administration concepts to perform complex analysis and provides analysis for complex project, issues and concerns.
|
20 |
| Establishes and maintains security and integrity controls. Monitors policies, procedures and standards relating to database management. | 20 |
| Other duties as assigned. | 5 |
| Applies project and program management practices. | 5 |
Knowledge, Skills & Abilities
| Knowledge/Skill/Ability | Requirement |
|---|---|
| Demonstrates interpersonal skills, problem solving skills, service orientation, active listening, effective verbal and written communication skills and organizational skills. | Required |
| Advanced database querying and modeling skills working with moderately complex databases. | Required |
| Knowledge relating to database system design. | Required |
| Working knowledge of database management systems and standards. | Required |
| Has effective written/verbal communication skills. | Required |
| Knowledgeable about professional approaches and relevant standards and technology for management of unstructured data such as text and images. | Required |
| Knowledge relating to capacity planning and interface specifications. | Required |
| Demonstrates reasoning and ability to develop original ideas to solve problems. | Required |
| Able to multi-task and prioritize tasks. | Required |
| Demonstrates good judgment and decision-making; problem identification and resolution; identifying measures of system performance and the actions to improve performance through application configuration and programming techniques. | Required |
| Experienced/Advance knowledge of SQL, NoSQL | Required |
| Knowledge of Data warehouse | Required |
| Knowledge of Data modeling | Required |
| ETL (extra, transform, load) knowledge | Required |
| Knowledge of Amazon Web Services (AWS) S3 / Microsoft Azure /GCP | Preferred |
| Understanding the basics of distributed systems | Preferred |
| Knowledge of algorithms and data structures | Preferred |
| Knowledge of software development | Preferred |
Special Requirements & Conditions
| Special Condition | Requirement |
|---|---|
| Must pass a background check. | Required |
Other Special Requirements & Conditions
|
|
Level of Supervision Received
| General Supervision |
Environment
Working Environment
| Campus |
Other Requirements
Items Used
|
Physical Requirements
|
Mental Requirements
|
Environmental Requirements
|
Critical Position
| Is Critical Position: Yes |