Why Join Iris
Are you ready to do the best work of your career at one of
India's Top 25 Best Workplaces in IT industry Do you want to grow in an award-winning culture that
truly values your talent and ambitionsJoin Iris Software one of the
fastest-growing IT services companies where
you 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 here.
Job Description
Role summary
We are looking for a hands-on database engineer to lead design, performance tuning, and optimization for high volume systems. The role focuses on SQL Server with exposure to SingleStore for caching and real time analytics. You will work closely with product and engineering teams and explain technical decisions clearly to business partners.
Key responsibilities
- Own database design, capacity planning, and performance tuning for SQL Server
- Build and optimize complex SQL, stored procedures, indexes, and partitioning strategies
- Design and manage caching or fast data access layers using SingleStore
- Diagnose bottlenecks, run query plans, and drive measurable performance gains
- Set up monitoring, alerting, and housekeeping jobs for availability and reliability
- Partner with application teams on schema changes, release readiness, and data migrations
- Create clear documentation and give walkthroughs to stakeholders
- Mentor engineers on SQL best practices and data modeling
Must have
- 10 plus years of hands-on experience with relational databases, mainly SQL Server
- Strong SQL writing skills and deep experience with performance improvement
- Solid understanding of indexing, isolation levels, query plans, and transaction handling
- Experience running production workloads and troubleshooting high severity issues
- Clear and confident communication with both technical and business users
Good to have
- Experience with MemSQL or SingleStore as a caching or analytical store
- Data modeling for OLTP and reporting use cases
- Linux or Unix shell scripting for automation
- Domain understanding of Capital Markets or broader financial services
Tools and environment
- SQL Server, SingleStore, Git, CI pipelines, monitoring and profiling tools
- Linux or Windows based database servers
Education
- Bachelor's degree in Computer Science, Engineering, or equivalent practical experience
Work setup
- Full time. Location and hybrid or on-site can be adjusted as per project needs
- On-call rotation for critical production systems as required
Keywords
SQL Server, T-SQL, SingleStore, MemSQL, caching, performance tuning, query optimization, indexing, partitioning, data modeling, Linux scripting, Capital Markets
iMandatory Competencies
Database - Database Programming - SQL
Database - Sql Server - SQL Packages
Beh - Communication
DevOps/Configuration Mgmt - DevOps/Configuration Mgmt - Git
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 here to view the benefits.
