Staff Database Administrator at AiDash

Gurugram, Haryana, India

AiDash Logo
Not SpecifiedCompensation
Senior (5 to 8 years), Expert & Leadership (9+ years)Experience Level
Full TimeJob Type
UnknownVisa
Climate Tech, SaaS, UtilitiesIndustries

Requirements

  • 12+ years of experience in PostgreSQL database administration and architecture
  • Hands-on experience with Amazon Aurora and AWS cost/performance optimization
  • Proven expertise in query tuning, indexing strategies, and storage management
  • Good understanding of geospatial queries, time-series data, and large-scale data processing
  • Familiarity with S3, Redshift, Snowflake, and Iceberg
  • Experience managing data-intensive platforms with complex reporting and analytics needs
  • Knowledge of observability tools, query logging, and alerting systems

Responsibilities

  • Assess and monitor the health of a large-scale PostgreSQL (Aurora RDS) database (>50 TB)
  • Identify and resolve performance bottlenecks, including I/O, memory, and CPU-related issues
  • Identify and optimize database bottlenecks, long-running SQL queries, indexes, and schema design
  • Implement robust guardrails for observability, monitoring, query control, and database health
  • Design data retention and purging policies to reduce storage bloat
  • Consult with application teams on schema redesign and query optimization
  • Guide transition and offloading of analytical workloads to OLAP
  • Recommend cost-effective strategies to reduce AWS resource consumption
  • Collaborate with business analysts and developers to align database performance with application functionality

Skills

PostgreSQL
Aurora RDS
SQL
Database Performance Tuning
Indexing
Schema Design
Query Optimization
AWS
Observability
Monitoring
OLAP

AiDash

AI solutions for infrastructure management and sustainability

About AiDash

AiDash offers AI-driven solutions that assist industries in managing their infrastructure against climate change threats. Their main products include systems for vegetation management, sustainability management, integrity management, and climate risk intelligence, which utilize AI and satellite data to provide actionable insights. AiDash differentiates itself by focusing specifically on the needs of sectors with geographically distributed assets, such as utility and transportation companies. The company's goal is to enhance the efficiency and sustainability of critical infrastructure while reducing costs and risks associated with climate change.

Palo Alto, CaliforniaHeadquarters
2019Year Founded
$98.7MTotal Funding
SERIES_CCompany Stage
Data & Analytics, Energy, AI & Machine LearningIndustries
201-500Employees

Benefits

Health Insurance
Dental Insurance
Vision Insurance
Health Savings Account/Flexible Spending Account
401(k) Retirement Plan
Parental Leave
Paid Vacation

Risks

Growing competition from AI and satellite data companies may impact market share.
Potential regulatory changes could increase compliance costs for AiDash.
Economic downturns may affect AiDash's ability to secure future funding.

Differentiation

AiDash uses satellite data for real-time infrastructure monitoring and management.
Their AI-driven systems reduce vegetation management costs by up to 20%.
AiDash's solutions improve sustainability by cutting land and air costs by 70-90%.

Upsides

Increased adoption of AI solutions by utilities enhances grid reliability and reduces costs.
Successful Series C funding round raised $58.5 million, surpassing initial targets.
Strategic partnerships, like with AccuKnox, enhance data security and compliance.

Land your dream remote job 3x faster with AI