Job Description
About the role
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
Platform Performance & Scalability
- 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 (e.g., PostgreSQL query plans, MongoDB indexes, DynamoDB access patterns).
- Proactively prevent performance regressions through representative load testing, performance analysis tooling, and CI/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.
Reliability, High Availability & Disaster Recovery
- Design, operate, and harden production‑grade SQL, NoSQL, and document database systems with strong replication, failover, backup/restore, and security controls.
- Define, implement, and validate backup and disaster recovery strategies, including routine restore testing and compliance with RPO/RTO objectives.
Observability & Operational Excellence
- Establish SLIs and SLOs for database health, including latency, error rates, contention, replication lag, storage growth, and cache efficiency across SQL & 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.
Security, Governance & Automation
- Enforce database security best practices in partnership with InfoSec, including least privilege access, RBAC, auditing, encryption, secure secret handling, access reviews, and secure service‑to‑database authentication across SQL and NoSQL data stores.
- Codify database infrastructure and operations using Infrastructure as Code (Terraform) and CI/CD pipelines.
- Standardize baseline configurations, schema migration practices, and operational guardrails across relational, document, and NoSQL databases.
Qualifications
- Hands‑on experience operating production‑scale SQL and NoSQL databases, with strong troubleshooting skills under pressure.
- Experience with managed cloud database services, including SQL and NoSQL databases (e.g., AWS RDS/Aurora PostgreSQL, MongoDB Atlas, DocumentDB, DynamoDB).
- Deep expertise across the following areas like performance tuning, indexing, query optimization, vacuum/auto vacuum,bloat management, data modeling, backup/restore, capacity planning, scalability design, and cost/performance trade‑offs
- Experience with observability, alerting, and operational metrics for data platforms.
- Automation‑first mindset with hands‑on experience in Infrastructure as Code, Gitlab CI/CD pipelines, and repeatable operational runbooks.
- Experience with IAM‑based access controls, KMS/encryption, secrets management, and compliance‑driven governance controls.
- Proven experience developing and maintaining Terraform modules.
- Strong Linux fundamentals and scripting experience (Bash and/or Python).
- Experience with Docker and Kubernetes for database‑adjacent workloads.
Employees in this role will work fully remote. Every department has different needs, and some positions will be designated in-office jobs, based on their function.
Benefits
iCapital offers a comprehensive benefits package that includes a total compensation program consisting of competitive salary, annual performance bonus, and equity for all full-time employees; healthcare with 100% employer-paid health and dental insurance; and generous paid time off (PTO).
For additional information on iCapital Network, please visit https://www.icapitalnetwork.com/about-us Twitter: @icapitalnetwork | LinkedIn: https://www.linkedin.com/company/icapital-network-inc
