remote
Lead Architect- Data & Database Systems - JPMorganChase
Software Engineer
Lead Architect for Data & Database Systems driving performance, reliability, and scalable architecture using SQL, advanced tuning, and observability tools to support mission‑critical applications.
About the role
Key Responsibilities
- Author and optimize SQL queries for performance and correctness across enterprise databases.
- Monitor, tune, and scale database performance through indexing, partitioning, and caching strategies.
- Build and maintain comprehensive monitoring, alerting, and observability pipelines for database systems.
- Lead production incident response, perform root cause analysis, and participate in on‑call rotations.
- Collaborate with application teams on data access patterns, migrations, and release planning.
- Engage technical and business stakeholders to design and propose data architecture solutions that meet current and future needs.
- Evaluate emerging technologies, provide actionable feedback, and drive continuous improvement.
Requirements
- Extensive experience with relational database systems (e.g., Oracle, SQL Server, PostgreSQL).
- Deep knowledge of query optimization, indexing, partitioning, and caching techniques.
- Proficiency in monitoring and observability tools (e.g., Prometheus, Grafana, ELK).
- Strong incident response and root cause analysis skills.
- Excellent communication and stakeholder management abilities.