Job | Immediate Hiring for SQL Developer with SSRS

Job Profile: DB Specialist (SSE/PSE) ? SQL Server

Experience: 5 -10 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 and Primary/Foreign Keys.

? Providing production support of related systems and operations.

? Working knowledge of Power BI is a plus.

? Develop SSRS Reports and dashboards using Microsoft Reporting Services platform (SSRS), Microsoft SQL, MS Excel, pivot tables and other tools Analysis Services Cubes and relational databases

? Creating SSRS reports for different departments

? Ability to work in Agile development environment and work effectively in a fluid/changing environment.

? Adhere to project timelines and deliverable, effective communication of changes or disruptions to the schedule with a focus on expectation alignment

? Experience in architecture and design of high-Volume transaction processing database systems.

? Experience in Data Transformation Services like SSIS will be an added advantage.

? Provide regular and effective progress updates to and work closely with Development Project Managers to ensure the management of any delivery risks or issues.

? Responsible for managing technology in projects and providing technical guidance / solutions for work completion and able to lead and inspire their team, delegate tasks effectively, and provide guidance and mentorship to junior developers.

? Ensure process compliance in the assigned module and participate in technical discussions/review.

? Provide technical root cause analysis and mitigation plan

? Should be able to create technical documents and diagrams

Regards,

VPTI SOLUTIONS PRIVATE LIMITED 

smanchi@viaplus.com