SQL DEVELOPER

Job Description & Responsibilities:

We are looking for a DB Developer who is highly skilled to join and be part of an extremely motivated and passionate team, who can:

Responsibilities:

1. Designing & Programming of Database for enhancing existing features to the Amukha’s applications and new initiatives taken up in the organization.
2. Second level coordination with client (mostly the technical and infrastructure team) to configure Infrastructure required for deploying the Amukha’s Application at client end.
3. Deploying & Configuring the Database components of the Amukha’s Application at client end for:

• Customized Features required by each client as per Contract.

• Maintaining system, server and application security in compliance with the policies at client end.

• Monitoring the overall health of the various processes involved in the deployment to ensure that the systems are up and running.

4. Monitoring and optimizing the performance at Amukha and components deployed at client.

5. Provides in-house expertise and technical support to end-users on database and software-related issues.

6. Support the company's Application, Database and Infrastructure Architecture.

7.Planning & implementing for backup and recovery of database.

8.Manages the implementation of database consolidations.

9.Backing up and restoring databases.

10.Ensuring availability of system storage and planning future storage requirements for the database system. Planning, setting up & deploying HA Solutions.

Role & Responsibilities:

Develop and deliver defect free, web-based applications using C#, ASP.Net and Oracle as per the specifications provided by the Business Analysts.

• Read and Understand the Functional and Technical Specification and have complete understanding of the work before commencing the work
• Design, develop, and unit test applications in accordance with established standards.
• Adhering to high-quality development principles while delivering solutions on-time.
• Adhere to the Quality Management Standards established in the organization.
• Understanding of the SDLC process defined in the organization and follow it without any deviation
• Providing third-level support to the support tickets raised by the business users
• Analyzing and resolving technical and application Logic related problems
• Ensure high performance in the application by developing efficient code

Ideal Candidate:

• Strong .NET Senior Software Engineer Profile
• Must have 5+ years of hands-on development experience with C#.NET, ASP.NET, ADO.NET.
• Must have 3+ years of experience in web application development using HTML, CSS, JavaScript/jQuery
• Must have strong experience in Writing Complex SQL Queries, Stored Procedures, Functions using Oracle / SQL Server.
• Must have experience in designing, developing, and unit testing applications with SDLC compliance
• Experience with AJAX, Crystal Reports, and front-end validations using JavaScript/jQuery.
• ME/MTech (CS) or BE/BTech (CS).

Roles and Responsibilities:

1.    Develop, enhance, document, and maintain application features in C#/Asp.Net.

2.    Excellent understanding of Database concepts and strong ability to write well-tuned SQL Statements.

3.    Participate in design, code and test inspections throughout product life cycle to contribute technical expertise and to identify issues.

4.     Knowledge of developing desktop-based applications is also desirable.

5.    Understand technical project priorities, implementation, dependencies, risks and issues.

6.    Big Data knowledge is a Plus.

7.    Drive design reviews while adhering to security requirements.

8.    Provide direction for .Net developers and act as escalation point for questions or issues.

9.    Performs technical analysis to identify and troubleshoot application code – related issues.

Keyskills

1. Must have hands on experience with ASP_Net, ASP_Net_MVC, Asp .net 4.5 , Core

2. Must have good experience in C#

3. Must have good experience in API

4. Must have hands on experience in HTML_5, angular js,CSS,CSS,CSS3, jQuery, Bootstrap, jAVASCRIPT,

5, Must have experience in Microsoft_SQL_server

The ideal candidate will be familiar with the full software design life cycle. They should have experience in designing, coding, testing and consistently managing applications They should be comfortable coding in a number of languages and have the ability to test code in order to maintain high-quality code.

Responsibilities

• Design, code, test and manage various applications, Product Development
• Collaborate with the engineering team and product team to establish the best products
• Follow outlined standards of quality related to code and systems
• Develop automated tests and conduct performance tuning

Qualifications

• Bachelor's degree in Computer Science or relevant field
• 6 to 10 years of experience working with .NET or relevant experience
• Must have experience in Product Development
• Experience developing web-based applications in C#, HTML, JavaScript, VBScript/ASP, or .NET, Angular 8+
• Experience working with MS SQL Server and MySQL Knowledge of practices and procedures for full software design life cycle
• Experience working in an agile development environment

1. Extensive experience in Javascript / NodeJS in the back end
2. Front end frameworks such as Bootstrap, Pug, Jquery
3. Experience in web frameworks like ExpressJS, Webpack
4. Experience in Nginx, Redis, Apache Kafka and MQTT
5. Experience with MongoDB
6. Experience with Version Control Systems like Git / Mercurial
7. Sound knowledge in Software engineering best practices
8. Sound knowledge in RestFul API Design
9. Working knowledge of Automated testing tools
10. Experience in maintaining production servers (Optional)
11. Experience with Azure DevOps (Optional)

1. Experience in digital payments or financial services industry is a plus.
2. Participation in the processes of strategic project-planning meetings.
3. Be involved and participate in the overall application lifecycle.
4. Collaborate with External Development Teams.
5. Define and communicate technical and design requirements, understanding workflows and write code as per requirements.
6. Develop functional and sustainable web applications with clean codes.
7. Focus on coding and debugging.

Knowledge of Node.js and frameworks available for it (such as Express, StrongLoop, etc depending on your technology stack)

Understanding the nature of asynchronous programming and its quirks and workarounds

Good with REST Api and integration of many API's in our backend

Good understanding of server-side templating languages (such as Jade, EJS, etc depending on your technology stack)

Understanding accessibility and security compliance

User authentication and authorization between multiple systems, servers, and environments
Integration of multiple data sources and databases into one system

Understanding fundamental design principles behind a scalable application

Understanding differences between multiple delivery platforms, such as mobile vs. desktop, and optimizing output to match the specific platform

Creating database schemas that represent and support business processes
Implementing automated testing platforms and unit tests

Proficient understanding of code versioning tools, such as Git
Good Code writing skills 
Integration with Shopfy, Zoho, ERP, CRM is a plus.