Python with SQL [Snowflake]

Senior Software Engineer – SQL Server / T-SQL

Chennai | IIT Madras Research Park | Full-Time

About Novacis Digital

Novacis Digital is a product-first technology company building AI-driven platforms and large-scale data systems. Our products process complex, high-volume data to power real-time analytics and GenAI-driven experiences.

We don’t see SQL as “just a database layer” - we treat it as a core compute engine. If you love writing efficient SQL and solving performance problems, this is the role for you.

What You Will Do

·      Design and build complex T-SQL stored procedures involving Dynamic SQL, along with views, functions, and triggers

·      Implement flexible, metadata-driven query frameworks using sp_executesql and parameterized Dynamic SQL

·      Engineer high-performance, set-based queries using CTEs, window functions, temp tables and table variables

·      Optimize queries using execution plans, statistics and DMVs

·      Refactor inefficient queries and redesign schemas for performance and scalability

·      Solve real-world challenges related to locks, blocking, deadlocks and transaction isolation

·      Collaborate with application engineers to build reliable, high-performance data access layers

What We’re Looking For

We’re looking for true SQL engineers — people who think in execution flow, logic and data behavior rather than just syntax.

You should have:

·      4+ years of deep hands-on experience with Microsoft SQL Server & T-SQL

·      Strong expertise in:

o  Stored Procedures (with Dynamic SQL)

o  Views

o  Functions

o  Triggers

·      Strong experience with:

o  Dynamic SQL best practices and secure execution patterns

o  Indexing strategies and query plan optimization

o  Handling parameter sniffing and plan instability

·      Strong knowledge of:

o  Temp tables vs table variables

o  Cardinality estimation

o  Cost-based optimization concepts

Nice to Have

·      Exposure to GenAI data pipelines or analytical architectures

·      Exposure to Graph, Vector and No SQL Databases

How We Work

·      We write production-grade T-SQL

·      We value performance, clarity, and correctness

·      We invest heavily in query readability and maintainability

·      Engineering quality is non-negotiable

Apply Now

If you enjoy designing complex Dynamic SQL-powered stored procedures and tuning systems at scale, we’d like to talk.

Role & Responsibilities

Design, develop, and implement high-quality software solutions for payment processing.

Maintain a regular release cadence and manage the product backlog.

Ensure timely and lossless communication across teams.

Uphold engineering values and best practices.

Collaborate with international teams to ensure successful product development and delivery.

Ideal Candidate

A strong technical background in software engineering and architecture, with experience in modern programming language

Ability to work independently with very little direction, taking full ownership of projects.

Identifying blind spots, anticipate challenges, and prioritize work effectively

Exceptional communication and organizational skills.

A Bachelor's degree in Computer Science, Engineering, or equivalent experience.

8+ years of relevant experience preferred

Proficiency using Python, Kafka, Kubernetes, and AWS

Experience with Distributed Task Queues such as Celery and RabbitMQ is preferred.

Experience with RDBMS/SQL is also preferred.

Profile: Senior PHP Developer

Experience- 10+Years

Mode: Remote

Required Skills:

• PHP (10+ years) & Symfony framework (5+ years)
• Team leadership experience (3+ years)
• OOP, design patterns, RESTful APIs
• Database optimization (MySQL/PostgreSQL)
• Git, CI/CD, testing frameworks
• Excellent communication skills

Responsibilities:

• Lead PHP/Symfony development
• Mentor team members
• Ensure code quality through reviews
• Collaborate with stakeholders
• Manage sprint cycles
• Optimize application performance

Requirements:

Java developer responsibilities include designing, developing, Testing and delivering high-volume, low-latency applications for mission-critical systems.

1. Proven hands-on Software Development experience

2. Proven working experience in Java development

3. Hands on experience in developing applications using Java EE platforms

4. Profound insight of Java and JEE internals (Classloading, Memory Management, Transaction management etc)

5. Excellent knowledge of Relational Databases, SQL and ORM technologies (JPA2, Hibernate)

6. Experience in the Spring Framework

• You have 3+ years of experience using Golang/ Go Programming development language.
• You can write clean, high-quality code in a variety of languages and are also able to spot (and improve) bad code
• You have experience with Agile, Lean and/or Continuous Delivery approaches such as Continuous Integration, TDD, Infrastructure as Code, etc.
• Bonus points if you have knowledge of cloud technology such as AWS, Docker or Kubernetes

Role- Software Development Engineer-2

As a Software Development Engineer at Amazon, you have industry-leading technical abilities and demonstrate breadth and depth of knowledge. You build software to deliver business impact, making smart technology choices. You work in a team and drive things forward.

Top Skills

You write high quality, maintainable, and robust code, often in Java or C++ or C#

You recognize and adopt best practices in software engineering: design, testing, version control, documentation, build, deployment, and operations.

You have experience building scalable software systems that are high-performance, highly-available, highly transactional, low latency and massively distributed.

Roles & Responsibilities

You solve problems at their root, stepping back to understand the broader context.

You develop pragmatic solutions and build flexible systems that balance engineering complexity and timely delivery, creating business impact.

You understand a broad range of data structures and algorithms and apply them to deliver high-performing applications.

You recognize and use design patterns to solve business problems.

You understand how operating systems work, perform and scale.

You continually align your work with Amazon’s business objectives and seek to deliver business value.

You collaborate to ensure that decisions are based on the merit of the proposal, not the proposer.

You proactively support knowledge-sharing and build good working relationships within the team and with others in Amazon.

You communicate clearly with your team and with other groups and listen effectively.

Skills & Experience

Bachelors or Masters in Computer Science or relevant technical field.

Experience in software development and full product life-cycle.

Excellent programming skills in any object-oriented programming languages - preferably Java, C/C++/C#, Perl, Python, or Ruby.

Strong knowledge of data structures, algorithms, and designing for performance, scalability, and availability.

Proficiency in SQL and data modeling.