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.

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 – SQL Database Administrator (4–7 Years) 
A senior-level SQL Server engineer responsible for owning the reliability, performance, security, and availability of enterprise SQL databases. This role manages complex multi-node clusters, performance engineering, mission-critical tuning, security enforcement, and DR orchestration. The Senior Associate leads high-impact database changes, RCAs, and modernization initiatives. 

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

Minimum Degree Required: Bachelor’s Degree 

Degree Preferred: Bachelor’s or Master’s degree in Computer Science, Engineering, or related field. 

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

Certifications Required: None 

Certifications Preferred: Microsoft SQL Server Certifications (MCSA/MCSE), Azure SQL-related certifications 

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

1. Advanced SQL Server Administration 

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

2. Advanced Performance Engineering 

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

3. Database Development Support 

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

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

4. Backup/Restore & Disaster Recovery 

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

5. Security, Auditing, and Compliance 

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

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

6. ITSM Responsibilities (Strengthened) 

• 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 

7. Modernization & Automation 

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

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

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

Should possess knowledge of following tools –  

A. SQL Server 

B. MySQL 

C. MariaDB 

D. MongoDB 

E. PostgreSQL 

F. PowerShell 

G. AWS RDS, Aurora, NoSQL) 

H. Terraform 

I. Solarwinds SQL Diagnostics 

J. Ansible 

Travel Requirements

Not Specified

Job Posting End Date

February 13, 2026