SQL Developer

Quess Corp Limited; Chennai; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Quess Corp Limited is seeking a T-SQL Database Developer with 5–7 years of hands-on experience to design, build, and optimize data solutions on high-volume transactional systems. The role emphasizes SQL performance tuning, data modelling, and exposure to banking/insurance domains, including payments and regulatory reporting.

Responsibilities include designing database objects, tuning queries, managing ETL/ELT flows with SSIS/Azure Data Factory, and ensuring reliability, security, and SDLC/DevOps

Qualifications

• 5-7 years of hands-on experience designing, building, and optimizing data solutions on high-volume transactional systems.
• Deep SQL performance-tuning expertise and strong data-modelling skills.
• Experience in banking and/or insurance domains such as payments, core banking, policy administration, claims, risk, or regulatory reporting.
• Knowledge of Sybase ASE is a plus.

Responsibilities

• Design & Development: Build robust database objects (stored procedures, functions, views, triggers) and performant SQL for OLTP workloads.
• Performance & Scalability: Diagnose and tune complex queries, indexing strategies, partitioning, and concurrency; analyse execution plans and remediate hot spots.
• Data Modelling & Standards: Create logical/physical models, enforce referential integrity, apply naming/versioning and code-quality standards.
• Batch & Automation: Author and maintain deployment and batch scripts and schedule/monitor jobs (e.g., Control-M/Autosys or native SQL Agent).
• Integration & ETL: Build and optimize ETL/ELT flows (e.g., SSIS/Azure Data Factory) feeding downstream apps, reports, and regulatory packs.
• Reliability & Security: Implement backup/restore, DR patterns, role-based access, and data-protection controls for PII/financial data; assist with audits.
• SDLC & DevOps: Use Git/SVN; participate in code reviews, CI/CD pipelines, and controlled releases across environments.
• Collaboration: Partner with application developers, BAs, testers, and platform/infra teams; provide L3 support for production incidents and root-cause analysis.
• Mentoring: Guide junior engineers on SQL craftsmanship, troubleshooting, and performance best practices.
• Ways of Working: Deliver in Agile/Scrum—plan, estimate, and track work using sprint ceremonies and tooling (e.g., Jira/Azure Boards).

Skills

T-SQL

Query optimization

Data modelling

SQL performance tuning

Banking/insurance domain

Sybase ASE

Tools

SSIS

Azure Data Factory

Git

CI/CD

PowerShell

Autosys

Control-M

Jira

Job description

Hiring for T-SQL Database Developer with 5–7 years of hands-on experience designing, building, and optimizing data solutions on high-volume transactional systems. The ideal hire brings deep SQL performance-tuning expertise, strong data-modelling skills, and practical exposure to banking and/or insurance—covering areas such as payments, core banking, policy administration, claims, risk, or regulatory reporting. Knowledge of Sybase ASE will be an added advantage.

Key Responsibilities

• Design & Development: Build robust database objects (stored procedures, functions, views, triggers) and performant SQL for OLTP/operational analytics workloads.
• Performance & Scalability: Diagnose and tune complex queries, indexing strategies, partitioning, and concurrency; analyse execution plans and remediate hot spots.
• Data Modelling & Standards: Create logical/physical models, enforce referential integrity, and apply naming/versioning and code-quality standards.
• Batch & Automation: Author and maintain deployment and batch scripts (e.g., PowerShell/Bash) and schedule/monitor jobs (e.g., Control-M/Autosys or native SQL Agent).
• Integration & ETL: Build and optimize ETL/ELT flows (e.g., SSIS/Azure Data Factory or equivalent) feeding downstream apps, reports, and regulatory packs.
• Reliability & Security: Implement backup/restore, DR patterns, role-based access, and data-protection controls for PII/financial data; assist with audits.
• SDLC & DevOps: Use Git/SVN; participate in code reviews, CI/CD pipelines, and controlled releases across environments.
• Collaboration: Partner with application developers, BAs, testers, and platform/infra teams; provide L3 support for production incidents and root-cause analysis.
• Mentoring: Guide junior engineers on SQL craftsmanship, troubleshooting, and performance best practices.
• Ways of Working: Deliver in Agile/Scrum—plan, estimate, and track work using sprint ceremonies and tooling (e.g., Jira/Azure Boards).