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:      

• Team Leading experience upto 2 years

• 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

• 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

🚀 We’re Hiring: Senior Python Backend Developer 🚀

📍 Location: Baner, Pune (Work from Office)

💰 Compensation: ₹6 LPA

🕑 Experience Required: Minimum 2 years as a Python Backend Developer

About Us

Foto Owl AI is a fast-growing product-based company headquartered in Baner, Pune.

We specialize in:

⚡ Hyper-personalized fan engagement

🤖 AI-powered real-time photo sharing

📸 Advanced media asset management

What You’ll Do

As a Senior Python Backend Developer, you’ll play a key role in designing, building, and deploying scalable backend systems that power our cutting-edge platforms.

Architect and develop complex, secure, and scalable backend services

Build and maintain APIs & data pipelines for web, mobile, and AI-driven platforms

Optimize SQL & NoSQL databases for high performance

Manage AWS infrastructure (EC2, S3, RDS, Lambda, CloudWatch, etc.)

Implement observability, monitoring, and security best practices

Collaborate cross-functionally with product & AI teams

Mentor junior developers and conduct code reviews

Troubleshoot and resolve production issues with efficiency

What We’re Looking For

✅ Strong expertise in Python backend development

✅ Solid knowledge of Data Structures & Algorithms

✅ Hands-on experience with SQL (PostgreSQL/MySQL) and NoSQL (MongoDB, Redis, etc.)

✅ Proficiency in RESTful APIs & Microservice design

✅ Knowledge of Docker, Kubernetes, and cloud-native systems

✅ Experience managing AWS-based deployments

Why Join Us?

At Foto Owl AI, you’ll be part of a passionate team building world-class media tech products used in sports, events, and fan engagement platforms. If you love scalable backend systems, real-time challenges, and AI-driven products, this is the place for you.

• Bachelor's degree required, or higher education level, or foreign equivalent, preferably in area wit
• At least 5 years experience in Duck Creek Data Insights as Technical Architect/Senior Developer.
• Strong Technical knowledge on SQL databases, MSBI.
• Should have strong hands-on knowledge on Duck Creek Insight product, SQL Server/DB level configuration, T-SQL, XSL/XSLT, MSBI etc
• Well versed with Duck Creek Extract Mapper Architecture
• Strong understanding of Data Modelling, Data Warehousing, Data Marts, Business Intelligence with ability to solve business problems
• Strong understanding of ETL and EDW toolsets on the Duck Creek Data Insights
• Strong knowledge on Duck Creek Insight product overall architecture flow, Data hub, Extract mapper etc
• Understanding of data related to business application areas policy, billing, and claims business solutions
• Minimum 4 to 7 year working experience on Duck Creek Insights product
• Strong Technical knowledge on SQL databases, MSBI
• Preferable having experience in Insurance domain
• Preferable experience in Duck Creek Data Insights
• Experience specific to Duck Creek would be an added advantage
• Strong knowledge of database structure systems and data mining
• Excellent organisational and analytical abilities
• Outstanding problem solver

Must-Have Technology Skills:

• OOP Concept, Java 8+, Spring Boot, API development, Agile Scrum knowledge, Strong Databases design concepts of RDBMS, and capable of writing and optimizing complex queries.
  Good understanding of any Database tool e.g. Postgres, MySQL, etc.,
• DevOps basic knowledge e.g. implementation of logging in the code, Application Performance Management.
• Basic API & Application security, and Basics of tuning application performance.
• Basic Understanding of DevOps concepts e.g. CI & CD, Deployment lifecycle, Basic understanding of unit testing concepts e.g. TDD (test-driven development).
• A basic understanding of Microservices patterns
• A basic understanding of Java scripting.
• Good understanding of UI Frameworks like Angular 8+

Must-Have Soft Skills:

• Verbal & Written English communication, Good Problem-solving skills,
• Good Planning skills,
• Team Player,
• Good leadership skills
• Good written and verbal communication

Job Description

• Good experience as a full-stack developer in DB-centric applications and should be able to write and optimize complex database queries
• Requirement gathering & understanding, effort estimation, technical design, project planning, and monitoring in an Agile environment.
• Work proactively & independently to address project requirements, and articulate issues/challenges with enough lead time to address project delivery risks.
• Providing expertise in technical analysis and solving technical issues during project delivery.
• Customer interfacing - understand customer requirements, and propose technical solutions.
• Full Software Development Lifecycle (Agile).
• Code reviews, test case reviews and ensure code developed meets the requirements.
• Component Design/ Coding/ Unit Testing/ Debugging / Test Driven Development / Continuous Integration.
• Carry out adaptive changes necessitated by changes in Business Requirements and Technology

• Design the architecture of new services to deliver timely communication from server to
• client and server to server, while still functioning alongside existing server components
• Describe and implement the communications across multiple network layers, considering
• performance, reliability, and flexibility with respect to the underlying infrastructure
• Enhance and expand the ORM layer of the studio’s in-house web framework
• Craft software solutions for supporting flexibility in resource allocation, from compute to storage
• Consult with technical operations on appropriate Kubernetes-based infrastructure design
• Design for performance, and measure the effects
• Review your colleagues’ code, and learn from their reviews as well
• Identify, document, and communicate best practices for the engineers who use the fruits of your labour
• Requirements:
• 7+ years professional work experience
• BS or MS degree in Computer Science or a related technical field
• Must be proactive, self-directed, detailed and organized
• Proficient in PHP, C++, or Go
• Knowledge of relational databases and SQL, preferably MySQL
• Experience with in-memory NoSQL databases, such as Redis
• Ability to debug issues within custom code quickly
• Passion for developing scalable and maintainable software systems

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