SQL Server Support Engineer I
Role Summary
The 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 Responsibilities
Write and optimize SQL queries for reporting, data extracts, troubleshooting, and minor feature enhancements.
Perform routine database maintenance , including:
Executing and monitoring database backups and restores
Verifying SQL Server versions , patch levels, and cumulative updates against standards
Running DBCC checks and basic integrity/health checks
Support day to day SQL Server administration , such as:
Managing log growth , database file sizes, and free space
Monitoring performance using tools like Activity Monitor, Profiler/Extended Events (as directed), and performance dashboards
Managing logins , basic permissions, and users under defined security policies
Build and maintain database objects under supervision, including:
Stored procedures , views , functions , and queries
Creating and updating indexes and statistics based on performance findings and senior guidance
Support Microsoft SQL Server Reporting Services (SSRS) :
Deploying and updating reports
Managing data sources and subscriptions
Basic troubleshooting of report failures and performance issues
Support Microsoft Windows Server environments hosting SQL:
Basic OS level checks (CPU, memory, disk space, services)
Applying standard OS patches and reboots following runbooks
Coordinating with infrastructure teams on incidents and change windows
Monitoring and incident response :
Responding to alerts related to SQL availability, performance, backups, and SSRS
Performing initial triage, documenting findings, and escalating when appropriate
Updating tickets and documentation for recurring issues and resolutions
Documentation & standards :
Maintaining runbooks, standard operating procedures, and environment documentation
Ensuring changes follow defined change management processes
Required Qualifications & Skills
5+ 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 tools
SSRS 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 Qualifications
Exposure to high availability SQL features (e.g., Always On, failover clusters) and their operational impact.
Experience with automation/scripting (Power Shell, TSQL jobs) for routine tasks.
