SQL - Lead

IRIS software

Noida, India

Fresher

Save

Posted 22 hours ago
Be among the first 10 applicants

Early Applicant

Job Description

Why Join Iris
Are you ready to do the best work of your career at one ofIndia's Top 25 Best Workplaces in IT industry Do you want to grow in an award-winning culture thattruly values your talent and ambitions
Join Iris Software - one of thefastest-growing IT services companies- whereyou own and shape your success story.

About Us
At Iris Software, our vision is to be our client's most trusted technology partner, and the first choice for the industry's top professionals to realize their full potential.

With over 4,300 associates across India, U.S.A, and Canada, we help our enterprise clients thrive with technology-enabled transformation across financial services, healthcare, transportation & logistics, and professional services.

Our work covers complex, mission-critical applications with the latest technologies, such as high-value complex Application & Product Engineering, Data & Analytics, Cloud, DevOps, Data & MLOps, Quality Engineering, and Business Automation.

Working with Us
At Iris, every role is more than a job - it's a launchpad for growth.

Our Employee Value Proposition, Build Your Future. Own Your Journey.reflects our belief that people thrive when they have ownership of their career and the right opportunities to shape it.

We foster a culture where your potential is valued, your voice matters, and your work creates real impact. With cutting-edge projects, personalized career development, continuous learning and mentorship, we support you to grow and become your best - both personally and professionally.

Curious what it's like to work at Iris Head to this video for an inside look at the people, the passion, and the possibilities. Watch it .

Job Description

Strong skills in SQL internals:
Execution plans, cardinality estimation
Memory grants, parallelism (DOP), waits & latches
Locking, blocking, deadlocks, isolation levels
. Experienced in designing and tuning large scale databases
. Performance optimization experience using :
Indexing strategies (B tree, Columnstore)
Partitioning & sliding window patterns
TempDB tuning and contention mitigation
. Hands on with In Memory OLTP, Columnstore, batch heavy workloads
. Ability to diagnose systemic issues, not just individual queries
This is not a DBA role, but a strong developer who is well versed with database performance tuning, OLTP etc

Mandatory Competencies

Database - Database Programming - SQL

Database - Oracle - Data Modelling

Database - Oracle - Database Design

Database - Oracle - Performance and scalability

Beh - Communication and collaboration

Perks and Benefits for Irisians
Iris provides world-class benefits for a personalized employee experience. These benefits are designed to support financial, health and well-being needs of Irisians for a holistic professional and personal growth. Click to view the benefits.

More Info

Job Type:

Permanent Job

Industry:

IT /Computers - Software

Function:

It Industry

Employment Type:

Full time

About Company

IRIS softwareJob Source: careers.irissoftware.com

A strategic partner that transformational leaders can trust to realize the full potential of technology-enabled transformation.As a trusted technology partner, we focus our highly-experienced talent and rightsized teams to develop complex, mission-critical applications and solutions for leading enterprise across financial services, life sciences, including pharmaceutical, CROs and medical devices, manufacturing & logistics and educational services.

Job ID: 147009785

Jobs by Skill - IT