JPMorgan Chase & Co.
Lead Architect- Data & Database Systems
How you stack up
Upload your CV to see how well it fits this job role
?%
Lead Architect- Data & Database Systems
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.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
J.P. Morgan is a global leader in financial services, providing strategic advice and products to the world’s most prominent corporations, governments, wealthy individuals and institutional investors. Our first-class business in a first-class way approach to serving clients drives everything we do. We strive to build trusted, long-term partnerships to help our clients achieve their business objectives.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. We also make reasonable accommodations for applicants’ and employees’ religious practices and beliefs, as well as mental health or physical disability needs. Visit our FAQs [https://careers.jpmorgan.com/us/en/how-we-hire/faqs] for more information about requesting an accommodation.
Our professionals in our Corporate Functions cover a diverse range of areas from finance and risk to human resources and marketing. Our corporate teams are an essential part of our company, ensuring that we’re setting our businesses, clients, customers and employees up for success.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills