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.
Required Skill Profession
Computer Occupations