About the Role
iCapital is looking to hire a DevOps Database Engineer to join the Platform Infrastructure team. This role is responsible for owning the performance, reliability, security, and operation of the company’s SQL and NoSQL database platforms. The role operates within a database team who partners with application engineering, platform, and security teams to ensure databases are scalable, resilient, secure, and observable across all environments.
Responsibilities
Own end to end performance of SQL and NoSQL databases across environments, including query optimization, indexing strategies, execution plan analysis, and tuning of database runtime parameters (i.e. PostgreSQL query plans, MongoDB indexes, DynamoDB access patterns).
Prevent performance regressions proactively through representative load testing, performance analysis tooling, and CI or CD validation gates.
Partner with application teams on schema design, data modeling, and workload driven performance improvements, including relational schemas, document models, and NoSQL access patterns.
Design, operate, and harden production grade SQL, NoSQL, and document database systems with strong replication, failover, backup or restore, and security controls.
Define, implement, and validate backup and disaster recovery strategies, including routine restore testing and compliance with RPO and RTO objectives.
Establish SLIs and SLOs for database health, including latency, error rates, contention, replication lag, storage growth, and cache efficiency across SQL and NoSQL databases.
Deliver actionable dashboards and alerts and maintain operational runbooks alongside up to date documentation.
Lead or participate in production incident response and post incident reviews related to database platforms.
Enforce database security best practices in partnership with InfoSec, including least privilege access, RBAC, a
