Description

Key Responsibilities

• Design, develop, and maintain complex stored procedures, functions, packages, and triggers within an Oracle database environment to support business requirements.
• Optimize SQL queries and PL/SQL code to ensure high performance and scalability for mission-critical applications handling large volumes of data.
• Collaborate closely with cross-functional teams, including business analysts and front-end developers, to translate technical requirements into robust database solutions.
• Perform comprehensive unit testing and debugging of database code to identify and resolve performance bottlenecks or logic errors effectively.
• Manage database migrations, schema updates, and deployment processes while ensuring data integrity and consistency throughout the software development lifecycle.
• Provide technical documentation for all database modules and assist in mentoring junior team members on best coding practices and industry standards.

• A minimum of 5 to 8 years of professional experience in developing complex database applications using PL/SQL within an Oracle database ecosystem.
• Extensive knowledge of advanced SQL concepts, including analytical functions, complex joins, indexing strategies, and query execution plan analysis for performance tuning.
• Strong understanding of database design principles, normalization, data modeling, and transaction management to ensure efficient data storage and retrieval.
• Demonstrated experience working with Oracle 12c, 19c, or higher versions, along with proficiency in using tools like SQL Developer, TOAD, or equivalent IDEs.
• Excellent analytical and problem-solving skills with the ability to troubleshoot production issues under pressure in a fast-paced environment.
• Effective communication skills and the capability to work independently or as part of a distributed team to meet tight deadlines and project goals

Key Skills

Education

Bachelor’s degree