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

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.

We are looking for an experienced Java Support Engineer with 4+ years of hands-on experience in supporting and maintaining Java/Spring Boot-based applications. The ideal candidate will be responsible for production support, debugging issues, and ensuring smooth application performance.

Key Responsibilities:

• Provide L2/L3 support for Java/Spring Boot applications in production and non-production environments.
• Perform incident analysis, root cause identification, and apply quick fixes or permanent solutions.
• Handle application deployments, environment monitoring, and performance tuning.
• Collaborate with development, DevOps, and database teams to resolve technical issues.
• Write and debug SQL queries, manage data fixes, and ensure database integrity.
• Use monitoring tools like Splunk, Kibana, or ELK Stack for issue investigation.
• Prepare documentation for recurring issues and maintain knowledge base.

Technical Skills:

• Strong in Core Java, Spring Boot, RESTful APIs
• Good knowledge of SQL / PL-SQL (Oracle / MySQL / PostgreSQL)
• Familiar with Linux/Unix commands and Shell scripting
• Exposure to microservices architecture and CI/CD tools (Jenkins, Maven)
• Hands-on experience with application monitoring and log analysis tools
• Knowledge of cloud (AWS / Azure) environments is a plus

Soft Skills:

• Strong problem-solving and analytical mindset
• Good communication and teamwork skills
• Ability to work under pressure and handle on-call support if required

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.

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

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.

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