Senior SQL Developer - Database Design & Implementation (8-10 yrs)

Roles and Responsibilities :

- Design, implement, and maintain database structures.

- Develop and update existing stored procedures and functions using T-SQL.

- Research required data and develop complex SQL queries.

- Develop procedures and scripts for data migration.

- Ensure performance, security, and availability of databases.

- Collaborate with other team members and stakeholders.

- Prepare documentation and specifications related to database design and architecture.

Skills :

- Proven work experience as a Senior SQL Developer or similar role.

- Excellent understanding of T-SQL programming.

- Knowledge of SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS).

- Proficient understanding of indexes, views, handling large data, and complex joins.

- Experience with performance tuning, query optimization, using Performance Monitor, and other related monitoring and troubleshooting tools.

- Excellent written and verbal communication skills.

- Research required data and develop complex SQL queries, with a focus on optimizing for multi-tenant environments.

Ensure data isolation between tenants and manage tenant-specific configurations.

- Strong understanding of multi-tenant database architecture and the specific challenges and considerations it presents.