DevOps Database Assistant Vice President
Source: RemoteOK
AI Summary Powered by Gemini
iCapital is seeking a DevOps Database Engineer to manage the performance, reliability, security, and operation of their SQL and NoSQL database platforms. This role requires expertise in database tuning, performance analysis, schema design, and security best practices, offering an opportunity to ensure scalable and resilient database systems within a collaborative team environment.
Job Description
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, aPlease mention the word PROPITIOUSLY and tag RODguMTk4Ljk5LjE0Mw== when applying to show you read the job post completely (#RODguMTk4Ljk5LjE0Mw==). This is a beta feature to avoid spam applicants. Companies can search these words to find applicants that read this and see they're human.
Full Description
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, aPlease mention the word PROPITIOUSLY and tag RODguMTk4Ljk5LjE0Mw== when applying to show you read the job post completely (#RODguMTk4Ljk5LjE0Mw==). This is a beta feature to avoid spam applicants. Companies can search these words to find applicants that read this and see they're human.