SQL Programmer - Ahmedabad, India - Vagaro

Vagaro
Vagaro
Verified Company
Ahmedabad, India

2 weeks ago

Deepika Kaur

Posted by:

Deepika Kaur

beBee Recuiter
Description

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 problemsolving 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 (Pointintime Recovery)

Call us on ** (tel:

**Hoping to hear from you soon Stay Safe & Healthy
More jobs from Vagaro
See all jobs of Vagaro