Sql Programmer (eb Sql Server Support)_night Shift_remote
- Calsoft
- 8 - 12 years
- Pune
- 2 days ago
- Email to a friend
- Report this job
Job Description
Work Hours and Remote Option
- Shift Timings: 5:30 PM- 2:30 AM IST
- Work Location and Address- Remote
- Experience Range
- Total Exp: 8-12Years
- Rel Exp: 5+ years
- Mandatory Skills (3 must have):
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)
Roles and Responsibilities (JD)
SQL Server Support Engineer I
Role Summary
The SQL Server Support Engineer I is responsible for daytoday support and operational management of SQL Server environments that underpin the Elevation Builder platform. They focus on monitoring, maintenance, incident resolution, and implementing welldefined 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 daytoday 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 OSlevel 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 changemanagement processes
Required Qualifications & Skills
- 8 years of experience supporting Microsoft SQL Server in a production or missioncritical 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 highavailability SQL features (e.g., AlwaysOn, failover clusters) and their operational impact.
- Experience with automation/scripting (PowerShell, TSQL jobs) for routine tasks.
- Experience working in ITILstyle environments (incident, problem, change management).
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Database Developer / EngineerEmployement Type: Full timeContact Details:
Company: CalsoftLocation(s): Pune
Keyskills: T-SQL SSMS Query Optimization Performance Optimization select Views SSRS Sql Querying Join SQL Server Performance Tuning Stored Procedures SQL Profiler Indexing
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in