Offer summary

Qualifications:

At least 3 years of hands-on experience with PostgreSQL and MariaDB in AWS RDS environments., Proficiency in writing complex SQL queries and analyzing database performance., Experience supporting multi-tenant database environments, preferably using schema-per-customer models., Strong analytical, communication skills, and familiarity with scripting and automation tools like Bash or Python..

Key responsibilities:

Develop and optimize SQL scripts for AWS RDS PostgreSQL and MariaDB environments.

Support customer data requests and ad hoc reporting with speed and accuracy.

Build internal tooling to enable faster and more precise product development.

Assist in migrating legacy databases to AWS Aurora and collaborate with cross-functional teams.

Job description

Job Title: Database Script Engineer
Location: Remote (North America ET hours preferred)
Type: Full-Time

About Property Vista

Property Vista is a fast-growing SaaS company transforming property management through intelligent, connected software. Our platform empowers multifamily operators to manage operations, leasing, communications, and data through automation and AI. If you’re excited by impact, speed, and solving real business problems — you’ll feel right at home here.

About the Role

We’re seeking a Database Script Engineer who thrives on digging into complex schemas, solving customer-specific data needs, and building internal tooling to power a modern SaaS platform. This role supports both AWS RDS PostgreSQL (ORM-managed) and MariaDB (script-driven) environments and will play a key role in supporting one-off requests, writing scalable scripts, and contributing to the modernization of our database infrastructure via AWS Aurora.

Work at a high-impact, fast-paced SaaS company with a modern AWS-native stack
Build internal tooling that helps product teams deliver faster and more accurately
Grow your technical expertise across cloud databases, schema design, and Aurora optimization
Be part of a global team solving real operational challenges for multifamily housing

Write, maintain, and optimize SQL scripts across AWS RDS-hosted PostgreSQL and MariaDB environments
Support one-off customer data requests and ad hoc reporting needs with speed and precision
Navigate complex multi-tenant PostgreSQL schemas (Java ORM-managed) to extract, transform, and deliver data
Build reusable internal tools or scripting utilities to enable self-service by product and support teams
Assist in modernizing legacy database flows by planning and supporting migrations to AWS Aurora
Collaborate with product managers, developers, and stakeholders to scope and fulfill data-related needs
Participate in production troubleshooting and scheduled after-hours support rotations when needed

3+ years of hands-on experience with PostgreSQL and MariaDB, in AWS RDS environments
Expertise in writing complex SQL queries and analyzing performance
Familiarity with Java-based ORMs (for PostgreSQL) and their impact on schema design
Experience supporting multi-tenant environments, ideally using schema-per-customer models
Strong analytical and communication skills to bridge technical and non-technical teams
Demonstrated ability to design and support AWS Aurora (PostgreSQL or MySQL-compatible) migrations
A self-driven, detail-oriented mindset with a passion for scalable data solutions