At a Glance
- Tasks: Lead the design and optimisation of data architecture for impactful projects.
- Company: Join a diverse and inclusive tech company that values innovation.
- Benefits: Competitive salary, flexible work options, and opportunities for professional growth.
- Other info: Dynamic team environment with a focus on creativity and problem-solving.
- Why this job: Shape the future of data systems and make a real difference in technology.
- 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.
- 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: JPMorganChase
As a Lead Architect in Data & Database Systems, you will thrive in a dynamic work environment that champions innovation and collaboration. Our company prioritises employee growth through continuous learning opportunities and a strong commitment to diversity and inclusion, ensuring that every voice is heard and valued. Located in a vibrant area, we offer a supportive culture that encourages creative problem-solving and the chance to work with cutting-edge technologies, making it an excellent place for those seeking meaningful and rewarding employment.
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 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 designs, or any projects you've worked on. This gives potential employers a taste of what you can do beyond just a CV.
✨Tip Number 3
Prepare for interviews by brushing up on common technical questions related to data architecture and performance tuning. Practice explaining your thought process clearly; it’s all about showing how you tackle problems!
✨Tip Number 4
Don’t forget to apply through our website! We love seeing candidates who are genuinely interested in joining us. Plus, it makes tracking your application a breeze!
We think you need these skills to ace Lead Architect- Data & Database Systems
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 those fancy aggregates. Don’t hold back – this is your chance to shine!
Tailor Your Experience:When you’re writing your application, tailor it to the job description. Mention your experience with RDBMS like PostgreSQL or MySQL, and any performance tuning you've done. We love seeing how your background aligns with what we need!
Be a Problem Solver:We’re looking for someone who can think outside the box. In your application, share examples of how you’ve tackled production incidents or improved operational stability. Show us your troubleshooting skills and creative solutions!
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. Plus, it shows you’re serious about joining our team!
How to prepare for a job interview at JPMorganChase
✨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 RDBMS
Get comfortable with at least one major RDBMS like PostgreSQL or MySQL. Be prepared to talk about your hands-on experience with these systems, including any performance tuning strategies you've implemented.
✨Showcase Your Monitoring Skills
Be ready to discuss your experience with monitoring tools like Prometheus or Grafana. Highlight any instances where you've built observability for database systems and how it improved performance.
✨Think Beyond the Routine
Demonstrate your ability to think creatively about data architecture solutions. Share examples of how you've tackled complex problems and engaged with technical teams to propose innovative approaches.
