Job Description

:

--------------------



We are looking for a highly motivated and skilled PL SQL Senior Developer to join our growing development team The ideal candidate will have 3 5 years of hands on experience in designing developing and optimizing robust PL SQL solutions within an Oracle database environment This role requires a strong understanding of database concepts excellent problem solving abilities and a commitment to delivering high quality code The PL SQL Senior Developer will play a key role in developing and enhancing our critical business applications working closely with various teams to ensure efficient and reliable data processing

Key Responsibilities:

-------------------------



Roles and Responsibilities Development and Implementation Design develop and implement efficient and scalable PL SQL stored procedures functions packages triggers and views Write and optimize complex SQL queries for data retrieval manipulation and reporting Collaborate with business analysts and solution architects to understand requirements and translate them into technical designs Participate in the full software development lifecycle SDLC including requirements analysis design coding testing and deployment Code Quality and Standards Ensure adherence to established coding standards best practices and architectural guidelines Perform thorough unit testing of developed code and assist with integration testing Identify and debug issues in existing PL SQL code providing timely and effective solutions Performance Tuning and Optimization Analyze and optimize the performance of existing PL SQL code and SQL queries Utilize Oracle performance monitoring tools e g Explain Plan SQL Trace to identify and resolve performance bottlenecks Contribute to discussions on database design improvements and indexing strategies to enhance application performance Documentation and Support Create and maintain clear concise technical documentation for developed modules and features Provide support for production issues analyzing and resolving database related problems Collaborate with DBAs on schema changes data migrations and other database related activities Collaboration and Mentorship Junior Developers Work effectively within a team environment actively participating in team meetings and discussions Potentially mentor junior developers offering guidance on PL SQL coding best practices and problem solving techniques Communicate technical concepts clearly to both technical and non technical stakeholders

Technical Requirements:

---------------------------



Technical Requirements Must Have 3 5 years of hands on experience in Oracle PL SQL development Strong proficiency in writing and optimizing complex SQL queries stored procedures functions packages and triggers Solid understanding of Oracle database concepts including data types indexes constraints and views Experience with SQL tuning and performance optimization techniques Familiarity with Oracle development tools such as SQL Developer or Toad Experience with version control systems e g Git SVN Good to Have Basic understanding of data modeling principles Exposure to Oracle Forms and Reports is a plus Familiarity with shell scripting Unix Linux for database automation Knowledge of Agile Scrum development methodologies Experience with large scale transactional systems Understanding of data warehousing concepts or ETL processes

Additional Responsibilities:

--------------------------------



Additional Information Education Bachelor s degree in Computer Science Information Technology or a related field Soft Skills Excellent analytical and problem solving skills Strong attention to detail and commitment to quality Good communication and interpersonal skills Ability to work independently and collaboratively in a team environment Proactive and eager to learn new technologies and concepts Ability to manage time effectively and handle multiple tasks

Preferred Skills:

---------------------


Technology->Oracle Cloud->Oracle Knowledge->Oracle Knowledge