Cloud Database Administrator - Vice President

InforCapital; Lisboa; Híbrido; EUR 120 000 - 150 000; Tempo integral

Resumo da oferta

iCapital seeks a Vice President Cloud Database Administrator to own the performance, reliability, security, and operation of SQL and NoSQL database platforms across environments. You will optimize queries, implement robust backups, and drive DR initiatives while collaborating with security and engineering teams.

The role focuses on production-grade SQL/NoSQL systems, including PostgreSQL, MongoDB, and DynamoDB, with Terraform and CI/CD tooling in a cloud environment.

Qualificações

• Bachelor's degree in a relevant field.
• Minimum several years of experience with SQL and NoSQL databases.
• Proven ability to design, tune, and operate production-grade database platforms.

Responsabilidades

• Own performance, reliability, and security of SQL/NoSQL databases across environments.
• Lead schema design, data modeling, and workload-driven performance improvements.
• Define backups, DR strategies, and disaster recovery testing.
• Establish SLIs/SLOs and deliver dashboards/alerts for database health.

Conhecimentos

PostgreSQL

MongoDB

DynamoDB

Query optimization

Terraform

CI/CD

Observability

Security RBAC

Formação académica

Bachelor's degree in CS/Engineering

Ferramentas

AWS RDS/Aurora

MongoDB Atlas

DocumentDB

Terraform

GitLab CI/CD

Descrição da oferta de emprego

LocationLisbon, Portugal## About This RoleJob Application for Cloud Database Administrator - Vice President at iCapitalThis 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.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 .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.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.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 .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‐offsExperience 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 ...