PL/SQL developer

Key Responsibilities:

• Design, develop, and maintain PL/SQL procedures, functions, triggers, and packages to meet business requirements.
• Write complex SQL queries and optimize them for performance and scalability.
• Collaborate with cross-functional teams, including business analysts, application developers, and data architects, to define requirements and implement solutions.
• Perform database tuning, indexing, and query optimization to ensure optimal performance.
• Troubleshoot and resolve database-related issues, including bugs, performance problems, and errors.
• Assist in the development of database schema changes, migrations, and updates.
• Conduct thorough testing and validation of PL/SQL code, ensuring quality and accuracy of results.
• Document all development processes, database schema, and changes to ensure proper knowledge transfer and future maintainability.
• Ensure compliance with data security policies and best practices when handling sensitive information.
• Stay up to date with the latest industry trends and technologies related to database development.

Requirements:

• Education: Bachelor's degree in Computer Science, Information Technology, or a related field.
• Experience: Minimum 3-5 years of experience as a PL/SQL Developer or in a similar role, with hands-on experience in designing and developing PL/SQL code.
• Technical Skills:
• Strong proficiency in Oracle PL/SQL, SQL, and relational database management systems.
• Experience in database design and development, including stored procedures, triggers, and functions.
• In-depth knowledge of query optimization and performance tuning.
• Familiarity with version control tools like Git, SVN, or others.
• Experience with Oracle database versions (11g, 12c, 18c, etc.).
• Strong debugging and problem-solving skills.