SQL Server Database Developer

Job Position Title: Level (Senior Associate) Skil l_(PLSQL) Competency_ Citizen Services LOS _Advisory Location (Jaipur)
Responsibilities:

Design, develop, and maintain complex PL/SQL scripts, stored procedures, functions, packages, and triggers.
Optimize and tune PL/SQL code for performance and scalability.
Collaborate with application developers to create and maintain efficient database solutions.
Perform database design and data modeling to support application development requirements.
Develop and maintain ETL processes to ensure data accuracy and integrity.
Conduct thorough testing and validation of database code and processes.
Troubleshoot and resolve database-related issues, ensuring minimal downtime and data integrity.
Implement and maintain database security policies to protect sensitive data.
Participate in code reviews to ensure adherence to best practices and coding standards.
Document database designs, processes, and code for future reference and knowledge sharing.
Stay current with the latest industry trends and advancements in database technologies.

Mandatory skill sets:

Proven experience of 6+ years in Oracle PL/SQL development.
Strong proficiency in writing and optimizing complex PL/SQL code.
In-depth knowledge of Oracle database architecture, performance tuning, and optimization techniques.

Preferred skill sets:

Experience with database design, data modeling, and normalization.
Familiarity with Oracle tools and utilities, such as SQL*Plus, SQL Developer, and Oracle Enterprise Manager.
Understanding of ETL processes and tools.
Strong problem-solving skills and attention to detail.
Excellent communication and collaboration skills.

Years of experience required:
~ Proven experience of 6+ years in Oracle PL/SQL development.