Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead the design and optimisation of data systems while collaborating with technical teams.
- Company: Join a forward-thinking tech company focused on innovative data solutions.
- Benefits: Attractive salary, flexible working options, and opportunities for professional growth.
- Other info: Dynamic role with potential for significant impact and career advancement.
- Why this job: Shape the future of data architecture and tackle exciting challenges every day.
- Qualifications: Strong SQL skills and experience with major RDBMS required.
The predicted salary is between 70000 - 90000 £ per year.
Job responsibilities:
- Author and optimize queries for performance and correctness.
- Monitor and tune database performance, including query tuning, indexing, partitioning, and caching.
- Build and maintain monitoring, alerting, and observability for database systems.
- Support production incidents and perform root cause analysis; participate in on-call rotations.
- Assist application teams with data access patterns, migrations, and release planning.
- Engage technical teams and business stakeholders to discuss and propose data architecture approaches to meet current and future needs.
- Evaluate recommendations for new technologies and provide actionable feedback.
- Execute creative data architecture solutions, including design, development, and technical troubleshooting, with the ability to think beyond routine or conventional approaches to build solutions or break down technical problems.
- Develop secure, high-quality production code; review and debug code written by others.
- Identify opportunities to eliminate or automate remediation of recurring issues to improve overall operational stability of software applications and systems.
Required qualifications, capabilities, and skills:
- Strong SQL skills, including complex joins, window functions, aggregates, subqueries, and explain/analyze plans.
- Experience with at least one major RDBMS: PostgreSQL, MySQL/MariaDB, Microsoft SQL Server, or Oracle.
- Performance tuning experience, including indexing strategies, query profiling, and execution plan interpretation.
- Experience with monitoring and observability tooling such as Prometheus, Grafana, Datadog, Dynatrace or New Relic.
- Familiarity with versioned schema migrations using tools such as Flyway, Liquibase, Alembic, or sqitch.
- Good understanding of storage, IOPS, and how database workload relates to underlying infrastructure.
- Familiarity with cloud-managed databases and their operational tradeoffs, including AWS RDS/Aurora, Google Cloud SQL, and Azure SQL/DMS.
- Strong troubleshooting skills and experience handling production incidents.
- Proficiency in automation and continuous delivery methods.
- Proficient in all aspects of the Software Development Life Cycle.
- Advanced knowledge of one or more software, application, and architecture disciplines, with the ability to evaluate current and emerging technologies to recommend the best data architecture solutions for future state architecture.
Lead Architect- Data & Database Systems in Glasgow employer: JPMorganChase
Contact Detail:
JPMorganChase Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Lead Architect- Data & Database Systems in Glasgow
✨Tip Number 1
Network like a pro! Get out there and connect with folks in the industry. Attend meetups, webinars, or even just grab a coffee with someone who’s already in the role you want. You never know who might have the inside scoop on job openings!
✨Tip Number 2
Show off your skills! Create a portfolio or GitHub repository showcasing your projects, especially those involving SQL and database performance tuning. This gives potential employers a taste of what you can do and sets you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on your technical knowledge. Be ready to discuss your experience with RDBMS, query optimisation, and monitoring tools. Practise explaining complex concepts in simple terms – it shows you really understand your stuff!
✨Tip Number 4
Don’t forget to apply through our website! We’re always on the lookout for talented individuals like you. Plus, applying directly can sometimes give you a better chance of getting noticed by hiring managers.
We think you need these skills to ace Lead Architect- Data & Database Systems in Glasgow
Some tips for your application 🫡
Tailor Your Application: Make sure to customise your CV and cover letter for the Lead Architect role. Highlight your SQL skills and experience with RDBMS that match our needs. We want to see how your background aligns with what we're looking for!
Showcase Your Problem-Solving Skills: In your application, share examples of how you've tackled complex database issues or optimised performance in the past. We love seeing creative solutions, so don't hold back on those success stories!
Be Clear and Concise: When writing your application, keep it straightforward and to the point. Use clear language to describe your experiences and skills. We appreciate a well-structured application that makes it easy for us to see your qualifications.
Apply Through Our Website: We encourage you to submit your application directly through our website. It’s the best way for us to receive your details and ensures you’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at JPMorganChase
✨Master Your SQL Skills
Make sure you brush up on your SQL skills before the interview. Be ready to discuss complex joins, window functions, and how to optimise queries for performance. Practising with real-world scenarios can help you articulate your thought process during the interview.
✨Showcase Your Performance Tuning Experience
Be prepared to share specific examples of how you've improved database performance in the past. Discuss your experience with indexing strategies and query profiling, and be ready to explain how you interpret execution plans. This will demonstrate your hands-on expertise.
✨Familiarise Yourself with Monitoring Tools
Since monitoring and observability are key parts of the role, make sure you know your way around tools like Prometheus or Grafana. You might be asked about how you've used these tools to troubleshoot issues, so having a couple of examples up your sleeve will be beneficial.
✨Engage with Data Architecture Discussions
Prepare to engage in conversations about data architecture approaches. Think about how you would propose solutions that meet both current and future needs. Being able to discuss emerging technologies and their potential impact on data architecture will show your forward-thinking mindset.