Senior Database Administrator

Job Description

Role Overview

We are looking for a Senior Database Administrator to own the reliability, performance and ongoing improvement of our client’s newly built point-of-sale (POS) database, including its product and customer master data. The role will help turn a clean, well-structured database into a trusted foundation for business analytics, AI, generative AI and data science. Alongside day-to-day database administration, you will establish the controls, ownership and workflows needed to keep data accurate, consistent, secure and usable as volumes and use cases grow, working closely with data engineers, analysts and data scientists to make the POS database dependable for both operational needs and advanced analytical applications.

Key Deliverables & Responsibilities

1. Database Administration & Reliability:

– Manage and optimize a large-scale database. Own database health, availability, capacity planning, indexing, query performance and workload management. Diagnose bottlenecks and support growing data volumes and increasingly complex analytical workloads.

– Protect reliability and recoverability. Establish monitoring, alerting, backup and recovery procedures, tested disaster recovery plans and clear incident response processes.

– Protect operational performance as usage expands. Design suitable workload isolation, replication or analytical access arrangements so reporting, experimentation and AI-driven queries do not compromise core database services.

2. Master Data & Data Quality:

– Maintain trusted POS and master data. Strengthen the structure and integrity of POS transactions, product master data and customer master data. Manage keys, relationships, duplicates, missing values, inconsistent classifications and changes to master records over time.

– Build lasting data-quality controls. Implement automated validation, reconciliation, quality monitoring and exception handling. Detect issues at ingestion and throughout the data lifecycle, with clear escalation and remediation workflows.

– Establish ownership and controlled workflows. Partner with business owners to define who can create, change, approve and correct data. Put in place documented processes for master data updates, schema changes, access requests and issue resolution.

3. Analytics, Data Science & AI Enablement:

– Make data ready for analytics and data science. Work with data engineers and analysts to provide documented schemas, reusable views, reliable historical data and efficient access patterns for reporting, customer and product analysis, forecasting and other analytical use cases.

– Enable safe AI and generative AI access. Collaborate with AI teams to provide governed datasets and controlled query access. Support approved use cases with appropriate permissions, sensitive-data protections, traceability and workload limits.

4. Security, Governance & Documentation:

– Maintain security and governance. Implement least-privilege access, audit logging, retention controls and appropriate protection of customer information in partnership with security and governance teams.

– Keep the database understandable and maintainable. Maintain data dictionaries, relationship diagrams, business definitions, lineage documentation and operational runbooks. Recommend and deliver improvements to database design and administration practices.

Requirements

– Good English skills

– Substantial hands-on experience administering large, business-critical databases with high data volumes and demanding performance requirements.

– Strong SQL skills and practical expertise in execution plans, indexing, partitioning, performance tuning and capacity management (Snowflake and Fabric experience strongly preferred).

– Proven experience with backup and recovery, high availability, monitoring, access control and production incident resolution.

– Strong understanding of relational data modeling, referential integrity, master data management and historical data handling.

– Experience implementing automated data-quality checks and sustainable correction workflows, including addressing issues at their source.

– Familiarity with data pipelines, ETL/ELT processes and the database requirements of analytics and data science teams.

– Ability to translate business definitions into clear data structures, validation rules and operational controls.

– Strong documentation, problem-solving and stakeholder collaboration skills, with a proactive approach to ownership.

Nice to have:

– Retail, FMCG or point-of-sale data experience, particularly large transaction datasets linked to product and customer masters.

– Cloud database platforms, data warehouses or lakehouse environments.

– Experience supporting machine learning, generative AI or natural-language-to-SQL applications through secure, governed data access.

– Scripting and automation for database operations, testing and data-quality monitoring.

Benefits

At SmartOSC, we offer the best to your values:

– Attractive salary package

– Flexible working hours (between 7:30am – 7:30pm on staff’s preference)

– Premium health care

– Working in one of the largest digital transformation agencies in Asia – 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

Personal Data Consent Notice

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.