MS-SQL Database Programmer

• Write clean, scalable code using .NET programming languages.
• Developing the web based software using computer programming languages such as Asp.net, Sql Server, MVC, C# & Entity framework.
• Revise, update, re-factor and debug code.
• Participate as a team member in all phases of S/W lifecycle, including the analysis and design of S/W systems.
• Participate in integrated testing of product/ package.
• Deploying applications on client server.
• Making changes to existing web applications according to the feedback received from the end users or clients.
• Design and develop REST API’s using ASP.NET/C#.

• Familiarity with the ASP.NET framework, SQL Server and design/architectural patterns (e.g. Model-View-Controller (MVC)
• 5 years of development experience using C# .NET
• Knowledge of at least one of the .NET languages (e.g. C#, Visual Basic .NET) and HTML5/CSS3
• Familiarity with architecture styles/APIs (REST, RPC)
• Understanding of Agile methodologies
• Strong attention to detail
• Excellent troubleshooting and communication skills
• Knowledge of REST and RPC APIs
• Able to work well in a team setting

Job Summary: We are looking for a skilled SQL Developer to join our team. The ideal candidate will have a strong understanding of database management systems, experience in writing complex SQL queries, and a solid understanding of data structures and algorithms. The SQL Developer will be responsible for designing, developing, and maintaining SQL databases, ensuring their performance, availability, and security.

Key Responsibilities:

• Design, develop, and optimize SQL databases, tables, views, stored procedures, and triggers.
• Develop efficient and complex SQL queries for data extraction, transformation, and loading (ETL).
• Create and maintain database schema designs, data models, and ER diagrams.
• Analyze and optimize complex SQL queries for better performance.
• Implement indexing strategies, query optimization techniques, and other performance tuning practices.
• Ensure data integrity and security by designing and implementing database constraints, data validation rules, and security policies.
• Work with software developers, data analysts, and system administrators to integrate SQL databases with other applications and systems.
• Collaborate with business stakeholders to understand data requirements and provide solutions.
• Document database designs, stored procedures, and other database-related activities.
• Maintain accurate records of database changes, optimizations, and configurations.

Eligibility Criteria:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 3 to 5 years of experience as an SQL Developer or in a similar role.
• Proven experience in database design, development, and management.
• Experience with SQL Server, MySQL, PostgreSQL, or other relational database management systems.
• Proficiency in writing complex SQL queries, stored procedures, functions, and triggers.
• Strong understanding of indexing, query optimization, and performance tuning.
• Familiarity with database security best practices.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration abilities.
• Attention to detail and commitment to quality.
• Ability to work independently and in a team environment.
• Experience with cloud-based databases (e.g., AWS RDS, Azure SQL Database).
• Experience with NoSQL databases.

What We Offer:

·        Competitive salary and performance based incentives.

·        Comprehensive benefits package, including health

·        Opportunities for professional growth and career advancement.

·        A collaborative and innovative work environment.

Around 4 years of experience in creating and implementing Web-based applications using

C#, ASP.net, Web API, MVC, Micro Services, JavaScript and SQL Server.

Familiarity or exposure to CI / CD, Dev Ops such as Dockers, containers, Azure, Pipeline is

highly recommended

Ability to work in an Agile, fast-paced environment, and learn rapidly.

Bachelor degree in computer science, computer engineering or similar.

Familiar with object-oriented development, design patterns and specifically in .NET

Framework (C#) with a strong background in web-based development and service-oriented

Architecture.

Expert in HTML, CSS, JavaScript, JQuery, JSON.

Writing clean, readable, and easily maintainable code.

Must have knowledge of project/task management tools like Jira,

Familiarity with Version Control like Bitbucket, Git etc.

Understanding of UI, cross-browser compatibility and web standards.

Build features and applications with responsive design

Good English communication skills, written and spoken.

Able to work with minimum supervision as well as perform under pressure and meet

Deadlines.

Primary Responsibilities:

• We need strong SQL database development skills using the MS SQL server.
• Strong skill in SQL server integration services (SSIS) for ETL development.
• Strong Experience in full life cycle database development project using SQL server.
• Experience in designing and implementing complex logical and physical data models.
• Exposure to web services & web technologies (Javascript, Jquery, CSS, HTML).
• Knowledge of other high-level languages (PERL, Python) will be an added advantage
• Nice to have SQL certification.

Good to have:

• Utilize established development tools, guidelines and conventions including but not limited to ASP.NET, SQL Server, HTML, CSS, JavaScript, and C#/VB.NET
• Prepare and maintain code for various .Net applications and resolve any defects in systems.
• Prepare test-based applications for various .Net applications
• Enhance existing systems by analyzing business objectives, preparing an action plan and identifying areas for modification and improvement

• Manage defect tracking system and resolve all issues and prepare update for systems
• Investigate and develop skills in new technologies
• Create technical specifications and test plans
• Monitor everyday activities of system and provide require support

• Required experience in .Net Core 2.2 and above, Web API, EF, AWS or Azure Cloud
• Familiarity with the ASP.NET framework, SQL Server and design/architectural patterns (e.g. Model-View-Controller (MVC))
• Knowledge of at least one of the .NET languages (e.g. C#, Visual Basic .NET) and HTML5/CSS3
• Familiarity with architecture styles/APIs (REST, RPC)
• Snaplogic (both ground and cloud plex ) or Biztalk ( basic administration , simple xlt translations, and Api management ) or any other similar tool
• Update to .net 50 and Microsoft CORE 30 general coding practices
• Visual Studio use for C#
• Shared library through Nugget
• Unit Test / Test driven methods (use of Xunit and MOCK )
• Concepts of “;” service threading, caching, injection, NTier and entity 
• GIT repository (Gitflow branching strategies )
• Azure DevOps pull requests, commitments and Task usage
• SQL artifact writing (sprocs, tables, triggers , indexes, FKs ,and PKs)
• SQL understanding of relational database models

• Should have good problem-solving abilities
• Should be able to troubleshoot issues and determine the cause of a plan’s success or failure
• Should keep up to date with changes in the market and technology that would affect
• Good interpersonal and communication skills
• Comfortable to work as per client requirements/time zones
• Should possess strong team handling experience

Job brief

As an Application Developer at Bridgei2i, you will participate in development and implementation of custom projects and products of Bridgei2i in Business Intelligence Applications. The role includes working closely with lead, testers, project managers, designers. 

You are expected to develop prototypes of the system design and work with lead, backend developers, testers and project managers as appropriate throughout development cycle. You will be developing bug free, maintainable, scalable web applications.

Requirements

• Working knowledge in JavaScript, CSS and HTML, Java/J2EE
• Experience of 1 + year's atleast in application development 
• Possess good knowledge of object-oriented design and development (OOA/OOD), algorithm and data structure
• Basic knowledge of web services (SOAP & Restful)
• Basic knowledge of relation database, SQL
• Knowledge in any of one of UI frameworks (AngularJS, ReactJS, NPM, node.js, JQuery) , or Spring or Struts
• Curiosity and attention to detail 
• Adaptable to changing technology and restrictions, design challenges, deadlines, and project requirements 

We are urgently looking Azure Data Factory Engineers with 3 to 7 years of overall experience, having good experience on Azure Data Factory and SSIS.

Requirements:

• Qualification: Engineering Graduate.
• Years of Experience: 2+ yrs of relevant experience on Azure Data Factory & SSIS.
• Strong understanding of ETL/ELT concepts.
• Hands on experience on Azure Data Factory.
• Exposure of Cloud technologies, standards, and platforms.
• Sound knowledge of ADF pipeline, configuration, parameters, variables, Integration services runtime (part of Data Factory).
• Strong Experience on SSIS.
• Sound knowledge of implementing slowly changing dimensions and transactional, fact less, snapshot fact tables.
• Azure Data Warehouse.
• Knowledge on Azure components especially file storage and Azure Sql, Blob storage and Data Lake Gen2 storage (just used as a file system on the blob).
• Azure Data Migration tool.
• Well versed with RDBMS systems like Sql server, DDL, DML scripts.
• Sound knowledge of T-SQL and stored procedures.
• Strong Query writing skills, Scheduling tools.
• Ensure quality deliverable and ability to extend work hours if required.
• Azure Certification: Preferred.
• Ability to understand Customer requirements and convert the requirements into technical specifications.
• Ability to understand the overall solution and design components to fit the overall solution.
• Ability to take technical decisions and support the decisions with justifications.
• Ability to work in Agile manner.
• Ability to work independently without much guidance.
• Self-Motivated, team player, results oriented, strong Time Management skills.
• Excellent written and verbal communication skills.
• Willing to travel to outside India (Short term as well as long term)