SQL Developer

Job description

Tech Stack: C#, .NET Core, XUnit, Entity Framework Core, MS SQL Server, PostgreSQL, Git, JIRA, Confluence

Senior (Lead) .NET Developer Responsibilities: -

Interface with product owners and software architects to review and finalize requirements

- Participate in the full SDLC including analysis, design, development, testing, deployment, and support of new features and applications

- Actively lead and participate in agile ceremonies (Standups, Refinements, Retrospectives, Planning, and Requirement’s discussions)

- Communicate effectively, clearly, and thoroughly with the Scrum Team and Stakeholders - Provide innovative solutions to complex problems

- Design, develop and modify software applications/systems according to specifications

- Develop technical documentation including services, object, and data model

- Create high quality code and perform code reviews

- Create unit and integration tests to ensure the code quality and functionality

- Proactively learn and share knowledge of technology and compare advantages and disadvantages of alternative solutions/technologies

- Identify areas needing process improvements and see them through to resolution

- Support and coach other Developers, provide technical guidance

- Help onboard new team members

Job Type: Full-time

Key Responsibilities:

• SDLC development of product features, enhancements, UAT/production issues.
• Work with development team members for development of product features.
• Client-side and server-side development.
• Develop and manage well-functioning databases and application.
• Write/ design product APIs and write unit test cases.
• Follow standard agile scrum practices for software development.
• Peer review, pull requests, code refactoring and managing source code per standards and ensure quality. 

Required Experience & Skills:

• 5+ years of software development experience using Microsoft .Net technology stack.
• Strong experience in .Net, .Net Core, C#, Entity Framework, SQL server, JavaScript, jQuery, etc.
• Experience in using unit test framework e.g., xUnit, Moq.
• Experience in Web API development.
• Experience in Agile / SCRUM development process.
• Good to have experience in Domain driven design development and Microservice architecture.
• Excellent communication and teamwork skills
• Good to have knowledge and experience in ABP.IO framework, Angular 8+, PostgreSQL and AWS cloud service and CI/CD process.

Primary Role

• As an SSRS Report Engineer, the primary job role is to develop a transactional data report using Microsoft SQL Service Reporting Service 2016 or above.
• This includes developing high performing Stored Procedures, Functions, and corresponding reporting formats.
• Required to design the required logics for the queries and collaboratively coordinate with the rest of the team.

Main Duties / Responsibilities

• Design & implement high performing T-SQL queries as per the functional specification.
• Create Technical Specification.
• Effective troubleshooting of technical issues and bugs.
• Package deployment and release management.
• Provides technical support to customers.
• Participate in Requirements discussions.
• Must be able to manage timelines and task priorities.
• Attention to detail and maintaining high-quality standards is a must.

TECHNICAL KNOWLEDGE

• Experience in Microsoft SQL Server 2016 (or above) and Microsoft SQL Service Reporting Service 2016 (or above).
• Knowledge of T-SQL including complex SQL queries, stored procedures, views and functions.
• Experience with usage of indexes and T-SQL performance tuning techniques.

QUALIFICATIONS

• Bachelor’s Degree or an equivalent qualification

• 5+ years of object-oriented software development of web applications
• 5+ years of C# in a .NET environment
• Preferable Experience in Cloud Technologies (AWS, AZURE)
• Experience with MS SQL stored procedures, database design and optimization
• Experience developing and utilizing web services
• Experience with high volume consumer oriented web sites
• Experience working in an Agile Scrum environment
• Experience with formal test procedures, release management
• Preferable Travel industry experience preferred, especially programming associated with GDS’s - SABRE, Farelogix, and Travelport
• Ability to distill complex business needs into functional requirements
• Excellent follow-up, verbal and written communication skills
• Excellent problem solving skills and an ability to make good decisions
• Team player with a professional attitude
• Ability to manage multiple tasks and maintain tight schedules
• Ability to work effectively with a geographically dispersed team in India

Strategic and Development Responsibilities

• Ability to "think outside the box"
• Ability to provide accurate and timely project estimates.

Pluses:

• Experience with Angular JS frameworks and Mobile Development.
• Experience with developing machine learning algorithms.
• Experience on projects that required localization/globalization
• Experience with MS SQL Reporting Services
• Knowledge of web farm configuration and best practices

Software Tools/Languages

Required:        MS Visual Studio, MS SQL Server Management Studio, IIS, AWS

C#, Web Services, MS SQL (stored procedures), Jenkins, DevOps Tools.

Education

Expereince: 3-5 years

Domain: SQL server/SSIS/Cloud technology

Good Knowledge in Creating new tables in database.

Using Triggers, trunket,delete,view,etc