Densify

Database Architect & Administrator

Canada

30 days ago
Save Job

Summary

Overview

Densify is seeking a skilled and forward-thinking Database Architect with deep Database Administration (DBA) capabilities and Data Modeling expertise to join our growing engineering team. This role will be integral to shaping and supporting the data infrastructure that powers our intelligent resource optimization solutions. The ideal candidate will blend traditional relational database skills with modern, AI-assisted tooling and next-gen architecture awareness, helping us remain ahead of the curve.


Key Responsibilities

  • Architect scalable, performant, and reliable data systems to support enterprise-scale applications and analytical workloads.
  • Develop conceptual, logical, and physical data models for both transactional and analytical systems. Promote data consistency, integrity, and accessibility across all platforms.
  • Participate in code reviews to ensure design, performance and standards are adhered to
  • Oversee database operations, health, backup/recovery strategies, and performance optimization for production and development environments.
  • Apply in-depth knowledge of PostgreSQL and TimescaleDB to manage time-series data with high performance and scalability.
  • Stay abreast of evolving database trends including NoSQL, distributed databases, cloud-native solutions, and AI-driven data tooling.
  • Integrate and leverage AI-powered or modern DevOps-friendly database tools to enhance schema management, query optimization, data migrations, and monitoring.
  • Work closely with application architects, engineers, DevOps, and data stakeholders to establish database best practices, enforce standards, and drive data initiatives.


Minimum Requirements

  • 8+ years in database architecture and administration, with a focus on PostgreSQL
  • Hands-on experience with TimescaleDB and managing time-series data
  • Experienced with Liquibase DB version control for schema management
  • Proficiency in data modeling techniques (ERDs, normalization/denormalization, star/snowflake schema)
  • Solid grasp of database performance tuning, indexing strategies, and query optimization
  • Familiarity with NoSQL technologies (e.g., MongoDB, Cassandra, Redis)
  • Exposure to modern data platforms (e.g., AWS RDS/Aurora, Google Cloud Spanner, Snowflake)
  • Experience with AI-enabled tools or automation frameworks related to database operations
  • Strong scripting skills (e.g., Python, Bash) for automation and tooling integration
  • Understanding of data security, privacy, and compliance (e.g., GDPR, SOC2)


Nice to Have

  • Experience with data warehousing, OLAP systems, or real-time analytics
  • Kubernetes ecosystem awareness (especially for DB deployments)
  • Knowledge of DevOps and CI/CD practices in a data context
  • Contributions to open-source database projects or tooling
  • Cloud certification (AWS, GCP, Azure)


Personal Attributes

  • Strong problem-solving and analytical skills
  • Self-starter, independent thinker, and collaborator
  • Comfortable working in a fast-paced and evolving technical environment
  • Curious and open to experimenting with emerging tools and methodologies
  • Clear and effective communicator—both written and verbal


Our Technologies & Tools

PostgreSQL, TimescaleDB, AWS, Google Cloud, Terraform, Docker, Kubernetes, Python, Bash, Kafka, RabbitMQ, Grafana, Prometheus, Git, Bitbucket, Agile, and more.

How strong is your resume?

Upload your resume and get feedback from our expert to help land this job