Job Description
- 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.
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, [protected info], 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
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.
Note: By submitting your resume for this position, you acknowledge and consent that the Company may collect, use, store, disclose (where necessary), and otherwise process your personal data for recruitment-related purposes, including evaluating your application, communicating with you, and making hiring decisions. Your personal data may be shared with relevant third parties involved in the recruitment process on a need-to-know basis. You acknowledge and consent that the Company shall retain your personal data for as long as necessary to fulfil the above purposes or to comply with applicable legal obligations. Where permitted by applicable law, you may submit a written request for the deletion of your personal data.