ONE BCG - Senior SQL Developer (5-7 yrs)

Key Responsibilities :

- Design, develop, and optimize complex stored procedures, functions, and triggers for performance and scalability.

- Collaborate with developers to design efficient database schemas and write high-performance queries.

- Analyze and optimize query execution plans, indexing strategies, and database partitioning to improve efficiency.

- Troubleshoot and resolve performance bottlenecks in queries and stored procedures.

- Implement best practices for data integrity, normalization, and indexing to ensure database efficiency.

- Work closely with application developers to review and enhance database logic within applications.

- Develop and maintain ETL processes using SSIS for data transformation and integration.

- Assist in designing and implementing replication, partitioning, and archiving strategies for large datasets.

- Provide expert-level SQL scripting support and mentor junior team members in writing efficient T-SQL.

- Stay updated with emerging database technologies and best practices to enhance database performance.

Qualifications :

- 5+ years of experience in Microsoft SQL Server development, focusing on stored procedures and database optimization.

- Expert-level proficiency in T-SQL and writing complex stored procedures.

- Strong knowledge of query optimization techniques, execution plans, and indexing strategies.

- Experience in database normalization, table partitioning, and query tuning for large-scale applications.

- Hands-on experience with SSIS (ETL), SSRS, and SSAS.

- Familiarity with database performance monitoring tools and techniques.

- Understanding of cloud-based database solutions (Azure SQL, AWS RDS)

- Strong problem-solving and analytical skills.

Nice to Have :

- Experience with NoSQL or hybrid database architectures.

- Knowledge of automated database testing and performance benchmarking.

- Exposure to CI/CD pipelines for database development