IN_Senior Associate_PLSQL_One Consulting_AppTech_Jaipur

Job Description & Summary: At PwC, our purpose is to build trust in society and solve important problems. We’re a network of firms in 157 countries with more than 300,000 people who are committed to delivering quality in Assurance, Advisory and Tax services. Within Advisory, PwC has a large teamthat focus on transformation in Government through Digital inclusion. The open position is for a candidate who desires to work with government clients and bring about a change in society. A successful candidate will be expected to work pro-actively and effectively on multiple client engagements over the period of time and take ownership of the entire project delivery he/she entrusted with. Job Position Title: Senior Associate_ Oracle PL/SQL_One Consulting_App Tech_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: 6Years- 9Years Education qualification: • BE/B.TECH/MCA or equivalent