
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
· Good understanding of OOPS, design principles and design patterns.
· C# development experience.
· Experience with WCF is required.
· Experience of working with web API is required.
· Experience with Windows services and Winforms will be useful.
· Experience of working with .NET Core is useful. Some exposure is expected.
· Experience of working with MS SQL Server.
· Experience of working with micro services will be useful.
· Experience of working with any queueing middleware like MSMQ, Rabbit MQ, WMQ will be useful.
· Exposure to cloud provisioning will be useful, in particular Azure.
· Exposure to security vulnerabilities and top 10 from OWASP will be useful.
· Exposure to front end technologies will be useful. Though it’s secondary but any experience with
SPA libs and frameworks in particular will be useful. Experience with either Angular or React will be
useful.
· Experience with any or all stated tools – TFS, Git, SOAP UI, Postman, Fiddler,
· Experience with CI/CD devOps tooling and practices is useful.
Soft skills required
· Good communication skills, both verbal and written. S/he should be able to articulate well.
Detailed JD:
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 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
Tech Stack:
C#, .NET Core, XUnit, Entity Framework Core, MS SQL Server, PostgreSQL, Git, JIRA, Web API
- 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.
HIRING SQL Developers with max 30 days Of NOTICE PERIOD
Job ID: TNS2022DB08
Who Should apply?
• Only for Serious job seekers
• Technically Strong Candidates who are willing to take up challenging roles and want to raise
their Career graph
• No DBA’s & BI Developers please
Why Think n Solutions Software?
• 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:
1. Technical Skills Desired:
a. Experience in MS SQL Server and one of these Relational DB’s, PostgreSQL / AWS
Aurora DB / MySQL / Oracle / NOSQL DBs (MongoDB / DynamoDB / DocumentDB) in
an application development environment and eagerness to switch DB.
b. Design database tables, views, indexes
c. Write functions and procedures for Middle Tier Development Team
d. 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).
e. Query Optimization for performance improvement
f. Design & develop SSIS Packages or any other Transformation tools for ETL
2. Functional Skills Desired:
a. Banking / Insurance / Retail domain would be a plus.
b. Interaction with a client a plus.
3. Good to Have Skills:
a. Knowledge in a Cloud Platform (AWS / Azure)
b. Knowledge on version control system (SVN / Git)
c. Exposure to Quality and Process Management
d. Knowledge in Agile Methodology
4. Soft skills: (additional)
a. Team building (attitude to train, work along, mentor juniors)
b. Communication skills (all kinds)
c. Quality consciousness
d. Analytical acumen to all business requirement
e. Think out-of-box for business solution
- 5+ years of object-oriented software development of web applications
- 5+ years of C# in a .NET environment
- Preferable Experience in Cloud Technologies (AWS, AZURE)
- Experience with MS SQL stored procedures, database design and optimization
- Experience developing and utilizing web services
- Experience with high volume consumer oriented web sites
- Experience working in an Agile Scrum environment
- Experience with formal test procedures, release management
- Preferable Travel industry experience preferred, especially programming associated with GDS’s - SABRE, Farelogix, and Travelport
- Ability to distill complex business needs into functional requirements
- Excellent follow-up, verbal and written communication skills
- Excellent problem solving skills and an ability to make good decisions
- Team player with a professional attitude
- Ability to manage multiple tasks and maintain tight schedules
- Ability to work effectively with a geographically dispersed team in India
Strategic and Development Responsibilities
- Ability to "think outside the box"
- Ability to provide accurate and timely project estimates.
Pluses:
- Experience with Angular JS frameworks and Mobile Development.
- Experience with developing machine learning algorithms.
- Experience on projects that required localization/globalization
- Experience with MS SQL Reporting Services
- Knowledge of web farm configuration and best practices
Software Tools/Languages
Required: MS Visual Studio, MS SQL Server Management Studio, IIS, AWS
C#, Web Services, MS SQL (stored procedures), Jenkins, DevOps Tools.
Education
Bachelor of Science in CS, MIS, or equivalentWe 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.











