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.

Role: .NET Developer

Exp: 5-7 Years

CTC: up to 15 LPA

Required Qualifications:

• 5+ years of professional software development experience.
• Post-secondary degree in computer science, software engineering or related discipline, or equivalent working experience.
• Development of distributed applications with Microsoft technologies: C# .NET/Core, SQL Server, Entity Framework.
• Deep expertise with microservices architectures and design patterns.
• Cloud Native AWS experience with services such as Lambda, SQS, RDS/Aurora, S3, Lex, and Polly.
• Mastery of both Windows and Linux environments and their use in the development and management of complex distributed systems architectures.
• Git source code repository and continuous integration tools.
• Proficient with debugging and profiling distributed systems.

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

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.

Minimum of 4+ years of experience in Java development

• Experience delivering Services (REST, SOAP) and Web applications in Micro services architecture
• Experience developing and deploying Java solutions to cloud
• Experience in Spring Boot and components of Spring framework
• Experience in a JavaScript framework such as Angular or React
• Experience in TDD using Junit or similar frameworks

·       Experience in Design Patterns and service oriented architectural principles, Data structures and Algorithms.

·       Individual should be an active participant in the product design and code reviews for self and team and can competently review any aspect of their product or major sub-system.

·       Experience in SQL, Unix skills.

·       Good communication Skill

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