IN_Associate 2_DBCS/OIC_Oracle_Advisory_Noida

Line of Service Advisory Industry/Sector Not Applicable Specialism Oracle Management Level Associate Job 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. * Why   PWC At  PwC , you will be part of a vibrant community of solvers that leads with trust and creates distinctive outcomes for our clients and communities. This purpose-led and values-driven work, powered by technology in an environment that drives innovation, will enable you to make a tangible impact in the real world. We reward your contributions, support your wellbeing, and offer inclusive benefits, flexibility programmes and mentorship that will help you thrive in work and life. Together, we grow, learn, care, collaborate, and create a future of infinite experiences for each other. Learn more  about us . At  PwC , we believe in providing equal employment opportunities, without any discrimination on the grounds of gender, ethnic background, age, disability, marital status, sexual orientation, pregnancy, gender identity or expression, religion or other beliefs, perceived differences and status protected by law. We strive to create an environment where each one of our people can bring their true selves and contribute to their personal growth and the firm’s growth. To enable this, we have zero tolerance for any discrimination and harassment based on the above considerations. " 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, and   on-premise   systems.   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 /