Server Support Engineer

SQL Server Support Engineer IRole SummaryThe SQL Server Support Engineer I is responsible for day to day support and operational management of SQL Server environments that underpin the Elevation Builder platform. They focus on monitoring, maintenance, incident resolution, and implementing well defined changes under guidance from senior team members.Key ResponsibilitiesWrite and optimize SQL queries for reporting, data extracts, troubleshooting, and minor feature enhancements.Perform routine database maintenance, including:Executing and monitoring database backups and restoresVerifying SQL Server versions, patch levels, and cumulative updates against standardsRunning DBCC checks and basic integrity/health checksSupport day to day SQL Server administration, such as:Managing log growth, database file sizes, and free spaceMonitoring performance using tools like Activity Monitor, Profiler/Extended Events (as directed), and performance dashboardsManaging logins, basic permissions, and users under defined security policiesBuild and maintain database objects under supervision, including:Stored procedures, views, functions, and queriesCreating and updating indexes and statistics based on performance findings and senior guidanceSupport Microsoft SQL Server Reporting Services (SSRS):Deploying and updating reportsManaging data sources and subscriptionsBasic troubleshooting of report failures and performance issuesSupport Microsoft Windows Server environments hosting SQL:Basic OS level checks (CPU, memory, disk space, services)Applying standard OS patches and reboots following runbooksCoordinating with infrastructure teams on incidents and change windowsMonitoring and incident response:Responding to alerts related to SQL availability, performance, backups, and SSRSPerforming initial triage, documenting findings, and escalating when appropriateUpdating tickets and documentation for recurring issues and resolutionsDocumentation & standards:Maintaining runbooks, standard operating procedures, and environment documentationEnsuring changes follow defined change management processesRequired Qualifications & Skills5+ years of experience supporting Microsoft SQL Server in a production or mission critical environment. 8-12 Years experience overall.Solid understanding of:SQL query writing (SELECT, JOINs, GROUP BY, basic DML)Core database objects (tables, views, stored procedures, indexes, statistics)Basic backup/restore concepts (full, differential, log)Familiarity with:Microsoft Windows Server (services, event logs, performance counters)SSMS (SQL Server Management Studio) and standard monitoring toolsSSRS basics (report deployment, subscriptions, data sources)Strong troubleshooting mindset, willingness to learn, and ability to follow detailed runbooks.Good written and verbal communication skills for collaborating with application teams, DBAs, and support staff.Preferred QualificationsExposure to high availability SQL features (e.g., AlwaysOn, failover clusters) and their operational impact.Experience with automation/scripting (PowerShell, TSQL jobs) for routine tasks.Experience working in ITIL style environments (incident, problem, change management).

Apply Now