SQL Developer

Skills:

- Very Strong in WCF, WPF, MVVM, Restful WS, and XML

- Very good in Design/Architecture understanding

- Knowledge in DevExpress, Entity Framework, RDBMS and MS SQL Server would be a BIG 

PLUS. 

- Very Strong knowledge in OOPS and Design Patterns

- Working Knowledge in Design, Code reviews/quality, unit testing with NUnit/ XUnit and 

Continuous integration

- Analytical, a problem solver, with good communication skills.

- Ability to understand the requirements, analyze and articulate into design.

- Ability to find out and work with alternatives, check feasibility and propose solutions.

- Experience in Agile methodology and following best practices

- R&D mindset and thirst for exploring/learning new skills 

Qualifications 

Qualifications - BE/BTech/MCA

Experience: 6+ years 

• Design, build and deploy effective SSIS packages to validate, synthesize, transform customer data for integrated business planning and analytics
• Understand platform’s data model (table structures, linkages, optimal designs) for designing various planning use cases
• Review and analyse the data provided by customers along with its technical/functional intent and interdependencies
• Participate in the technical design, data requirements gathering and making recommendations on best practices, in case of inaccurate or missing data
• Design and automate the data loading and insights generation process with intelligent checks and balances for sustained value delivery
• Create and execute test plans,document issues and track progress at resolving issues.

• Manage different versions of complicate code and distribute them to different teams in the organization utilizing TFS.
• Develop an ASP.Net application to input and manage a production schedule, production statistical analysis and trend reporting.
• Create routines for importing data utilizing XML, CSV and comma delimitate files.
• Filter and cleanse OLTP data with complex store procedures and SSIS packages in the staging area.
• Develop a dimensional database and OLAP cube using SSAS for analysis, maintenance and good customer service.
• Involve in development and implementation of SSIS, SSRS and SSAS application solutions for various business units across the organization.
• Extract the data from XML and load it to dimensional model.
• Maintain SQL scripts, indexes, complex queries for data analysis and extraction.
• Create advanced reports like dashboard and scoreboard using SharePoint and power pivot for better presentation of data.
• Create cubes in SSAS reports which require complex calculations such as calculation of the premium for a particular policy.
• Create SharePoint sub sites, lists, libraries, folders and apply site permissions according to the given requirement.
• Work with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements.
• Develop T-SQL functions and store procedures to support complex business requirements.
• Create and configure an OLTP replication database for disaster recovery purpose.
• Designed/Implemented/Maintain OLAP servers and processes to replicate production data to the server.

Position : Database Programmer:

Job Description / Required Skills

• Strong experience in Database design for complex web and mobile application, including writing complex store procedures, function, triggers and ad-hoc queries.
• Hands-on development experience with T-SQL.
• Strong experience on Database designing, normalization, optimization and performance tuning.
• Experience in advanced SQL programming, problem-solving and analytical skills.
• Experience in security, troubleshooting and optimizing the performance of databases and stored procedures.
• Experience in Refactoring/troubleshooting existing databases as needed.
• Deep understanding of referential integrity and indexing.
• Assisting with production database issues and helping to troubleshoot and isolate the root cause of issues and provide issue resolution by interacting with Developers.
• Ability to estimate development tasks accurately and meet agreed upon deadlines.
• Understanding of code promotion, version control and QA procedures.
• Good Communication skills.

Technical Skills:

• MySql, MS-SQL, SQL Server Management Studio and SQL Server Profiler.
• PostgreSQL
• DCL, DDL, DML Scripts.
• T-SQL, SSRS and SSIS
• OS Environments: Windows XP/Windows 7, Windows Server 2003/2008

Experience         :               3 to 4 years

Qualification       :               B. Tech/BE/MCA/MSC Computers

Location               :               Mumbai

We are looking for some one with 3+ Years of experience  with Microsoft technologies including.NET, ASP.Net Core MVC, C#, MS SQL Server. WPF, WCF C#, ASP.NET, XML, XSL, scripting languages including JQuery/JavaScript and HTML. 

Good to have knowledge with SQL Server 2012, indexing and queries and SSIS/SSRS.

Has Implemented Ajax Controls in C# . Net Projects

Complete understanding of MS SQL Database. Data modelling to visualize database structure.

Writing queries use for front‐end applications (websites, desktop applications, Mobile App or cloud apps).

Good understanding of Reviewing query performance and optimizing code.

Designing and coding database tables to store the application’s data.

Creating database triggers, stored procedures & functions.

Creating table indexes to improve database performance.

Has experience in writing unit tests & performing unit tests on own codes.

Responsibilities:‐

• To be responsible for managing technology in projects and providing technical guidance / solutions for work completion.

• To develop and guide the team members in enhancing their technical capabilities and increasing productivity.

• To ensure process compliance in the assigned module and participate in technical discussions/review.

• To prepare and submit status reports for minimizing exposure and risks on the project.

• Experience working with MVC framework.

• Hands on experience on various design patterns

• Experience in Unit testing development.

• Good to have experience on Team foundation server and Agile Development.

• Oversee and review code as required.

• Drive implementation and address technical roadblocks that the team is facing.

• Experience with diagnosing performance and/or memory issues is a plus, including using relevant profiler tools.

• Oversee and assist during system testing, UAT and deployment.