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

Level of skills and experience:

5 years of hands-on experience in using Python, Spark,Sql.

Experienced in AWS Cloud usage and management.

Experience with Databricks (Lakehouse, ML, Unity Catalog, MLflow).

Experience using various ML models and frameworks such as XGBoost, Lightgbm, Torch.

Experience with orchestrators such as Airflow and Kubeflow.

Familiarity with containerization and orchestration technologies (e.g., Docker, Kubernetes).

Fundamental understanding of Parquet, Delta Lake and other data file formats.

Proficiency on an IaC tool such as Terraform, CDK or CloudFormation.

Strong written and verbal English communication skill and proficient in communication with non-technical stakeholderst

As an engineer, you will help with the implementation, and launch of many key product features. You will get an opportunity to work on a wide range of technologies (including Spring, AWS Elastic Search, Lambda, ECS, Redis, Spark, Kafka etc.) and apply new technologies for solving problems. You will have an influence on defining product features, drive operational excellence, and spearhead the best practices that enable a quality product. You will get to work with skilled and motivated engineers who are already contributing to building high-scale and high-available systems.

If you are looking for an opportunity to work on leading technologies and would like to build product technology that can cater millions of customers inclined towards providing them the best experience, and relish large ownership and diverse technologies, join our team today!

What You'll Do:

• Creating detailed design, working on development and performing code reviews.
• Implementing validation and support activities in line with architecture requirements
• Help the team translate the business requirements into R&D tasks and manage the roadmap of the R&D tasks.
• Designing, building, and implementation of the product; participating in requirements elicitation, validation of architecture, creation and review of high and low level design, assigning and reviewing tasks for product implementation.
• Work closely with product managers, UX designers and end users and integrating software components into a fully functional system
• Ownership of product/feature end-to-end for all phases from the development to the production.
• Ensuring the developed features are scalable and highly available with no quality concerns.
• Work closely with senior engineers for refining the and implementation.
• Management and execution against project plans and delivery commitments.
• Assist directly and indirectly in the continual hiring and development of technical talent.
• Create and execute appropriate quality plans, project plans, test strategies and processes for development activities in concert with business and project management efforts.

The ideal candidate is a passionate engineer about delivering experiences that delight customers and creating solutions that are robust. He/she should be able to commit and own the deliveries end-to-end.

What You'll Need:

• A Bachelor's degree in Computer Science or related technical discipline.
• 2-3+ years of Software Development experience with proficiency in Java or equivalent object-oriented languages, coupled with design and SOA
• Fluency with Java, and Spring is good.
• Experience in JEE applications and frameworks like struts, spring, mybatis, maven, gradle
• Strong knowledge of Data Structures, Algorithms and CS fundamentals.
• Experience in at least one shell scripting language, SQL, SQL Server, PostgreSQL and data modeling skills
• Excellent analytical and reasoning skills
• Ability to learn new domains and deliver output
• Hands on Experience with the core AWS services
• Experience working with CI/CD tools (Jenkins, Spinnaker, Nexus, GitLab, TeamCity, GoCD, etc.)

• Expertise in at least one of the following:

    - Kafka, ZeroMQ, AWS SNS/SQS, or equivalent streaming technology

    - Distributed cache/in memory data grids like Redis, Hazelcast, Ignite, or Memcached

    - Distributed column store databases like Snowflake, Cassandra, or HBase

    - Spark, Flink, Beam, or equivalent streaming data processing frameworks

• Proficient with writing and reviewing Python and other object-oriented language(s) are a plus
• Experience building automations and CICD pipelines (integration, testing, deployment)
• Experience with Kubernetes would be a plus.
• Good understanding of working with distributed teams using Agile: Scrum, Kanban
• Strong interpersonal skills as well as excellent written and verbal communication skills

• Attention to detail and quality, and the ability to work well in and across teams

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

Job Description:

• Excellent troubleshooting and communication skills
• Participate in requirements analysis and give estimates for development.
• Collaborate with internal teams to produce software design and architecture
• Client handling experience
• Write clean, scalable code using .NET programming languages
• Test and deploy applications and systems
• Revise, update, refactor and debug code
• Improve existing software
• Ability to work as a team player also as an individual contributor.
• Understanding of Scrum, Agile and Agile processes.

Required Knowledge, Skills, and Abilities:

• 3+ years of C#, .Net core, ASP.NET MVC professional development experience
• Candidate should have  hands-on with Logic App, Function App, Azure Function
• Working experience on SQL Server and No SQL Database
• Experience in ORM like LINQ & Entity Framework
• Knowledge of the NoSQL Database will be a great advantage.
• Great analytical skills and logical reasoning.
• Thorough understanding of object-oriented programming concepts, and data structures.
• Experience designing and consuming REST APIs
• Experience in JavaScript, jQuery or related frameworks.
• Knowledge of Code Repository systems including GIT, Github & SVN
• Should have strong practical knowledge of API Management Services (APIM)
• Good to have: Angular JS, React JS or any other frameworks.

Tools :  Visual Studio ,Visual studio code ,SQL server management studio, swagger and postman tool
Educational Qualification: BE, MCA OR Msc IT

Job Description for Drools developer -

• Hands on experience in design and development in Drools rule engine (minimum 1.5 years) and Core Java
• Exceptional ability to communicate with both technical and non-technical people
• Expertise in object oriented programming
• Experience in Deploying and supporting core and advanced features
• Good exposure to SQL and/or Oracle/ MySQL,
• Candidate should be well verse with Agile processes
• Strong ability to work collaboratively across diverse groups of business and technical stakeholders is required.

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

Roles and Responsibilities

• Develop and manage highly trafficked, highly scalable web properties with PHP5 using Laravel/ZEND CodeIgniter/Yii/Symfony framework.
• Understand the specifications to define system requirements.
• Collaborate and communicate project updates and progress to team members and clients.
• Analyze, design, code, debug, test, document and deploy changes to the system.

Company Profile

Prescinto is a VC funded SaaS company in the renewable energy space enabling digital transformation for customers across the globe.

Prescinto provides solutions to improve power generation for Renewable energy power plants by identifying areas of underperformance and lost generation opportunities through patent pending methodologies; systematically addressing these through an automated workflow system to improve power generation for our customers.

 This is achieved by leveraging the IoT and Analytics platform built to collect high frequency data from distributed renewable energy assets and the comprehensive data lake.

 Roles & Responsibilities

 You are responsible for understanding the product architecture and Design laid out by the Architect and Develop product features in alignment with the architecture.

Product is built on Microsoft stack with Angular 11, .NET and data residing in MS SQL Server and InfluxDB, mobile application built on Flutter and data lake deployed on Azure environment. It extensively uses multi-threading for parallel processing, stored procedures for data access and leverages time-series database for storing high frequency equipment data.

In this role, you should be able to work independently as well as work with vendor and junior members to collaboratively build the features and take them to production. You need to be both a big picture thinker and in-depth problem solver, your knowledge and skills are both broad and deep.

Do you take pride in building customer centric functionalities with an eye on performance? Are you remembered for the quality of your code? This position is for you.

Desired Skills & Experience

• 8+ years of Product development experience of which at least 2 years should comprise of working independently with minimal supervision and guidance
• Experience with at least one full cycle development of product features from requirements to Production deployment to Post production support is critical
• Excellent Programming Skills using C#, WPF, MVVM, Winforms, .NET Framework, Windows Communication Foundation (WCF), ASP.net web api, SQL Server, Store Procedure, Triggers
• Solid Understanding of Multi-Threading and Parallel Programming
• Excellent understanding of Windows Operating System Internals (Process, Threads, Memory Management).
• Clear understanding of OOP and OOAD
• Excellent application debugging skills using Visual Studio Debugger
• Strong knowledge in design patterns, data structures and algorithms
• Experienced in developing Windows desktop applications
• Ability to work independently and be self-driven
• Should have knowledge on code repositories like SVN, GitHub etc and Agile tools like JIRA
• Should have excellent communication skills, excellent analytical and problem-solving skills
• Have working experience in Test-driven Development and Test Automation experience in third party control like DevExpress, Telerik WPF controls
• Experience building a SaaS product preferable
• Startup experience preferable