Oracle PL/SQL Developer

In this role as a PL/SQL Developer, you will be responsible for writing efficient and optimized PL/SQL code to support applications. This includes developing procedures, functions, packages, and triggers. You will also be involved in designing and implementing relational databases, optimizing queries, and stored procedures for performance. Your duties will involve reviewing and optimizing existing SQL and PL/SQL code, collaborating with software engineers and analysts, troubleshooting PL/SQL related issues, writing unit tests, and providing ongoing support for PL/SQL-based applications. Key Responsibilities: - Write efficient and optimized PL/SQL code, including procedures, functions, packages, and triggers. - Design and implement relational databases and optimize queries and stored procedures for performance. - Review and optimize existing SQL and PL/SQL code to enhance system performance. - Collaborate with software engineers, database administrators, and analysts to develop and integrate database solutions. - Diagnose and resolve PL/SQL related issues and performance bottlenecks. - Write unit tests and document the design and functionality of developed components. - Provide ongoing support for PL/SQL-based applications, including bug fixes, updates, and enhancements. Qualifications Required: For Freshers: - Basic knowledge of SQL and PL/SQL. - Familiarity with database concepts like tables, indexes, joins, and triggers. - Ability to work with Oracle databases or any relational database. - Strong analytical and problem-solving skills. - Good understanding of data structures and algorithms. For Experienced Candidates: - Strong expertise in PL/SQL, including writing and optimizing complex stored procedures, triggers, and functions. - Experience with Oracle Database (version X.x or higher). - Hands-on experience with performance tuning and optimization techniques. - Proficient in writing complex SQL queries and using analytical functions. - Understanding of database architecture, design, and data modeling. - Knowledge of software development life cycle (SDLC) and agile methodologies. - Experience in troubleshooting and debugging PL/SQL code. - Good understanding of version control tools like Git or SVN.,