MS-SQL Database Programmer

Skills Required:

• 7+ years of experience as software engineer.
• Experience in Dot.Net technologies - Asp.Net MVC, WebAPI, .NetCore
• Experience in ORM like Entity Framework /Dapper
• Experience with Object-Oriented Design and SOLID principles
• Experience with Unit Testing, Mocking and Dependency Injection frameworks
• Experience with SQL Server, NoSQL or other database technology
• Experience with software quality, testing procedures and build automation tools
• Knowledge of the Principles & Patterns of Agile Software
• Ability to understand and troubleshoot existing code and maintain existing systems.
• Ability to identity performance bottlenecks.
• Experience working with version control tools such as GIT and CI/CD tools.

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.

Open Position for Dot Net Developer Profile:

Job Description:

Require hands-on .NET, SQL experience with working knowledge in MVC and SaaS.

Experience of .NET, C#, SQL Server, MVC, SaaS (Essential)

Experience in IIS, REST, AJAX, XML, open source, cloud computing (Desirable)

Company: Sidqam Technologies Pvt Ltd

Job Location: Noida (Currently Work from home)

Experience: 3 to 8 years

Healthcare IT experience is a definite advantage

Role: Software Developer

Industry Type: Software Product

Functional Area IT Software: - Application Programming, Maintenance

Role Category: Programming & Design

Salary: Upto 15 LPA

Education

UG : B.Sc - Computers, BCA - Computers, B.Tech/B.E. - Computers

PG : M.Tech - Computers, MS/M.Sc(Science) - Computers, MCA - Computers

Company Profile:

We are a team of high-energy, enthusiastic, highly-skilled, and experienced health informaticians, clinicians, technical geeks, and sales and marketing enthusiasts who together want to improve patient experience with the help of technology.

Each person in our team is special because of who he or she is and what we can achieve together. This makes for a special company! Our company, Sidqam Ltd. was established in September 2014 and is headquartered in Manchester, UK. Although a startup, the co-founders of the company have over 15 years of experience each in the healthcare IT industry, working for the National Health Service (NHS) in the UK.

• 5 to 8 years of hands-on experience in automating MS Office applications like Excel, Word, PPT and Outlook using VBA
• 5 plus years of experience in the design, development, and implementation of programming code
• Experience in database development
• VBA - Should have good experience in developing efficient logic/algorithms using VBA
• Solid understanding of SDLC concepts
• Solid experience in MS Excel (2003, 2007, 2010, 2013,2016)
• Must be good at all excel features and excel formulas
• Well versed with complete MS Office package (Excel, Word, Outlook, PPT)
• Work both independently and as part of a team
• Experience in requirements gathering, effort estimate, designing and implementation, and creating mock-up screens
• Experience in databases like MS SQL Server(2005 to 2012,2014), MySQL, and MS Access
• Must have strong database concepts and DB designing skills
• SQL - must be good at writing efficient, fine-tuned queries using joins and aggregates
• Experience in writing Stored procedures, Triggers and T-SQL
• Nice to have programming knowledge in C# coding should be MANDATORY
• working with C# DLL development and integration with Excel VBA

Interpersonal

• Strong analytical and problem-solving skills
• Excellent interpersonal and communication skills
• Should be able to take complete ownership of the project from requirements gathering to delivery and maintenance
• Should be able to work independently
• Must be Proactive and Self-motivated
• Must have the ability to prioritize the work, execute tasks and meet the deadline without fail
• Effective time management skills
• Customer Focus, Willing to learn and self-teach any new technology
• Strong business and collaboration skills, and responsive to service needs and operational demands

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.