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

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

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 (47 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 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

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