Database Administrator (Intermediate) at PwC South Africa

Services to be provided:

• Monitor and report on the health of our SQL db environment - databases and integrations.
• Providing monthly stakeholder reports and proactive input on the health of their products database environment, potential risks and improvements.
• Assist teams with implementing and configuring SQL databases, integrations and data models - local network and Azure.
• Assist the Data Engineering team with the migration of their local on-premise SQL data warehouse environment to Azure.
• Remediation of any security audit findings to ensure that the data environment is secure and effectively managed.
• Monitor the data requests job queue and deal with business requests and incidents.
• Adhere to our IT change and release processes.
• Creating and updating backlog and sprint tasks in Azure DevOps.
• Collaboration within the data team to help bring about improvements and efficiencies relating to the technical data environment.
• Collaboration with our security and risk teams to ensure that our environment and deliverables meet PwC and industry standards.
• Technical documentation of the data environment, updating this with any changes implemented.

Scope of services included:

• Database administration tasks and projects in support of the Africa data environment.
• Delivery of assigned tasks as captured and assigned in the Data team’s product backlog and job queue.
• Engagement with, and support to, our internal business teams, ensuring that we apply best practices and standards across the Africa firm.

Scope of services included:

• Database administration tasks and projects in support of the Africa data environment.
• Delivery of assigned tasks as captured and assigned in the Data team’s product backlog and job queue.
• Engagement with, and support to, our internal business teams, ensuring that we apply best practices and standards across the Africa firm.

Scope of services excluded:

• Any tasks not specified in the Data team’s product backlog or jog queue, unless agreed with the Team Lead

Approach:

• The position will report to the DBA stream lead with overall feedback to the Data Engineering team lead as a capability within the Africa Data Office..
• Projects and work tasks will be assigned through the Scrum process as prioritized and approved by the DE team lead in Azure DevOps.
• Adherence to PwC technical best practices and standards.
• Adherence to PwC software development and release processes including, but not limited to, change and release controls, security, risk and governance.
• Development of professional relationships and communication with key stakeholders to manage expectations and build trust.

Deliverables:
Database implementation and support requirements, such as:

• Database design (with assistance from the DBA stream lead
• Database upgrades
• Database patching
• Database backup and ensuring high availability
• Database security
• Database tuning
• Database monitoring
• Task automation/scheduling
• Data environment documentation and reporting
• Product and environment support tasks as assigned through the product backlogs and helpdesk.
• Data Engineering team project tasks related to internal projects.
• Technical input into delivery plans.

Skills required
Essential skills:

• SQL
• T-SQL
• SSIS
• SSAS
• Database design
• Database security
• Database tuning
• Database monitoring
• Task automation/scheduling

Advantageous skills:

• Alteryx server management
• Power Bi
• Azure Data Factory
• Azure Data Lake
• Azure SQL
• Azure Synapse

Education (if blank, degree and/or field of study not specified)
Degrees/Field of Study required:
Degrees/Field of Study preferred:

Certifications (if blank, certifications not specified)
Required Skills
Optional Skills

Desired Languages (If blank, desired languages not specified)