Job Position Title:
Level (Senior Associate) Skill_(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.
