Likeremote

Subscribe to the latest remote jobs:

  • Likeremote jobs on https://LinkedIn.com/
  • Likeremote jobs on https://telegram.org/
  • Likeremote jobs on Reddit.com
DL

MSSQL Database Admin

Diverse Lynx India
Location not stated
3 months ago
  • T-SQL
  • PowerShell
  • Disaster Recovery
  • Windows Server
  • Active Directory
Not scoredNo CV on file. Upload one and this job gets a score out of 100.Upload CV
  • Responsible for physical database architecture and design, capacity planning, development, performance tuning, implementation, and support of the applications from a database perspective
  • Should have at least 8+ years of experience as a MSSQL Server DBA
  • Conduct T- SQL Code Reviews to ensure coding standards, best practices and avoid potential performance issues
  • Work on Writing custom stored procedures, T-SQL queries , PowerShell scripts , views, and triggers based on requirements for DB maintenance and automate tasks
  • Join bridge SWAT calls to troubleshoot and fix P1(SEV1) and P2 (SEV2) incidents
  • work on performance tuning like provide suggestions to create indexes and tune stored procedures
  • Conduct DB DR Drill activity , ensure to bring the DR site online if any outage at Primary site
  • Troubleshoot recurring problems and fix them permanently
  • Work on writing technical and RCA(Root Cause Analysis) documentation
  • Monitor system's high levels of performance, availability, sustainability and security
  • Analyse, solve, and correct issues in real time
  • Provide suggestions for solutions
  • Refine and automate regular processes, track issues, and document changes
  • Assist developers with query tuning and schema refinement
  • Provide 24x7 support for critical production systems
  • Perform scheduled maintenance and support release deployment activities after hours
  • Should be expertise in handling MSSQL Database Performance Tuning and Optimization (PTO) requests and Incidents
  • Should be expertise in trouble shooting the MSSQL DB performance issues at high level
  • Should be expertise to handle High Availability (HA), Disaster Recovery (DR)
  • Should be expertise in AlwaysOn, Replication, Mirroring and TDS technologies in SQL Server
  • Should be expertise to handle backups, restores and recovery models and day to day work
  • Should be expertise to handling swat calls and on-call support
  • Should have knowledge on Windows server administration, including Active Directory
  • Sense of ownership and pride in your performance and its impact on company's success
  • Critical thinker and problem-solving skills
  • Good Team player

MSSQL Database Admin · Diverse Lynx India

Auto apply with Likeremote