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

Azure Chatbot Developer

Location :Bangalore / Mumbai / Pune

Job Description

Build and maintain bots on Azure platform. Integration with Active directory, WEB API based integration with external systems. Training and Integrate bots as per users’ requirements. Work in line with design guidelines, best practices and standards of bot deliverable. Creative approach to the conversation flow design, human aspects in the bot responses and sentiments

Qualifications

a) 5 years of experience in software development with clear understanding of the project life cycle
b) Min 2-3 years of hands-on experience in Microsoft Azure Bot Framework, LUIS and other Cognitive services offered by Azure
c) Hands on experience with Machine Learning based chat bots
d) Experience with Azure bot services like Text Analytics etc.
e)Strong database skills and hands-on experience on databases like SQL Server/Oracle

f) Strong experience on Azure Active directory and adaptive cards integration in Chat bot.

g) Strong experience designing and working with

with service-oriented architectures (SOA) and WebAPIs.

h) A strong experience on Microsoft Azure, ASPNET / MVC and programming languages such as C#/VBNET

i) Knowledge of Python and NodeJS is a plus

j) Ability to design and optimize SQL Server 2008 stored procedures.

k) Experience with JQuery, CSS3, HTML5 or similar technologies.

l) Ability to adapt quickly to an existing, complex environment.

Position: Sybase Developer

Location: Bangalore /Pune

Exp.Level: 8+ Yrs

Proven experience as a. Sybase Developer

Familiarity with Oracle, Sybase, Performance tuning and Optimization

Required Skills: Sybase, Performance tuning and Optimization

Must-Have:

• Core Java (Must be good in Core Java concepts, Java programming practices, Clean coding.)
• Spring Framework(Must have working experience in Spring Core)
• Any SQL framework(hands-on working experience in any of these: Hibernate/JPA/MyBatis/Spring Data/Others)
• Hands-on experience in REST API
• Hands-on experienceSQL Database(any of the databases: Oracle/MySQL/PostgreSQL/SQLServer)
• Must have working experience with basic GIT
• Maven or Gradle (Must have working experience in building Java projects using maven or Gradle.)
• Should be able to work independently under someone's guidance.

Good to have:

• Advanced Java(Threading, Performance optimization)
• Spring Boot
• Other Spring frameworks(Spring Security, Spring Batch, Others)
• Microservices - Any NoSQL database(MongoDB, Cassandra, others)
• Application designing concepts.

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:

Job Description-

Backend Developer- Senior

Experience - 3-6 years

Location: Pune/Kota

Minimum Qualifications:

- BE/B.Tech or ME/M.Tech in Computer Science.

- Must have “Can Do Attitude” towards work

- Must have work exp of 3-6 years

- Must have programming exp of 1-2 years in any of Python/Golang/Java languages

- Must have worked in product based company

- Ready to work in a startup and adaptable to a dynamic environment

- Ready to accept ad-hoc requirements and track them till they get implemented

- Ready to learn new technologies like Andriod, Angular, etc.

- Good at HTTP basics, OOPs concepts, data structures, algorithms, networking and

security aspects

- Ability to write clean code and maintain it

- Good at SQL/No-SQL databases

Preferred Qualifications:

- Experience in any good product based startup

- Experience in working with the team and managing a small team of 2-5 associates

- Experience in being a mentor for co-developers

- Experience in design/developing scalable systems.

- Experience in public cloud platforms services/APIs of AWS, Google Cloud, etc.

- Experience in data engineering

- Experience in SOA/Microservice architecture development

Responsibilities:

- Design and develop scalable services and APIs in Python/Golang

- Always maintain the services secure

- Should optimize APIs for mobile data and apps

- Use off-the-shelf and state-of-the-art services for faster development of product

- Guide team members with designs

- Take the end to end ownership of features and resolve customer issues on priority

- Mentor/guide/monitor junior developer

- Expertise Android/Angular to the required extent and guide app developers while

designing APIs

Opportunities in the role:

- LearnAngular, Python, Node.js, Golang, ELK stack, MEAN/MERN

- Work on AWS, Azure, Google Cloud Platform

- Work on databases like RDS, MongoDB, Big Table & DynamoDB, Redis, Aerospike

- Experience with SQL/ NoSQL Databases (RDS, DynamoDB, Google Datastore, Redis)

- Experience with ELK stack.

- Fast prototyping of proof-of concept features/application based on a brief

- Work on data engineering