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.Skills Required
Oracle Pl / sql, Sql, Debugging, Git