SQL Server Support Engineer I
Share
Job Location:
Monthly Salary:
Posted on:
Yesterday
Vacancies:
1 Vacancy
Job Summary
Overview:
TekWissen Group is a workforce management provider operating throughout India and several other countries worldwide. The client below is a leading technology company offering a range of IT solutions to businesses and organizations enabling them to transform their digital futures
Position: SQL Server Support Engineer I
Location: Bangalore
Duration: 17 Months
Job Type: Contract
Work Type: Remote
Shift Timings: 5 :30 PM 2:30 AM
Shift Timings: 5 :30 PM 2:30 AM
Job Description:
- 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
- 1 3 years of experience supporting Microsoft SQL Server in a production or mission critical environment.
- 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. AlwaysOn failover clusters) and their operational impact.
- Experience with automation/scripting (PowerShell T SQL jobs) for routine tasks.
- Experience working in ITIL style environments (incident problem change management).
Mandatory Skills
- SQL query writing (SELECT JOINs GROUP BY basic DML)
- SQL Server
- Database maintenance (backup restore)
- DBCC checks
- Performance monitoring (Activity Monitor Profiler Extended Events)
- Database administration (log growth file sizes free space)
- User and permission management
- Stored procedures
- Views
- Functions
- Indexes
- Statistics
- SSRS (report deployment subscriptions data sources)
- SSMS
- Windows Server (services event logs performance counters)
- Incident management
- Troubleshooting
Good-to-Have Skills
- AlwaysOn
- Failover clustering
- PowerShell
- T-SQL scripting
- SQL Agent jobs
- Automation
- ITIL (incident problem change management)
Experience required:
- Total Exp: 8-12Years
- Rel Exp: 5 years
TekWissen Group is an equal opportunity employer supporting workforce diversity.
