INAssociate 2DBCSOICOracleAdvisoryNoida
Job Summary
Line of Service
AdvisoryIndustry/Sector
Not ApplicableSpecialism
OracleManagement Level
AssociateJob Description & Summary
At PwC our people in business application consulting specialise in consulting services for a variety of business applications helping clients optimise operational efficiency. These individuals analyse client needs implement software solutions and provide training and support for seamless integration and utilisation of business applications enabling clients to achieve their strategic objectives.Those in Oracle technology at PwC will focus on utilising and managing Oracle suite of software and technologies for various purposes within an organisation. You will be responsible for tasks such as installation configuration administration development and support of Oracle products and solutions.
Responsibilities
Oracle DBCS (Database Cloud Service) Administration
Database Provisioning: Deploy configure and scale Oracle DBCS instances (Bare Metal Virtual Machine and Exadata) on OCI.
Lifecycle Management: Manage automated patching regular backups point-in-time recovery and performance scaling.
Security & Compliance: Implement OCI security lists Network Security Groups (NSGs) data encryption at rest (TDE) and in transit.
High Availability: Configure and maintain Oracle Data Guard Real Application Clusters (RAC) and disaster recovery setups in DBCS.
Oracle OIC (Oracle Integration Cloud) Development
Integration Design: Build end-to-end integrations (App-driven and Scheduled orchestration) connecting Oracle ERP Cloud third-party SaaS andon-premisesystems.
Adapter Configuration: Expertly utilize native OIC adapters including REST SOAP ERP Cloud Database FTP and Salesforce.
Data Mapping: Author complex data mappings XSLT transformations lookups and error-handling frameworks.
API Management: Design and secure REST APIs manage connection certificates and handle payload payloads securely.
Performance & Operations
Monitoring & Alerting: Set up OIC dashboard tracking database alerts and OCI monitoring metrics for proactive failure detection.
SQL/PLSQL Tuning: Optimize database objects stored procedures packages and triggers interacting with the integration layer.
DevOps Automation: Work with CI/CD tools Terraform or OCI CLI to automate provisioning and deployment pipelines.
What PwC India Offers
Exposure to large-scale global digital transformation projects.
Continuous upskilling with fully sponsored Oracle Cloud certifications.
Competitive benefits and a structured merit-based career path.
Mandatory Skill sets:
Core Platform Knowledge: Deep technical hands-on experience with Oracle Integration Cloud (OIC) Gen 2 / Gen 3 and Oracle DBCS.
Database Mastery: Advanced SQL PL/SQL database performance tuning and basic Linux/Unix shell scripting.
Web Services: Solid understanding of JSON XML XSD XSLT SOAP and RESTful web service architectures.
OCI Networking: Foundational knowledge of VCNs subnets routing tables and internet/service gateways.
Certifications (Preferred):
Oracle Cloud Platform Application Integration Certified Professional
Oracle Database Cloud Service Certified Professional
Soft Skills: Excellent client communication strong analytical problem-solving and capability to work in fast-paced consulting environments.
Preferred Skill sets:
Core Platform Knowledge: Deep technical hands-on experience with Oracle Integration Cloud (OIC) Gen 2 / Gen 3 and Oracle DBCS.
Database Mastery: Advanced SQL PL/SQL database performance tuning and basic Linux/Unix shell scripting.
Web Services: Solid understanding of JSON XML XSD XSLT SOAP and RESTful web service architectures.
OCI Networking: Foundational knowledge of VCNs subnets routing tables and internet/service gateways.
Certifications (Preferred):
Oracle Cloud Platform Application Integration Certified Professional
Oracle Database Cloud Service Certified Professional
Soft Skills: Excellent client communication strong analytical problem-solving and capability to work in fast-paced consulting environments.
Years of Experience Required:
4-8
Education Qualification
(if blank degree and/or field of study not specified)
Degrees/Field of Study required: Bachelor DegreeDegrees/Field of Study preferred:Certifications (if blank certifications not specified)
Required Skills
Oracle Integration Cloud (OIC)Optional Skills
Accepting Feedback Active Listening Business Transformation Communication Design Automation Emotional Regulation Empathy Inclusion Intellectual Curiosity Optimism Oracle Application Development Framework (ADF) Oracle Business Intelligence (BI) Publisher Oracle Cloud Infrastructure Oracle Data Integration Process Improvement Process Optimization Strategic Technology Planning Teamwork Well BeingDesired Languages (If blank desired languages not specified)
Travel Requirements
Available for Work Visa Sponsorship
Government Clearance Required
Job Posting End Date
June 30 2026Required Experience:
IC
About Company
At PwC, our purpose is to build trust in society and solve important problems. We’re a network of firms in 155 countries with over 284,000 people who are committed to delivering quality in assurance, advisory and tax services. Find out more and tell us what matters to you by vis ... View more