MS SQL Database Administrator
Posted Updated 16
views
Summary
SQL Server database administrator at Vensure, working from the office in Hyderabad, Noida, or Thiruvananthapuram on a 5:30 PM–2:30 AM shift. Day-to-day involves performance tuning, backups and recovery, encryption (TDE, Always Encrypted), high availability (AlwaysOn, Windows clustering), monitoring, and on-call production support.
Location: Hyderabad / Noida / Thiruvananthapuram
Experience: 5+ Years
Shift: 5:30 PM - 2:30 AM
Work Mode: Work from Office (Monday to Friday)
Responsibilities :
Configure and maintain database servers and processes, including monitoring of system health and performance to ensure high levels of performance, availability and security
Troubleshoot and resolve performance issues
SQL Server performance tuning, including analyzing query execution plans, SQL server profiling, index design and tuning, and index maintenance strategies
Database backup management and recovery
Database administration related projects, as needed
Respond to critical and non-critical production alerts, and availability to be on an on-call rotation schedule to provide production support when critical issues arise will be required
Create requested database objects and assist with production releases
Qualifications:
- 6+ years in Database Administration
- SQL Server 2016 and 2019 experience required.
- Experience in Troubleshooting and resolving performance issues.
- Experiences in backup management and recovery.
- Experiences in data encryption.
- Basic understanding in writing SQL queries and stored procedures
- Experience optimizing queries and database objects, including advanced skills in index design and maintenance
- Experience with SQL Server Service Broker, SQL Server in a Windows Cluster environment, and AlwaysOn Availability Groups
- Experience with encryption including TDE and Always Encrypted
- Experience with monitoring tools such as SQL Monitor, Zabbix, SolarWinds, Idera, System Center
- Excellent in Availability group in the cluster IP, Resouces database, Log Shipping, Tail log backup, DBCC Command, Isolation level, Covering Index, Execution plan, Key lookup, RID Lookup, kind of backup plans, TDE