PL/SQL Developer

Position : SQL Database Developer

Experience : 10+ Years

Domain : Mutual Fund / Capital Markets

Location : Noida

Work Mode : Hybrid

Role Overview :

We are looking for a Senior SQL Developer with 10+ years of experience in SQL Server and T-SQL development, preferably with experience in the Mutual Fund / Capital Markets / Financial Services domain.

Mandatory Skills :

• SQL Server & T-SQL
• Stored Procedures, Functions, Triggers, Views & SQL Jobs
• Complex SQL Queries & Data Manipulation
• Query Performance Tuning & Optimization
• Indexing, Execution Plans & Partitioning
• Data Migration, Porting, Transformation & Validation
• Database Troubleshooting
• SQL Server Performance Monitoring
• Version Control / Git
• Database Security & Data Integrity

Domain Knowledge :

• Mutual Fund / Capital Markets experience preferred.
• Understanding of financial transactions, reporting, reconciliation, and business processes.

Key Responsibilities :

• Develop and optimize T-SQL queries, stored procedures, views, functions, and triggers.
• Perform query tuning, indexing, execution plan analysis, and performance optimization.
• Handle data migration, transformation, porting, validation, and reconciliation.
• Troubleshoot database and production/UAT issues.
• Ensure data accuracy, integrity, consistency, and security.
• Work with developers, BAs, QA teams, and business stakeholders.
• Independently own database development and optimization activities.
• Education: Bachelor's degree in Computer Science, IT, Engineering, or related field.

Job Summary

We are looking for an experienced Essbase Developer / Consultant with strong hands-on experience in Oracle Essbase OLAP (ASO/BSO) and financial reporting solutions. The candidate will be responsible for designing, developing, testing, supporting, and optimizing Essbase applications and reporting solutions.

The role requires strong technical expertise in Essbase, financial reporting, database modeling, Unix/Linux scripting, and production support.

Key Responsibilities

• Design, develop, test, debug, document, and maintain Essbase solutions using Agile development practices.
• Manage the complete lifecycle of multidimensional financial reporting and analytical applications, including requirements gathering, design, development, testing, deployment, and maintenance.
• Develop and support Oracle Essbase ASO/BSO applications.
• Work extensively with:
• Essbase Outline Design
• Load Rules
• MaxL Scripts
• Calculation Scripts
• Partitions
• Security
• Performance Tuning and Optimization
• Smart View / Excel Add-in
• Design and maintain financial reporting and analytical solutions.
• Work with Star Schema design and relational database modeling using Oracle or SQL Server.
• Source hierarchy and fact data from file-based and relational data sources.
• Work with metadata management systems such as DRM (Data Relationship Management).
• Develop Unix/Linux shell scripts to automate Essbase database outline builds, data loads, and aggregations.
• Build and maintain automation processes using CA AutoSys.
• Troubleshoot and resolve complex technical issues in Essbase applications.
• Provide production and on-call support when required.
• Ensure quality, security, and compliance requirements are met.
• Collaborate with business users, finance teams, and technical stakeholders.
• Document technical solutions, processes, and application changes.

Mandatory Skills

• 7+ years of overall IT/application development experience.
• 5–7 years of hands-on experience with Oracle Essbase OLAP.
• Strong experience with Essbase ASO and BSO.
• Hands-on experience with Outline Design, Load Rules, MaxL, Calc Scripts, Partitions, Security, and Performance Tuning.
• Strong experience with Smart View / Excel Add-in.
• Experience with financial reporting and multidimensional analytical applications.
• Experience with Oracle or SQL Server databases.
• Strong knowledge of Star Schema and relational database modeling.
• Experience with Unix/Linux Shell Scripting.
• Experience with CA AutoSys.
• Experience supporting production environments and providing on-call support.
• Strong communication and stakeholder management skills.

We are seeking a skilled SQL Developer to join our team. This role serves as a key bridge between insurance operations and technical solutions, ensuring business requirements are accurately translated into efficient system functionality. The SQL Developer will play a critical part in maintaining and enhancing underwriting software products and system integrations—helping deliver reliable, high-quality solutions to clients in the insurtech space.

The ideal candidate possesses strong SQL expertise, advanced data mapping capabilities, and hands-on experience working with APIs, JSON, XML, and other data exchange formats. Experience with insurance technology platforms, such as ConceptOne or similar underwriting systems, is preferred. In this role, you will regularly develop, maintain, and troubleshoot stored procedures and functions, perform data validation, support integration efforts across multiple systems, and configure insurance workflows. You will work closely with business analysts, underwriters, and technical teams to ensure smooth product updates and continuous improvement of system functionality.

What We’re Looking For:

• 5+ years of experience in a technical, insurance, or insurtech-focused role
• Strong proficiency in writing SQL, including complex queries, stored procedures, and performance tuning
• Expertise in data mapping, data validation, and reporting
• Experience working with APIs, JSON, XML, and system-to-system integrations
• Strong analytical and problem-solving skills with the ability to troubleshoot and optimize complex workflows
• Clear and effective communication skills, able to translate technical concepts for non-technical stakeholders
• Ability to work independently and manage multiple tasks in a fast-paced environment
• Keen attention to detail and commitment to delivering accurate, high-quality results
• 
  

Bonus:

• Hands-on experience with underwriting or policy administration systems (e.g., ConceptOne or similar platforms)
• Familiarity with core insurance processes, such as policy issuance, endorsements, raters, claims, and reporting
• Experience with the U.S. P&C (Property & Casualty) insurance

What You’ll Be Doing:

• Develop and optimize SQL stored procedures, functions, and triggers to support underwriting and compliance requirements
• Create and maintain reports, quote covers, and validations or map and configure forms, raters, and system workflows to ensure accurate data processes
• Set up, troubleshoot, and optimize underwriting platforms (ConceptOne/others) for performance and accuracy
• Manage integrations with APIs, JSON, and XML to connect external services and streamline data exchange
• Collaborate with BAs, QAs, and Developers to translate requirements, test outputs, and resolve issues
• Provide technical support and training to internal teams and clients to ensure effective system usage

We are looking for a Database Engineer (PostgreSQL) with 1-5 years of experience to manage, optimize, and maintain PostgreSQL databases. The ideal candidate will have expertise in PostgreSQL, SQL Optimization, Database Design, Performance Tuning, Data Migration, and Backup & Recovery.

Responsibilities:

• Design, develop, and maintain PostgreSQL databases.
• Optimize SQL queries and improve database performance.
• Perform database design, indexing, and schema management.
• Execute data migration, backup, recovery, and disaster recovery activities.
• Monitor database health and troubleshoot performance issues.
• Collaborate with development teams to ensure scalable database solutions.

Requirements:

• 1-5 years of PostgreSQL database experience.
• Strong SQL and performance tuning skills.
• Knowledge of database backup, recovery, and migration processes.

This role will be permanent with NAM info and deploy to client location Hyderabad & Pune.

Work Mode: WORK FROM OFFICE

Role Descriptions:

• Perform detailed data analysis and support business decision-making
• Gather and document business requirements and translate them into technical specifications
• Work closely with stakeholders to define data needs and reporting requirements
• Create user stories, functional specifications, and support UAT activities
• Ensure alignment between business objectives and data solutions

Required Skills:

• Strong expertise in SQL and data querying
• Proven experience in data analysis, requirement gathering, and stakeholder management
• Ability to translate business requirements into technical solutions and user stories
• Good understanding of data models, reporting, and analytics concepts

Skills: Business Analysis~ORACLE SQL

Locations: ~HYDERABAD~PUNE~

Desire candidate

• Candidate should have valid PF.

Qualifications

● 3-8 years experience in Cloud Database Administration

● Proficient in PostgreSQL database management, including installation, configuration, and performance tuning.

● Experience with Amazon RDS or Cloud SQL and managing databases in cloud environments.

● Proficient in PostgreSQL/MySQL database management, including installation, configuration, and performance tuning.

● Proven experience as a Database Administrator with a focus on

PostgreSQL/MySQL.

● In-depth knowledge of database design, implementation, and management for both PostgreSQL/MySQL environments.

● Familiarity with database security, backup procedures, and performance tuning for both systems.

● Strong analytical and problem-solving skills.

● Excellent communication and collaboration abilities.

● Relevant certifications (e.g., PostgreSQL Certified Professional, MySQLDatabase Administrator) are a plus.

Skills:

● Expertise in PostgreSQL/MySQL database management systems.

● SQL programming and query optimization for both databases.

● Data modeling and database design for PostgreSQL/MySQL.

● Backup and recovery procedures for both environments.

● Performance tuning and optimization for PostgreSQL/MySQL.

● Security protocols and measures for PostgreSQL/MySQL.

● Capacity planning and scalability for both systems.

Job Description — L2/L3 Oracle DBA and Oracle Apps DBA 

Experience: 5–10 years of relevant experience​

Support coverage: Dubai customer business hours and on-call support as required 

Role Overview 

We are seeking an experienced Oracle DBA and Oracle Apps DBA to support 

customer Oracle Database and Oracle E-Business Suite (EBS) environments. The role 

involves L2 incident resolution, L3 troubleshooting, performance tuning, patching, 

upgrades, and maintaining database and application availability. 

Key Responsibilities 

Oracle Database Administration 

∙Install, configure, administer, and maintain Oracle databases across 

production and non-production environments. 

∙Monitor database health, availability, performance, storage, and capacity. 

∙Troubleshoot database incidents, connectivity failures, locking, blocking, and 

resource issues. 

∙Analyse AWR and ASH reports, SQL execution plans, and database wait 

events to resolve performance problems. 

∙Configure and manage RMAN backups; perform recovery and restore 

validation. 

∙Administer Oracle RAC, ASM, Grid Infrastructure, and Data Guard 

environments. 

∙Perform database patching, upgrades, migrations, and refreshes through 

approved change procedures. 

∙Manage database users, roles, privileges, auditing, and security controls. 

∙Execute disaster recovery drills, Data Guard switchovers, and failovers. 

∙Automate routine administration and monitoring using shell scripts and SQL. 

Oracle Applications DBA 

∙Administer Oracle E-Business Suite R12.2 application and database tiers. 

∙Monitor and troubleshoot concurrent managers, concurrent requests, 

Workflow Mailer, application services, and login issues. 

∙Perform EBS online patching using ADOP and manage the associated 

patching lifecycle. 

∙Clone and refresh EBS environments using supported tools, including Rapid 

Clone. 

∙Maintain application configuration using AutoConfig and context files. 

∙Administer EBS-related WebLogic Server, Oracle HTTP Server, and Forms 

services. 

∙Troubleshoot application-tier performance and coordinate with functional 

and development teams. 

∙Support EBS upgrades, technology-stack patches, certificate renewals, and 

integration-related incidents. 

∙Maintain operational procedures for application startup, shutdown, backup, 

recovery, and maintenance. 

L2/L3 Support and Customer Operations 

∙Own incidents and service requests within agreed SLAs. 

∙Provide L2 troubleshooting and escalate complex issues with complete 

diagnostic evidence. 

∙Lead L3 investigation, root-cause analysis, and permanent corrective actions. 

∙Support major incidents, communicate progress, and document recovery 

actions. 

∙Raise and manage Oracle Support service requests. 

∙Prepare change plans, risk assessments, validation steps, and rollback 

procedures. 

∙Maintain runbooks, knowledge articles, configuration records, and shift 

handovers. 

∙Coordinate with customer teams and internal infrastructure, storage, 

network, and application teams. 

∙Mentor junior DBAs and identify opportunities to reduce recurring incidents. 

Required Skills and Experience 

∙Hands-on production experience administering Oracle Database, including 

Oracle 10g, 11g, 12c, 18c and 19c. 

∙Strong experience supporting Oracle EBS R12.2 as an Apps DBA. 

∙Practical knowledge of RAC, ASM, Data Guard, RMAN, Data Pump, and 

Key Responsibilities

Administer, monitor, and support database platforms including Couchbase, PostgreSQL, and Oracle.

Perform database performance tuning, optimization, and troubleshooting.

Write and optimize complex SQL queries, stored procedures, and scripts.

Ensure database availability, reliability, backup, recovery, and security compliance.

Support production incidents, root cause analysis, and ongoing operational improvements.

Collaborate with application, infrastructure, and support teams to resolve database-related issues.

Required Skills

5 to 10 years of hands-on experience in Database Administration.

Strong experience with Couchbase, PostgreSQL, and/or Oracle databases.

Expertise in performance tuning, query optimization, indexing, and SQL development (Complex Queries, Stored Procedures, Scripts)

Experience with database monitoring, backup, recovery, and maintenance activities.

Production Support, Troubleshooting & RCA

Strong analytical and troubleshooting skills.

Nice to Have

Experience with cloud platforms such as AWS, Azure, or GCP.

Exposure to database automation and scripting

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.

Primary Skills: Linux Administration, Production Support

Secondary Skills: Oracle SQL, Splunk, Grafana, AppDynamics, Cloud (OCP/AWS/Azure/GCP), Incident Management, AI/Automation.