Job | Immediate Hiring for SQL Developer with SSRS @Viaplus India PVT LTD

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

Skill Set:

? Strong communication and problem-solving skills. skills and team work

? Should have minimum 8+ 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.

? Performance tuning of database objects.

? Working knowledge in Database Administration & SQL Server Reporting.

? Ability to prioritize tasks effectively and reprioritize on short notice.

? Strong knowledge and understanding of RDBMS development techniques.

? Should be well versed with all phases of the SDLC.

? Software Development Process, Software Requirements, Software Architecture.

? Agile/Scrum project development.

? Strong problem-solving skills required.

? Have strong and confident communication skill set in customer support and presentation.

? Excellent Team Management skills should have experience in handing a team (5-9).

? Experience in communicating with engineering leadership to understand requirements describing software product features, technical designs, and product strategy.

Qualifications:

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

Regards,

Divya.

smanchi@viaplus.com