Postgres RLS + Aurora v2 expert for HIPAA/SOC2 DynamoDB-to-Aurora migration (part time, ~16 weeks)

Posted 4 weeks ago

Worldwide

Summary

We're migrating a HIPAA and SOC 2 compliant platform from DynamoDB to Aurora Serverless v2 (PostgreSQL). Real PHI, BAA in place. The stack is TypeScript: AWS Amplify Gen 2, AppSync GraphQL, ~74 Lambdas, and Cognito. This is a part-time advisory and supervision role, roughly 10 to 12 hours a week for about 16 weeks. Two main areas: Co-design and cutover supervision. Designing DB-enforced Row-Level Security for multi-tenancy, a per-request RLS dispatcher Lambda, VPC/RDS Proxy networking, and a rehearsed production cutover and rollback plan. You'd be live with us during the overnight cutover window. Code reviews. Light, ongoing TypeScript reviews to keep the wider codebase healthy. What I'm looking for: hands-on production experience with Postgres RLS, Aurora Serverless, NoSQL-to-relational migrations, and compliant cutovers under HIPAA or SOC 2. This is design and review work, not heads-down implementation, so I care more about judgment and scar tissue than raw output. To apply, send me a couple of quick examples of how you handled tenancy and cutovers on past projects, plus your current availability.

  • More than 30 hrs/week
    Hourly
  • 3-6 months
    Duration
  • Expert
    Experience Level
  • $30.00

    -

    $50.00

    Hourly
  • Remote Job
  • Ongoing project
    Project Type
Skills and Expertise
Mandatory skills
PostgreSQL
TypeScript
AWS Amplify
Activity on this job
  • Proposals:10 to 15
  • Last viewed by client:4 weeks ago
  • Interviewing:
    5
  • Invites sent:
    5
  • Unanswered invites:
    1
About the client
Member since Apr 20, 2016
  • United States
    Cincinnati1:55 AM
  • $118K total spent
    19 hires, 1 active
  • 5,587 hours

Explore similar jobs on Upwork

Set up sellers.json fileFixed-price‐ Posted 3 weeks ago
JSON
JavaScript
Advertising Networks
Application InstallationFixed-price‐ Posted 2 weeks ago
Android
Smartphone
Tablet
iPhone

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo