Overview
Responsibilities:
1. Design, implement, and maintain database structures.
2. Develop and update existing stored procedures and functions using T-SQL.
3. Research required data and develop complex SQL queries.
4. Develop procedures and scripts for data migration.
5. Ensure performance, security, and availability of databases.
6. Collaborate with other team members and stakeholders.
7. Prepare documentation and specifications related to database design and architecture.
Required Skills and Experience:
1. Minimum of 8+ years of experience as a SQL Developer.
2. Proven work experience as a Senior SQL Developer or similar role.
3. Excellent understanding of T-SQL programming.
4. Knowledge of SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS).
5. Proficient understanding of indexes, views, handling large data, and complex joins.
6. Experience with performance tuning, query optimization, using Performance Monitor, and other related monitoring and troubleshooting tools.
7. Excellent written and verbal communication skills.
Nice to have
1. Research required data and develop complex SQL queries, with a focus on optimizing for multi-tenant environments.
2. Ensure data isolation between tenants and manage tenant-specific configurations.
3. Strong understanding of multi-tenant database architecture and the specific challenges and considerations it presents.
Treat the requirements very important and start working on this as a priority.
Job Types: Full-time, Permanent
Pay: ₹2,000,000.00 - ₹2,500,000.00 per year
Benefits:
- Flexible schedule
- Health insurance
- Life insurance
- Paid sick time
- Paid time off
- Provident Fund
- Work from home
Schedule:
- Day shift
- Fixed shift
Supplemental Pay:
- Joining bonus
- Performance bonus
- Quarterly bonus
- Yearly bonus
Work Location: In person