Talent.com
No longer accepting applications
Site Reliability Engineers (SRE) with MSSQL

Site Reliability Engineers (SRE) with MSSQL

Astra North Infoteck Inc.Laval, Qc
30+ days ago
Job type
  • Full-time
Job description

Experience (Years) : 6-8

Essential Skills :

Site Reliability Engineers (SRE) need database platform experience ( MSSQL), service maintenance, monitoring, process automation and incident management skill.

The key focus of this role is upon system reliability, availability, performance, and scalability.

Day to Day Operations :

1] HIGH Priority PROD Ticket Support / Database Outage Handling

2] Weekend Support

3] Change Management

4] Bug Fixes with Microsoft

5] Consultation to Users / other support team / L2 Team

6] Handling Projects ( like DB migration , Host level upgrades / migrations )

7] Script changes

8] Other Technology Support ( like Delphix / HVR / RTDS )

9] L2 Runbook review

10] Medium / Low PROD / Non-PROD Escalation Handling from L1 / L2 team

11] Escalation Reduction / Problem Management

12] Provides Training to L2 / L1 team

Skills Required :

1. Ability to perform day to day database administration tasks with deep understanding of SQL Server internals e.g. Indexing,

partitioning , filestream , Always-On , replication cctv and Mirroring technologies.

2. Troubleshoot and provide advice on SQL Server performance issues and be able to work with application development

teams and provide recommendations.

3. Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related

monitoring and troubleshooting tools

4. Knowledge of relational databases, T-SQL, query execution plans, solving concurrency issues and deadlocks

5. Knowledge of administrating azure SQL databases is an added advantage.

6. Good communication skill and experience to handle P1 / P2 outages.

7. MSSQL DBA Certification will be added advantage8. Good in Powershell.