SQL Programmer

**About the Company**:
Vagaro, Inc. develops an all-in-one business management platform and a powerful online marketplace for the salon, spa, and fitness industries. More than 173,000 professionals and 67,000+ businesses in the United States, Canada, UK, and Australia use Vagaro's cloud-based software to manage all aspects of their operations. Consumers choose Vagaro to search for and book services in their community at their convenience. Vagaro is easy-to-use and works on any device.

**About the perks we offer**:

- 5 days working
- Yearly performance bonus
- Referral bonus
- Overtime Pay
- Leave encashment
- Maternity leaves
- Mediclaim for family
- 11 Public Holidays
- 15 PTO
- Cozy work area with swings and bean bags
- Library and gaming zones
- MS SQL Server 2019 with Azure cloud SQL database.
- Strong Technical and Interpersonal Communication
- Work Closely with Development Teams with Regards to Database Updates and Design
- Must write SP, function, Triggers, Tables, View etc.
- Performance Tuning and Optimization for database and server level
- How to solve the performance bottleneck using Query Store
- Extensive experience writing T-SQL and stored procedures and query tuning on high transaction systems.
- Proficient with SQL server profiler for monitoring and troubleshooting database activity and performance.
- Good knowledge of Indexes, Execution plan and missing indexes
- Must know the DMV to find the culprit.
- Improve performance using wait statistics.
- Knowledge of SQL Server Integration Service (SSIS)
- Create automation process for daily tasks.
- Must have knowledge of ETL.
- Comfortable Working with Production Servers

**Mandatory**:

- Good understanding of T-SQL
- Take care of the Database design and implementation
- Database tuning and performance monitoring
- Prevention of the deadlock and Timeouts
- SQL Performance Improvement
- SQL Database coding standards
- Bug tracking
- Excellent problem-solving abilities
- Data analysis
- Data extracting and import
- Data management
- Creation of SP, Functions, Triggers using T-SQL with proper logic

**Good to have**:

- Installation, configuration and upgrading of Microsoft SQL Server
- Microsoft Azure SQL Database
- Implement and maintain database security
- SSIS for the ETL operations and Data Migration
- SSAS for data warehouse
- SSRS and Power BI for Reports
- Data backup and retrieval (Point-in-time Recovery)

**Call us on** 079-71279028** (tel:917971279028)

**Hoping to hear from you soon Stay Safe & Healthy