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