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

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

1. 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
2. f) Strong experience on Azure Active directory and adaptive cards integration in Chat bot.
3. g) Strong experience designing and working with

with service-oriented architectures (SOA) and WebAPIs.

1. h) A strong experience on Microsoft Azure, ASPNET / MVC and programming languages such as C# / VBNET
2. i) Knowledge of Python and NodeJS is a plus
3. j) Ability to design and optimize SQL Server 2008 stored procedures.
4. k) Experience with JQuery, CSS3, HTML5 or similar technologies.
5. l) Ability to adapt quickly to an existing, complex environment.

Position = Java Developer

We are looking forward to hire a committed Java Developer with experience in building high performing, scalable, enterprise-grade applications. You will be part of our Engineering team that works on mission-critical applications. You will be managing Java/Java EE application development while providing expertise in the full software development lifecycle, from concept and design to testing.

You are required to:

Contributing in all phases of the development lifecycle.

Write well designed, testable & efficient code.

Ensure designs are in compliance with specifications.

Prepare and produce releases of software components.

Support continuous improvement by investigating alternatives and technologies and presenting these for architectural review.

Technical Skills required

Java, Springboot, Microservices, Data structures & Algorithms, MySQL, NoSQL, Mongodb and Hibernate.

OUR CURRENT STACK

Backend: Spring (JAVA), Laravel (PHP), MySQL, NoSQL, NGINX Plus.

Frontend: Angular 5+ Ngrx/store 5

Infrastructure: Google cloud platform (App engine, CloudSQL, BigQuery, PubSub, Firebase Hosting), Scrapy Cloud, Pusher.io (websockets), Getstream.io, Filestack, Postmark app, AS2 Gateway, Google Cloud Endpoints Framework, MongoDB, Algolia, Memcache

Tools: Gitlab, Postman app, JIRA. Wondering what your Responsibilities would be? Technical Skills required O

You are where our search ends, if you hold:

B. Tech/ M. Tech or corresponding degree

Experience in the same role of almost 1-6 years

Experience with connecting backend and frontend services.

Exposure to consuming data through different interfaces (Web API's/Socket/ REST/ RESTFUL/ JSON/ XML).

Proficiency in Data Structures and Algorithms.

Understanding of web markup, including HTML 5 CSS.

Understanding of client-side scripting and JavaScript frameworks.

Ability to write clean, reusable and well documented code.

Proficient understanding of code versioning tools, such as Git.

Knowledge of API authentication techniques (Token, JWT, OAuth2) - desirable but not mandatory. (Experience with API Design will be a plus)

Fair spoken and written English Flexibility - Things change around here. FAST!

Other Inter-personal skills like self-motivation, persistency, patience and eagerness to learn and work independently.

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

Must have,

- Fundamental of Python(Data types in python, scope of variable, asynchronous programming)
- Should be able to code in Python

- Basic Understanding of Database

- API designing

- Problem Solving skills

- Fundamentals of storage, caching

Good to have,

- AWS Knowledge,

- Python Framework(Django, Flask)

- Knowledge on Message Broker, Caching

- SQL and no-SQL database

Primary Responsibilities

• Architect and drive complex software performance improvement projects that mitigate the performance challenges of the product and establish new guidelines for future product features
• Work with the development team, and database administrators to analyze performance bottlenecks, make recommendations to address performance concerns, and co-design performance into new feature development
• Efficiently working with various profiling and monitoring tools to identify performance and concurrency bottlenecks, propose and implement optimizations to improve cloud product
• Review end-user usage patterns and customer logged performance defects and enhance performance test coverage based on gaps identified.
• Understand database internals, server and storage system design, application interactions with database queries and stored procedures and with other downstream systems
• Troubleshoot issues experienced by users and propose solutions

Basic Qualifications

• 8+ years of experience in implementing and driving software performance engineering projects and solutions. Advanced level experience with concurrency, multithreading, and distributed system architectures
• Experience analyzing performance bottlenecks with application code interfacing with databases using ORM Frameworks, cache layers, data storage, servers, networking, and database query protocols including developing stored procedures, SQL queries, and database applications
• Working knowledge of relational database internals (locking, consistency, replication, serialization, failover, recovery)
• Comfortable with Windows, SQL Server, .NET Framework/Core, GIT, Nuget, SPA, Modern UI Frameworks, ORM Framework NHibernate in terms of both tools and application development
• Passionate about finding software performance bottlenecks and optimizing code to produce a better customer experience
• Experience with APM (Application Performance Monitoring), RUM (Real User Monitoring), and other Dev tools used for Performance monitoring and analysis
• Experience with performance bottleneck analysis, system design for scaling

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: