MS IT InfraCloud Senior Associate(Sr. Analyst) Database Administrator Oracle operate

Bengaluru - India

Monthly Salary: Not Disclosed

Posted on: 12 hours ago

Vacancies: 1 Vacancy

Job Summary

Industry/Sector

Not Applicable

Specialism

Managed Services

Management Level

Senior Associate

Job Description & Summary

At PwC our people in infrastructure focus on designing and implementing robust secure IT systems that support business operations. They enable the smooth functioning of networks servers and data centres to optimise performance and minimise downtime.

Those in cloud operations at PwC will focus on managing and optimising cloud infrastructure and services to enable seamless operations and high availability for clients. You will be responsible for monitoring troubleshooting and implementing industry leading practices for cloud-based systems.

Focused on relationships you are building meaningful client connections and learning how to manage and inspire others. Navigating increasingly complex situations you are growing your personal brand deepening technical expertise and awareness of your strengths. You are expected to anticipate the needs of your teams and clients and to deliver quality. Embracing increased ambiguity you are comfortable when the path forward isnt clear you ask questions and you use these moments as opportunities to grow.

Examples of the skills knowledge and experiences you need to lead and deliver value at this level include but are not limited to:

Respond effectively to the diverse perspectives needs and feelings of others.
Use a broad range of tools methodologies and techniques to generate new ideas and solve problems.
Use critical thinking to break down complex concepts.
Understand the broader objectives of your project or role and how your work fits into the overall strategy.
Develop a deeper understanding of the business context and how it is changing.
Use reflection to develop self awareness enhance strengths and address development areas.
Interpret data to inform insights and recommendations.
Uphold and reinforce professional and technical standards (e.g. refer to specific PwC tax and audit guidance) the Firms code of conduct and independence requirements.

Instructions:

Please update areas marked in red

Link to Tips & Tricks for Writing PwC Job Description

****Quick Tips for Reviewing your JD!

Make sure you have the appropriate header sentence based on the level of the JD (i.e. Manager level role should start with appropriate descriptor Demonstrates extensive abilities and/or a proven record of success as a team leader: The appropriate header can be found in the Tips and Tricks document provided above.

Be mindful of grammatical consistency; the list should either be all verb-driven or all noun-driven (but not both).

When listing requirements under the required or preferred skills section each sentence should end in a semi-colon (;) except for the last bullet which should end with a period (.)

Job Profile Name:

*TC/Recruiting to Update*

Child Name:

*TC/Recruiting to Update*

Global LoS:

*TC/Recruiting to Update*

Global Network:

*TC/Recruiting to Update*

Global Competency Network:

*TC/Recruiting to Update*

Go-To-Market:

Managed Services

Sector:

Not Applicable

Programme Type:

Experienced

Additional Responsibilities: (This field may be used to describe the daily role duties and/or purpose of this Job Profile/Job Description. The field is limited to 500 characters including spaces.)

Senior Associate Oracle Database Administrator (47 Years)
Job Summary

We are seeking a Oracle database administrator to design deploy configure secure monitor and maintain enterprise databases (SQL Server Oracle MySQL PostgreSQL etc.) across development test and production environments. The ideal candidate will build and manage automated provisioning and change pipelines implement HA/DR and backup strategies enforce security and compliance standards mentor junior members in the team and continuously monitor performance and capacity to ensure high availability and optimal operation.

Minimum Degree Required: Bachelors Degree

Degree Preferred: Bachelors or Masters degree in Computer Science Engineering or related field.

Minimum Years of Experience: 4-7 year(s)

Certifications Required: None

Certifications Preferred: Oracle Certified Professional (OCP) Oracle RAC Expert Cloud-related Oracle certifications

Required / Mandatory Knowledge/Skills: (character count limit 5000) *PLEASE ONLY USE THIS FIELD IF THIS IS A MUST HAVE SKILL FOR APPLICANT*

Key Responsibilities:

1. Database Provisioning & Infrastructure-as-Code

Deploy and configure new database instances (dev test prod) in accordance with system and storage requirements

Build and maintain automated provisioning pipelines using Terraform Ansible and CI/CD tools

Enforce infrastructure-as-code standards audit logging and reporting

Validate automation through test runs and integrate database changes into CI/CD workflows

2. Backup Recovery & Disaster Recovery

Design and schedule daily weekly and monthly backups; configure and validate backup jobs in native DBMS tools

Test recovery scenarios quarterly and maintain up-to-date DR runbooks

Monitor backup job success/failure; escalate and remediate missed or failed backups

Implement and validate log shipping Always On Availability Groups Oracle RAC or clustering for DR

3. Patch Management & Upgrades

Plan and coordinate quarterly patch reviews and database version upgrades

Apply vendor-released patches perform post-upgrade validation and resolve any functional regressions

4. Performance Monitoring Tuning & Capacity Planning

Monitor CPU memory storage usage query performance waits and latches using native and third-party tools

Run baseline health checks post-maintenance resolve anomalies and document changes

Forecast resource growth (1224 months) identify workload spikes and plan infrastructure scaling

Recommend and implement index and query optimizations in collaboration with application owners

5. High Availability & Replication

Design configure and validate HA solutions including clustering Always On log shipping and replication

Monitor replication jobs troubleshoot latency/errors and conduct periodic failover drills

6. Security Compliance & Audit

Implement database security standards: encryption data masking role-based access control schema and user setup

Approve or deny access requests remove orphaned accounts and audit user activity (failed logins suspicious behavior)

Generate compliance reports track policy adherence and escalate any violations

7. Incident Management & Root Cause Analysis

Monitor for deadlocks transaction failures data corruption and alert conditions

Troubleshoot and resolve incidents in partnership with application teams or escalate to vendors

Document root-cause analyses corrective actions and update runbooks

8. Reporting & Dashboarding

Produce weekly performance and availability dashboards

Provide insights and recommendations for tuning optimization and capacity upgrades

9. Scripting & Task Automation

Develop and maintain scripts in Shell PowerShell PL/SQL T-SQL etc. and store them in version control

Automate routine tasks such as patching backups user provisioning and environment deployments

Test scripts in lower environments and deploy to production via automated pipelines

Contribute to modernization initiatives such as:

Cloud migrations (AWS RDS/Aurora OCI)

Goldengate implementations

Oracle to PostgreSQL transitions (if applicable)

Preferred Knowledge/Skills: (character count limit 5000)* PLEASE MAKE THIS A BULLETED LIST WHERE EACH SENTENCE STARTS WITH THE SAME VERB TENSE (I.E. PROVIDES DEVELOPS FACILITATES ETC.)

Strong expertise with Terraform Ansible Git Jenkins/GitLab CI or equivalent CI/CD tools

Deep understanding of HA/DR architectures backup/restore processes and disaster recovery testing

Proven ability to monitor troubleshoot and tune database performance at scale

Familiarity with security best practices compliance frameworks and audit reporting

Scripting proficiency (Shell PowerShell PL/SQL T-SQL) and infrastructure-as-code principles

Excellent communication documentation and collaboration skills

Should possess hands-on knowledge about following tools -

A. B. Oracle (i.e. Oracle RAC Data Guard Log Shipping)

B. MySQL

C. MariaDB

D. MongoDB

E. PostgreSQL

F. PowerShell

G. AWS RDS Aurora NoSQL

H. Terraform

I. Solarwinds SQL Diagnostics

J. DBArtisan for Oracle DB Management

K. Ansible

Travel Requirements

Not Specified

Job Posting End Date

Required Experience:

Senior IC

Industry/SectorNot ApplicableSpecialismManaged ServicesManagement LevelSenior AssociateJob Description & SummaryAt PwC our people in infrastructure focus on designing and implementing robust secure IT systems that support business operations. They enable the smooth functioning of networks servers an...

Industry/Sector

Not Applicable

Specialism

Managed Services

Management Level

Senior Associate

Job Description & Summary

Examples of the skills knowledge and experiences you need to lead and deliver value at this level include but are not limited to:

Respond effectively to the diverse perspectives needs and feelings of others.
Use a broad range of tools methodologies and techniques to generate new ideas and solve problems.
Use critical thinking to break down complex concepts.
Understand the broader objectives of your project or role and how your work fits into the overall strategy.
Develop a deeper understanding of the business context and how it is changing.
Use reflection to develop self awareness enhance strengths and address development areas.
Interpret data to inform insights and recommendations.
Uphold and reinforce professional and technical standards (e.g. refer to specific PwC tax and audit guidance) the Firms code of conduct and independence requirements.

Instructions:

Please update areas marked in red

Link to Tips & Tricks for Writing PwC Job Description

****Quick Tips for Reviewing your JD!

Make sure you have the appropriate header sentence based on the level of the JD (i.e. Manager level role should start with appropriate descriptor Demonstrates extensive abilities and/or a proven record of success as a team leader: The appropriate header can be found in the Tips and Tricks document provided above.

Be mindful of grammatical consistency; the list should either be all verb-driven or all noun-driven (but not both).

When listing requirements under the required or preferred skills section each sentence should end in a semi-colon (;) except for the last bullet which should end with a period (.)

Job Profile Name:

*TC/Recruiting to Update*

Child Name:

*TC/Recruiting to Update*

Global LoS:

*TC/Recruiting to Update*

Global Network:

*TC/Recruiting to Update*

Global Competency Network:

*TC/Recruiting to Update*

Go-To-Market:

Managed Services

Sector:

Not Applicable

Programme Type:

Experienced

Senior Associate Oracle Database Administrator (47 Years)
Job Summary

Minimum Degree Required: Bachelors Degree

Degree Preferred: Bachelors or Masters degree in Computer Science Engineering or related field.

Minimum Years of Experience: 4-7 year(s)

Certifications Required: None

Certifications Preferred: Oracle Certified Professional (OCP) Oracle RAC Expert Cloud-related Oracle certifications

Required / Mandatory Knowledge/Skills: (character count limit 5000) *PLEASE ONLY USE THIS FIELD IF THIS IS A MUST HAVE SKILL FOR APPLICANT*

Key Responsibilities:

1. Database Provisioning & Infrastructure-as-Code

Deploy and configure new database instances (dev test prod) in accordance with system and storage requirements

Build and maintain automated provisioning pipelines using Terraform Ansible and CI/CD tools

Enforce infrastructure-as-code standards audit logging and reporting

Validate automation through test runs and integrate database changes into CI/CD workflows

2. Backup Recovery & Disaster Recovery

Design and schedule daily weekly and monthly backups; configure and validate backup jobs in native DBMS tools

Test recovery scenarios quarterly and maintain up-to-date DR runbooks

Monitor backup job success/failure; escalate and remediate missed or failed backups

Implement and validate log shipping Always On Availability Groups Oracle RAC or clustering for DR

3. Patch Management & Upgrades

Plan and coordinate quarterly patch reviews and database version upgrades

Apply vendor-released patches perform post-upgrade validation and resolve any functional regressions

4. Performance Monitoring Tuning & Capacity Planning

Monitor CPU memory storage usage query performance waits and latches using native and third-party tools

Run baseline health checks post-maintenance resolve anomalies and document changes

Forecast resource growth (1224 months) identify workload spikes and plan infrastructure scaling

Recommend and implement index and query optimizations in collaboration with application owners

5. High Availability & Replication

Design configure and validate HA solutions including clustering Always On log shipping and replication

Monitor replication jobs troubleshoot latency/errors and conduct periodic failover drills

6. Security Compliance & Audit

Implement database security standards: encryption data masking role-based access control schema and user setup

Approve or deny access requests remove orphaned accounts and audit user activity (failed logins suspicious behavior)

Generate compliance reports track policy adherence and escalate any violations

7. Incident Management & Root Cause Analysis

Monitor for deadlocks transaction failures data corruption and alert conditions

Troubleshoot and resolve incidents in partnership with application teams or escalate to vendors

Document root-cause analyses corrective actions and update runbooks

8. Reporting & Dashboarding

Produce weekly performance and availability dashboards

Provide insights and recommendations for tuning optimization and capacity upgrades

9. Scripting & Task Automation

Develop and maintain scripts in Shell PowerShell PL/SQL T-SQL etc. and store them in version control

Automate routine tasks such as patching backups user provisioning and environment deployments

Test scripts in lower environments and deploy to production via automated pipelines

Contribute to modernization initiatives such as:

Cloud migrations (AWS RDS/Aurora OCI)

Goldengate implementations

Oracle to PostgreSQL transitions (if applicable)

Preferred Knowledge/Skills: (character count limit 5000)* PLEASE MAKE THIS A BULLETED LIST WHERE EACH SENTENCE STARTS WITH THE SAME VERB TENSE (I.E. PROVIDES DEVELOPS FACILITATES ETC.)

Strong expertise with Terraform Ansible Git Jenkins/GitLab CI or equivalent CI/CD tools

Deep understanding of HA/DR architectures backup/restore processes and disaster recovery testing

Proven ability to monitor troubleshoot and tune database performance at scale

Familiarity with security best practices compliance frameworks and audit reporting

Scripting proficiency (Shell PowerShell PL/SQL T-SQL) and infrastructure-as-code principles

Excellent communication documentation and collaboration skills

Should possess hands-on knowledge about following tools -

A. B. Oracle (i.e. Oracle RAC Data Guard Log Shipping)

B. MySQL

C. MariaDB

D. MongoDB

E. PostgreSQL

F. PowerShell

G. AWS RDS Aurora NoSQL

H. Terraform

I. Solarwinds SQL Diagnostics

J. DBArtisan for Oracle DB Management

K. Ansible

Travel Requirements

Not Specified

Job Posting End Date

Required Experience:

Senior IC

Key Skills

Children Activity
Cost Accounting
Feed
Corporate Strategy
ERP

Apply Now

About Company

PricewaterhouseCoopers

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

View Profile View Profile

AI AutoApply

Apply to 100+ jobs with one click