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.
Keeping the record6
Create data models and schemas
+Design the relational and dimensional schemas for the sales and customer domains, document field types and…
Create data models and schemas
+Design the relational and dimensional schemas for the sales and customer domains, document field types and keys, ensure GDPR-compliant exchange formats, and produce the DDL and an ER diagram for review by Friday noon.
The tools that do the workApache HiveESCOjob descriptionsO*NETWikipedia
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Optimize database performance
+Analyze the slowest queries from last week's reports, propose and apply index and partitioning changes,…
Optimize database performance
+Analyze the slowest queries from last week's reports, propose and apply index and partitioning changes, capture before/after plans and runtime metrics, and schedule a rollback if latency rises above 300ms.
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?
Express strategic data requirements
+Draft a one-page brief of strategic data requirements: core entities, freshness SLAs, ownership, allowed…
Express strategic data requirements
+Draft a one-page brief of strategic data requirements: core entities, freshness SLAs, ownership, allowed consumers, and exchange formats, circulate to product, analytics and security for sign-off by Wednesday.
The tools that do the workApache Airflowjob descriptionsWikipedia
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Develop and test database modifications
+Implement the schema change in a dev copy, write migration scripts with backward-compatible views, run the…
Develop and test database modifications
+Implement the schema change in a dev copy, write migration scripts with backward-compatible views, run the full test suite and a sampled production replay, then open a changelog entry and request QA sign-off.
The tools that do the workApache Cassandrajob descriptionsO*NET
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Implement data backup and recovery procedures
+Create a nightly backup plan including full and incremental snapshots, document restore steps with RTO/RPO…
Implement data backup and recovery procedures
+Create a nightly backup plan including full and incremental snapshots, document restore steps with RTO/RPO targets, run a test restore to a staging instance and record timing and data integrity results.
The tools that do the workAmazon Elastic Compute Cloud EC2job descriptionsO*NET
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Create and manage data models
+Build canonical data models for customer, product and order, enforce naming and data-exchange standards,…
Create and manage data models
+Build canonical data models for customer, product and order, enforce naming and data-exchange standards, publish the model package with sample datasets and a versioned migration path for downstream teams.
The tools that do the workApache Hivejob 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 work14
Troubleshoot database issues
+Investigate the slow-running orders database: run the failing report query, collect the execution plan and…
Troubleshoot database issues
+Investigate the slow-running orders database: run the failing report query, collect the execution plan and recent wait stats, capture the error logs from last 48 hours, and summarise three likely causes with priority and next steps for the on-call dev by noon tomorrow.
The tools that do the workApache Hivejob descriptions
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Collaborate with software developers and analysts
+Coordinate with Marco in backend, Priya the analyst, and the frontend team to define the data contract for…
Collaborate with software developers and analysts
+Coordinate with Marco in backend, Priya the analyst, and the frontend team to define the data contract for the new customer profile API, list required fields, types, example rows, and one reconciliation test, then circulate the draft for approval by Friday.
The tools that do the workApache Airflowjob descriptions
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Create an inventory of the data needed
+Inventory the data needed for the quarterly churn model: extract table names, key fields, update frequency,…
Create an inventory of the data needed
+Inventory the data needed for the quarterly churn model: extract table names, key fields, update frequency, owners and sample row counts from the customer schema, compile into a single spreadsheet and flag any missing sources by Wednesday.
The tools that do the workApache HiveWikipedia
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Provide a standard common business vocabulary
+Draft a one-page common business vocabulary for customer, account, transaction and subscription with plain…
Provide a standard common business vocabulary
+Draft a one-page common business vocabulary for customer, account, transaction and subscription with plain definitions, canonical field names, data types and examples, then send to product and finance for comments by Friday close of business.
The tools that do the workApache HiveWikipedia
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Manage standards for data exchange
+Publish the data exchange standard for partner imports: specify CSV layout, delimiter, required columns,…
Manage standards for data exchange
+Publish the data exchange standard for partner imports: specify CSV layout, delimiter, required columns, validation rules, error codes and an example file, then notify partners and the integration team with the new spec effective next Monday.
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Web programming
+Build the small user lookup service: list endpoints, request/response JSON schemas, required SQL queries and…
Web programming
+Build the small user lookup service: list endpoints, request/response JSON schemas, required SQL queries and indexes, and a smoke test; deliver the spec and a sample dataset to the frontend team by Wednesday.
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Perform data analysis
+Run the sales-to-support join, filter for completed orders in Q2, compute churn and average revenue per user…
Perform data analysis
+Run the sales-to-support join, filter for completed orders in Q2, compute churn and average revenue per user by product tier, validate missing customer IDs, and save a clean analysis table named sales_churn_q2 for review on Wednesday.
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Create data sets
+Assemble a customer activity dataset by extracting user events, normalising timestamps to UTC, deduplicating…
Create data sets
+Assemble a customer activity dataset by extracting user events, normalising timestamps to UTC, deduplicating by event_id, enrich with product tier and last_purchase_date, and publish the final table customer_activity_master to the shared schema before Friday.
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Provide technical guidance to team members
+Write a concise technical note for the team outlining our SQL coding standards, recommended data types,…
Provide technical guidance to team members
+Write a concise technical note for the team outlining our SQL coding standards, recommended data types, naming conventions, and three common query patterns to avoid performance regressions; include examples and one‑page checklist for reviews.
The tools that do the workApache Hivejob descriptionsO*NET
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Define how the data will be stored
+Describe the storage design for the new customer analytics dataset: table layouts, partition and clustering…
Define how the data will be stored
+Describe the storage design for the new customer analytics dataset: table layouts, partition and clustering keys, column compression choices, and retention policy so downstream analysts can join efficiently and storage costs remain predictable.
The tools that do the workAmazon Redshiftjob descriptionsWikipedia
Pasted it? Good. When the reply comes back, push once: ask it to sharpen the weakest part. — Did this prompt help?
Review project requests describing database user needs to estimate time and cost required to accomplish project.
+Review the project request from Marketing describing their user cohorts and reporting cadence, list the…
Review project requests describing database user needs to estimate time and cost required to accomplish project.
+Review the project request from Marketing describing their user cohorts and reporting cadence, list the required tables, estimated development hours, staging needs, and a rough cost estimate for storage and compute over six months.
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?
Establish and calculate optimum values for database parameters, using manuals and calculators.
+Calculate recommended database parameter values for our transaction database using the vendor manuals and…
Establish and calculate optimum values for database parameters, using manuals and calculators.
+Calculate recommended database parameter values for our transaction database using the vendor manuals and current workload: buffer/cache size, max connections, checkpoint interval, and expected I/O; show formulas and final numbers with margin assumptions.
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?
Train users and answer questions.
+Prepare a one‑hour training plan and quick reference for analysts showing how to run approved queries,…
Train users and answer questions.
+Prepare a one‑hour training plan and quick reference for analysts showing how to run approved queries, interpret results, and where to ask questions; include three hands‑on exercises and an FAQ with answers to expected confusion points.
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?
Ensure data integrity and security
+Audit the current schema and access lists for sensitive tables, produce a remediation plan to enforce…
Ensure data integrity and security
+Audit the current schema and access lists for sensitive tables, produce a remediation plan to enforce referential integrity, column encryption, row‑level permissions and a schedule for validating checksums and backups weekly.
The tools that do the workAmazon DynamoDBjob descriptions
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