Database Architect

DATABASE ARCHITECT

SHIFT: NIGHT / GRAVEYARD PHT

TYPE: FULL TIME; INDEPENDENT CONTRACTOR

We are seeking a Database Architect to design, manage, and optimize both our application data architecture and data warehousing environment. This role will define database schemas, ensure data consistency, and maintain performance across transactional and analytical systems.

In our organization, this role plays a key part in ensuring our data layer supports scalable application development and reliable reporting. The Database Architect works closely with Engineering, Product, and leadership to align data design with business workflows, analytics, and system performance.

This role requires strong technical expertise across relational databases and modern data platforms such as Snowflake.

Key Responsibilities

Data Architecture & Schema Design

Design and maintain database schemas aligned to business workflows and product requirements

Define standards for data modeling, naming conventions, and structure across systems

Ensure consistency between transactional systems and analytics platforms

Review and approve schema changes to maintain integrity and scalability

Data Warehousing & Analytics Architecture

Design and manage data models within Snowflake or similar platforms

Define data pipelines and structures to support reporting and analytics

Ensure data is structured for efficient querying and business intelligence use

Partner with stakeholders to support reporting, dashboards, and data access needs

Database Performance & Optimization

Monitor and optimize performance across both application databases and data warehouse environments

Improve query performance, indexing strategies, and data access patterns

Identify and resolve bottlenecks across transactional and analytical workloads

Ensure systems operate efficiently under expected load and growth

Data Integrity & Governance

Ensure accuracy, consistency, and reliability of data across systems

Define rules for data validation, relationships, and constraints

Implement governance practices for data quality, lineage, and usage

Establish standards for managing schema changes and data access

Scalability & Reliability

Design systems to support growth in data volume and system usage

Define strategies for partitioning, replication, and scaling

Ensure high availability and disaster recovery planning

Support backup, restore, and failover processes

Cross-Functional Collaboration

Partner with Engineering to align database design with application architecture

Work with Product and Business Analysts to translate workflows into data models

Support analytics and reporting teams with well-structured data models

Provide guidance on data-related decisions across teams

Standards & Best Practices

Define and enforce database and data platform standards across the organization

Guide teams on proper data access, modeling, and performance practices

Review implementations to ensure alignment with architecture standards

Continuously improve how data is structured and used across systems

Documentation & Visibility

Maintain clear documentation of schemas, data models, and data flows

Ensure data structures are understandable and accessible across teams

Track changes to database and warehouse structures over time

Provide visibility into data health, performance, and risks

Qualifications

Required

510 years of experience in database architecture, data engineering, or related roles

Strong experience with relational databases (SQL Server, PostgreSQL, or similar)

Experience designing and working with Snowflake or similar data warehouse platforms

Deep understanding of data modeling for both transactional and analytical systems

Experience optimizing database and warehouse performance

Strong problem-solving skills and attention to detail

Preferred

Experience with data pipelines and ETL/ELT processes

Experience with cloud platforms such as AWS

Familiarity with data governance, lineage, and auditing practices

Experience in compliance-driven or regulated environments

Tools & Platforms (Preferred Experience)

SQL Server, PostgreSQL, or similar relational databases

Snowflake or similar data warehouse platforms (Redshift, BigQuery)

AWS RDS, Aurora, or equivalent cloud database services

Data pipeline or orchestration tools

Database monitoring and performance tools

Jira

Confluence

Power BI or other BI/reporting platforms

Collaboration tools such as Zoom and chat platforms

Familiarity with EOS / Ninety or similar operating frameworks is helpful but not required

Home Office Requirements:

• Internet Connection : Must be 50 mbps at the least, preferably wired connection with PLDT, Cable connection is fine if it's more than 5mbps. We DO NOT accept plug-in, wi-fi or wimax.
• Computer/Laptop: The contractor must have a good working computer.
• Headsets : The Contractor must have noise cancelling headsets preferably Plantronics Blackwire C320M headsets. Assessment will be done during test calls.
• Dedicated Home Office - Contractors are required to have a dedicated home office free from noise and distractions.
• Web Cam - for meeting purposes
• Must be comfortable in working with Time Doctor/Screenshot Monitor