
Candidate need to handle the ticket raised by the team, where they asked to perform the operations on database. Once ticket get’s solved they need to update team for the same.
What would be the key responsibilities expected out of this role
1) Help write and optimize in-application SQL statements
2) Ensure performance, security, and availability of databases
3) Prepare documentations and specifications
4) Handle common database procedures such as upgrade, backup, recovery, migration, etc.
5) Good in DML and DDL
Must Have Skills:
MS-SQL
Good To Have Skills:
SSIS & SSRS Or MSBI
Notice Period:
15 Days - 30 Days (Immediate Joiners Preferred)

Similar jobs
Job brief
We are looking for a qualified Database developer to design stable and reliable databases, according to our company’s needs. You will be responsible for developing, testing, improving and maintaining new and existing databases to help users retrieve data effectively.
As part of our IT team, you will work closely with developers to ensure system consistency. You will also collaborate with administrators and clients to provide technical support and identify new requirements. Communication and organization skills are keys for this position, along with a problem-solution attitude.
Ultimately, you should be able to ensure our database systems run effectively and securely on a daily basis.
Responsibilities
- Design stable, reliable and effective databases
- Optimize and maintain legacy systems
- Modify databases according to requests and perform tests
- Solve database usage issues and malfunctions
- Liaise with developers to improve applications and establish best practices
- Gather user requirements and identify new features
- Develop technical and training manuals
- Provide data management support to users
- Ensure all database programs meet company and performance requirements
- Research and suggest new database products, services and protocols
Requirements
- Proven work experience as a Database developer (5+ Years)
- In-depth understanding of data management (e.g. permissions, recovery, security and monitoring)
- Knowledge of software development and user interface web applications
- Advanced proficiency and hands on experience with T-SQL, Stored Procedures, Cursors, Triggers, Schedulers etc.
- Familiarity working with MS SQL Server, MySQL, .Net Framework, java
- Excellent analytical and organization skills
- An ability to understand front-end users’ requirements and a problem-solving attitude
- Ability to craft detailed technical manuals.
- Excellent verbal and written communication skills
- BE/MCA/MSc Degree in Computer Science or relevant field.


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.
RequiredSkills:
• Minimum of 4-6 years of experience in data modeling (including conceptual, logical and physical data models. • 2-3 years of experience inExtraction, Transformation and Loading ETLwork using data migration tools like Talend, Informatica, Datastage, etc. • 4-6 years of experience as a database developerinOracle, MS SQLor another enterprise database with a focus on building data integration process • Candidate should haveanyNoSqltechnology exposure preferably MongoDB. • Experience in processing large data volumes indicated by experience with BigDataplatforms (Teradata, Netezza, Vertica or Cloudera, Hortonworks, SAP HANA, Cassandra, etc.). • Understanding of data warehousing concepts and decision support systems.
• Ability to deal with sensitive and confidential material and adhere to worldwide data security and • Experience writing documentation for design and feature requirements. • Experience developing data-intensive applications on cloud-based architectures and infrastructures such as AWS, Azure etc. • Excellent communication and collaboration skills.


- 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.
As one of our Backend Software Engineers, you will be part of the team responsible for the development of all server-side logic, the definition and maintenance of the database, and ensuring high performance and responsiveness to requests from the front-end developers.
What will you be engaged in?
Collaborate with key internal stakeholders to determine how to scalable design backend systems and APIs to meet their needs
Architect, develop and operate services deployed to millions of users
Collaborate with the DevOps team for the necessary infrastructure needed for services to run on the cloud platform
Write backend services and Restful APIs
Be in charge of data migration, transformation, and scripting
Write reusable, testable, and efficient code
Design and implementation of low-latency, high-availability, scalability, and performant applications
Implement security and data protection
Manage web apps that impact millions of users
What do we expect from you?
3 + years of experience building large-scale backend systems
Knowledge of MVC concepts
Knowledge of web applications systems
A good understanding of data pipelines, data lakes, and data ingestion is Plus
Strong understanding of Database management (MSSQL, SQL)
Strong understanding of NoSQL Database (MongoDB)
Strong understanding of RESTful API
Understanding of JavaScript and Typescripts
Understanding of Node.js frameworks and Nest JS Framework
Passion for building high performance, high throughput, low latency frameworks
Problem-solving mindset
Understanding of GIT Source code
Good at JavaScript and passionate about solving challenges using JavaScript.
Good Understanding of Pub/SUB (Kafka, RabbitMQ etc.)
Fintech Industry experience is plus



.NET C# developer provides custom web application development using the .NET Framework, C#, http://VB.NET">VB.NET, http://ASP.NET">ASP.NET, SQL Server and other advanced components of Microsoft technology and provide training to programmer analysts who support the web services manager' responsibilities.
Responsibilities:
The tool development also involves working with SQL queries and web front end
Designing, developing, and testing web applications with .Net HTML, CSS and other technologies
Design and development of software applications (primarily web based) used in various areas of the bank (such as Loans processing, Treasury, Middle Office )
Manages the architecture, design, and coding of software for TFI from concept to finished product, in order to answer the needs of the Strategies, Sales, and Trading departments
Consults with end users within the Strategies, Sales, and Trading departments to identify where technology can automate current processes to enhance revenues and cut cost
Maintains currency in technical skills and all relevant fixed income industry sector factors
May lead the work of others and provide ideas which help to enhance TFI software applications
Software design & development principles such as SOLID, Domain-Driven-Design and Object-Oriented Development
ORM frameworks, particularly the Entity Framework
Managing source code with Git, including Gitlow Workflow

Proficient with .NET Core development using C#
In-depth knowledge and experience with web development technologies including http://asp.net/" target="_blank">ASP.NET, ADO.net, MVC, HTML, HTML5, XML, JavaScript, JSON, JQUERY/Angular Js, Bootstrap and CSS
In-depth knowledge and experience with distributed application development: Web API, WCF, WF, LINQ, EF
In-depth knowledge and experience with database development including relational database design, SQL(TSQL, SPs, Triggers), and ORM technologies
Skills: Ap.net Core, C#, SQL server, Javascript, and Jquery
Experience: Min 1 year
Location: Andheri, 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.

