11+ Transact-SQL Jobs in Pune | Transact-SQL Job openings in Pune

We are looking for a Senior Microsoft SQL Developer to design, develop, test, plan, implement and maintain conceptual and logical database models.

For this role, you should know how to analyze system requirements and implement migration methods for existing data. Hands-on experience with SQL Server 2012 and above is also required. Ideally, you are familiar with database design, reviewing code, writing stored procedures, creating and modifying SQL agent jobs, making structural changes to tables and views.

Ultimately, you will develop database solutions to ensure project information is stored effectively and securely.

We’re a fast-growing company with clients in the United States, UK, and Australia. You will join a team of talented developers, quality engineers, product managers whose mission is to impact above 100 million people across the world with technological services by the year 2030.

Working as Senior Microsoft SQL Developer at Navtech, you will:

1. Design conceptual and logical data models and flowcharts.
2. Improve system performance by conducting tests, troubleshooting, and integrating new elements.
3. Design and Build database systems of high availability and quality depending on each end user’s specialized role.
4. Help write and optimize in-application SQL statements.
5. Handle common database procedures such as upgrade, backup, recovery, migration, etc.
6. Ensure performance, security, and availability of databases.
7. Use high-speed transaction recovery techniques and backup data.
8. Provide proactive and reactive data management support and training to users.
9. Determine, enforce and document database policies, procedures, and standards.
10. Perform tests and evaluations regularly to ensure data security, privacy, and integrity.
11. Monitor database performance, implement changes, and apply new patches and versions when required.

1. 5+ years of experience in SQL Server Development with at least 1 year of Lead experience.
2. Advanced experience in database monitoring, troubleshooting, performance tuning, and high availability strategies for SQL Server 2016, SQL Server in Cloud (AWS RDS preferred).
3. Advanced skills in resolving database locking conflicts/blocking and resource utilization.
4. Ability to work with other developers and engineers to analyze database performance and identify problems in areas such as execution plans, index coverage, and SQL server statistics.
5. A thorough understanding of Performance Monitoring, Tuning, and Optimization, using native and third-party monitoring and troubleshooting tools.
6. Advanced knowledge of SQL Server Disaster Recovery (DR) options, Always On availability groups, and experience administering Windows Server, including Active Directory, Failover clustering, database partitioning, security, and encryption (a plus).
7. Experience supporting SSIS, SSRS, replication, database mirroring (a plus).
8. PowerShell scripting experience with the ability to write automated scripts and strong knowledge of system tables and DMV’s is required. (a plus).
9. Administering Microsoft SQL Server databases in a high transaction, 24x7 database environment (a plus).
10. Experience in Postgres, No-SQL databases (a plus).
11. MCSA SQL Server 2012/2016 , MCSE or MCDBA (a plus).
12. Should have excellent logical, analytical, and communication skills with client interaction experience.

Benefits

• Working with industry giants while following your passion for technology.
• Competitive pay package with additional bonus and benefits.
• Performance review and Appraisal Twice a year.
• Family Health Insurance cover for self and family.
• Work with US, UK, and Europe-based industry-renowned clients for exponential technical growth.
• Work with a culturally diverse team from different geographies

Integration Developer

ROLE TITLE

Integration Developer

ROLE LOCATION(S)

Bangalore/Hyderabad/Chennai/Coimbatore/Noida/Kolkata/Pune/Indore

ROLE SUMMARY

The Integration Developer is a key member of the operations team, responsible for ensuring the smooth integration and functioning of various systems and software within the organization. This role involves technical support, system troubleshooting, performance monitoring, and assisting with the implementation of integration solutions.

ROLE RESPONSIBILITIES

·       Design, develop, and maintain integration solutions using Spring Framework, Apache Camel, and other integration patterns such as RESTful APIs, SOAP services, file-based FTP/SFTP, and OAuth authentication.

·       Collaborate with architects and cross-functional teams to design integration solutions that are scalable, secure, and aligned with business requirements.

·       Resolve complex integration issues, performance bottlenecks, and data discrepancies across multiple systems. Support Production issues and fixes.

·       Document integration processes, technical designs, APIs, and workflows to ensure clarity and ease of use.

·       Participate in on-call rotation to provide 24/7 support for critical production issues.

·       Develop source code / version control management experience in a collaborative work environment.

TECHNICAL QUALIFICATIONS

·       5+ years of experience in Java development with strong expertise in Spring Framework and Apache Camel for building enterprise-grade integrations.

·       Proficient with Azure DevOps (ADO) for version control, CI/CD pipeline implementation, and project management.

·       Hands-on experience with RESTful APIs, SOAP services, and file-based integrations using FTP and SFTP protocols.

·       Strong analytical and troubleshooting skills for resolving complex integration and system issues.

·       Experience in Azure Services, including Azure Service Bus, Azure Kubernetes Service (AKS), Azure Container Apps, and ideally Azure API Management (APIM) is a plus.

·       Good understanding of containerization and cloud-native development, with experience in using Docker, Kubernetes, and Azure AKS.

·       Experience with OAuth for secure authentication and authorization in integration solutions.

·       Strong experience level using GitHub Source Control application.

·       Strong background in SQL databases (e.g., T-SQL, Stored Procedures) and working with data in an integration context.

·       Skilled with Azure DevOps (ADO) for version control, CI/CD pipeline implementation, and project management.

·       Experience in Azure Services, including Azure Service Bus, Azure Kubernetes Service (AKS), Azure Container Apps, and ideally Azure API Management (APIM) is a plus.

GENERAL QUALIFICATIONS

·       Excellent analytical and problem-solving skills, with a keen attention to detail.

·       Effective communication skills, with the ability to collaborate with technical and non-technical stakeholders.

·       Experience working in a fast paced, production support environment with a focus on incident management and resolution.

·       Experience in the insurance domain is considered a plus.

EDUCATION REQUIREMENTS

·       Bachelor’s degree in Computer Science, Information Technology, or related field.

• 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

ESSENTIAL EXPERIENCE 

1.   3.5 to 12-14 years of experience as a Software Developer.

2.   Experience in .Net technologies - C#, ASP.net is must.

3.   Experience in developing REST based PAPIs.

4.   Experience in building web user interface.

5.   Good to have experience in developing single page apps using modern JS framework.

6.   Skills in cross browser development.

7.   Understanding of Agile methodology.

8.   Excellent trouble shooting and communication skills.

9.   Knowledge of Azure will be an added advantage. 

JOB DESCRIPTION

1. Developing and implementing web-based applications using .Net technology and MS-SQL.
2. Developing front end with highly responsive user interface concept using React concept.
3. Identifying web-based user interaction.
4. Participate in requirement analysis.
5. Collaborate with internal teams and positive mindset to help and seek help.
6. Documentation of application development changes and updates. 

We are on a mission to enable businesses to build agile and accountable technology teams that can deliver results in a secure and scalable way. You will be working in one such technology team for our clients across the world.

• Collaborate with front-end and back-end developers and designers to build website following client requirements

• Create clear, simple, and reusable code

• Develop all server-side logic, including data storage to optimize website performance

• Identify programming bottlenecks and bugs and find fixes

• Test, update and validate web applications to be used on different web browsers

• Execute automated testing platforms and system tests

• BSc/BE/BTech in Computer Science, Engineering or a related field

• At least 2+ years of experience with JavaScript and Node.js

• Hands-on expertise in REST, MySQL/PostgreSQL, WebSocket, MongoDB, Redis, etc.

• Familiarity with Docker and AWS infrastructure

• Understanding of data security principles

• Proficiency in JavaScript, web stacks, libraries, and frameworks

• Strong analytical and problem-solving aptitude skills

1.   7 to 12-14 years of experience as a Software Developer.

2.   Experience in .Net technologies - C#, ASP.net is must.

3.   Experience in developing REST based APIs.

4.   Experience in building web user interface.

5.   Good to have experience in developing single page apps using modern JS framework.

6.   Skills in cross browser development.

7.   Understanding of Agile methodology.

8.   Excellent trouble shooting and communication skills.

9.   Knowledge of Azure will be an added advantage.

JOB DESCRIPTION -

1. Developing and implementing web-based applications using .Net technology and MS-SQL.
2. Developing front end with highly responsive user interface concept using React concept.
3. Identifying web-based user interaction.
4. Participate in requirement analysis.
5. Collaborate with internal teams and positive mindset to help and seek help.
6. Documentation of application development changes and updates.

TECHNICAL SKILLS

1. Expert in C#, ASP.Net, Web API, MS SQL Server.
2. Good to have experience in React and workflows such as Redux or Flux, MongoDB.
3. Knowledge of HTML, CSS and JavaScript.
4. Familiar with source control system (GIT, SVN).

Responsibilities

• Determines technical feasibility of medium to low complexity features or solutions by evaluating problem, customer requirements, possible solutions and technology requirements.

• Exercises judgment in prioritizing tasks and selecting methods and techniques for obtaining solutions.

• Create a low-level design of modules of a software application through proper documentation and diagrams.

• Develops software solutions by studying requirements, clarifying customer/user needs, analyzing data and processes, and following established software development practices and processes.

• Develops proof of concepts for technical evaluation and early customer feedback.

• Updates and shares knowledge by studying state-of-the-art development tools, programming techniques, and computing technology; reading professional publications.

• Networks with internal and external personnel in their area of expertise.

Requirements

• B.Tech/B.S. or M.Tech/M.S. in Computer Science, IT or related field.

• 3-5 years of experience

Visit us on :

Mandatory Skills

• Should be proficient in the following areas of .NET (.NET 4.5 or above, .NET Core)

• Expert in C# and ASP.NET

• Knowledge of JavaScript/TypeScript is a plus

• Development of Windows and Web services

• Parallel and Asynchronous programming

• Unit testing, Linq, ORM

• Debugging/troubleshooting in .Net

• Should be proficient in SQL Server 2012 and above in the following areas

• T-SQL Stored Procedures

• Transaction in SQL

• Should have the following design skills

• Expert in OOPs

• Proficiency in Design Patterns

• Proficiency in Unit testing Patterns

• Understanding of Algorithms and Data structures.

• Experience on Requirement/Design/Code Review & Inspections

• Excellent problem-solving and analytical skills.

Desirable Skills

• Hands-on experience with using Git (handling branching and merging), any DevOps pipeline

• Experience with Agile methodologies

Required Technical Skills: 

• Java (highly capable)
• SQL (highly capable)
• Strong knowledge of software best practices, build processes, IDEs, database tools (e.g. SQL Developer, SQL Management Studio)
• Strong knowledge of source code control systems (GIT)
• Confident with Windows, Linux, Unix operating systems including command line
• Working knowledge of JIRA

Beneficial Technical Skills: 

• .Net
• C 
• Javascript 
• Experience in test management and test execution
• Experience of Agile development methods

Additional Skills and Behaviour Required 

• Experience of full software development lifecycle
• Considers competing solutions and evaluates options to create the best outcome in all aspects of the role.
• Willingness to takes ownership of whole project and engineers assigned.
• Confident to make suggestions and recommendations for improvements.
• Excellent written and verbal communication skills and ability to build good rapport
• Fluency in English, both written and oral
• Collaborates with others to achieve objectives and ensure information flow
• Seeks assistance and feedback as appropriate 

Education 

• Bachelor's degree (or equivalent) in Computer Science or Engineering or other relevant discipline (MCA, MSc in Computer Science etc.)