SQL Database Administrator

SQL Database Administrator

Posted 1 week ago by Concept Resourcing on JobServe

£300 Per day
Outside
Onsite
Cardiff, Wales, UK
p>Junior SQL Database Administrator (DBA) with Power BI Analytics

Location: Remote with once-a-month onsite presence in South Wales.
Contract Length: 6- months
Salary: 300 per day OUTSIDE IR35

About the Role:
We are seeking a motivated and detail-oriented Junior SQL Database Administrator (DBA) with strong experience in Power BI analytics to join our client on a contract basis. This role offers an excellent opportunity to enhance your database management skills while leveraging analytics to drive actionable insights. As part of a dynamic team, you will contribute to the smooth operation, performance, and security of our database infrastructure and analytics processes.

Key Responsibilities:

Database Administration:

  • Assist in the installation, configuration, and ongoing maintenance of SQL Server databases.
  • Monitor and manage database performance, including query optimisation and index management.
  • Implement and maintain robust backup and recovery processes to ensure data integrity and availability.
  • Enforce database security measures, including user role management, permissions, and encryption.

Data Integration:

  • Support ETL (Extract, Transform, Load) processes to integrate data from various sources into the SQL Server environment.
  • Ensure data quality and consistency across all data pipelines.

Power BI Analytics:

  • Develop, create, and maintain Power BI dashboards and reports to support business decision-making.
  • Translate complex datasets into user-friendly visualizations and insights for stakeholders.

Performance Monitoring and Troubleshooting:

  • Diagnose and resolve database-related issues efficiently.
  • Proactively identify performance bottlenecks and recommend solutions.
  • Provide technical support and guidance to end-users as needed.

Documentation:

  • Maintain comprehensive and up-to-date documentation of database configurations, policies, and procedures.

Skills & Qualifications:

  • Experience: 1-2 years in SQL database administration and Power BI analytics.
  • Technical Proficiency:
    • Hands-on experience with SQL Server management and administration.
    • Proven expertise in creating Power BI dashboards and reports.
    • Knowledge of ETL processes and data integration tools.
    • Familiarity with database security best practices.
    • Basic understanding of database performance tuning and optimisation techniques.
  • Soft Skills:
    • Strong analytical and problem-solving skills.
    • Excellent communication and teamwork abilities.
    • Attention to detail and a proactive approach to continuous learning.