Owns the administration, optimization, scalability, monitoring, reliability, and architecture of PostgreSQL, MongoDB, and Databricks environments. Responsibilities include performance tuning, schema configuration, observability, autoscaling, capacity planning, production troubleshooting, maintenance, high availability, disaster recovery, incident response, and data analysis support. The role designs resilient, cost-efficient data platforms at very high volumes and partners with engineering, analytics, and product teams.
Be at the Forefront of the Agentic AI Revolution
At Skan AI, you'll be part of the team pioneering the context engine for human and agentic execution, bringing context from enterprise operators, systems, and processes to power how the world's largest organizations execute their most complex, mission-critical work.
Why Join Skan AI
We're in hyper-growth mode at exactly the right moment in history. As enterprises race to adopt agentic AI, we're uniquely positioned to deliver the clear signal they desperately need: a platform that trains and grounds AI Agents in trillions of real execution signals, enabling reliable, compliant automation of their most complex processes.
Backed by Dell Technologies Capital and other leading investors, we're the only company that can bridge the gap between AI's promise and enterprise reality, making us perfectly positioned to define the agentic era for modern enterprises.
Our diverse, collaborative team of 250+ innovators is solving category-defining challenges at the intersection of AI, process intelligence, and enterprise work. Diverse perspectives fuel breakthrough thinking, cross-functional collaboration is the norm, and our work directly transforms how Fortune 500 companies operate. We are shaping the future of work itself.
Role Summary
We are seeking a Senior Database Administrator (DBA) with deep, hands-on expertise in PostgreSQL and in analytical (OLAP) and data warehouse platforms such as StarRocks, ClickHouse, or similar. You will own the health, performance, scalability, and reliability of the data stores that power real-time analytics and customer-facing reporting at very high data volumes. You take pride in building systems that are fast, resilient, and cost-efficient.
The primary focus is administration and platform engineering: configuring and tuning database platforms, instrumenting monitoring and metrics, right-sizing environments as demand changes, and standing up schemas and data models aligned to evolving requirements. Secondary focus: supporting analytics teams, troubleshooting production data issues, planning capacity, performing maintenance, and preventing outages before they happen.
The ideal candidate is technically outstanding across both transactional and analytical systems, highly collaborative, and eager to keep learning as our data estate evolves.
Primary Responsibilities: Administration & Platform Engineering
Configuration, Setup & Optimization
- Provision and configure PostgreSQL and OLAP warehouse clusters (StarRocks, ClickHouse, Doris, Redshift, BigQuery, or similar) from the ground up, with tuned parameters, storage layouts, and connection strategies suited to very large data volumes.
- Continuously optimize PostgreSQL: memory and buffers, connection pooling (PgBouncer), indexing, partitioning, vacuum/autovacuum, query planning, and workload isolation.
- Continuously optimize OLAP and warehouse engines (concepts apply across tools): table models and keys (duplicate, aggregate, primary key), partitioning and bucketing/distribution, sort keys, materialized views, compaction, caching, and resource groups for workload isolation.
- Design and tune ingestion into the warehouse: streaming and batch loads (Kafka, Flink CDC, Stream Load/Routine Load, S3 or object-storage loads), handling late data, upserts, and schema evolution.
- Stand up schemas and data models from functional and non-functional requirements gathered from engineering, analytics, and product stakeholders, balancing normalization, denormalization, access patterns, and performance.
- Tune query performance using query profiles, EXPLAIN plans, join strategies, and data skew analysis to keep dashboards and ad hoc queries fast at scale.
Monitoring, Metrics & Observability
- Design and implement monitoring across all platforms: throughput, latency, query performance, replication lag, ingestion lag, lock contention, compaction backlog, storage utilization, and resource saturation.
- Build dashboards and alerting (e.g., Prometheus, Grafana) with thresholds that surface issues early and drive proactive intervention rather than reactive firefighting.
- Define and track service-level objectives (SLOs) and key operational indicators, and report on the health and performance of the data estate.
Elastic Scaling & Capacity Management
- Resize and scale clusters vertically and horizontally (adding or removing frontend/backend or shard/replica nodes, rebalancing tablets or partitions) based on real-time and forecasted demand.
- Tune replication, sharding, and partitioning strategies to support sustained growth in data volume and query concurrency.
- Continuously evaluate cost-to-performance trade-offs across storage and compute tiers, including hot/cold storage, tiered storage, and compute/storage separation.
Secondary Responsibilities: Operations, Reliability & Analysis Support
Production Troubleshooting & Proactive Reliability
- Troubleshoot and resolve production data issues, including slow queries, data anomalies, replication or ingestion problems, contention, and platform incidents, often under time pressure.
- Watch for performance degradation and act before it affects users, using data-driven signals and early-warning indicators.
- Participate in incident response and on-call rotations, run root-cause analysis, and drive durable fixes.
Capacity Planning & Maintenance
- Forecast growth in storage, compute, and I/O, and schedule upgrades ahead of demand.
- Perform routine and preventative maintenance (patching, version upgrades, index and partition maintenance, vacuum/compaction, backup verification, configuration hygiene) with minimal disruption.
- Maintain runbooks, operational documentation, and disaster-recovery procedures.
Data Analysis Support
- Help analysts and engineers with query optimization, data access, and data modeling for efficient analytical workloads.
- Partner with analytics and BI teams (e.g., Superset, Power BI) to ensure dashboards and downstream tools get reliable, fast access to large datasets.
Architecture & Design
- A defining requirement of this role is the ability to architect data platforms that stay high performing, highly available, and recoverable at very high data volumes.
- Architect transactional (PostgreSQL) and analytical (OLAP) designs that sustain very high write, ingestion, and query volumes without degradation.
- Design the data flow between systems, such as operational PostgreSQL to the warehouse via CDC, and choose the right engine for each workload (OLTP, real-time OLAP, batch analytics).
- Design high-availability (HA) architectures: replication, clustering, failover, and multi zone or multi-region topologies to meet demanding uptime targets. Design and validate disaster-recovery (DR) strategies, including backup/restore, replication, failover runbooks, and defined RPO/RTO targets, with regular DR testing.
- Translate business and technical requirements into scalable, resilient, and cost effective platform designs.
Required Qualifications
- Extensive hands-on database administration experience, with senior-level depth in PostgreSQL.
- Hands-on production experience with at least one modern OLAP/columnar warehouse engine (for example StarRocks, ClickHouse, Apache Doris, Druid, Redshift, or BigQuery; depth in the underlying concepts matters more than the specific tool), including data modeling, partitioning, and performance tuning.
- Demonstrated experience scaling data environments for very large data volumes, including sharding, partitioning, replication, and tuning at scale.
- Deep expertise in configuration, optimization, indexing, and query performance tuning for both row-store and columnar systems.
- Proven experience designing and operating HA and DR solutions for high-volume databases.
- Strong monitoring and observability skills: instrumenting metrics, dashboards, and alerting to drive proactive operations.
- Experience with capacity planning, maintenance, patching, and upgrade management in production.
- Solid command of SQL and a scripting/automation language (e.g., Python, Bash) for operational tooling
- Working knowledge of data pipelines and CDC/streaming tools (e.g., Kafka, Flink, Debezium) and of cloud storage and compute scaling.
- Strong troubleshooting and root-cause analysis skills, with the ability to stay calm and effective during production incidents.
Preferred Qualifications
- Experience with infrastructure-as-code and automation (e.g., Terraform, Ansible) and CI/CD for database changes.
- Familiarity with Docker and Kubernetes for running database and data workloads (e.g., operators for PostgreSQL, StarRocks, or ClickHouse).
- Experience with data lake and lakehouse formats (Parquet, Iceberg, Delta) and external or federated querying from the warehouse.
- Exposure to BI and visualization tools (Superset, Power BI, Grafana) and how their query patterns affect warehouse design.
- Exposure to data governance, security, encryption, role-based access, and compliance requirements at scale.
- Relevant certifications in PostgreSQL, a data warehouse or OLAP platform, or major cloud providers.
- Prior experience mentoring engineers or leading platform initiatives.
Key Skills & Attributes
- Technically savvy: genuinely strong and current in PostgreSQL and OLAP warehouse engines, with the instincts to diagnose and optimize complex systems.
- Highly collaborative: works closely with engineering, analytics, and product teams and communicates clearly with technical and non-technical audiences.
- Eager to learn and grow: curious, adaptable, and motivated to expand skills as technologies evolve.
- Proactive and ownership-minded: anticipates problems, prevents outages, and takes end-to-end responsibility for platform health.
- Detail-oriented and reliable: disciplined about maintenance, documentation, and operational rigor.
Skan AI is an equal opportunity employer committed to building a diverse, inclusive, and respectful workplace around the world. We do not discriminate based on race, color, religion or belief, sex (including pregnancy, sexual orientation, gender identity, or gender expression), national origin, ancestry, age, disability, medical condition, genetic information, marital or family status, military or veteran status, or any other characteristic protected by applicable laws in the locations where we operate.
We welcome people from all backgrounds and provide reasonable accommodations throughout the hiring process.
Similar Jobs
Database
Lead database administration for Oracle (19c+) with MS SQL and PostgreSQL support. Design/maintain infrastructure, DR and backup strategies (RMAN), implement security/compliance controls, automate tasks, tune performance, mentor junior DBAs, and provide 24/7 on-call support using monitoring tools like SolarWinds and DataDog.
Top Skills:
Azure SqlBashClusteringDatadogFailoverLinuxAzureMs Sql 2012OelOracleOracle 19COracle Enterprise ManagerPl/SqlPostgresPowershellReplicationRhelRmanSite24X7SolarwindsVirtualization
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Principal Software Engineer focused on encryption, working remotely within Atlassian’s distributed-first engineering organization. The provided description contains limited role-specific responsibilities.
Top Skills:
Encryption
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Principal Software Engineer role focused on building and developing Atlassian’s Trusted Data Platform. The position is full-time and based in Bengaluru, India, with remote flexibility. The provided description emphasizes Atlassian’s distributed-first work model, virtual interviews and onboarding, and location flexibility for eligible employees.
What you need to know about the Mumbai Tech Scene
From haggling for the best price at Chor Bazaar to the bustle of Crawford Market, the energy of Mumbai's traditional markets is a key part of the city's charm. And while these markets will always have their place, the city also boasts a thriving e-commerce scene, ranking among the largest in the region. Driven by online sales in everything from snacks to licensed sports merchandise to children's apparel, the local industry is worth billions, with companies actively recruiting to meet the demands of continued growth.
