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 advantage
8. Good in Powershell.
MSSQL DBA + Performance Tuning expert
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools. MSSQL DBA Certification will be added advantage. Troubleshoot and provide advice on SQL Server performance issues and be able to work with application...
MSSQL DBA + Performance Tuning expert
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools. MSSQL DBA Certification will be added advantage. Troubleshoot and provide advice on SQL Server performance issues and be able to work with application...
MSSQL DBA + Performance Tuning expert
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools. MSSQL DBA Certification will be added advantage. Troubleshoot and provide advice on SQL Server performance issues and be able to work with application...
MSSQL DBA - Performance Tuning & Replication
MSSQL DBA </b></p> <p style="margin-bottom:13px"><b>Montreal, QC</b></p> <p style="margin-bottom:13px"><b>Long Term Contract</b></p> <p style="margin-bottom:13px"><b>Experience (Years): 6-10</b&g...
MSSQL DBA(Performance & Tuning) @ Montreal, QC - Long Term
Role : MSSQL DBA(Performance & Tuning)</p> <p>Location : Montreal, QC</p> <p>Duration : Long Term</p> <p> </p> <p>Microsoft SQL Server Database Administrator (MSSQL DBA) + Strong knowledge in Performance & Tuning + Replication</p> <p&...
MSSQL DBA - Performance Tuning & Replication
Role: MSSQL DBA - Performance Tuning & Replication</div> <div> </div> <div>Location : Montreal </div> <div> </div> <div> </div> <div> Microsoft SQL Server Database Administrator (MSSQL DBA) + Strong knowledge in Performance Tuning ...
Analyste automatisation de tests Tosca / Tosca Test automation engineer
Ingénieur d'automatisation de test Tosca. Au nom de notre client dans le secteur du conseil, Procom est à la recherche d'un ingénieur d 'automatisation de test Tosca. Ingénieur d'automatisation des tests Tosca - Description du poste. ...
Senior Data Scientist credit risk modeling
A career as a Senior analytical data scientist within the Credit risk models team involves acting as an expert in credit risk modeling. You will work on developing and deploying models to assess the credit risk of retail and commercial clients of the bank, on combining data with internal credit expe...
Stage - Hiver - Analyste en comptabilité financière / Internship - Winter - Financial Accounting Analyst
What your day to day will look like: Within a dynamic and friendly team, focused on quality and results, participate in preparing financial reports regarding the monthly and quarterly performance of different business segments Prepare monthly general ledger reconciliations Perform journal entries to...
Financial Planning and Finance Analyst
So, if you're looking to do what you love, we could be a perfect match Our expectations Reporting to the Department Manager, the Financial Planning and Analysis Analyst will be responsible for the financial planning and analysis of transportation-related activities. Financial Planning and Finance A...