Database - Lead

2 weeks ago

Noida India IRIS software Full time

Job Description

Why Join Us
Are you inspired to grow your career at one ofIndia's Top 25 Best Workplaces in IT industryDo you want to do the best work of your life at one of thefastest growing IT services companies Do you aspire to thrive in an award-winning work culture thatvalues your talent and career aspirations It'shappening right hereat Iris Software.

About Iris Software
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 at Iris
Be valued, be inspired, be your best.
At Iris Software, we invest in and create a culture where colleagues feel valued, can explore their potential, and have opportunities to grow.
Our employee value proposition (EVP) is about Being Your Best - as a professional and person. It is about being challenged by work that inspires us, being empowered to excel and grow in your career, and being part of a culture where talent is valued. We're a place where everyone can discover and be their best version.

Job Description

- Extensive knowledge in SQL/ PLSQL/Oracle/Oracle Forms/Oracle reports/Ms SQL/Power Builder.
- Create and optimise packages, procedures, functions, Triggers, Views, cursors to develop application.
- Experience in create/modifies packages, views, procedures, Triggers, Views, cursors and functions.
- Create new custom Reports, Forms and modify existing Reports according to the requirement.
- Involve in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation, maintenance and reporting to the client.
- Experience on Evaluation, Implementation and support with a skillset of Oracle, PL-SQL.
- Involve in requirement gathering and coordination with users.
- Hands on in Oracle version 19c and 21c
- Strong coding knowledge in PLSQL (Bulk Collect, Recursion, Loops (FOR, WHILE DO), Nested blocks, Exception Handling)
- Strong Coding knowledge in SQL (Analytical functions, View and Materialized Views, Sys tables and Privileges)
- Good understanding of Performance tuning concepts like Access Paths, Join methods, Partitioning, etc..
- Awareness about Oracle data various dictionary and their significance.
- Complex Queries : Nested queries, inline views, co-related subqueries
- Awareness about Hierarchical queries

Mandatory Competencies

Beh - Communication and collaboration
Database - Oracle - Oracle 12c
Database - Database Programming - PL/SQL
Database - Database Programming - SQL

Perks and Benefits for Irisians

At Iris Software, we offer world-class benefits designed to support the financial, health and well-being needs of our associates to help achieve harmony between their professional and personal growth. From comprehensive health insurance and competitive salaries to flexible work arrangements and ongoing learning opportunities, we're committed to providing a supportive and rewarding work environment.
Join us and experience the difference of working at a company that values its employees success and happiness.

  • Database PostgreSQL

    1 week ago

    Noida, India IRIS software Full time

    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...

  • Database Technical Lead

    5 days ago

    India Twinline Business Solutions Full time

    Database Technical Lead Twinline Business Solutions Pvt Ltd. – Gurgaon, Haryana Job Summary A very strong experience of developing PL/SQL procedures, functions, packages . Creates new and reviews existing PL/SQL packages, procedures to support development efforts. Responsible for the design, development, test, release, maintenance ,...

  • Lead Database Developer

    3 weeks ago

    Noida, Uttar Pradesh, India Clarivate Full time

    Job DescriptionWe are looking for Senior Database Developer-PostgreSQL to join our technology team at Clarivate.The Lead Database Developer will be responsible for overseeing the design, development, and maintenance of high-performance databases using PostgreSQL and Oracle.About You - experience, education, skills and accomplishments- Bachelor s degree in...

  • Database - Lead

    1 week ago

    Noida, India Iris Software Full time

    Extensive knowledge in SQL/ PLSQL/Oracle/Oracle Forms/Oracle reports/Ms SQL/Power Builder. Create and optimise packages, procedures, functions, Triggers, Views, cursors to develop application. Experience in create/modifies packages, views, procedures, Triggers, Views, cursors and functions. Create new custom Reports, Forms and modify existing Reports...

  • Database - Lead

    14 hours ago

    Noida, Uttar Pradesh, India Iris Software Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Extensive knowledge in SQL/ PLSQL/Oracle/Oracle Forms/Oracle reports/Ms SQL/Power Builder.Create and optimise packages, procedures, functions, Triggers, Views, cursors to develop application.Experience in create/modifies packages, views, procedures, Triggers, Views, cursors and functions.Create new custom Reports, Forms and modify existing Reports according...

  • Lead Database Administrator

    6 days ago

    India People Prime Worldwide Full time

    ```html About the Company Must have Strong installation and database administration experience on DB2 11.x and 10.x version. About the Role Database upgrade to DB2 11.x and migration experience using DB2 tools for performance. Responsibilities Installation and administration of DB2 11.x, 10.x on Linux, UNIX and Windows servers. ...

  • Lead Database Developer-Oracle

    2 days ago

    Noida, Uttar Pradesh, India Clarivate Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    We are looking for Lead Database Developer-Oracle to join our technology team at Clarivate.The Lead Database Developer will be responsible for overseeing the design, development, and maintenance of high-performance databases using Oracle and PostgreSQL.About You – Experience, Education, Skills And AccomplishmentsBachelor's degree in computer science,...

  • Lead Database Specialist

    2 weeks ago

    Noida, Uttar Pradesh, India beBeeDatabase Full time ₹ 20,00,000 - ₹ 25,00,000

    Database Expert WantedWe are searching for an experienced database professional to join our team.As a Senior Database Engineer, you will be responsible for administering and maintaining NoSQL and relational SQL Server/MySQL databases. You will work on multiple NoSQL clusters running on Azure and be responsible for installing, configuring, monitoring,...

  • Lead Database Administrator

    6 days ago

    India People Prime Worldwide Full time

    html About the Company Must have Strong installation and database administration experience on DB2 11.Database upgrade to DB2 11.x and migration experience using DB2 tools for performance. Installation and administration of DB2 11.x on Linux, UNIX and Windows servers. Creation and maintenance of UDB DB2 instances, databases, schema and objects....

  • Database Administrator

    12 hours ago

    India AITORCH CONSULTANTS LLP Full time ₹ 5,40,000 - ₹ 12,00,000 per year

    Mandatory Skills: SQL Server SQL Server DBA with AWS Experience in managing databases Contract: 1 yearExperience:Total 1) Exp – 5 Years exp for Junior DBA (junior position)2)Non stop Oracle DBA with Oracle Gate experience ( 9 Years Experience)Automation and Scripting Skills:1. Ability to automate routine database tasks and create custom alerts/reports...