General Information
| Job Description | DATABASE ADM 4 | Working Title | MSSQL Database Engineer |
|---|---|---|---|
| Job Code | 000597 | Grade | 25 |
| Department Name | Data Base Administration - D02044 | Department Head | Michael Kennedy |
| Supervisor | Jeremy Fisher | Effective Date | 11/22/2021 |
Position(s) Directly Supervised
| Job Code | Title | FTE |
|---|
Generic Scope
| Technical leader with a high degree of knowledge in the overall field and recognized expertise in specific areas; problem-solving frequently requires analysis of unique issues/problems without precedent and/or structure. May manage programs that include formulating strategies and administering policies, processes, and resources; functions with a high degree of autonomy. |
Custom Scope
| Applies advanced database administration concepts and campus/medical center/OP, institutional and/or multi-institutional objectives to resolve highly complex issues of diverse scope where incumbent must assess business needs and technical considerations with minimal direction in order to complete database projects of advanced scope and complexity. Selects methods, techniques and evaluation criteria to obtain results. Implements database solutions from evaluation to implementation of large enterprise level hardware and software. |
Department Custom Scope
| The Microsoft SQL Database Engineer will be responsible for the implementation, configuration, maintenance, and performance of critical MS SQL Server systems to ensure the availability and consistent performance of campus enterprise applications. This position requires solid technical skills, as well as excellent interpersonal and communication skills. The MS SQL Database Engineer will be responsible for the development and sustainment of SQL Server databases and clusters, ensuring operational readiness (security, health and performance), executing data loads, and performing data modeling in support of multiple development teams. Must be capable of working independently and collaboratively. |
Education & Experience Requirements
Education Requirements
| Degree | Requirement |
|---|---|
| Bachelor's degree in related area and/or equivalent experience/training. | Required |
Experience Requirements
| Experience | Requirement |
|---|---|
| 6 - 10 years of related experience. | Required |
License Requirements
Certification Requirements
| Certification | Requirement |
|---|
Educational Condition Requirements
| Condition | Requirement |
|---|
Key Responsibilities
| Description | % Time |
|---|---|
Applies advanced concepts in working on highly complex projects including all aspects of enterprise class database administration, including the management of structured and unstructured content. Initiates, designs and communicates with senior level personnel regarding database administration studies, summary reports and background material including approaches, trends and sources. Interacts with teams of advanced IT professionals as a proactive member. Provides software consulting for database performance and design.
|
35 |
| Implements database solutions from evaluation to implementation of large enterprise level hardware and software. Formulates procedures and standards relating to database management. | 20 |
Develops disaster recovery plans and tests, backup solutions and system security.
|
20 |
| Maintains and manages MS SQL platform including SQL Database, SQL Reporting Services, SQL Analysis Services, SQL Server Integration Services, and PowerBI for various applications and departments on campus. | 15 |
| In partnership with the Systems Engineering and Operations team, perform some systems administration tasks on the underlying operating system that is supporting MS SQL database instances. | 10 |
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 |
| Demonstrated knowledge archictecting, building and managing Microsoft SQL Server clusters in a highly available, fault-tolerant configuration running on a virtualized platform such as VMWare or Hyper-V. | Required |
| Knowledge of conceptual database design. | Required |
| Demonstrates reasoning and ability to develop original ideas to solve problems. | Required |
| Advanced knowledge of database management systems and standards. | Required |
| Has effective written/verbal communication skills. | Required |
| Able to multi-task and prioritize tasks. Ability to work independently on complex technical projects as well as on a team of technical professionals and relevant decision-makers. | Required |
| Advanced database querying and modeling skills working with moderately complex databases. | Required |
| Knowledgeable about professional approaches and relevant standards and technology for management of unstructured data such as text and images. | Required |
| Skills necessary to develop procedures and standards relating to database management systems. | Required |
| Skills associated with implementing database enhancements that improve performance and reliability of the system at the software, hardware and operating system level. | Required |
| Strong security skills for protecting the operating system, software, data and hardware. Technical skills to develop, implement and test disaster recovery functions using backup technologies. | 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 |
| Knowledge of test software code in client server environment. | Required |
| Demonstrated knowledge performing based Windows systems administration tasks. | Required |
| Broad knowledge of the IT environment. | Required |
| Familiarity with power shell or other scripting languages. | Required |
| Knowledge relating to capacity planning and interface specifications. | Required |
| Familiarity with MVC programming frameworks such as Grails, .NET, Java Spring/Hibernate, etc. | Preferred |
| Familiarity with other RDBMS platforms such as Oracle. | Preferred |
Special Requirements & Conditions
| Special Condition | Requirement |
|---|---|
| Must pass a background check. | Required |
| Occasional travel to conferences and systemwide meetings. | Required |
| Travel | Required |
| Travel Outside of Normal Business Hours | Required |
| Must actively participate in an on-call rotation supporting a 24/7 IT operation. | Required |
Other Special Requirements & Conditions
|
|
Level of Supervision Received
| Direction |
Environment
Working Environment
| 100% Remote (Working from Home) with occasional visits to campus. |
Other Requirements
Items Used
|
Physical Requirements
|
Mental Requirements
|
Environmental Requirements
|
Critical Position
| Is Critical Position: Yes |