PLSQL Developer

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.

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

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.