Data Analyst Sql

Jago Consultants; United Kingdom; On-site; GBP 50,000 - 80,000; Full time

Job summary

Jago Consultants is seeking an Experienced Database Analyst or Data Engineer with SQL expertise to join our team and help elevate a client’s data platform. You will work with in-house developers, testers, cloud operations and support services to support, maintain and optimise the data platform in both lab and live environments.

The role focuses on tuning and optimising data workloads, managing migrations from on-premise to cloud, and contributing to a roadmap that leverages automation and

Qualifications

• Experience with relational databases (SQL Server and/or Oracle).
• Strong query troubleshooting and remediation skills.
• Experience with database performance tuning.
• Experience migrating data between on-premise and cloud.
• Ability to contribute to data platform roadmaps and automation.

Responsibilities

• Support, maintain, tune and optimise data platform in lab and live environments.
• Assist with third line support.
• Contribute to roadmap and automation for data platform.

Skills

SQL Server

Oracle

Query tuning

Cloud platforms

Data migrations

CI/CD

Education

Bachelor's degree in computer science

Tools

SSMS

Oracle SQL Developer

Job description

Experienced Database Analyst or Data Engineer with SQL experience required

Working within a team of inhouse developers and testers plus cloud operations and support services, you will be empowered to take the client’s product to greater heights and look to the future in supporting the building of a data platform roadmap.

Looking for someone that can make an immediate contribution around supporting, maintaining, tuning and optimising the data that the client’s platform sits upon in ‘lab’ conditions, as observed in our CI/CD pipeline, and when live for on‐premise and cloud customers assist with third line support.

Combined with contributing to the current model, build a road map that looks to further leverage automation, review and update technology/architecture to ensure long term technical viability, provide insight to feed DevOps pipeline, infusing key analytics technologies where appropriate. Prior experience of working through data platform transitions and upgrade desired.

Ultimate responsibility, as part of the team, for ensuring that the solution continues to exhibit high levels of performance, security, scalability, maintainability and reliability.

Skills/Experience

1. 1. Experience working with relational databases (SQL Server and/or Oracle) in a DBA / Data Engineer type role.
2. 2. Query troubleshooting knowledge such as isolating blocks of poor performing SQL, determining root cause, and developing remediation actions.
3. 3. Experience with database management tools.
4. 4. Experience with database performance tuning.
5. 6. Experience having worked through a solution’s customer base transitioning from on‐premise/hybrid to cloud
6. 7. Experience with data migration strategies and moving large scale production systems either in on‐ premise/data centre environments or migration to cloud scenarios.
7. 8. Knowledge of cloud development platforms and options.
8. 9. Proven track record in designing, building and maintaining enterprise level applications.

Qualifications

• A degree or industry recognised equivalent in a computer/numerate subject

Person Profile

Enterprise‐scale technical experience working with relational databases and cloud/hybrid infrastructures, architecture designs and database migrations.

The technical aptitude and experience to learn new/emerging technologies and understand relevant cloud trend.

Someone who can blend the near‐term needs with the long‐term vision and provide leadership on that long term data platform vision.

Package:

Salary depending on Experience level