At a Glance
- Tasks: Optimise database performance and develop innovative data architecture solutions.
- Company: Join J.P. Morgan, a global leader in financial services.
- Benefits: Competitive salary, diverse workplace, and opportunities for professional growth.
- Other info: Be part of a diverse team that values inclusion and innovation.
- Why this job: Make a real impact in a dynamic environment with cutting-edge technology.
- Qualifications: Strong SQL skills and experience with major RDBMS required.
The predicted salary is between 80000 - 100000 € 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: hackajob
J.P. Morgan is an exceptional employer that values diversity and inclusion, fostering a collaborative work culture where innovative ideas thrive. As a Lead Architect in Data & Database Systems, you will have access to cutting-edge technologies and opportunities for professional growth, all while contributing to impactful projects that shape the future of financial services. With a commitment to employee well-being and a supportive environment, J.P. Morgan stands out as a rewarding place to build your career.
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 your connections in the industry, attend meetups, and engage on platforms like LinkedIn. We all know that sometimes it’s not just what you know, but who you know that can land you that dream job.
✨Tip Number 2
Prepare for those interviews by practising common questions and scenarios related to data architecture. We recommend doing mock interviews with friends or using online resources to get comfortable discussing your experience and skills.
✨Tip Number 3
Showcase your expertise! Create a portfolio or GitHub repository with examples of your work, especially any complex SQL queries or database optimisations you've done. This gives potential employers a tangible look at what you can bring to the table.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we’re always looking for talented individuals who can contribute to our team at J.P. Morgan.
We think you need these skills to ace Lead Architect- Data & Database Systems in Glasgow
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Lead Architect role. Highlight your SQL skills, database performance tuning experience, and any relevant projects you've worked on. We want to see how your experience aligns with what we're looking for!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about data architecture and how your skills can benefit J.P. Morgan. Keep it concise but impactful – we love a good story!
Showcase Your Problem-Solving Skills:In your application, don’t forget to mention specific examples where you’ve tackled complex database issues or optimised performance. We’re all about creative solutions, so let us know how you think outside the box!
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way to ensure your application gets into the right hands. Plus, it shows us you’re serious about joining our team at J.P. Morgan!
How to prepare for a job interview at hackajob
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills, especially complex joins and window functions. Be ready to discuss your experience with performance tuning and how you've optimised queries in the past.
✨Familiarise Yourself with Database Tools
Get comfortable with monitoring and observability tools like Prometheus or Grafana. Be prepared to talk about how you've used these tools to enhance database performance and stability.
✨Showcase Your Problem-Solving Skills
Think of specific examples where you've tackled production incidents or performed root cause analysis. Highlight your troubleshooting skills and how you've contributed to operational stability.
✨Engage with Data Architecture Concepts
Be ready to discuss data architecture approaches and how they align with business needs. Show that you can evaluate new technologies and provide actionable feedback based on your insights.
