SQL DBA

This job has now expired please search on the home page to find live IT Jobs.

Our Client is urgently looking for a SQL DBA,

Contract inside the scope of IR35,

Location: Home-based/on-site South-West,

What I'll be doing - your accountabilities:

Solution Design

*Partner with the wider People Reporting and Analytics team to design data solutions that enable the delivery of Clinet's people data reporting needs.

*Partner with the Better Workplace Programme to ensure data requirements are understood and delivered conistently.

*Support the design of the new data architecture and configuration of SAP SuccessFactors for managing reporting and analytics services utilising as part of I Connect

HR Database Management

*Manage database changes and operational processes required to maintain a source of trusted and reliable data

*Accountable for documenting database design and database management processes

*Partner with the Technology support teams to ensure the maintenance of the system and associated integrations including regular upload and extraction of data

*Ensure database compliance with Client's security and data protocols and adherence to the relevant data controls across the data lifecycle (capture, storage, access, retention, deletion)

*Accountable for ensuring that all delivery is in line with legislative requirements e.g. GDPR, as well as the Client's Security and Safety Policies

Data Extraction

*Managing regular data extracts provided to other applications e.g. BWP solution, Annaplan, Orgvue or to support reporting e.g. Headcount and Movements files.

*Automate data extracts for ease of production.

*New requests for data to support reporting may require complex SQL code to be developed to extract the relevant data from the HRDB.

*Provide guidance to the wider People Reporting and Analytics team to manage data queries and extraction effectively

Data Integrity

*The HRDB transforms data from different data sources which requires active management to ensure data integrity. Data anomalies can disrupt the refresh process and require detailed data checks to ensure data uploads work.

*Identify data integrity and data quality risks and issues and recommend changes to inform data definitions and requirements that ensure consistent and trusted data for the purposes of reporting and analytics.

Experience you would be expected to have:

*Mandatory - Knowledge of database design and query tools

*Mandatory - Understanding of relational databases and transactions

*Mandatory - Data privacy requirements and managing controls for sensitive data

*Mandatory - Use of Transact SQL (SSMS2016)

*Mandatory - Management and application of temporal tables

*Preferred - Previous role experience with people data

*Preferred - Experience in the development of database operational processes

*Preferred - Experience of PowerShell scripting

*Preferred - An analytical problem solver with diagnostic skills such as root cause analysis

LA International Computer Consultants Ltd is an HMG Approved Consultancy and operates as an IT & Engineering Consultancy or as an Employment Business & Agency, depending upon the precise nature of the work, for security cleared jobs or non-clearance vacancies, we welcome applications from all sections of the community and from people with diverse experience and backgrounds.

Award Winning LA International Computer Consultants Ltd (Recruiter Awards for Excellence - Best IT, Best Public Sector & Gold Awards) and the most prestigious award, that any business can receive, won in consecutive years, The Queens Award for Enterprise: International Trade;