
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 Title : Senior .NET Developer
Experience : 8+ Years
Location : Trivandrum / Kochi
Notice Period : Immediate
Working Hours : 12 PM – 9 PM IST (4-hour mandatory overlap with EST)
Job Summary :
We are hiring a Senior .NET Developer with strong hands-on experience in .NET Core (6/8+), C#, Azure Cloud Services, Azure DevOps, and SQL Server. This is a client-facing role for a US-based client, requiring excellent communication and coding skills, along with experience in cloud-based enterprise application development.
Mandatory Skills :
.NET Core 6/8+, C#, Entity Framework/Core, REST APIs, JavaScript, jQuery, MS SQL Server, Azure Cloud Services (Functions, Service Bus, Event Grid, Key Vault, SQL Azure), Azure DevOps (CI/CD), Unit Testing (XUnit/MSTest), Strong Communication Skills.
Key Responsibilities :
- Design, develop, and maintain scalable applications using .NET Core, C#, REST APIs, SQL Server
- Work with Azure Services: Functions, Durable Functions, Service Bus, Event Grid, Key Vault, Storage Queues, SQL Azure
- Implement and manage CI/CD pipelines using Azure DevOps
- Participate in Agile/Scrum ceremonies, collaborate with cross-functional teams
- Perform troubleshooting, debugging, and performance tuning
- Ensure high-quality code through unit testing and technical documentation
Primary Skills (Must-Have) :
- .NET Core 6/8+, C#, Entity Framework / EF Core
- REST APIs, JavaScript, jQuery
- SQL Server: Stored Procedures, Views, Functions
- Azure Cloud (2+ years): Functions, Service Bus, Event Grid, Blob Storage, SQL Azure, Monitoring
- Unit Testing (XUnit, MSTest), CI/CD (Classic/YAML pipelines)
- Strong knowledge of design patterns, architecture, and microservices
- Excellent communication and leadership skills
Secondary Skills (Nice to Have) :
- AngularJS/ReactJS
- Azure APIM, ADF, Logic Apps
- Azure Kubernetes Service (AKS)
- Application support & operational monitoring
Certifications (Preferred) :
- Microsoft Certified: Azure Fundamentals
- Microsoft Certified: Azure Developer Associate
- Relevant Azure/.NET/Cloud certifications
About the Role
We're seeking a Junior .NET Developer with 2 years of experience to join our insurtech team. This role offers an opportunity to work with cloud technologies and contribute to our existing codebase and cloud migration initiatives.
Key Responsibilities
- Write clean, maintainable code using C# and .NET Framework (.NET Core, ASP.NET, web API)
- Develop new features and participate in microservices architecture development
- Write unit and integration tests to ensure code quality
- Work with MS SQL Server - write Stored Procedures, Views, and Functions
- Support Azure cloud integration and automated deployment pipelines using Azure DevOps
- Collaborate with infrastructure teams and senior architects on migration initiatives
- Estimate work, break down deliverables, and deliver to deadlines
- Take ownership of your work with focus on quality and continuous improvement
Requirements
Essential
- 2 years of experience with C# and .NET development
- Strong understanding of OOP concepts and Design Patterns
- MS SQL Server programming experience
- Experience working on critical projects
- Self-starter with strong problem-solving and analytical skills
- Excellent communication and ability to work independently and in teams
Desirable
- Microsoft Azure experience (App Service, Functions, SQL Database, Service Bus)
- Knowledge of distributed systems and microservices architecture
- DevOps and CI/CD pipeline experience (Azure DevOps preferred)
- Front-end development with HTML5, CSS, JavaScript, React
Tech Stack
C#, .NET Framework, WPF, WCF, REST & SOAP APIs, MS SQL Server 2016+, Microsoft Azure, HTML5, CSS, JavaScript, React, Azure DevOps, TFS, Github
- Bachelor's degree required, or higher education level, or foreign equivalent, preferably in area wit
- At least 5 years experience in Duck Creek Data Insights as Technical Architect/Senior Developer.
- Strong Technical knowledge on SQL databases, MSBI.
- Should have strong hands-on knowledge on Duck Creek Insight product, SQL Server/DB level configuration, T-SQL, XSL/XSLT, MSBI etc
- Well versed with Duck Creek Extract Mapper Architecture
- Strong understanding of Data Modelling, Data Warehousing, Data Marts, Business Intelligence with ability to solve business problems
- Strong understanding of ETL and EDW toolsets on the Duck Creek Data Insights
- Strong knowledge on Duck Creek Insight product overall architecture flow, Data hub, Extract mapper etc
- Understanding of data related to business application areas policy, billing, and claims business solutions
- Minimum 4 to 7 year working experience on Duck Creek Insights product
- Strong Technical knowledge on SQL databases, MSBI
- Preferable having experience in Insurance domain
- Preferable experience in Duck Creek Data Insights
- Experience specific to Duck Creek would be an added advantage
- Strong knowledge of database structure systems and data mining
- Excellent organisational and analytical abilities
- Outstanding problem solver
- 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.
• Exposure to latest Technology
• Opportunity working in different platforms
• Rapid Career Growth
• Friendly Knowledge sharing Environment
Criteria:
• BE/MTech/MCA/MSc
• 3+yrs Hands on Experience in TSQL / PL SQL / PG SQL or NOSQL
• Immediate joiners preferred/ Maximum notice period between 15 to 30days
• Candidates will be selected based on logical / technical and scenario-based testing
Note: Candidates who have attended the interview process with TnS in the last 6 months will not be
eligible.
Job Description:
Technical Skills Desired:
- Experience in either of these Relational DB’s MS SQL Server / PostgreSQL / AWS Aurora DB / MySQL / Oracle / NOSQL DBs (MongoDB / DynamoDB / DocumentDB) in an application development environment and eagerness to switch DB.
- Design database tables, views, indexes
- Write functions and procedures for Middle Tier Development Team
- Work with any front-end developers in completing the database modules end to end (hands-on experience in parsing of JSON & XML in Stored Procedures would be an added advantage).
- Query Optimization for performance improvement
- Design & develop SSIS Packages or any other Transformation tools for ETL
Functional Skills Desired:
- Banking / Insurance / Retail domain would be a plus.
- Interaction with a client a plus
Good to Have Skills:
- Knowledge in a Cloud Platform (AWS / Azure)
- Knowledge on version control system (SVN / Git)
- Exposure to Quality and Process Management
- Knowledge in Agile Methodology
Soft skills: (additional)
- Team building (attitude to train, work along, mentor juniors)
- Communication skills (all kinds)
- Quality consciousness
- Analytical acumen to all business requirement
- Think out-of-box for business solution
Key Responsibilities :
1. Work closely with client and team and understanding the requirement, design, analyze and do the code changes
2.Helping team and client to resolve issues
3.Should able to handle day to day activity like team management, daily meeting
Technical Experience :
- Net development work experience
- Proficiency in NET Development with Net Core.
- Strong object-oriented programming OOPS design skills, SOLID principles and proficiency in software design patterns
- Experience in database MS SQL Server, No SQL
- Solid understanding of Microservices
- Good understanding Azure, Docker and Kubernetes
- Experience with version control systems GitHub and Bitbucket
Professional Attributes :
1.Should have good communication Skills
2.Should be good team player
3.Should be able to work independently and under pressure
4.Should have good logical and analytical thinking
2) developing and testing software and resolving technical issues that arise
3) Prepare and maintain all applications utilizing standard development tools
4) Utilize backend data services and contribute to increasing existing data services API
5) Lead the entire development life cycle right from concept stage to delivery and post-launch support
6) Convey effectively with all task progress, evaluations, suggestions, schedules along with technical and process issues
7) Document the development process, architecture, and standard components
8) Coordinate with co-developers and keeps project manager well informed of the status of development effort and serves as a liaison between development staff and project manager
9) Keep abreast of new trends and best practices in web development
10) Fixing bugs
Candidate must have core .Net experience and experience in ASP.net,MVC,C# & MS SQL
Experience in SDL process
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.











