XTN-C07E553 | DATABASE SCRIPT ENGINEER

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
• Experience with scripting and automation (e.g., Bash, Python)
• Building internal admin tools or dashboards for non-engineering stakeholders
• Familiarity with AWS CLI or SDKs for managing RDS backups, parameters, and logs