PL/SQL – Manager Full Time

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 ambitions?

Join 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

Technical skill : Strong hands‑on experience with Oracle Database (12c/19c )

• Advanced proficiency in PL/SQL development
• Strong command over SQL performance tuning and query optimization
• Experience with:
• Indexing strategies
• Partitioning
• Execution plan analysis

Good To Have

• Exposure to Unix/Linux environments
• Familiarity with shell scripting
• Experience with data warehousing concepts

Key Responsibility

• Experience working with large data volumes and complex schemas
• Design, develop, and maintain Oracle database objects including tables, indexes, views, packages, procedures, and functions
• Write and optimize complex PL/SQL code for performance, scalability, and reliability
• Perform SQL and PL/SQL tuning using execution plans, indexing strategies, and optimization techniques
• Work closely with application teams to support data modeling, schema design, and database integration
• Troubleshoot and resolve database‑related issues in development, QA, and production environments
• Support data migration, data validation, and release deployments
• Ensure adherence to security, compliance, and data governance standards
• Participate in code reviews and contribute to best practices and architectural decisions

Mandatory Competencies

Database – Database Programming – PL/SQL

Database – Oracle – PL/SQL Packages

Database – Oracle – Data Modelling

Database – Oracle – Performance and scalability

Database – Oracle – Oracle 19c

Database – Oracle – Oracle 12c

Database – Database Programming – SQL

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 here to view the benefits.