Database Architect

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.