PLSQL Developer

• 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: