Apply in 3 Minutes: Oracle PLSQL Lead

3 days ago

Chennai, India BONbLOC Full time
Roles and Responsibilities:

- Should have hands on experience and be able to guide the team of developers- Design, develop and maintain tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.- Extensively worked on creating database objects including tables, indexes, views, sequences, packages.- Worked with Bulk Collections for bulk load processing. Involved in code walk through and review sessions with the development team.- Extensively done performance tuning of oracle databases by rewriting optimized SQL queries.- Worked on Partitioning large tables using rollback tablespace, range partitioning and created indexes on various tables to improve query performance.- Extensively worked on SQL commands including all DDL (Data Definition Language), DML (data manipulation language), and DCL (Data Control Language) .- Interacted with Business Analysts and Users for gathering and analyzing the Business Report requirements. For discussion purposes only | Page 1 of 2 Job Description – PLSQL Lead- Requirements gathering for the Interfaces and custom programs development through meetings with functional team and business users.- Analysis (Business and Technical) of existing system with objective of improving & optimizing the system performance.- Handled a project where it involved building a process for BEx Team.

Required Skills:

- Worked on Various OBIEE Reports as part of OBIEE Implementation.- Executed queries and reports during Everest Transition Tests and its follow-up with data migration team regarding data discrepancies.- Involved in preparation of various documents like MD050, MD070 (functional & Technical Design) documents.- Strong understanding of architecture discipline, processes, concepts, and best practices. Must have hands on experience in coding and be able to guide the team of developers.- Developed Advanced PL/SQL packages, procedures, triggers, functions, cursors and collections to implement business logic using SQL developer.- Generated SQL scripts for data validation, data conversion and manipulation and materialized the views for remote instances.- Wrote conversion scripts using SQL, PL/SQL procedures, functions and packages to migrate data from one database (SQL Server) to Oracle platform.

  • Oracle PLSQL Architect

    2 weeks ago

    Chennai, India Virtusa Full time

    Oracle PLSQL Architect - CREQ190333 Description Hands-on with Oracle PLSQL Development UNIX AutoSysHands-on experience knowledge in Presto Tool (This is a tool that is used to Query across multiple Databases)Analyze explain plan and AWR reports monitor long running queries using OEM tools and able to tune or re-write logic to achieve optimal performanceWork...

  • Oracle PLSQL Architect

    1 week ago

    Chennai, Tamil Nadu, India Virtusa Full time

    Oracle PLSQL Architect - CREQ190333 Description Hands-on with Oracle PLSQL Development UNIX AutoSysHands-on experience knowledge in Presto Tool (This is a tool that is used to Query across multiple Databases)Analyze explain plan and AWR reports monitor long running queries using OEM tools and able to tune or re-write logic to achieve optimal performanceWork...

  • Fusion SCM Fuctional Lead Apply in 3 Minutes

    1 week ago

    Chennai, Tamil Nadu, India Oracle Full time

    Working Location:Bangalore, Hyderabad, Chennai , NCR , Pune , Mumbai , Gandhinagar , KolkataOverviewOracle Global Service Center (GSC) is a unit within oracle that establishes long-term relationships with many of Oracle's customers through annuity-based service contracts and project-based one-time services. It is an offshore Hub that will cater to the needs...

  • Oracle PLSQL Architect

    1 week ago

    Chennai, Tamil Nadu, India Virtusa Full time

    Oracle PLSQL Architect - CREQ190333 Description Hands-on with Oracle PLSQL Development UNIX AutoSysHands-on experience knowledge in Presto Tool (This is a tool that is used to Query across multiple Databases)Analyze explain plan and AWR reports monitor long running queries using OEM tools and able to tune or re-write logic to achieve optimal performanceWork...

  • Oracle PLSQL Architect

    2 weeks ago

    chennai, India Virtusa Full time

    Oracle PLSQL Architect - CREQ190333 Description Hands-on with Oracle PLSQL Development UNIX AutoSysHands-on experience knowledge in Presto Tool (This is a tool that is used to Query across multiple Databases)Analyze explain plan and AWR reports monitor long running queries using OEM tools and able to tune or re-write logic to achieve optimal performanceWork...

  • Oracle PLSQL Lead

    4 days ago

    Chennai, India BONbLOC Full time

    Roles and Responsibilities: Should have hands on experience and be able to guide the team of developers Design, develop and maintain tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database...

  • Oracle PLSQL Lead

    2 weeks ago

    Chennai, India BONbLOC Full time

    Roles and Responsibilities: Should have hands on experience and be able to guide the team of developers Design, develop and maintain tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database...

  • Oracle PLSQL Lead

    2 weeks ago

    chennai, India BONbLOC Full time

    Roles and Responsibilities: Should have hands on experience and be able to guide the team of developers Design, develop and maintain tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects....

  • Senior PLSQL JAVA support specialist

    2 months ago

    Chennai, India Oracle Full time

    As a member of the Support organization, your focus is to deliver post-sales support and solutions to the Oracle customer base while serving as an advocate for customer needs. This involves resolving post-sales non-technical customer inquiries via phone and electronic means, as well as, technical questions regarding the use of and troubleshooting for our...

  • Senior PLSQL JAVA support specialist

    3 weeks ago

    Chennai, India Oracle Full time

    As a member of the Support organization, your focus is to deliver post-sales support and solutions to the Oracle customer base while serving as an advocate for customer needs. This involves resolving post-sales non-technical customer inquiries via phone and electronic means, as well as, technical questions regarding the use of and troubleshooting for our...

  • Senior PLSQL JAVA support specialist

    4 weeks ago

    Chennai, India Oracle Full time

    As a member of the Support organization, your focus is to deliver post-sales support and solutions to the Oracle customer base while serving as an advocate for customer needs. This involves resolving post-sales non-technical customer inquiries via phone and electronic means, as well as, technical questions regarding the use of and troubleshooting for our...

  • Oracle PLSQL Lead

    1 week ago

    Chennai, India BONbLOC Full time

    Roles and Responsibilities:Should have hands on experience and be able to guide the team of developersDesign, develop and maintain tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database...

  • Senior PLSQL JAVA support specialist

    1 week ago

    Chennai, Tamil Nadu, India Oracle Full time

    As a member of the Support organization, your focus is to deliver post-sales support and solutions to the Oracle customer base while serving as an advocate for customer needs. This involves resolving post-sales non-technical customer inquiries via phone and electronic means, as well as, technical questions regarding the use of and troubleshooting for our...

  • ▷ Apply Now: HCM Cloud Functional Lead

    3 days ago

    Chennai, India Oracle Full time

    Oracle GSC is hiring for HCM Cloud Functional Leads with minimum 7 years of relevant experienceJob locations - PAN India (Bangalore, Mumbai, Pune, Hyderabad, Chennai, Noida, Kolkata, Gandhinagar, Trivandrum)Do you have a finger on the pulse of cloud technology? Are you an analytical problem solver looking for an exciting new challenge? If you have great...

  • Oracle PLSQL Developer

    2 weeks ago

    Chennai, India BONbLOC Full time

    Job Description: • We are looking for a PLSQL developer with 6+ Years experience. Roles and Responsibilities: • Design, develop and maintain tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursors for loops, reference cursors and other database...

  • Oracle PLSQL Developer

    2 weeks ago

    chennai, India BONbLOC Full time

    Job Description: • We are looking for a PLSQL developer with 6+ Years experience. Roles and Responsibilities: • Design, develop and maintain tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursors for loops, reference cursors and other database...

  • Oracle PLSQL Developer

    2 weeks ago

    Chennai, India BONbLOC Full time

    Job Description: • We are looking for a PLSQL developer with 6+ Years experience. Roles and Responsibilities: • Design, develop and maintain tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursors for loops, reference cursors and other database...

  • PLSQL Architect

    2 days ago

    chennai, India Virtusa Full time

    PLSQL Architect - CREQ190343 Description Hands-on with Oracle PLSQL Development UNIX AutoSysHands-on experience knowledge in Presto Tool (This is a tool that is used to Query across multiple Databases)Analyze explain plan and AWR reports monitor long running queries using OEM tools and able to tune or re-write logic to achieve optimal performanceWork with...

  • PLSQL Architect

    2 days ago

    Chennai, India Virtusa Full time

    PLSQL Architect - CREQ190343 Description Hands-on with Oracle PLSQL Development UNIX AutoSys Hands-on experience knowledge in Presto Tool (This is a tool that is used to Query across multiple Databases) Analyze explain plan and AWR reports monitor long running queries using OEM tools and able to tune or re-write logic to achieve optimal performance Work with...

  • Oracle Plsql Developer

    1 week ago

    Chennai, Tamil Nadu, India BONbLOC Full time

    Job Description: We are looking for a PLSQL developer with 6+ Years experience.Roles and Responsibilities: Design, develop and maintain tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursors for loops, reference cursors and other database objects....