IN_Senior Associate_Oracle PL/SQL_Application Technology_Advisory_Bhubaneswar

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. 

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: 

9yrs-14yrs 

Education qualification: 

• BE/B.TECH/MCA or equivalent