At a Glance
- Tasks: Lead the design and optimisation of data systems for high-performance applications.
- Company: Join J.P. Morgan, a global leader in financial services with a commitment to innovation.
- Benefits: Enjoy competitive pay, diverse work culture, and opportunities for professional growth.
- Other info: Be part of a diverse team that values inclusion and collaboration.
- Why this job: Make a real impact by shaping data architecture solutions that drive business success.
- 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 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 within a global leader in financial services, all while contributing to impactful projects that shape the future of finance.
StudySmarter Expert Advice🤫
We think this is how you could land Lead Architect- Data & Database Systems
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, especially those at J.P. Morgan or similar companies. A friendly chat can sometimes lead to job opportunities that aren't even advertised.
✨Tip Number 2
Prepare for interviews by brushing up on your SQL skills and database performance tuning. We recommend practising common interview questions and scenarios related to data architecture to show off your expertise.
✨Tip Number 3
Don’t forget to showcase your problem-solving skills! Be ready to discuss past experiences where you tackled complex database issues or optimised performance. Real-life examples can make you stand out.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets noticed. Plus, we’re always looking for talented individuals who can bring their unique skills to our team.
We think you need these skills to ace Lead Architect- Data & Database Systems
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 what J.P. Morgan is looking for. We want to see how your background aligns with their needs!
Showcase Your Problem-Solving Skills:In your application, don’t just list your skills; share examples of how you've tackled complex database issues or optimised performance. We love seeing creative solutions and your ability to think outside the box!
Be Clear and Concise:When writing your application, keep it straightforward. Use clear language and avoid jargon unless necessary. We appreciate a well-structured application that gets straight to the point without fluff!
Apply Through Our Website:We encourage you to submit your application through our website. It’s the best way to ensure it reaches the right people. Plus, you’ll find all the details you need about the role there!
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 prepared 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. You might be asked about your experience with these tools, so having specific examples ready will show you're well-prepared.
✨Showcase Your Problem-Solving Skills
Be ready to discuss a time when you handled a production incident or performed root cause analysis. Highlight your troubleshooting skills and how you approach technical problems creatively.
✨Engage with Data Architecture Concepts
Understand the current trends in data architecture and be prepared to discuss how you would approach future needs. This shows that you’re not just thinking about the present but also about long-term solutions.
