Job Description : -
- Develop, test, and deploy Oracle SQL and PL / SQL scripts, packages, procedures,
functions, and triggers.
Optimize and tune SQL queries to improve performance and efficiency.Work closely with application developers to design, implement, and maintaindatabase solutions.
Troubleshoot and resolve database-related issues, including data discrepancies andperformance bottlenecks.
Participate in code reviews and ensure adherence to best practices for SQL andPL / SQL development.
Collaborate with business analysts and stakeholders to understand requirementsand translate them into efficient database solutions.
Perform data modelling and design database structures that meet application needsand business requirements.
Create and maintain documentation for database procedures, structures, andprocesses.
Required Skills : -
2-3 years of experience working with Oracle SQL and PL / SQL in a developmentenvironment.
Strong understanding of relational database concepts and SQL.Proficiency in writing complex SQL queries and optimizing them for performance.Experience with PL / SQL programming, including the creation of stored procedures,functions, triggers, and packages.
Familiarity with database design principles and data modelling.Knowledge of performance tuning techniques and tools for Oracle databases.Strong problem-solving skills and attention to detail.Ability to work independently as well as part of a team.Excellent communication and interpersonal skills.Qualification & Experience : -
2-3 years of experience with Oracle 19c or later versions.Knowledge of database security practices and data integrity concepts.Experience with version control systems (e.g., Git) for database code management.