SQL Database Developer

Viaplus; Hyderabad; On-site; INR 1,800,000 - 2,800,000; Full time

Job summary

Viaplus is seeking a Senior Software Engineer specialized in SQL Server for our Hyderabad office. You will design and develop database solutions, optimize performance, and ensure data security for large-scale systems.

The ideal candidate has 4–8 years of hands-on experience with T-SQL, SSRS, and SQL Server, and can work across UI, middleware, and batch applications while following best practices. You will collaborate with cross-functional teams and contribute to data modeling, performance

Qualifications

• Experience in implementing business logic using Triggers, Indexes, Views and Stored procedures.
• Understand Business Logic thoroughly and design, develop DB accordingly
• Should possess practical workings with large data sets and DB volumes.
• Should also be able to optimize database performance, ensure data security and access controls, and monitor database health.
• Development of high-quality database solutions & managing large scale database system is a plus.
• Extensive Knowledge of advance query concepts (e.g. group by, having clause, union so on).
• Strong experience in developing complex database code with T-SQL, SSRS and SQL Server following best practices to support UI, Middleware and Batch applications.
• Candidate should be strong in Transact-SQL i.e. writing Stored Procedures, UDF and Triggers.
• Proficient in Tuning T-SQL queries to improve the database performance and availability.
• Monitoring Server Performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers.
• Qualifications: Any Graduate with B. E / B. Tech, MCA or equivalent degree with more than 4+ years relevant work experience.

Responsibilities

• Experience in implementing business logic using Triggers, Indexes, Views and Stored procedures.
• Understand Business Logic thoroughly and design, develop DB accordingly
• Should possess practical workings with large data sets and DB volumes.
• Should also be able to optimize database performance, ensure data security and access controls, and monitor database health.
• Development of high-quality database solutions & managing large scale database system is a plus.
• Extensive Knowledge of advance query concepts (e.g. group by, having clause, union so on).
• Strong experience in developing complex database code with T-SQL, SSRS and SQL Server following best practices to support UI, Middleware and Batch applications.
• Candidate should be strong in Transact-SQL i.e. writing Stored Procedures, UDF and Triggers.
• Proficient in Tuning T-SQL queries to improve the database performance and availability.
• Monitoring Server Performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers.

Skills

T-SQL

Stored Procedures

SQL Server

Indexes

Performance Tuning

Communication

Teamwork

Education

BE/BTech, MCA or equivalent

Tools

SSRS

SQL Profiler

SSMS

Job description

Job Profile: Senior Software Engineer SQL Server

Experience: 4-8 Yrs

Job Responsibilities:

• Experience in implementing business logic using Triggers, Indexes, Views and Stored procedures.
• Understand Business Logic thoroughly and design, develop DB accordingly
• Should possess practical workings with large data sets and DB volumes.
• Should also be able to optimize database performance, ensure data security and access controls, and monitor database health.
• Development of high-quality database solutions & managing large scale database system is a plus.
• Extensive Knowledge of advance query concepts (e.g. group by, having clause, union so on).
• Strong experience in developing complex database code with T-SQL, SSRS and SQL Server following best practices to support UI, Middleware and Batch applications.
• Candidate should be strong in Transact-SQL i.e. writing Stored Procedures, UDF and Triggers.
• Proficient in Tuning T-SQL queries to improve the database performance and availability.
• Monitoring Server Performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers.

Skill Set:

• Strong communication and problem-solving skills. skills and team work
• Should have minimum 4+ years of experience in database development in a large enterprise environment.
• Proficient in Relational Database Management Systems (RDBMS)
• Familiar and expert in Database Design, Development & Support of MS SQL Server 2008/2005/2000for Production/development.
• Expertise in Transact-SQL (DDL, DML, DCL) and in Design and Normalization of the database tables.
• Very good experience and understanding of database design/modeling, OLTP systems.
• Experience with either SQL 2005 or SQL 2008 R2 is a must.
• Working Knowledge on SQL 2012 is an added advantage.
• Have strong and confident communication skill set in customer support and presentation.

Qualifications: Any Graduate with B. E / B. Tech, MCA or equivalent degree with more than 4+ years relevant work experience.