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

  • 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

    2 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

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

  • 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

    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

    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

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

  • PLSQL Architect

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

  • PLSQL Architect

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

  • Oracle PlSQL Architect

    1 week ago

    Chennai, Tamil Nadu, India Virtusa Full time

    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 DBA team to implement SQL tuning...

  • Oracle PLSQL Developer

    1 week 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

    1 week 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

    1 week 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

    2 weeks ago

    Chennai, India Virtusa Full time

    Position: PLSQL lead/developer Exp:5 to 10years Location:Chennai Skills:PLSQL,RDBMS DATABASE, SQL SCRIPTS,Oracle Database,Agile Methodology Ability to work in a high-paced agile atmosphere Self-motivated and demonstrate initiative in tackling work, while following software development best practices and company guidelines Ability to communicate clearly...

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

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