MS - IT Infra/Cloud - Associate(Analyst) - DBA Support Admin #2 - operate

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

• Apply a learning mindset and take ownership for your own development.
• Appreciate diverse perspectives, needs, and feelings of others.
• Adopt habits to sustain high performance and develop your potential.
• Actively listen, ask questions to check understanding, and clearly express ideas.
• Seek, reflect, act on, and give feedback.
• Gather information from a range of sources to analyse facts and discern patterns.
• Commit to understanding how the business works and building commercial awareness.
• Learn and apply professional and technical standards (e.g. refer to specific PwC tax and audit guidance), uphold the Firm's 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.)

Associate – Oracle Database Administrator ( 2 – 4 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, and continuously monitor performance and capacity to ensure high availability and optimal operation.

Minimum Degree Required : Bachelor’s Degree

Degree Preferred : Bachelor’s in IT, Computer Science, or related technical field.

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

Certifications Required : None

Certifications Preferred : Oracle OCA, ITIL Foundation. •

Relevant certifications (e.g., Oracle OCP, AWS /GCP database certifications) are a plus.

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 (12–24 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

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. 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

Job Posting End Date