DL
MSSQL Database Admin
Diverse Lynx India
Location not stated
3 months ago
- T-SQL
- PowerShell
- Disaster Recovery
- Windows Server
- Active Directory
3 months ago
- 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