Oracle PL/SQL Developer

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.

Job Role-12 months(contract) which is extendable /permnanent

Required Skills:

• Advanced Java skills, Spring, Spring Boot, REST APIs,
• Intermediate in Design Patterns and Principles
• Application is moving into PCF  any cloud native experience is helpful
• DB:  Oracle, SQL Server, RDBMS
• Network Infrastructure knowledge is helpful (work with network support team to troubleshoot)
• Production support skills are highly preferred.
• CI/ CD knowledge is helpful
• Junit for unit testing
• Java certifications are a huge plus

Job Description:

• An ideal candidate is someone who works well with a cohesive team-oriented group of engineers, who have a passion for developing software, who enjoy solving problems in a challenging environment, and who have the desire to take their career to the next level.
• Participate in and lead day to day system development and maintenance activities of the team to meet service level agreements (SLAs) and create solutions with high level of innovation, cost effectiveness, high quality and faster time to market.
• Accountable for full systems development life cycle including creating high quality requirements documents, use-cases, design and other technical artifacts including but not limited to detailed test strategy/test design, performance benchmarking, release rollout and deployment plans, contingency/back-out plans, feasibility study, cost and time analysis and detailed estimates.
• Research and evaluate current and upcoming technologies and frameworks.
• Participate in PoCs (Proof of Concept) and help the Department with selection of Vendor Solutions, Technologies, Methodologies and Frameworks.
• Collaborate with Vendor Resources for Support of Products.
• Conduct brownbag sessions on new and upcoming technologies, methodologies and application appropriate frameworks. Ensure knowledge transfer of vendor technology to *** staff. Provide technical training to the other team members.
  
  

Qualifications:

• Bachelor's degree in Information Systems, Information Technology, Computer Science or Engineering or equivalent work experience.
• 3 to 5 years of experience in related field.
• Broad understanding of Software Engineering Concepts and Methodologies is required.
• Back end Java Development
• API- Restful Services
• Automated Unit Testing (J Unit)
• Spring MVC
• SQL skills- Ability to work with tables, views, and stored procedures
• GIT
• Must be high-energy, detail-oriented, proactive and have the ability to function under pressure in an independent environment.
• Must provide the necessary skills to have a high degree of initiative and self-motivation to drive results.
• Possesses strong communication skills -- both verbal and written and strong relationship, collaborative skills and organizational skills.
• Willingness and ability to learn and take on challenging opportunities and to work as a member of matrix based diverse and geographically distributed project team.

Position Overview:

We are seeking a skilled Java Developer to join our dynamic team. The ideal candidate will have a strong foundation in Core Java and extensive experience in developing and deploying applications using Spring Boot, Apache Tomcat, and other related technologies. The candidate should possess expertise in building Restful Web Services, Microservices architecture, and be proficient in implementing multi-threading concepts.

Additionally, experience with Maven, Git, Jenkins, and Agile Scrum methodologies is essential for this role. The candidate should also have a solid understanding of software development lifecycle (SDLC) processes. Familiarity with various databases such as MySQL, PostgreSQL, Oracle, or MongoDB, along with third-party API integration and payment gateway integration, is required.

Key Responsibilities:

• Develop, test, deploy, and maintain Java-based applications.

• Design and implement Restful Web Services and Microservices using Spring Boot.

• Utilize multi-threading concepts to enhance application performance.

• Integrate third-party APIs and payment gateways into applications.

• Collaborate with cross-functional teams to gather requirements and deliver high-quality solutions.

• Participate in Agile Scrum ceremonies and contribute to sprint planning, backlog grooming, and retrospectives.

• Ensure adherence to best practices and coding standards.

• Conduct code reviews and provide constructive feedback to peers.

• Troubleshoot and debug complex issues in production environments.

• Document design decisions, processes, and procedures.

Required Qualifications:

• Bachelor’s degree in computer science, Engineering, or related field.

• Minimum 3 years of experience as a Java Developer with expertise in Core Java.

• Strong knowledge of Spring Boot, Apache Tomcat, and multi-threading concepts.

• Hands-on experience in building Restful Web Services and Microservices architecture.

• Proficiency in using Maven, Git, and Jenkins for build and deployment processes.

• Familiarity with Agile Scrum methodologies and SDLC processes.

• Experience working with databases such as MySQL, PostgreSQL, Oracle, or MongoDB.

• Demonstrated ability to integrate third-party APIs and payment gateways.

• Excellent problem-solving and analytical skills.

• Effective communication and collaboration skills.

• Familiarity with NoSQL databases like MongoDB.

• Knowledge of Azure DevOps for CI/CD pipelines

Job Description

1. 5- 8 yrs IT industry experience preferably Banking domain
2. Strong Python Skills and good understanding of Java and Microservices
3. Should have handled banking customers and exposure to Production support processes
4. Good in database and Pl/SQL – Ability to write SQL as and when needed  
5. Good attitude and communication
6. WFH not allowed – Working from Bank premises as per bank calendar in Saifabad or Hitech City – Saifabad Flexibility must

We are building for the future of work by changing the way the world looks at information and data paradigms. The Meaning Engine by India-based Needle Innovision enables building solutions by processing meaningful data out of anything stored anywhere - structured, unstructured data types, distributed, at scale and more. 

In our quest to do more, we are looking for a fantastic Java Tech Lead to join us in a hybrid setting from New Delhi. Below are some (seriously important) green flags that we are looking for from you: 

🟢 Ability to build and repeat the vision, not just work on tasks in the new phase of your career

🟢 The excitement to architect awesome products and resilient teams

🟢 Preparedness to move into enterprise-ready environments 

🟢 Build team motivation, delegate smartly and create a career path

This could be an awesome launching pad for someone who enjoys working towards big-picture goals, has a keen interest in leadership, and has a deep understanding of Java technologies.  Our teams are sustained on values of care and we offer a generous number of vacation days, the opportunity to craft your calendar with flexible schedules and very soon an insurance plan for you and your loved ones. We offer a starting salary range of 10-14LPA.

What you will do: 

• Collaborate with the client to understand problem statements and provide solutions for the same.
• Explain client requirements to the project team and plan and delegate work requirements
• Ensure the applications are released to production in the committed timeline
• Work with the QA team to ensure the code developed by the team passes the necessary quality check.
• Document application changes and development updates
• Set and evolve standards and best practices for our application development team 
• .Guide and mentor junior developers and engage in regular learning activities
• Oversee development process compliance and CI activities.

What you will bring: 

• 4 years minimum detail-oriented experience as a Senior Software Engineer.
• Experience in client interactions and/or are looking forward to doing that (preferred if, you have worked in B2B application development for large enterprises 🟢)
• Prior experience of at least one large project with a few people under your belt. (🟢)
• Expert-level knowledge of Java, Spring Boot, Oracle/Postgres.
• Expert-level knowledge on one or all of Hibernate/JPA/MyBatis.
• Experience in RESTful services and fundamentals of MVC architecture.
• Experience in working with and configuring web and application servers, such as Apache/Nginx/Tomcat.
• Proficient understanding of build tools, such as Maven/Gradle and code versioning tools, such as Git/SVN.
• Ability to review specifications documents and provide technical inputs on successfully implementing business solutions.

As a Java Tech Lead, you would be expected to understand business requirements, represent Needle to external stakeholders, and have experience in working in agile teams.

If leading a squad that implements digital transformation solutions at the intersection of data science and AI excites you, and if our awesome bite-sized team inspires you to be a part of our quest, we think you could be the one to help build the impact, we are looking to building here. 

Lets talk!

Mandatory Requirement/ Preference:

- 4 years of experience for delivering enterprise solutions or products using full SDLC 

- 4 years of work experience with enterprise solutions for Microsoft platform (SQL Server, stored procedures, WCF, C#.net, Entity Framework) 

- Extensive knowledge and experience with creating and maintaining stored procedure in MS SQL Server.

- Working with WEB API added advantage

Job Role – SDE2

Duration – 12 months

Location – HYD

Key Skills:

• 3- 5 years
• Understanding databases and building reports
• Ideal candidate should have experience in Cosmos, Kusto and powerbi
• Mandatory experience in some Database query language(such as SQL)