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

We're seeking an experienced Backend Software Engineer to join our team.

As a backend engineer, you will be responsible for designing, developing, and deploying scalable backends for the products we build at NonStop.

This includes APIs, databases, and server-side logic.

Responsibilities:

• Design, develop, and deploy backend systems, including APIs, databases, and server-side logic
• Write clean, efficient, and well-documented code that adheres to industry standards and best practices
• Participate in code reviews and contribute to the improvement of the codebase
• Debug and resolve issues in the existing codebase
• Develop and execute unit tests to ensure high code quality
• Work with DevOps engineers to ensure seamless deployment of software changes
• Monitor application performance, identify bottlenecks, and optimize systems for better scalability and efficiency
• Stay up-to-date with industry trends and emerging technologies; advocate for best practices and new ideas within the team
• Collaborate with cross-functional teams to identify and prioritize project requirements

Requirements:

• At least 2+ years of experience building scalable and reliable backend systems
• Strong proficiency in either of the programming languages such as Python, Node.js, Golang, RoR
• Experience with either of the frameworks such as Django, Express, gRPC
• Knowledge of database systems such as MySQL, PostgreSQL, MongoDB, Cassandra, or Redis
• Familiarity with containerization technologies such as Docker and Kubernetes
• Understanding of software development methodologies such as Agile and Scrum
• Ability to demonstrate flexibility wrt picking a new technology stack and ramping up on the same fairly quickly
• Bachelor's/Master's degree in Computer Science or related field
• Strong problem-solving skills and ability to collaborate effectively with cross-functional teams
• Good written and verbal communication skills in English

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).

Your duties include

• Database development using T-SQL on MS SQL Server
• API Development using ASP.Net WEB API and C#
• R & D for available solutions and 3rd party API integrations
• Comparative Analysis of different approaches and finding optimal solutions
• Supporting existing applications in SQL, ASP.NET WEB API, C#, Angular or TypeScript

SKILLS

• Should have hands-on Experience in .NET Core, Asp.Net, MVC, Entity Framework, SQL Server with Good Communication skills.
• Use Microsoft technologies: C#, ASP.NET, SQL, MVC, and Microsoft Workflow to develop technical solutions to complex problems that require the regular use of ingenuity and creativity
• Design, code, test, debug and document software according to the functional requirements
• Develop, maintain and support programs/tools for internal and external clients
• Analyse, diagnose and resolve errors related to their applications
• Help define project plans requiring software development and hardware installations
• Provide technical and project management expertise across multiple areas of application development
• Investigate operational or systematic problems and user queries as required.
• If the candidate has experience in MVC / Angular / Azure / Xamarin, it would be an added advantage.

Education

Bachelor’s or Master’s degree in Computer engineering or relevant field
Students working towards their degree and with sufficient experience will be considered.
Qualifications-BCA, BE/B.Tech(Information Science/Technology (IS/IT)), MCA, ME/M.Tech(Information Science/Technology)

Responsibilities:

• Develop new and enhance existing micro-services, libraries, and features that form our B2B KYC platform.
• Create and document APIs, Queue Contracts to be consumed by other services.
• Work closely with the Product and Engineering Leads to implement features following best design principles and patterns.
• Participate in all phases of the development cycle - plan, design, implement, review, test, deploy, document, and training.
• Help junior developers with best practices like TDD etc. and make sure their code meets the standards.
• Educate them continuously to improve overall team performance and work quality.

Requirements:

• Bachelors/Masters in Computer Science or equivalent experience.
• Strong understanding of Computer Science fundamentals, software design principles, algorithms & design patterns.
• Development experience (> 3 to 6 years ) - preferably on languages such as GoLang / NodeJS and scripting skills.
• Interest and ability to quickly learn and ramp-up on new languages and technologies.
• Ability to write understandable, reliable and testable code with minimum supervision.
• Distributed, Highly-available systems running at large scale.
• Distributed platforms which use Kafka, Elasticsearch, Cassandra or similar systems.
• Cloud environments (e. g., Docker, AWS, GCP, Kubernetes etc., ).
• Asynchronous programming patterns (e. g., GO Routines/Channels, NodeJS Async Programming).
• Experience in CI/CD (Continuous Integration & Delivery), AGILE work environments.
• Ability to troubleshoot and solve issues on distributed systems.

Qualifications & Responsibilities 

• Strong hands-on experience with Java; full-stack development
• Designs, codes, tests, debug, and documents software, and enhance existing components to ensure that software meets business needs
• Deploy and maintain Applications/Systems
• Work with other software engineers for one or more Agile scrum teams assigned to work on the project · Contribute to the design and architecture to enable secure, scalable, and maintainable software and should be able to clearly articulate the implications of design/architectural decisions, issues, and plans to technology leadership
• Develop reusable patterns and encourage innovation that will enhance team velocity · Collaborate on the design with other team members and product owners, both inside and outside the scrum team
• Estimate engineering work effort for the engineering team and effectively identify and prioritize the high impact tasks
• Conduct design and code reviews to ensure code developed meets coding best practices guidelines, unit testing, security, and scalability and maintainability guidelines
• Drive a quality mindset within the team

Skills: 

• 2+ years of full Software Development Life Cycle experience
• 2+ years of experience working as a full-stack java developer
• 1+ years of web development with AngularJS
• Experience or familiarity with technologies such as WSDL, REST and/or SOAP web services, XML, JBoss, Adobe CQ5 DAM, HTML5, CSS3, Bootstrap, Hibernate, Spring.

Mandatory Skills:

1. Good Coding Skills
2. Hands on Experience on C#
3. Indexer
4. Object Oriented concepts using C#
5. Linq
6. Generics
7. Delegates
8. File IO
9. GAC concepts
10. MVC
11. Entity framework
12. .Net Core Concepts
13. Web-API
14. Sql Queries

Secondary Skills:

• Knowledge of Angular/React/Vue/Java Script/ Type Script
• Knowledge of HTML and CSS
• SQL Server and PL/SQL
• Understanding of Design Patterns

Interpersonal Skills:

1. Good in communications (Verbal and Written)
2. Should have worked individually or in team

Job Description: