What it pays
Government survey numbers — not estimates, not ads.
Half of all Database Architects in the U.S. earn more than $139,500 a year — the middle 80% land between $86,240 and $204,000. About 67,140 people in the U.S. do this work. Figures are for the U.S. occupation group “Database Architects”. (U.S. Bureau of Labor Statistics survey, published 2025.) In India, Professionals earn about ₹38,298 a month on average — around ₹4.6 lakh a year (government PLFS survey via ILOSTAT, occupation-family figure).
$139,500typical pay / year
67,140people in this work
$204,000+top 10% earn
₹4.6 lakha year in India (family avg)
Think you get this job?Six quick questions on how it really works — with a hint and the reason behind every answer.
Test yourself →The work, task by task
These are the real jobs-to-be-done, not a wish list. Each task shows where we found it, and the prompt underneath is written for that exact task.
Protecting3
Monitor data warehouse health
+Monitor the data warehouse health for the nightly ingestion pipeline, verify table row counts, check ETL job…
Monitor data warehouse health
+Monitor the data warehouse health for the nightly ingestion pipeline, verify table row counts, check ETL job success rates and latency, flag any failed loads to the data ops team, and open a ticket if replication lag exceeds ten minutes.
The tools that do the workAmazon Redshiftjob descriptionsO*NET
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Troubleshoot data issues
+Troubleshoot today's dashboard discrepancies by tracing the metric from the visualization back to its source…
Troubleshoot data issues
+Troubleshoot today's dashboard discrepancies by tracing the metric from the visualization back to its source table, validate source row counts and data quality checks, isolate whether the issue is in the transformation or freshness, and note remediation steps in the incident log.
The tools that do the workApache SparkESCOjob descriptions
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Develop data management procedures
+Develop data management procedures for dataset onboarding: define source acceptance criteria, mandatory…
Develop data management procedures
+Develop data management procedures for dataset onboarding: define source acceptance criteria, mandatory cleansing steps, lineage documentation, SLA for refresh frequency, and an ownership matrix, then circulate to data governance and legal for sign-off by Friday.
The tools that do the workApache Hadoopjob descriptionsO*NET
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Analysing1
Model data
+Model the customer engagement dataset into a star schema, define facts and dimensions, document column…
Model data
+Model the customer engagement dataset into a star schema, define facts and dimensions, document column meanings and grain, create example SQL for joins and aggregations, and circulate the model to analytics and product for review on Wednesday.
The tools that do the workApache HiveESCOjob descriptions
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Sending & sharing1
Implement ETL processes
+Design and deploy nightly ETL that extracts raw event batches, applies cleansing rules and validation, writes…
Implement ETL processes
+Design and deploy nightly ETL that extracts raw event batches, applies cleansing rules and validation, writes partitioned cleaned tables with data quality reports, and notify the data stewards on failure starting next Monday.
The tools that do the workApache HadoopApache Sparkjob descriptionsO*NET
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
The daily work17
Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
+Analyze the data pipeline to find where schema drift and null inflation occur, profile sample tables and…
Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
+Analyze the data pipeline to find where schema drift and null inflation occur, profile sample tables and scripts, list the failing transformations with line numbers and propose three remediation options with estimated effort and risk by Tuesday.
The tools that do the workApache SparkO*NET
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Create or implement metadata processes and frameworks.
+Design a metadata framework that captures source lineage, field definitions, retention policy and…
Create or implement metadata processes and frameworks.
+Design a metadata framework that captures source lineage, field definitions, retention policy and RDF-compatible identifiers, produce the metadata model diagram and a one-page governance checklist for the analytics team by Friday.
The tools that do the workApache HiveO*NET
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Review designs, codes, test plans, or documentation to ensure quality.
+Review the visualization code, accompanying test plan and documentation for the Q2 dashboard, flag any data…
Review designs, codes, test plans, or documentation to ensure quality.
+Review the visualization code, accompanying test plan and documentation for the Q2 dashboard, flag any data quality or RDF query mismatches, list defects with severity and required fixes, and sign off or request rework within two business days.
The tools that do the workApache Subversion SVNO*NET
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Implement business rules via stored procedures, middleware, or other technologies.
+Implement the customer segmentation business rules as stored procedures or middleware routines, document…
Implement business rules via stored procedures, middleware, or other technologies.
+Implement the customer segmentation business rules as stored procedures or middleware routines, document inputs, edge cases and RDF query examples, add unit tests covering nulls and duplicates, and deploy to staging by Thursday evening.
The tools that do the workApache CassandraO*NET
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Configure database software
+Harden the analytics database configuration for performance: tune connection limits, storage compaction,…
Configure database software
+Harden the analytics database configuration for performance: tune connection limits, storage compaction, backup schedule and retention, record the changes and rollback steps, and validate with a full ingest test by Wednesday.
The tools that do the workAmazon Redshiftjob descriptions
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Create data marts
+Build the sales data mart with cleansed source feeds, standardized field mappings, primary keys, partitioning…
Create data marts
+Build the sales data mart with cleansed source feeds, standardized field mappings, primary keys, partitioning strategy and RDF-friendly identifiers, populate with a month of data and deliver a refresh script and documentation by next Monday.
The tools that do the workApache Hadoopjob descriptions
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Maintain data security
+Lock down the visualization project datasets and access lists, revoke any users without a business…
Maintain data security
+Lock down the visualization project datasets and access lists, revoke any users without a business justification, encrypt the archive copy, and document the changed permissions and retention policy for audit by Friday.
The tools that do the workAmazon Redshiftjob descriptions
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Collaborate with IT teams
+Meet with the network engineer, database lead, and DevOps on Tuesday to map data feeds, agree SLA for refresh…
Collaborate with IT teams
+Meet with the network engineer, database lead, and DevOps on Tuesday to map data feeds, agree SLA for refresh cadence and error reporting, then update the team data contract and raise any blockers for a decision.
The tools that do the workAtlassian JIRAjob descriptions
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Gather data requirements
+Interview product managers and three analysts this week to capture which metrics they need, required…
Gather data requirements
+Interview product managers and three analysts this week to capture which metrics they need, required dimensions, acceptable latency and sample datasets, then produce a one‑page requirements summary for signoff.
The tools that do the workApple macOSjob descriptions
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Support data migration projects
+Prepare the source-to-target mapping for the migration, list transformations and data quality checks, run a…
Support data migration projects
+Prepare the source-to-target mapping for the migration, list transformations and data quality checks, run a dry transfer of a representative table, and report failures and remediation steps to the migration lead.
The tools that do the workApache KafkaApache Sparkjob descriptions
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Import data
+Bring the new CSV extracts into a staging dataset, validate headers and types, flag rows with missing keys,…
Import data
+Bring the new CSV extracts into a staging dataset, validate headers and types, flag rows with missing keys, add provenance fields, and hand the clean staging table to the analysts by close of day.
The tools that do the workAmazon DynamoDBESCO
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Clean data
+Run the cleansing pipeline on the staging table to remove duplicates, standardise date and ID formats, apply…
Clean data
+Run the cleansing pipeline on the staging table to remove duplicates, standardise date and ID formats, apply the quality rules from the handbook, and write a data quality report for the data steward.
The tools that do the workApache SparkESCO
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Transform data
+Transform the raw ICT usage logs into a cleaned, analysis-ready table: remove duplicates, standardise…
Transform data
+Transform the raw ICT usage logs into a cleaned, analysis-ready table: remove duplicates, standardise timestamps to UTC, normalise device and app names, flag missing IDs, and produce a CSV with column-level data-quality notes for the analytics team by Thursday noon.
The tools that do the workApache SparkESCO
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Validate data
+Validate the recent ICT dataset against the reference master: check foreign key integrity, verify value…
Validate data
+Validate the recent ICT dataset against the reference master: check foreign key integrity, verify value ranges for bandwidth and uptime, run the RDF queries that confirm schema expectations, summarize all exceptions and confidence scores in a one-page QA report for procurement by end of day Friday.
The tools that do the workApache HiveESCO
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Inspect data
+Inspect the weekly extract for anomalies: profile each field for null rates, outliers and distinct counts,…
Inspect data
+Inspect the weekly extract for anomalies: profile each field for null rates, outliers and distinct counts, sample ten problematic rows per field with original source pointers, and drop a short issue list into the team channel before the 11am stand-up.
The tools that do the workApache HadoopESCO
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Prepare visual reports
+Prepare two visual reports for the CIO: a one-page dashboard showing monthly ICT availability and incident…
Prepare visual reports
+Prepare two visual reports for the CIO: a one-page dashboard showing monthly ICT availability and incident trends with clear thresholds, and a two-slide executive summary that highlights three root-cause charts and recommended actions; export as print-ready PNGs and email by Wednesday 4pm.
The tools that do the workApple macOSESCO
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Ensure data repositories provide reliable data
+Ensure the primary data repository serves reliable records: run nightly integrity checks, reconcile counts…
Ensure data repositories provide reliable data
+Ensure the primary data repository serves reliable records: run nightly integrity checks, reconcile counts with the ingestion logs, implement alerts for schema drift and a weekly audit report that documents fixes and outstanding risks for the data-steering group on Monday mornings.
The tools that do the workApache KafkaESCO
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Says who?
These are the pages we read to build this. Open any of them and check us.
The logs, files & records this job keeps
Shared with other careers — the same record means something different in each.
Related careers
Same family of work — each with its own tasks and prompts.
The LLOS Work Atlas is the world's largest evidenced task library — a map of human work, with a ready prompt behind every task. 1,774 careers · every task named by the sources that witnessed it — O*NET, ESCO, real job descriptions, Wikipedia — and the deepest tasks by several at once. And it is honest about limits: where AI cannot help, the map says so.
The rest of the map
Same library, five ways in.
Copyright © LLOS.ai · 2026 — original pedagogy, voice, and design — all rights reserved.
Built on public evidence: O*NET®, ESCO, Wikipedia, U.S. Bureau of Labor Statistics, ILOSTAT. All sources & licenses
Built on public evidence: O*NET®, ESCO, Wikipedia, U.S. Bureau of Labor Statistics, ILOSTAT. All sources & licenses