DATABASE SCRIPT ENGINEER

XTN-C07E553

City
N/A, N/A
Schedule
SITE
KMC site or other business locations as may be instructed by KMC Solutions from time to time

Make your next big career move by applying as KMC Solutions’ next 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.

On top of your salary, here are the exciting benefits you can look forward to:

  • 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

The main responsibilities of a DATABASE SCRIPT ENGINEER include:

  • 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

To apply, you must be an expert on the following requirements:

  • 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

It will also be favorable if you are knowledgeable in:

  • 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

The successful candidate must submit the following pre-employment requirements

  • Scanned copy of valid NBI Clearance
  • Accomplished Medical or PEME Slip (covered by KMC)
  • 2x2 & Half body picture with white background
  • Proof of government numbers (TIN, SSS, Pag-ibig, & Philhealth)
  • Photocopy of 2 valid IDs – front & back (government-issued)
  • Clear copy of your Birth Certificate (PSA or NSO)
  • Accomplished HR Forms & Promissory Note (will be provided by KMC’s Onboarding Team

Click here to view the complete list of KMC’s pre-employment requirements.

KMC Careers

If you're a rockstar at what you do and looking to be a part of our amazing story, we want to hear from you!

We offer attractive salaries and benefits plus you get to work in some of the Philippines' best flexible workspaces. Our employees also get to enjoy exclusive discounts, rewards and freebies, and invites to our monthly events. We are always recruiting for roles in IT & Development, Marketing, Business Administration, HR & Recruitment and Legal & Finance Roles.

KMC provides quality employment opportunities for job-seekers looking for a career that is both challenging and fulfilling. We are also committed to providing equal opportunities at every selection stage. We do not discriminate due to age, gender, sexual orientation, ethnicity, nationality, and religion.

Work with Us. Grow with Us.

KMC Solutions offers a variety of career opportunities in Metro Manila, Cebu and Clark & Iloilo. We are always looking for talented and enthusiastic individuals who are ready to make their next big career move.

Our Culture

At KMC, we foster an inclusive and positive workplace for all. We push our members to succeed in everything they do through our collaborative work environment. We encourage our community to work hard and reach their full potential while delivering results that matter for our members and you as professionals.

We host amazing and quality events and implement people-centric policies to work flexibly. We ensure that everyone in our expansive network is engaged, from our internal employees and those who work on behalf our offshore partners.

Life within KMC: Work Hard Party Harder

At KMC, we work hard and we are committed to putting our best foot forward in everything we do. Everyone is encouraged to be an individual while also working for the collective good of the KMC Community. We believe mistakes are opportunities and that you should not present a solution without a problem.

We also know when hard work deserves to be recognized so we reward our employees with monthly parties, free trips and much much more!

No account yet

Sign up to view exciting career opportunities!

RECRUITMENT PROCESS

Apply

Self-recorded Interview

Critical Thinking

Recruiter Interview

Hiring Manager Interview