Oracle PL/SQL Developer

Job Description:

Role: Senior Backend Developer

Mode of work: WFO

Supercharge Your Career as a Senior Backend Developer at Technoidentity!

Are you ready to solve people challenges that fuel business growth? At Technoidentity, we’re a Data+AI product engineering company building cutting-edge solutions in the FinTech domain for over 13 years—and we’re expanding globally. It’s the perfect time to join our team of tech innovators and leave your mark!

What’s in it for You?

We are looking for a highly motivated Senior Backend Developer with 4-6 years of experience to join our team. The ideal candidate will have strong backend development expertise, a deep understanding of distributed systems, and a high sense of ownership. This role requires working independently on POCs and projects while also mentoring junior team members and enabling scalable delivery.

What Will You Be Doing?

• Design, develop, and maintain scalable backend systems and services.
• Work independently on project implementations and backend solution development.
• Implement distributed architecture design patterns to build reliable and high-performance systems.
• Collaborate with cross-functional teams to deliver robust backend solutions.
• Guide and mentor junior developers, ensuring quality implementation and adherence to best practices.
• Participate in system design discussions, code reviews, and technical decision-making.
• Ensure high ownership in delivering solutions aligned with project timelines and goals.

What Makes You the Perfect Fit?

• 4-6 years of backend development experience with strong expertise in Java or Go,
• Hands-on exposure to distributed systems, and solid knowledge of PL/SQL, with the ability to work independently and take high ownership of deliverables.
• Strong problem-solving and critical thinking abilities.
• Experience working with distributed systems and architecture design patterns.
• Strong database development skills with PL/SQL.
• Excellent team coordination and collaboration skills.
• High sense of ownership, accountability, and commitment towards project delivery.
• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related technical field is required.

Good to Have Skills

• Exposure to Cloud platforms (AWS or GCP).
• Understanding of Frontend technologies or DevOps practices.
• Experience with workflow orchestration tools such as Temporal or similar platforms.

Work Requirements:

• Willingness to work in US or flexible shift timings based on project requirements
• Ability to work independently on POCs/projects and help scale additional pods of work
• Guide and direct junior team members to ensure proper implementation

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 Profile

Purpose of Role: To support and maintain the existing and future applications managed by ABD (Agile Business Development) Team.

Main Responsibilities:

• To work on existing and future applications as required
• Work with ABD India Application Support and Business Support team to address production issues and/or to do development work
• Work with US ABD team to coordinate the on-going support and monthly release of C-Hub (Customer-Hub) application and other ABD Applications
• Report status to management on project progress
• Identify and escalate related issues and risks
• Coordinate with others in Development and Business Support team to implement new features of SQL Server/ MS Web based technologies 
• Assess current modules and offer performance improvements techniques  
• Make sure Database Design Standards/coding standards established by ABD are followed
• Constant communication with ABD leadership team in US.
• Problem Solving ability with “Can-do” attitude
• IT experience in Banking industry is preferred

Candidate Profile:

• Minimum 10 years of experience at least 3-5 years of experience in Corporate & Investment Banking area and Bachelor's degree in Engineering, Accounting, Finance, or equivalent
• Expertise with MS SQL Server development including SSIS and SSRS, Proficient in development of Stored procedure, Views, Functions etc in MS SQL Server
• Experienced with DBA kind tasks such as replication, linked server, query analyzer, DBCC commands, data transfer from one DB server to other DB Server etc
• Experienced in MS Excel VBA and macro scripting
• Knowledge of data Encryption in database

JOB DUTIES & RESPONSIBILITIES:

• Lead and mentor developers thru coaching and sharing of knowledge
• Architecture design and Develop new functionality and critical business logic of software products
• Enhance existing applications and software products and design new product

SKILLS:

• Strong knowledge on software implementation best practices
• Strong knowledge of SQL Server and/or Oracle database including store procedure, trigger etc.
• Knowledge of security and vulnerability best practices to design secure web application
• Knowledge of web application architecture with horizontal and vertical scalability
• Experience of working with application with large dataset of millions or billions of row in database table
• Ability to adapt quickly to an existing, complex environment
• Ability to complete all phases of software development life cycle including analysis, design, development, testing and support
• Ability to develop large scale web/database applications
• Ability to work on multiple projects with multiple deadlines
• Ability to communicate clearly with business users and project manager
• Ability to innovate and provide functional applications with intuitive interfaces

About Sportz Interactive

Sportz Interactive (SI) works with its clients and partners to revolutionize the sports fan experience across consumption points by creating best-in-class, kickass products. SI was founded in 2002 as a B2B sports content business. Through the years, it gained immense reputation for its state-of-the-art hosted solutions, digital simulators, match centers and fantasy games. Sportz Interactive has a fantastic reputation in the online sports community, having worked with clients across the globe including the likes of The International Cricket Council, STAR Sports, Yahoo!, AOL, Eurosport, Castrol, Web 18, NDTV, Nimbus, Times of India, Rediff.com and Singtel amongst others. 

Sportz Interactive provides in-depth sports information and content and specializes in product development for the web, mobile and other interactive platforms. 
http://www.sportzinteractive.net/">www.sportzinteractive.net 

Designation: Senior Associate 

Office Location: Goregaon East, Mumbai

Position description:

3+ years of experience in database development.

Primary Responsibilities:

• Understand requirements from front end applications developers
• Write advanced queries, stored procedures, cursors, functions & triggers
• Conduct code reviews
• Work with high-traffic application servers
• Complete understanding of various DB like Postgresql, Mongo DB, MySQL 
• Ability to identify root cause and mitigate issues
• Ability to lead a team of DB developers

Required Skills:

Mandatory: Passionate about sports, Problem solving, Team player, Target & Result oriented, Strong communication skills.

Functional: Oracle SQL, PostgreSQL Development - TSQL, Advance Queries, Query Optimization, Stored Procedures, Triggers & Cursors, Database Design, Indexes, Joins, ETL tools like SSAS, SSIS, High Data Volume Processing, DB Backup/Recovery.

Office Location: Goregaon Mumbai

Position description:

4+ years of experience in database development.

Primary Responsibilities:

• Understand requirements from front end applications developers
• Write advanced queries, stored procedures, cursors, functions & triggers
• Conduct code reviews
• Work with high-traffic application servers
• Complete understanding of various DB like Postgresql, Mongo DB, MySQL 
• Ability to identify root cause and mitigate issues
• Ability to lead a team of DB developers

Required Skills:

Mandatory: Passionate about sports, Problem solving, Team player, Target & Result oriented, Strong communication skills

Functional: Oracle SQL, PostgreSQL Development - TSQL, Advance Queries, Query Optimization, Stored Procedures, Triggers & Cursors, Database Design, Indexes, Joins, ETL tools like SSAS, SSIS, High Data Volume Processing, DB Backup/Recovery.

Required Qualifications and Skills:

• 3-5 years of work experience in the development background, with at least 2 years experience in Java, Spring, Sprint Boot, Hibernate or JPA, MySQL, Oracle, Spring MVC.
• B.E. degree in Computer Science, Graduate in Software Engineering or equivalent
• Experience in Core JAVA, Spring, Spring Boot Frameworks.
• Experience with ORM's like Hibernate.
• Good knowledge of developing RESTful web services using Spring Boot, Java1.x,Servlet2.4, JSP2.0, JDBC3.0, Java Mail, Struts2.x, HTML, HTML5, Angular7+, JavaScript, JSF, Bootstrap2.x-3.x, JQuery & CSS 3.x, Maven 3.x, Apache Tomcat7
• Knowledge of Cloud AWS.
• Experience in any Messaging Queue e.g. Apache Kafka, ActiveMQ, etc.
• Experience on Web services with REST and SOAP.
• Experience working on tool set like Eclipse IDE, SQL clients.
• Experience using application server like Jboss, TomCat, Wildfly, glassfish.
• Experience in using tools like SOAP UI, POSTMAN
• Ability to write SQL queries to fetch data.
• Knowledge of Micro services, Redis Cache and Mongo DB (or any other NoSQL) is good to have