Database Designer

HRTX; Philippines; On-site; PHP 800,000 - 1,200,000; Full time

Job summary

HRTX is seeking a Database Designer to architect scalable, maintainable data models for our SaaS platforms. You will design sound schemas, refactor fragmented databases, and guide developers to adopt data modeling best practices.

Requirements include 5+ years in database design, strong SQL Server experience, familiarity with ER/Studio or ERwin, and the ability to translate business requirements into efficient data structures. Occasional DBA coverage for operational continuity is expected.

Qualifications

• 5+ years of experience in database design, data modeling, or equivalent role.
• Proven experience normalizing databases and consolidating schemas in production environments.
• Familiarity with data modeling tools (ER/Studio, ERwin, SQL Server Data Tools, etc.).
• Strong understanding of relational database theory and best practices for OLTP environments.
• Ability to collaborate with developers to translate business requirements into efficient data structures.

Responsibilities

• Create and implement sound database schema and data models for scalable, performant SaaS platforms.
• Refactor fragmented, non-normalized databases into cohesive, well-structured models.
• Guide developers to adopt data modeling best practices.
• Provide occasional DBA coverage to ensure operational continuity during absences.

Skills

Database design

Data modeling

SQL Server

OLTP concepts

Team collaboration

Tools

ER/Studio

ERwin

SQL Server Data Tools

Job description

The Database Designer will be responsible for creating and implementing sound database schema and data models that support our SaaS platforms scalability, performance, and maintainability. This role will refactor our existing fragmented and non-normalized databases into a cohesive, well-structured model, while guiding developers to adopt best practices moving forward.

While the primary focus will be schema and data model design in SQL Server, experience with ETL, reporting, and data warehouse design is a plus. The ideal candidate can also provide occasional DBA coverage during absences, ensuring operational continuity.

Required Qualifications

• 5+ years of experience in database design, data modeling, or equivalent role.
• Proven experience normalizing databases and consolidating schemas in production environments.
• Familiarity with data modeling tools (ER/Studio, ERwin, SQL Server Data Tools, etc.).
• Strong understanding of relational database theory and best practices for OLTP environments.
• Ability to collaborate with developers to translate business requirements into efficient data structures.

Preferred Qualifications

• Experience with ETL tools, reporting platforms (e.g., SSRS, Power BI), or data warehouse design.
• Understanding of database performance tuning and query optimization.
• Familiarity with SaaS environments and multi-tenant database design considerations.
• Experience with SQL Server administration tasks (backup/restore, indexing, performance monitoring).

Soft Skills

• Strong communication skills able to explain database concepts to both technical and non-technical stakeholders.
• Detail-oriented with a commitment to quality and accuracy.
• Comfortable challenging existing designs and advocating for best practices.
• Self-motivated and able to work independently while collaborating in a team environment.