MS SQL Database Developer

Job ID: HRIN294

Location(s): Noida & Mohali & Hyderabad

Position: Open

ONE BCG is a fast-paced, rapidly growing IT organization currently looking for a MS SQL Developer who will evaluate performance across Databases, make improvement recommendations and implement changes. You will also be responsible for plan, design, and scheduled Database maintenance & administrative tasks.

How can you make a difference.

  • Write quality SQL code in procedures & make sure all existing procedures are performing well

  • Knowledge of standard concepts, practices, and procedures related to database management

  • SQL Server database design, stored procedure design, and implementation

  • Experience with performance tuning, query optimization, using Performance Monitor, SQL Profile, and other related monitoring and troubleshooting tools

  • Experience coding complex stored procedures

  • Proven analytical problem solving and debugging skills

  • Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, etc.

  • Administer, develop, test, or demonstrate databases

  • Perform many related database functions across one or more teams or clients, including designing, implementing, and maintaining new databases

  • Backup/recovery and configuration management

What all you need.

  • Min. 5 years of experience in software development using Microsoft SQL Server 2016 and above, T-SQL and T-SQL language (queries, views, procedures)

  • Extensive experience to handle SQL Server's DB

  • Good knowledge of high availability, AlwaysON, Replication, clustering, etc.

  • Experience in troubleshooting slow running queries and take necessary steps to resolve them

  • Troubleshooting the failed backup jobs

  • Experience in SQL Server Version Upgrades

  • Know best practices to deploy SQL

  • Good to Have SSIS & SSRS

  • Good to have Azure experience