
Closed
Posted
Paid on delivery
Senior AWS / Aurora PostgreSQL Engineer Required We are looking for an experienced AWS / Database / Cloud Engineer to help with a critical multi-region deployment for a healthcare SaaS application. Project Overview Our healthcare SaaS application currently runs in AWS us-east-1 and needs to expand into us-west-2 to support West Coast customers and improve disaster recovery. The core challenge is migrating the existing database architecture to Amazon Aurora PostgreSQLand making the application work reliably across both AWS regions. During implementation, we discovered that Aurora PostgreSQL cross-region write forwarding is not functionally compatible with the application's current database usage patterns. We therefore need an experienced engineer to evaluate the architecture and implement the most appropriate alternative. Responsibilities Analyze the existing AWS architecture and application/database interaction. Review the current PostgreSQL database and migration approach to Aurora PostgreSQL. Design and implement a reliable multi-region AWS architecture. Deploy the application successfully in us-west-2 Evaluate alternatives to Aurora cross-region write forwarding. Balance: West Coast application performance Database consistency Disaster recovery requirements Application code changes Operational complexity and cost Configure Aurora PostgreSQL replication / cross-region DR as appropriate. Troubleshoot database connectivity, replication, latency, and application compatibility issues. Work with the existing development/consulting team to implement the selected architecture. Document the final architecture, deployment process, and DR/recovery procedure. Required Experience Strong hands-on AWS experience Advanced PostgreSQL knowledge Experience with Amazon Aurora PostgreSQL Multi-region AWS deployments Database replication and disaster recovery AWS networking, IAM, security groups, and infrastructure configuration Experience troubleshooting production database/application compatibility issues Understanding of high availability, RTO/RPO, failover, and data consistency Nice to Have Healthcare SaaS experience AWS ECS/EKS/EC2 experience Terraform or CloudFormation CI/CD experience PostgreSQL performance optimization Experience migrating traditional PostgreSQL workloads to Aurora Experience designing active/passive or active/active architectures Important This is a hands-on engineering role not a consulting-only position. We need someone who can analyze the current architecture, recommend a practical solution, and implement and validate the solution. The project is on a tight timeline so candidates should be available to start quickly and work closely with the existing engineering team. Please include: Relevant AWS/Aurora PostgreSQL experience Examples of multi-region projects you have worked on Your proposed approach to this type of cross-region architecture problem Availability and timezone Hourly/project rate We are open to continuing with the right engineer for additional AWS, database, and infrastructure work after this project.
Project ID: 40643857
57 proposals
Remote project
Active 8 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
57 freelancers are bidding on average $497 USD for this job

To address the cross-region write forwarding compatibility issue, I would first evaluate the existing PostgreSQL database and migration approach to Aurora PostgreSQL. Given the tight timeline, I estimate delivery within 14 days. What is the current RTO/RPO requirement for the healthcare SaaS application?
$675 USD in 14 days
7.7
7.7

With over 14 years of experience in System and IT administration, I believe I possess the necessary skills and expertise to effectively address your multi-region deployment needs. My proficiency in AWS cloud architecture, particularly Aurora PostgreSQL, aligns perfectly with the requirements of your project. Over the years, I have not only deployed numerous applications on multiple AWS regions, but also implemented comprehensive disaster recovery strategies to ensure maximum availability and data consistency in case of any contingency. In regard to your challenges with Aurora PostgreSQL cross-region write forwarding, I completely understand the complexities involved. As a seasoned AWS engineer, I have dealt with similar issues previously and have a solid understanding of alternative solutions that can meet your needs for West Coast application performance, database consistency, disaster recovery, and operational cost. Furthermore, my past experience with Terraform and CloudFormation can be leveraged to optimize your infrastructure along with ensuring secure networking through IAM and security groups. Availability-wise, I will be fully dedicated and ready to work closely with your existing engineering team being conscious of the tight timeline of this project. Overall, I firmly believe that my holistic perspective towards AWS/Aurora PostgreSQL and other domains associated with this project such as Terraform/CouldFormation etc make me an ideal candidate for this job.
$750 USD in 7 days
7.6
7.6

Hello, I have 10 years of experience in AWS database management and cloud solutions, specializing in multi-region deployments and database architecture optimization. I am well-versed in Aurora PostgreSQL and have a robust background in healthcare SaaS deployments. I can analyze your current architecture, devise effective solutions, and ensure a seamless expansion to us-west-2. I am ready to start immediately and work closely with your team to achieve project goals. Regards, VishnuLal NB*
$750 USD in 1 day
6.5
6.5

Hi! This is something we can take on. Before going deeper, one thing that would help me scope this properly: have you already identified which write patterns are breaking with Aurora's cross-region forwarding, or is part of the work figuring that out first? That distinction matters a lot for estimating — diagnosing an unknown issue is a different engagement than implementing a known architectural fix (say, moving to an active/passive model with app-level routing or a global write endpoint via a proxy layer). On approach: we'd start by auditing the current DB interaction patterns and the Aurora migration state, then recommend the lowest-complexity path that meets your RTO/RPO needs without requiring heavy app changes. Could be Aurora Global Database with read routing, could be something simpler. Happy to keep talking through the scope before committing to anything. Gustavo & the DoTheCode team
$590 USD in 7 days
6.0
6.0

As a seasoned AWS-certified professional with a proven track record in successful multi-region deployments, I believe my expertise will be crucial in transforming your healthcare SaaS application into an efficient and highly available solution. My deep understanding of the AWS ecosystem, its networking, IAM configurations, and infrastructure coupled with my advanced knowledge of PostgreSQL and Amazon Aurora PostgreSQL would enable me to comprehensively analyze your current architecture, make necessary recommendations and deploy a practical solution for you. To tackle your challenge, I propose analyzing various alternative approaches to the Aurora cross-region write forwarding issue within a context that balances West Coast application performance, database consistency, disaster recovery requirements, and operational complexity. Drawing on my experience troubleshooting database/application compatibility issues, I can anticipate and preemptively mitigate all connectivity, replication, latency risks across the regions. Considering this project's tight timeline and need for extensive collaboration with existing teams, it's worth noting my proficiency in CI/CD implementation using tools like Jenkins or GitLab CI/CD. My deep understanding of backend development (Node.js/Python/PHP), DevOps engineering (Terraform/Docker), and monitoring tools like Prometheus and Grafana position me uniquely to offer both architectural recommendations as well as robust hands-on implementation.
$750 USD in 7 days
5.5
5.5

Hi, A multi-region healthcare SaaS deployment requires more than simply replicating a database, you need the right balance between West Coast latency, PostgreSQL consistency, failover reliability, RTO/RPO, security, and operational cost. I can help evaluate the current architecture and implement a production-ready solution. I have 16+ years of experience in AWS, PostgreSQL, cloud infrastructure, DevOps, security, and production environments, with hands-on experience across Aurora PostgreSQL, RDS, EC2, ECS, VPC, IAM, Terraform, monitoring, replication, backup, and disaster recovery. I can review your current database workload and Aurora migration, identify why cross-region write forwarding does not fit the application, and evaluate practical alternatives such as Aurora cross-region replication with active/passive architecture, regional failover, read/write routing, or application-level changes. I’ll then implement and validate the selected approach in us-west-2, troubleshoot connectivity and replication issues, and document the complete deployment and DR procedure. I’m available to start quickly and can collaborate directly with your existing engineering team through the Freelancer call option. My hourly rate is USD 15/hour. Best regards, SaD
$700 USD in 7 days
5.3
5.3

With my team, we are extremely skilled and experienced in exactly the areas that your project demands. Firstly, as AWS experts, we have a thorough understanding of the platform's workings with sophistication in both general and specific areas, such as multi-region deployments and utilizing Amazon Aurora PostgreSQL services. We have been successful in creating system architectures that have proven durable, cost-effective with efficient failover capacities. Not only do we bring a great deal of analytical dexterity to your task but also an unparalleled ability in troubleshooting production database issues, be they performance-related or inclined towards application compatibility. We understand the pressing need for precision and flexibility within healthcare sectors and thus aim to deliver nothing but assured, high-quality work. Additionally, I am confident that our knack for ensuring clean code and optimized results aligns greatly with your project vision. More than just ensuring a swiftly completed task, we envision a long-term partnership with you, should you require further assistance. Between our technical proficiency in AWS/Aurora PostgreSQL designs and problem-solving techniques acquired over numerous cross-region architecture projects, I feel our availability will complement tight deadlines seamlessly.
$500 USD in 7 days
4.3
4.3

Hi, I can help analyze and implement your AWS multi-region healthcare SaaS database architecture, focusing on Aurora PostgreSQL, us-east-1 to us-west-2 deployment, DR, replication, failover, latency, and application compatibility. I’m comfortable with AWS, Aurora PostgreSQL, PostgreSQL administration, multi-region deployment, replication, failover planning, database migration, VPC/networking, IAM, security groups, troubleshooting connectivity/latency issues, Terraform/CloudFormation-style infrastructure, CI/CD coordination, and production database validation. Deliverables will include: * Existing architecture review * Aurora PostgreSQL migration assessment * Multi-region architecture recommendation * us-west-2 deployment support * Replication/DR configuration * Connectivity and latency troubleshooting * Failover/RTO/RPO documentation * Security/networking review * Validation and testing support * Final architecture and recovery guide I can start quickly and will focus on a hands-on, practical implementation that works with your current application patterns rather than forcing an incompatible Aurora feature. Best regards Ankit
$250 USD in 4 days
3.8
3.8

Hi, I can help you tackle the challenge of expanding your healthcare SaaS application into us-west-2 using Amazon Aurora PostgreSQL. I've worked on multi-region AWS deployments before and handled similar database architecture migrations. My approach would involve analyzing your current PostgreSQL setup, evaluating alternatives to cross-region write forwarding, and configuring Aurora replication to maintain performance and consistency. I recently led a project that successfully migrated a client’s legacy database to Aurora with a focus on cross-region compatibility and disaster recovery. I’m available to start immediately and can deliver this in 15 days for $[Price]. What specific database interaction challenges have you encountered so far?
$430 USD in 15 days
3.1
3.1

Same project I have done in past and currently it's going on as we moving from self hosted data centre to AWS. This is bit complex task but can be achieved in a week. Let me know if i can help you
$250 USD in 3 days
3.2
3.2

Hi, I’m a DevOps/AWS Engineer with 4+ years of hands-on experience managing AWS infrastructure, PostgreSQL/RDS, Docker, CI/CD, networking, and production environments. I can help evaluate the current Aurora PostgreSQL multi-region architecture, identify the limitations with cross-region write forwarding, and implement a practical solution based on your RTO/RPO, consistency, performance, and cost requirements. I’m comfortable working hands-on with AWS networking, IAM, security groups, replication, DR, and application deployment. I’m available to start quickly and can work closely with your existing engineering team to implement, test, and document the final architecture. Best regards, Abdullah
$500 USD in 7 days
2.9
2.9

I’m a Cloud/DevOps Engineer with strong hands-on experience in AWS, PostgreSQL, cloud networking, IAM, Terraform, Kubernetes, and production infrastructure. I can help analyze your current architecture, evaluate Aurora PostgreSQL cross-region options, and implement a reliable multi-region design balancing performance, consistency, DR, RTO/RPO, complexity, and cost. I would first review the existing application/database interaction and replication requirements, then determine whether an active/passive Aurora architecture, application-level routing, or another approach is the right fit. I can handle the implementation, troubleshooting, validation, and DR documentation alongside your engineering team. I’m based in Noida, while your team is in Bijnor, so occasional in-person collaboration is also feasible if required. I’m available to start quickly and would be happy to discuss the architecture and timeline.
$500 USD in 25 days
3.0
3.0

I understand the need to analyze the existing AWS architecture and evaluate alternatives for Aurora PostgreSQL cross-region write forwarding. My first step will be to assess the current database usage patterns and identify the best migration strategy to ensure reliability across us-east-1 and us-west-2. Based in Toronto, I work efficiently and remain available for any questions or updates throughout the project.
$250 USD in 7 days
2.3
2.3

The key issue here isn’t simply getting Aurora running in us-west-2 — it’s choosing a multi-region write/replication model that fits your application’s existing PostgreSQL behavior without compromising consistency or RTO/RPO. I’d start by tracing the current DB access patterns and validating exactly where Aurora cross-region write forwarding breaks compatibility. My approach would be: Audit the current AWS/ECS/EC2 networking, IAM, security groups, PostgreSQL workload, transactions, connection handling, and deployment flow. Validate the current Aurora PostgreSQL migration and identify the specific write-forwarding incompatibilities. Compare practical alternatives such as Aurora Global Database with controlled primary/secondary failover, application-level regional write routing, or an active/passive model depending on your RTO/RPO. Deploy and validate us-west-2, including connectivity, replication lag, failover behavior, application compatibility, and recovery procedures. Document the final architecture and provide a repeatable DR/failover runbook. I’ll focus on the trade-off between West Coast latency, consistency, recovery objectives, operational complexity, and application changes rather than forcing a particular AWS feature where it doesn’t fit.
$500 USD in 15 days
2.4
2.4

As a seasoned professional with extensive experience in AWS, database management, and cloud infrastructure, I bring a value proposition well-suited to address the challenges posed by your project. My expertise extends beyond just consulting; I'm equipped to analyze your existing architecture, suggest practical solutions, and most importantly, implement them to ensure effective results. My past projects include designing and deploying multi-region infrastructures in AWS while prioritizing factors like performance, consistency, disaster recovery and cost. The successful management of these simultaneous demands has refined my troubleshooting skills and demonstrated my ability to handle issues concerning database connectivity, latency, replication and application compatibility seamlessly. Additionally, my proficiency extends into areas that could provide unexpected yet crucial benefits for your team. My knowledge of CI/CD practices is particularly useful when it comes to agile environments as it helps minimize risks while expediting the progress significantly. At Web Crest we value long-term commitment and I am excited to potentially extend my work with you beyond this project for additional AWS and database support if needed. I can't wait to dig into the complexities your project offers in multi-region deployment that can benefit from my proficiency in conscientiously balancing client priorities and finding optimized solutions.
$300 USD in 3 days
2.3
2.3

As an accomplished product developer and skilled AWS engineer, I possess the expertise required to ensure a seamless deployment of your healthcare SaaS application across multiple AWS regions. With an advanced proficiency in Amazon Aurora PostgreSQL, multi-region AWS deployments, and database replication for effective disaster recovery, I have successfully tackled projects similar to yours. My approach would be rooted in an in-depth analysis of your existing architecture and application/database interaction to identify suitable alternatives to Aurora cross-region write forwarding. Drawing on my extensive experience with AWS networking, IAM, security groups and infrastructure configuration, I'd design and implement a reliable multi-region AWS architecture that optimizes West Coast application performance while maintaining database consistency. My special understanding of high availability, RTO/RPO, failover, and data consistency will play a pivotal role in determining the most viable solution. Furthermore, my proficiency using Terraform alongside relevant knowledge in PostgreSQL would be invaluable throughout the migration process.
$500 USD in 7 days
1.6
1.6

As someone who has a deep understanding of Amazon Web Services (AWS), I believe I am the ideal fit for your AWS Database Expert role. With over three years of experience delivering digital solutions across various industries, my team and I have become adept at transforming ideas into scalable, secure, and high-performing digital products. Our cloud architects and DevOps specialists have successfully implemented multi-region AWS deployments, supported by strong skills in AWS networking, IAM, security groups, and infrastructure configuration to assure database management and disaster recovery.
$250 USD in 3 days
0.7
0.7

Multi-region Aurora for a healthcare SaaS raises one question before any of the technical work, and the answer changes everything: does us-west-2 need to be an active writer, or a read region with failover? Aurora Global Database gives fast cross-region replication and quick promotion, but writes still go to one region. If West Coast customers only need low-latency reads, that is clean and I would recommend it. If they need local writes, you are into write-conflict territory and that is a much bigger design decision — one worth taking deliberately rather than discovering mid-migration. What I would do: - Migrate to Aurora PostgreSQL with the cutover planned around a measured replication lag and a tested rollback, not a hopeful maintenance window. - Global Database with the standby region genuinely exercised — a failover that has never been rehearsed is not a disaster recovery plan. - Application-side connection handling for reader and writer endpoints, since this is where multi-region deployments usually break: an app that keeps writing to a promoted-away endpoint. - Backup, retention and encryption reviewed against your HIPAA obligations, including audit logging. Proof: PostgreSQL is my core database — schema design, tuning, and multi-tenant platforms with database-enforced isolation — plus AWS and production deployments I run daily. Questions: current database engine and size, and is a short write-downtime window acceptable for cutover? Martin
$375 USD in 7 days
0.3
0.3

Hello, my name is Trieu Tuan C. I have strong experience with AWS, PostgreSQL, cloud architecture, database migrations, replication, CI/CD, and production infrastructure. I can analyze your current architecture, identify why Aurora cross-region write forwarding conflicts with the application, and implement a practical multi-region design rather than providing only recommendations. For this project, I would evaluate an active/passive Aurora PostgreSQL architecture using cross-region replication, with careful consideration of RTO/RPO, consistency, latency, failover, networking, IAM, and the application changes required. I can deploy and validate the us-west-2 environment, troubleshoot replication and connectivity issues, and document the final architecture and disaster-recovery procedure. I am comfortable working closely with an existing engineering team, using Terraform where appropriate, and handling hands-on AWS/database implementation. I am available to start quickly and can continue supporting AWS and infrastructure work after the initial deployment. I look forward to your response to discuss the project in more detail.
$300 USD in 4 days
0.0
0.0

From your brief, I understand you need a hands-on engineer to design and implement a multi-region Aurora PostgreSQL setup that works around the write-forwarding limitation. I'll analyze your database patterns and application queries against the alternatives (standby clusters, application-side routing, DMS, or other approaches), evaluating each against your RTO/RPO and consistency requirements. Once we identify the right approach, I'll deploy to us-west-2, troubleshoot integration issues, and document the full architecture and failover procedures. I've handled production database connectivity and API integration issues for multi-service deployments. 5.0 rating on Freelancer, 100% completion. Quick question: is the application code available for review, or should I work from documentation of the current queries and schema? Available this week, US timezone. Jeremy
$450 USD in 3 days
0.0
0.0

Bijnore, India
Payment method verified
Member since Aug 15, 2021
$250-750 USD
₹1500-12500 INR
$250-750 USD
$250-750 USD
$30-250 CAD
₹750-1250 INR / hour
₹12500-37500 INR
₹12500-37500 INR
₹750-1250 INR / hour
$250-750 USD
₹750-1250 INR / hour
₹12500-37500 INR
₹75000-150000 INR
$250-750 AUD
₹37500-75000 INR
₹400-750 INR / hour
£18-36 GBP / hour
$10-30 USD
₹12500-37500 INR
$110-150 USD
$250-750 USD