
Closed
Posted
Paid on delivery
Job Title: AWS Aurora RDS Database Optimization Freelancer (PostgreSQL, Prisma ORM Expertise Required) Project Description: We are Entugo, a growing startup building an all-in-one customer loyalty and digital marketing platform for food and beverage businesses (restaurants, cafes, bars, etc.) in markets like the UK, Germany, and India. Our platform helps convert first-time visitors into loyal customers through QR-based engagement, automated discounts, loyalty coins, CRM tools, and analytics. We're currently in post-beta launch and scaling our operations. We're seeking an experienced Database Freelancer to optimize our AWS Aurora RDS setup (PostgreSQL-compatible). Our current database is incurring high costs due to poor optimization and suboptimal instance selection. We need someone to audit, refactor, and implement cost-saving improvements while ensuring performance and scalability for our growing user base. Key challenges we're facing: High AWS costs from inefficient queries, indexing, and resource allocation. Need for better instance sizing and configuration to handle increasing traffic without overprovisioning. Integration with our stack, including Prisma as our ORM for TypeScript/Node.js. What we need you to do: Conduct a thorough audit of our existing Aurora RDS database schema, queries, and performance metrics. Optimize queries, indexes, and data structures to reduce latency and costs. Recommend and implement the right AWS instance types, scaling strategies (e.g., read replicas, auto-scaling), and cost-management features like reserved instances or savings plans. Ensure seamless compatibility with Prisma ORM – refactor schemas or migrations if needed. Provide documentation and best practices for ongoing maintenance to prevent future issues. Optionally, advise on monitoring tools (e.g., CloudWatch, Performance Insights) for proactive optimization. This is a short-term project (estimated 10-20 hours initially, with potential for ongoing support). We can provide access to our AWS environment and codebase for review. Skills Required: Expert in AWS Aurora RDS (PostgreSQL engine) – proven experience with optimization, cost reduction, and scaling. Strong knowledge of PostgreSQL (queries, indexing, partitioning, vacuuming, etc.). Hands-on experience with Prisma ORM (schema design, migrations, query optimization). Familiarity with AWS services like EC2, CloudWatch, and cost management tools. Bonus: Experience with Node.js/TypeScript stacks, database performance tuning for SaaS platforms, or similar loyalty/CRM systems. Excellent problem-solving skills and ability to work independently with clear communication. Please include in your proposal: Your relevant experience with Aurora RDS and Prisma (include examples or case studies). A high-level plan for how you'd approach this optimization. Your availability and estimated timeline. Hourly rate or fixed price quote. We're looking for someone who can start ASAP. If you're a database wizard who can help us cut costs and boost efficiency, apply now! Project Type: One-time project with potential for long-term collaboration.
Project ID: 39727487
11 proposals
Remote project
Active 8 mos ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
11 freelancers are bidding on average ₹7,936 INR for this job

As an AWS Aurora and PostgreSQL expert with Prisma ORM proficiency, I can leverage my deep understanding of these technologies to optimize your database while minimizing costs. I have hands-on experience auditing database schemas, improving query efficiency, and implementing cost-saving strategies such as identifying better instance types and scaling mechanisms. This expertise will prove invaluable in reducing high AWS expenses incurred due to inefficient queries and resource allocation. My familiarity with complementary tools like CloudWatch and EC2 will allow me to provide a comprehensive optimization plan that ensures long-term performance, scalability, and compatibility with your TypeScript/Node.js stack. One of your main concerns is seamless compatibility with Prisma ORM which I am experienced with from other projects. My knowledge extends not just to schema design and migrations but also query optimization making me suitable to help refactor schemas or migrations if necessary. Additionally, as a professional who values clear communication, I'll provide you with thorough documentation of the process and best practices for ongoing maintenance to prevent future issues. Proactivity, in my approach is also guaranteed, I'll gladly advise on relevant monitoring tools like CloudWatch, Performance Insights for proactive alerts that would preemptively prevent optimization hurdles.
₹7,000 INR in 7 days
2.3
2.3

Hello, I am a AWS Cloud developer with 10 years of experience, specializing in building robust, scalable, and high-performance applications. I deliver clean, readable code optimized for speed and follow a structured approach to development. I am confident I can provide high-quality results for your project and look forward to contributing to your team. Best regards,
₹7,000 INR in 2 days
2.5
2.5

Hi, I can easily DO your work IN 24 HOURS, DM me now to get started, PRICE NEGOTIABLE 100% Work satisfaction is provided!
₹11,000 INR in 1 day
2.4
2.4

Dear Arunk, I am a perfect fit for your project. With extensive experience in end-to-end software development and meticulous quality assurance, I can deliver the high-quality solution you seek. I have successfully optimized AWS Aurora RDS setups, particularly PostgreSQL databases, reducing costs and enhancing performance. My expertise with Prisma ORM and AWS services align perfectly with your requirements. I am dedicated to providing scalable and efficient solutions for your growing platform. Let's discuss how I can help optimize your database and achieve your goals effectively. Looking forward to working with you, Graham Valentyn
₹6,250 INR in 14 days
1.7
1.7

Hello, I have solid experience with AWS (Aurora RDS, EC2, CloudWatch) and PostgreSQL optimization, and I can help you cut costs and improve performance for your Aurora RDS setup while keeping Prisma ORM fully compatible. My plan: Audit: review schema, queries, indexes, and current instance sizing. Optimization: refactor queries, tune indexes/configuration, and apply cost-saving scaling strategies. Validation: confirm reduced costs, improved performance, and seamless Prisma integration, with clear documentation. Budget: ₹10,000 INR Timeline: 5 days (audit, optimization, validation) Start: Immediately Let’s optimize your Aurora RDS and scale efficiently . Best regards, Jose M.
₹10,000 INR in 5 days
1.9
1.9

"I am a perfect fit for your project, specializing in AWS Aurora RDS optimization. I understand your need to reduce costs and improve database efficiency with Prisma ORM integration. While I am new to freelancer, I have tons of experience and have done other projects off site. I have expertise in AWS Aurora RDS, PostgreSQL optimization, and Prisma ORM. I have successfully audited and optimized databases for cost reduction and performance improvement. I would love to chat more about your project! Regards, Tiffany Pienaar"
₹6,250 INR in 14 days
0.0
0.0

I am a seasoned software developer with 13 years of experience in delivering successful projects aligned with your requirements. My expertise in requied skills, and I have worked extensively on similar solutions. With a strong academic background from IIT Delhi, I bring both technical depth and practical implementation skills. I am confident that my experience and proven track record will add great value to your project. Looking forward to discussing how I can contribute effectively.
₹7,000 INR in 7 days
0.0
0.0

Hi, I’ve worked extensively with AWS Aurora RDS (PostgreSQL engine) and can help optimize your setup for both cost savings and performance while keeping Prisma ORM compatibility intact. Relevant experience: Optimized Aurora RDS for SaaS platforms handling 50k+ daily users, reducing costs by 30–40% via query tuning, proper indexing, and right-sizing instances. Refactored Prisma schemas/migrations to improve query performance and reduce over-fetching. Implemented read replicas, auto-scaling policies, and CloudWatch monitoring for high-traffic workloads. Familiar with PostgreSQL best practices (VACUUM, partitioning, connection pooling, caching strategies). High-level approach: Audit your current RDS usage (queries, schema, indexes, instance config). Identify inefficient queries and optimize them (with Prisma-aware changes if needed). Recommend and implement cost-saving measures: better instance sizing, reserved instances/savings plans, read replicas, and auto-scaling. Provide best practices + documentation for ongoing database health and monitoring. Timeline: 10–20 hours (1–2 weeks depending on scope). Rate: Flexible – can work hourly or fixed price. Available to start immediately. Let’s connect and discuss access/setup.
₹7,000 INR in 7 days
0.0
0.0

Hi, I am a Full Stack Developer with 4+ years of experience in building scalable SaaS platforms, POS integrations, and loyalty systems. Relevant experience with Aurora RDS and Prisma -> 4+ years of experience with Aurora RDS and relational databases (MySQL, PostgreSQL) along with ORMs like Sequelize and Prisma. -> Managed large-scale databases with tables containing 800M+ entries. -> Designed and developed analytics for a SaaS company generating $10M+ annual revenue. Action plan and approach -> Review current RDS instance size and configuration vs. operational scale. -> Upgrade instance only if required (smaller RDS machines often handle millions of rows). -> Identify slow queries using CloudWatch and manual review. -> Optimize queries for improved performance. Availability -> 4–6 hrs/day with flexible timings. Timeline -> Exact timeline after codebase review, but approx. 2 weeks. Hourly rate or fixed price quote -> To be finalised after assessing scope in detail. PS: I also submitted a proposal for your POS–Loyalty integration project. With expertise in both SaaS development and database optimisation, I can act as a one-stop solution, ensuring smooth delivery of your requirements under a single roof. Thanks & Regards, Akash Pandey
₹7,000 INR in 7 days
0.0
0.0

Chennai, India
Member since May 21, 2025
₹1500-12500 INR
₹4000-10000 INR
£1500-3000 GBP
$10-30 USD
₹150000-250000 INR
₹12500-37500 INR
$30-250 USD
₹12500-37500 INR
£10-15 GBP / hour
$1500-3000 USD
$30-250 USD
min €36 EUR / hour
$250-750 NZD
₹600-1500 INR
₹37500-75000 INR
$1500-3000 USD
₹750-1250 INR / hour
$750-1500 USD
₹1500-12500 INR
min ₹2500 INR / hour
$10-30 USD
$8-15 USD / hour