SQL Database Administrator

SQL Database Administrator

Posted 1 day ago by Vector Resourcing

Apply
£55 Per hour
Undetermined
Undetermined
Greater Bristol Area, United Kingdom
Apply
Database Administration Data Warehousing Management Oracle Database Administration (DBA) SQL (Programming Language)

Summary: The SQL Database Administrator will be responsible for diagnosing and resolving performance issues within a client's legacy Data Warehouse. This role requires collaboration with the Data Warehouse Lead and offshore support team to ensure efficient operations and the implementation of best practices. The DBA will also focus on optimizing SQL queries and developing a modernization roadmap for the Data Warehouse environment.

Key Responsibilities:

  • Analyse existing Data Warehouse structures to identify performance bottlenecks.
  • Troubleshoot and resolve issues relating to indexes, file groups, and other areas of concern.
  • Work closely with the Data Warehouse Lead to develop a remediation plan.
  • Collaborate with the offshore team to deliver solutions quickly and effectively.
  • Optimise SQL queries, stored procedures, and workloads for improved performance.
  • Implement best practice methodologies for monitoring and maintaining the Data Warehouse.
  • Provide clear documentation of issues identified and solutions applied.
  • Support in developing a roadmap to modernise and future-proof the Data Warehouse environment.

Key Skills:

  • Experience with SQL and Data Warehouse management.
  • Strong troubleshooting skills related to performance issues.
  • Ability to collaborate effectively with teams.
  • Knowledge of best practices for Data Warehouse maintenance.
  • Experience in optimizing SQL queries and stored procedures.
  • Documentation skills for issue resolution and solutions.
  • Understanding of modern Data Warehouse technologies.

Salary (Rate): £55.00/hr

City: Greater Bristol Area

Country: United Kingdom

Working Arrangements: undetermined

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

We are searching for an experienced SQL Data Warehouse DBA who will play a vital role in diagnosing and resolving performance issues within our client’s legacy Data Warehouse. This role involves working closely with the Data Warehouse Lead and the offshore support team to identify, troubleshoot, and rectify critical issues at pace, ensuring smooth and efficient day-to-day operations.

Responsibilities

  • Analyse existing Data Warehouse structures to identify performance bottlenecks.
  • Troubleshoot and resolve issues relating to indexes, file groups, and other areas of concern.
  • Work closely with the Data Warehouse Lead to develop a remediation plan.
  • Collaborate with the offshore team to deliver solutions quickly and effectively.
  • Optimise SQL queries, stored procedures, and workloads for improved performance.
  • Implement best practice methodologies for monitoring and maintaining the Data Warehouse.
  • Provide clear documentation of issues identified and solutions applied.
  • Support in developing a roadmap to modernise and future-proof the Data Warehouse environment.
Apply
Similar Jobs
Loading data...