Group Company: Varuna Integrated Logistics Pvt. Ltd
Designation: SQL Developer
Office Location: Corporate Office Gurgaon (Corporate Office)
Position description:
Optimize and fine tune database systems to maximize their performance and operation.
· Skilled at optimizing large, complicated SQL statements
· Server Monitoring (Disk, CPU and Memory usage) and Resource Management.
· Knowledge on any SQL server, Database Management & IT performance tool.
· SQL Server Error Log monitoring.
· Good experience in Performance Tuning concepts like Index, Query and Store Procedures tuning
· Patching and Upgrading SQL Server (Both versions & platform).
· Hands on with SQL Profiler/Extended Event
· Implementing and managing multi-node clusters.
· Knowledge of best practices when dealing with relational databases.
· Capable of troubleshooting common database issues
·· Strong in MS SQL Development and Troubleshoot DB issues - MUST have.
· Advanced skill on handling High Availability and Disaster recovery using Always ON Availability Groups as well as SQL Server failover clustering.
· Advanced knowledge of database security, backup and recovery, and performance monitoring standards
· Troubleshoot SQL Server Reporting Services related issues
· Manage packages built in SQL Server Integration Services
Primary Responsibilities:
- Data Base Administrator
Additional Responsibilities:
- SQL Server error log monitoring