MSSQL Database Engineer

03 Nov 2024

Vacancy expired!

Job Description: 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.

Education & Experience RequirementsEducation Requirements

DegreeRequirement

Bachelor's degree in related area and/or equivalent experience/training. Required

Experience Requirements

ExperienceRequirement

6 - 10 years of related experience.Required

License Requirements

Certification Requirements

CertificationRequirement

Educational Condition Requirements

ConditionRequirement

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.

  • The incumbent will manage MS SQL Server instances for third party applications supporting campus departments, databases for the campus portal and databases for in-house developed applications on Grails and .NET.

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.

  • Applies updates and patches for MS SQL Server during regularly scheduled maintenance windows. Arcitects, builds, and manages MS SQL Server clustered databases utilizing SQL Always On.

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/AbilityRequirement

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 ConditionRequirement

Must pass a background check. Required

Occasional travel to conferences and systemwide meetings.Required

TravelRequired

Travel Outside of Normal Business HoursRequired

Must actively participate in an on-call rotation supporting a 24/7 IT operation.Required

Other Special Requirements & Conditions

Level of Supervision Received

Direction

EnvironmentWorking Environment

100% Remote (Working from Home) with occasional visits to campus.

Other RequirementsItems Used

  • Standard Office Equipment
  • Computer
  • Printer
  • Scanner
  • Copier

Physical Requirements

  • Bend : N/A
  • Sit : Constantly
  • Squat : N/A
  • Stand : Occasionally
  • Crawl : N/A
  • Walk : Occasionally
  • Climb : N/A

Mental Requirements

  • Read/Comprehend : Constantly
  • Write : Occasionally
  • Perform Calculations : Frequently
  • Communicate Orally : Constantly
  • Reason & Analyze : Constantly

Environmental Requirements

  • Is exposed to excessive noise : No
  • Is around moving machinery : No
  • Is exposed to marked changes in temperature and/or humidity : No
  • Drives motorized equipment : No
  • Works in confined quarters : No
  • Dust : No
  • Fumes : No

Critical Position

Is Critical Position: Yes

PI149451653

  • ID: #22116625
  • State: California Riverside 92521 Riverside USA
  • City: Riverside
  • Salary: USD TBD TBD
  • Job type: Permanent
  • Showed: 2021-11-03
  • Deadline: 2021-12-07
  • Category: Et cetera