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

• Position: Appian Tech Lead
•  
• Job Description:      
•  
• Extensive experience in Appian BPM application development
• Knowledge of Appian architecture and its objects best practices
• Participate in analysis, design, and new development of Appian based applications
• Mandatory Team leadership and provide technical leadership to Scrum teams Certification Mandatory- L1, L2 or L3
• Must be able to multi-task, work in a fast-paced environment and ability to resolve problems faced by team
• Build applications: interfaces, process flows, expressions, data types, sites, integrations,
• Proficient with SQL queries and with accessing data present in DB tables and views
• Experience in Analysis, Designing process models, Records, Reports, SAIL, forms, gateways, smart services, integration services and web services
• Experience working with different Appian Object types, query rules, constant rules and expression rules

 Qualifications:

• At least 6 years of experience in Implementing BPM solutions using Appian 19.x or higher
• Over 8 years in Implementing IT solutions using BPM or integration technologies
• Experience in Scrum/Agile methodologies with Enterprise level application development projects
• Good understanding of database concepts and strong working knowledge any one of the major databases e g Oracle SQL Server MySQL

Additional Information Skills Required

• Appian BPM application development on version 19.x or higher
• Experience of integrations using web services e g XML REST WSDL SOAP API JDBC JMS
• Good leadership skills and the ability to lead a team of software engineers technically
• Experience working in Agile Scrum teams
• Good Communication skills

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

The key aspects of this role: 

• Candidate with exceptional programming skills, problem-solving abilities and strong work  ethic. 
• The candidate has to work on custom programming and web application development for  Drupal. 
• Testing, maintenance and troubleshooting of existing company sites and resolving issues if  any. 
• Contributing ideas and efforts towards internal projects and working as part of a team to  find solutions on various problems. 
• Communicate technical ideas to business users and other teams (design, QA). • Collaborate with team members and to work independently when needed. • Eager to embrace current and emerging web technologies. 

To be the right fit, you'll need: 

• Experience of total 4+ years working on PHP and Drupal 7,8 Development (at least 2+ years  in Drupal 8) 
• Strong knowledge of MySQL, jQuery, HTML5, CSS 
• Experience with Drupal architecture, best practices and coding standards 
• Knowledge on Views, Services etc. 
• Experience in custom module and theme creation 
• Familiar with sub version control systems such as Git or SVN 
• Basic knowledge of environment setup for Linux distribution

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

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