Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead the design and optimisation of data systems for peak performance.
- Company: Join a forward-thinking tech company focused on innovation.
- Benefits: Attractive salary, flexible working options, and opportunities for growth.
- Other info: Dynamic team environment with a focus on creativity and problem-solving.
- Why this job: Shape the future of data architecture and tackle exciting challenges.
- 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: Jpmorgan Chase & Co.
Contact Detail:
Jpmorgan Chase & Co. 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! Reach out to folks in your industry on LinkedIn or at local meetups. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Show off your skills! Create a portfolio or GitHub repository showcasing your SQL queries, database optimisations, and any cool projects you've worked on. This gives potential employers a taste of what you can do.
✨Tip Number 3
Prepare for interviews by brushing up on common database scenarios and performance tuning questions. Practise explaining your thought process when solving technical problems – it’s all about showing how you think!
✨Tip Number 4
Don’t forget to apply through our website! We love seeing candidates who are genuinely interested in joining us. Plus, it’s a great way to ensure your application gets the attention it deserves.
We think you need these skills to ace Lead Architect- Data & Database Systems in Glasgow
Some tips for your application 🫡
Show Off Your SQL Skills: Make sure to highlight your strong SQL skills in your application. We want to see your experience with complex joins, window functions, and all that good stuff. Don’t forget to mention any performance tuning you've done!
Talk About Your Experience: When you’re writing your application, share your hands-on experience with RDBMS like PostgreSQL or MySQL. We love seeing how you've tackled database performance issues and what tools you've used for monitoring and observability.
Be Creative with Solutions: We’re looking for someone who can think outside the box! In your application, give examples of creative data architecture solutions you've implemented. Show us how you’ve approached technical problems in unique ways.
Apply Through Our Website: Don’t forget to apply through our website! It’s the best way for us to keep track of your application and ensure it gets the attention it deserves. We can’t wait to see what you bring to the table!
How to prepare for a job interview at Jpmorgan Chase & Co.
✨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.
✨Know Your RDBMS Inside Out
Familiarise yourself with at least one major RDBMS like PostgreSQL or MySQL. Be prepared to talk about your experience with performance tuning, indexing strategies, and query profiling. Showing that you can handle these systems will impress the interviewers.
✨Showcase Your Troubleshooting Skills
Prepare examples of past production incidents you've handled. Discuss your approach to root cause analysis and how you’ve improved operational stability. This will demonstrate your ability to think critically and solve problems effectively.
✨Engage with Technical and Business Stakeholders
Be ready to discuss how you would engage with both technical teams and business stakeholders. Think about how you can propose data architecture solutions that meet current and future needs. This shows that you can bridge the gap between tech and business, which is crucial for a Lead Architect.