Database - Lead

As an esteemed member of the Iris Software team, you will have the opportunity to contribute to one of India's Top 25 Best Workplaces in the IT industry. You will be a part of a dynamic and rapidly growing IT services company where you can unleash your full potential and excel in a vibrant work culture that prioritizes your talents and career aspirations. Iris Software is dedicated to fostering an environment where innovation thrives and employees are empowered to be their best selves. Iris Software is a visionary organization that aims to be the most trusted technology partner for its clients and a premier choice for top industry professionals to realize their career goals. With a workforce of over 4,300 associates spread across India, the USA, and Canada, we specialize in driving technological transformations in sectors such as financial services, healthcare, transportation & logistics, and professional services. Our projects involve cutting-edge technologies like Application & Product Engineering, Data & Analytics, Cloud, DevOps, Data & MLOps, Quality Engineering, and Business Automation, focusing on critical applications that deliver high value to our clients. Joining Iris Software means being part of a community where you are valued, inspired, and encouraged to thrive. We are committed to investing in our employees and fostering a culture that promotes personal and professional growth. Our Employee Value Proposition revolves around the concept of "Being Your Best," which entails being motivated by challenging work, having the freedom to excel and advance in your career, and being part of a supportive culture that recognizes and nurtures talent. At Iris Software, every individual has the opportunity to explore their potential and become the best version of themselves. Your role at Iris Software will involve utilizing your expertise in SQL/PLSQL/Oracle/Oracle Forms/Oracle reports/Ms SQL/Power Builder to create and optimize packages, procedures, functions, triggers, views, and cursors for application development. You will be responsible for crafting custom reports, forms, and modifying existing reports based on project requirements, as well as participating in all stages of the Software Development Life Cycle (SDLC) from analysis to maintenance. Additionally, you will engage in requirement gathering and user coordination, utilizing your skills in Oracle, PL-SQL, and Oracle version 19c and 21c. To excel in this role, you will need to demonstrate strong coding knowledge in PLSQL and SQL, with expertise in areas such as bulk collect, recursion, loops, nested blocks, exception handling, and analytical functions. Familiarity with performance tuning concepts like access paths, join methods, and partitioning will be essential, along with an understanding of Oracle data dictionary and complex query structures. Your mandatory competencies will include effective communication and collaboration skills, proficiency in Oracle 12c, PL/SQL, and SQL database programming. As an Irisian, you can look forward to a range of perks and benefits designed to support your financial, health, and well-being needs, enabling you to achieve a harmonious balance between your personal and professional growth. From comprehensive health insurance and competitive salaries to flexible work arrangements and continuous learning opportunities, Iris Software is committed to providing a supportive and rewarding work environment where your success and happiness are valued. Come join us at Iris Software and discover the difference of working for a company that prioritizes the success and well-being of its employees, providing a platform for you to thrive and excel in your career journey.,