MS - IT Infra/Cloud - Senior Associate(Sr. Analyst) - Database Administrator - SQL- operate

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 isn't 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 Firm's code of conduct, and independence requirements.
  
  

• Make sure you have the appropriate header sentence based on the level of the JD (i.e. Manager level role should start with appropriate descriptorDemonstrates 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 (.)
  
  

• Infrastructure-as-Code & Provisioning: Terraform/Ansible CI/CD pipelines, audit logging, environment setup (dev/test/prod)
  

• Backup & Recovery: Schedule and validate daily/weekly/monthly backups, quarterly DR tests, maintain runbooks
  

• Patch Management & Upgrades: Plan and apply vendor patches, validate post-upgrade functionality
  

• Performance & Capacity Planning: Monitor CPU/memory/storage, tune queries and indexes, forecast 1224 month growth
  

• High Availability & Replication: Configure clustering, Always On, log shipping, replication; conduct failover drills
  

• Security & Compliance: Implement encryption, masking, RBAC; audit user activity; generate compliance reports
  

• Incident Management & RCA: Detect deadlocks, corruption, failed logins; troubleshoot with app teams; document root causes
  

• Reporting & Dashboarding: Weekly performance and uptime dashboards; recommend optimization opportunities
  

• Scripting & Automation: Develop Shell, PowerShell, PL/SQL, T-SQL scripts; automate patching, backups, and user provisioning
  
  

• Manage complex environments with AlwaysOn AGs, multi-subnet clusters, multiple replicas, automatic failover, and geo-distributed DR.
  

• Tune cluster quorum settings, failover policies, listener configurations, and read routing.
  

• Implement encryption-at-rest, TDE, SSL enforcement, and security baselines.
  
  

• Perform deep-dive performance tuning using:
  

• DMVs/DMFs
  

• Execution plan analysis (actual & estimated)
  

• Stats & index maintenance frameworks
  

• Extended Events
  

• Query Store insights
  

• Wait statistics, blocking chains, and resource semaphore analysis
  

• Identify long-term performance trends and build proactive tuning strategies.
  
  

• Support schema design reviews, indexing strategies, partitioning, and stored procedure optimizations.
  

• Collaborate with dev teams to optimize data models and improve transactional efficiency.
  
  

• Design and maintain enterprise backup strategies (full, diff, log, copy-only, encrypted backups).
  

• Execute PIT recovery, AG replica rebuilds, DR failovers, cluster migrations, and cross-site replication checks.
  

• Document and lead DR drills.
  
  

• Implement role/security policies, least-privilege models, data masking, and auditing.
  

• Remediate vulnerabilities, manage secrets, and enforce encryption policies.
  
  

• Lead major database changes, patch cycles, upgrades, and migrations through CAB.
  

• Own SQL-related incident triages, RCAs, and stability engineering.
  

• Maintain SQL SLAs/KPIs:
  

• Backup success rate
  

• Query performance thresholds
  

• AG health
  

• Job reliability
  

• DR readiness metrics
  
  

• Build automation frameworks for indexing, stats updates, health checks, and DR validation.
  

• Assist with modernization: PaaS migrations, SQL Managed Instance planning, DMS migrations.
  
  

Travel Requirements
Not Specified

Job Posting End Date
February 13, 2026