Database Architect

Job Description

Mô tả công việc
1. KEY DELIVERABLES AND RESPONSIBILITIES

Participate actively in architecture design sessions alongside Solution Architects and Engineering Leads; review application-level designs to identify upstream data risks early
Propose and evaluate database architecture patterns (e.g., CQRS, event sourcing, data mesh) and assess trade-offs between RDBMS, NoSQL, NewSQL, and time-series solutions
Design, implement, and optimize database schemas, stored procedures, indexing strategies, and access patterns; manage full database lifecycle (provisioning, patching, migration, decommissioning)
Analyze how application code interacts with the database layer; identify N+1 queries, ORM anti-patterns, and connection pool misconfigurations in collaboration with backend engineers
Design and maintain HA/DR strategies including replication topologies, failover automation, and RTO/RPO planning; lead incident response and root cause analysis for database-related issues
Implement and audit RBAC, data masking, encryption at rest and in transit; ensure compliance with relevant standards (GDPR, ISO 27001, PCI-DSS)
Serve as a technical reference for developers and junior DBAs; produce Architecture Decision Records (ADRs), data modeling standards, and internal knowledge-sharing sessions
Collaborate with DevOps/SRE teams to ensure database infrastructure is cloud-ready, observable, and integrated into CI/CD pipelines with proper migration tooling (Flyway, Liquibase, or equivalent)
Other tasks assigned by supervisor.

Yêu cầu ứng viên
2. REQUIREMENTS

Bachelor’s degree in Computer Science, Information Technology, or related field
7+ years of hands-on database architecture experience across production environments, with demonstrated experience engaging at solution / system design level
Strong proficiency in at least one RDBMS (PostgreSQL, MySQL, Oracle, SQL Server) and familiarity with NoSQL solutions (MongoDB, Cassandra, DynamoDB, or equivalent)
Solid understanding of application architecture: how services communicate, how ORMs generate queries, how microservices interact with shared databases
Experience in cloud-native database management (AWS RDS/Aurora, or equivalent) and performance diagnostics (execution plans, query profiling, index tuning)
Experience with CI/CD pipelines and database migration tooling (Flyway, Liquibase, or similar); ability to read and review application code (Python, Java, Node.js, or equivalent) to identify database anti-patterns
Professional working proficiency in English (both written and spoken)
Preferred Qualifications

Prior experience in a Solution Architect, Senior/Principal database admin, or Data Platform Lead role
Background in distributed systems; familiarity with data streaming and event-driven architectures (Kafka, Debezium, CDC pipelines)
Hands-on experience with Infrastructure as Code (Terraform, Ansible) and observability tools (Datadog, Prometheus/Grafana, or equivalent)
Relevant certifications: AWS Database Specialty, Oracle Certified, Microsoft Certified: Azure Database Administrator, or similar cloud/database certification

Quyền lợi được hưởng
3. BENEFITS

At SmartOSC, we offer the best to your values

Attractive salary package upto 3500 USD/ month
Salary review twice a year
Flexible working hour
Premium health care
Working in One of the largest digital transformation agencies – A professional English environment
Firm’s Certified Qualifications Sponsorship for career development
Annual company trip inside or outside Vietnam
Other fun activities: happy hour, quarterly team building, football club, yoga club, swimming club, charity activities, etc.
Free entertainment parties: Birthday party, Anniversary party, Sum-up Party, Year-End Party, etc.