Talent.com
This job offer is not available in your country.
Oracle PL / SQL Developer - Database Schema

Oracle PL / SQL Developer - Database Schema

Shorlist ProfessionalsBangalore
30+ days ago
Job description

Talent Worx is a growing services & recruitment consulting firm, we are hiring for our client which is a leading Big4 Consulting firm and provider of financial intelligence, data analytics, and AI-driven solutions, empowering businesses worldwide with insights for confident decision-making.

Join to work on cutting-edge technologies, drive digital transformation, and shape the future of global markets.

Job Description :

An Oracle PL / SQL Developer is responsible for developing and maintaining Oracle database applications using the PL / SQL programming language.

  • Developing and maintaining Oracle database applications using PL / SQL.
  • Designing and developing database schemas, stored procedures, functions, and triggers using PL / SQL.
  • Optimizing database performance by tuning SQL queries and PL / SQL code.
  • Developing and executing test plans to ensure the quality and accuracy of PL / SQL code.
  • Troubleshooting and resolving issues related to PL / SQL code.

Responsibilities :

  • Designs, develops, implements, and maintains custom oracle applications written in PL / SQL and supports back-end data processing in PL / SQL.
  • Good Experience in SQL Analytical Query, Performance Tunning concepts.
  • Knowledge about oracle architecture 9i and 18c different and ETL Process.
  • Design and Develop database objects like Stored Procedures, Functions, Packages and Triggers.
  • Develop database for Ref Cursor, Collections, Dynamic SQL and Exception handling.
  • Able to work on Collections like PL / SQL Records, PL / SQL Tables, and Nested Tables in PL / SQL blocks and Bulk Collection.
  • Good Experience Oracle Partitioning is a key feature.
  • Must have experience in creating scheduler jobs, Views, Materialized Views.
  • Should have good understanding in Indexing.
  • SQL Query tuning using different tools.
  • Clear understanding of query plan.
  • Perform code reviews to ensure code quality, standards compliance, and best practices.
  • Debug and troubleshoot PL / SQL code to identify and resolve issues.
  • Collaborate with cross-functional teams to gather and analyze requirements.
  • Design and develop database schema, tables, and relationships.
  • Create and optimize SQL queries and PL / SQL code for efficient data retrieval and manipulation.
  • Ensure data integrity, security, and performance in database operation.
  • Collaborate with application developers to design and implement database structures that meet application requirements.
  • Optimize database performance through indexing, query optimization, and other tuning techniques.
  • Implement and maintain database security measures, such as roles, privileges, and access controls.
  • Monitor and troubleshoot database issues.
  • Excellent problem solving, issue identification, analytical and technical documentation skills.
  • Strong interpersonal skills and ability to work well in a team environment.
  • Understand SDLC process and tools, agile program management concepts and version control.
  • Qualifications :

  • Bachelor's degree in Computer Science or a related field.
  • 6 to 8 years of proven experience in Database Development.
  • Strong proficiency in ORACLE SQL, PL / SQL.
  • Proven experience as a PL / SQL Developer in a senior or lead role.
  • Strong problem-solving skills and the ability to work collaboratively in a team environment.
  • Exposure to cloud hosting and IT domains such as CI / CD pipelines and automated testing.
  • Excellent communication and interpersonal skills.
  • ref : hirist.tech)

    Create a job alert for this search

    Plsql Developer • Bangalore

    Related jobs
    Oracle PL / SQL Developer

    Oracle PL / SQL Developer

    Recmatrix ConsultingBengaluru, Karnataka, India
    Job Title : Oracle PL / SQL Developer.Location : Bang / Hyd / Pune / Remote.Shift Timing : 2 : 00 PM – 11 : 00 PM IST.Notice Period : Immediate joiners only. The role involves optimizing queries, handling large da...Show moreLast updated: 1 day ago
    • Promoted
    Oracle PL-SQL Developer

    Oracle PL-SQL Developer

    consignBangalore
    We are seeking a highly skilled Oracle PL / SQL Developer with strong experience in Oracle 11g and Oracle Reports.The ideal candidate will have a minimum of 5 years of hands-on experience i...Show moreLast updated: 30+ days ago
    Oracle, PL / SQL - Developer

    Oracle, PL / SQL - Developer

    NTT DATA ServicesBangalore, KA, IN
    NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us.If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now....Show moreLast updated: 23 hours ago
    Oracle SQL Developer-MDM Support

    Oracle SQL Developer-MDM Support

    PradeepIT Consulting Services Pvt LtdBangalore, Karnataka, India
    Quick Apply
    Job Title : Oracle SQL Developer MDM Support.We are seeking an experienced Oracle SQL developer with strong expertise in database development and MDM (Master Data Management) system support.The idea...Show moreLast updated: 30+ days ago
    • Promoted
    SystechCorp - PL-SQL Developer - Database Performance Tuning

    SystechCorp - PL-SQL Developer - Database Performance Tuning

    SystechcorpBangalore
    Key Responsibilities : - PL / SQL Development & Optimization : Develop, optimize, and maintain complex PL / SQL stored procedures, functions, and p...Show moreLast updated: 10 days ago
    Majesco Devstudio Developer

    Majesco Devstudio Developer

    CIEL HR ServicesBengaluru, karnataka, India
    Quick Apply
    The Devstudio developer will be responsible for implementing and maintaining Majesco Insurance products that uses Devstudio toolkit framework as the development framework Devstudio is a Majescos pr...Show moreLast updated: 30+ days ago
    • Promoted
    Avaloq Technical Lead

    Avaloq Technical Lead

    Luxoft IndiaBengaluru, IN
    Avaloq Certified Professional (ACP) with 6-10 years' experience in customisation and implementation of Avaloq Banking System. Good understanding of banking operations, trade lifecycle and investment...Show moreLast updated: 30+ days ago
    • Promoted
    Oracle PL-SQL Developer

    Oracle PL-SQL Developer

    VariteBangalore
    Job Description : - Should have Database Support experience to handle the production database operations.Should be flexible to work in any shift in rotations.Require...Show moreLast updated: 30+ days ago
    PLSQL Developer

    PLSQL Developer

    Talent WorxBengaluru, KA, IN
    Quick Apply
    We are seeking a skilled PLSQL Developer to join our team at Talent Worx.In this role, you will be responsible for designing, developing, and optimizing database applications using PL / SQL.The ideal...Show moreLast updated: 30+ days ago
    Oracle PL / SQL Developer- Bangalore

    Oracle PL / SQL Developer- Bangalore

    CGIBangalore, Karnataka, India
    At CGI were a team of builders.We call our employees members because all who join CGI are building their own company - one that has grown to 72000 professionals located in 40 countries.Founded in 1...Show moreLast updated: 30+ days ago
    • Promoted
    Database Migration Specialist - Oracle DB

    Database Migration Specialist - Oracle DB

    Mobile Programming LLCBangalore
    Job Description : Job Title : Database Migration Specialist Experience : Overall 6+ Years, 5+ Years Relevant Location : Bang...Show moreLast updated: 30+ days ago
    PL / SQL Developer

    PL / SQL Developer

    Tata Consultancy ServicesBengaluru, Karnataka, India
    Good Knowledge and hands on in Unix shell scripting and has the capability to develop shell scripts, perform test run and validate results and deploy to production. Experience in working with stakeh...Show moreLast updated: 13 days ago
    Oracle PL / SQL Developer

    Oracle PL / SQL Developer

    Talent CornerBangalore
    Strong development experience in Oracle PL-SQL and advanced PL / SQL including Procedures, Packages, Functions, Indexes, Collections, Materialized views, Triggers, Bulk Binding, Exception handling et...Show moreLast updated: 30+ days ago
    • Promoted
    Database Developer - SQL

    Database Developer - SQL

    DexianBangalore
    Roles & Responsibilities : An Ideal candidate will support SQL Master Data Services and is actively involved in small-scale data warehousing projects.Their role ...Show moreLast updated: 14 days ago
    Oracle, PL / SQL - Developer

    Oracle, PL / SQL - Developer

    NTTBangalore, IN
    We are currently seeking a Oracle, PL / SQL - Developer to join our team in Bangalore, Karnātaka (IN-KA), India (IN).Some knowledge on ETL, Informatica, Control M, Autosys. Some knowledge on Azure and...Show moreLast updated: 23 hours ago
    Oracle Developers

    Oracle Developers

    PENTOZ Technologybengaluru, KA, in
    Quick Apply
    Oracle Developer : Architect Reliable Data Systems and Enterprise Apps.You’ll work across products and platforms—powering secure, scalable solutions that support everything from finance and HR to Sa...Show moreLast updated: 20 days ago
    SQL Database Developer

    SQL Database Developer

    VAYUZ TechnologiesBengaluru, Karnataka, India
    Develop, debug, and maintain T-SQL and stored procedures.Write efficient and scalable SQL queries for complex datasets.Perform database performance tuning and query optimization.Analyze business re...Show moreLast updated: 1 day ago
    • Promoted
    PL-SQL Developer

    PL-SQL Developer

    MResultBangalore
    Job Description : - 5+ Strong experience with Oracle PL / SQL development.Proficient in writing complex SQL queries, joins, and subqueries.Familiarity ...Show moreLast updated: 30+ days ago