Contract: Senior Database Automation Engineer (LATAM)

<p>Upwork ($UPWK) is the world’s work marketplace. We serve everyone from one-person startups to large, Fortune 100 enterprises with a powerful, trust-driven platform that enables companies and talent to work together in new ways that unlock their potential.</p> <p>Last year, more than $3.8 billion of work was done through Upwork by skilled professionals who are gaining more control by finding work they are passionate about and innovating their careers.</p> <p>This is an engagement through Upwork’s Hybrid Workforce Solutions (HWS) Team. Our Hybrid Workforce Solutions Team is a global group of professionals that support Upwork’s business. Our HWS team members are located all over the world.</p> <hr> <p>Join Upwork's Data Infrastructure team within the Data Platform Services (DPS) organization, responsible for designing, operating, and automating all database systems (Postgres, MySQL, DynamoDB, MongoDB) across Upwork’s global infrastructure. This role combines database engineering expertise with software development rigor to build mission-critical automations for Upwork’s core data assets.<br><br>You’ll orchestrate complex systems spanning Terraform, RDS, Presto, and Rancher to solve challenges like:</p> <ul> <li>Zero-downtime migrations and cross-region replication</li> <li>End-to-end database provisioning (infrastructure deployment, user/access configuration, service integration)</li> <li>Vulnerability management and security hardening at scale</li> <li>Incident response for high-severity database alerts (24/7 on-call rotation) </li> </ul> <h4>Key Responsibilities:</h4> <ul> <li>Design and implement Python-based automation frameworks (not scripts) for database lifecycle management </li> <li>Collaborate with infrastructure teams to integrate systems via APIs (AWS, Kubernetes, HashiCorp) </li> <li>Optimize Postgres performance, replication, and backup strategies (99% of relational DB use cases) </li> <li>Participate in LATAM Time-friendly on-call shifts with weekend coverage </li> </ul> <h4>Must-haves (required skills):</h4> <ul> <li><strong>Hybrid expertise:</strong> Deep experience in both database engineering/administration and software development. Candidates who have transitioned from database engineering to software development (or vice versa) are especially encouraged.</li> <li><strong>Programming skills:</strong> Strong background in Python (required); ability to develop robust automation beyond basic scripting. Experience with Ruby or Perl is acceptable if you can quickly adapt to Python.</li> <li><strong>Database expertise: </strong>7+ years of professional experience with relational databases, with a strong preference for Postgres. Experience with MySQL or Oracle is also valued. NoSQL experience (e.g., DynamoDB) is a plus but not required.</li> <li><strong>SQL proficiency: </strong>Solid understanding of SQL; experience with procedural languages (PL/pgSQL for Postgres or PL/SQL for Oracle) is beneficial but not essential, as most automation is done in Python.</li> <li><strong>Cloud & DevOps familiarity:</strong> Experience with Terraform and related infrastructure-as-code tools is a plus, but not a core requirement. Familiarity with cloud environments (AWS, GCP, Azure) is helpful.</li> <li><strong>Automation mindset:</strong> Passion for automating repetitive tasks and improving operational efficiency.</li> <li><strong>Ownership & accountability:</strong> Proactive, resourceful, and able to take full responsibility for solving problems and delivering outcomes.</li> <li>&l ... (truncated, view full listing at source)