About AiDASH AiDASH is making critical infrastructure industries climate-resilient and sustainable with satellites and AI Using our full-stack SaaS solutions customers in electric gas water utilities transportation and construction are transforming asset inspection and maintenance - and complying with biodiversity net gain mandates and carbon capture goals AiDASH exists to safeguard critical infrastructure and secure the future of humanAIty TM Learn more at www aidash com We are a Series C climate tech startup backed by leading investors including Shell Ventures National Grid Partners G2 Venture Partners Duke Energy Edison International Lightrock Marubeni among others We have been recognized by Forbes two years in a row as one of America s Best Startup Employers We are also proud to be one of the few climate software companies in Time Magazine s America s Top GreenTech Companies 2024 Deloitte Technology Fast 500 TM recently ranked us at No 12 among San Francisco Bay Area companies and No 59 overall in their selection of the top 500 for 2024 Join us in Securing Tomorrow What ll you do 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 db bottlenecks long-running SQL queries indexes and schema design Implement robust Guardrails for observability monitoring query control and DB 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 DB performance with app functionality What re we looking for 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 Positive 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 We are proud to be an equal-opportunity employer We are committed to embracing diversity and inclusion in our hiring practices and we promote a work environment where everyone from any race color religion sex sexual orientation gender identity or national origin can do their best work We are committed to providing an inclusive and accessible interview experience for all candidates Please let us know if you require any accommodation during the interview process and we will make every effort to meet your needs