How a database architect can use AI, task by task

I work as a database architect. Part of my job is to collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.

Product or system: [describe]
Stakeholders: [users, management]

Draft questions to settle requirements. Keep it under 150 words with a clear ask, plus a 2-sentence version for chat.

I work as a database architect. Part of my job is to design databases to support business applications, ensuring system scalability, security, performance, and reliability.

Context: We use Microsoft Azure software and Apache Kafka; the work draws on engineering and technology, design and computers and electronics.
What to store: [appraisals, records, inventory]
How it's used: [searches, reports]

Design tables and fields, and give setup steps for a spreadsheet or database tool, plus example queries.

I work as a database architect. Part of my job is to design database applications, such as interfaces, data transfer mechanisms, global temporary tables, data partitions, and function-based indexes to enable efficient access of the generic database structure.

Context: We use Microsoft Azure software and Apache Kafka; the work draws on engineering and technology, design and computers and electronics.
What to store: [appraisals, records, inventory]
How it's used: [searches, reports]

Design tables and fields, and give setup steps for a spreadsheet or database tool, plus example queries.

I work as a database architect. Part of my job is to develop data models for applications, metadata tables, views or related database structures.

Context: We use Tableau and Microsoft Power BI; the work draws on engineering and technology, design and computers and electronics.
System: [network, communications]
Requirements: [users, traffic, reliability]

Draft conceptual and logical designs with capacity calculations. Show your working step by step and give spreadsheet formulas so I can reproduce the numbers.

I work as a database architect. Part of my job is to develop data model describing data elements and their use, following procedures and using pen, template or computer software.

Context: We use Tableau and Microsoft Power BI; the work draws on engineering and technology, design and computers and electronics.
System: [network, communications]
Requirements: [users, traffic, reliability]

Draft conceptual and logical designs with capacity calculations. Show your working step by step and give spreadsheet formulas so I can reproduce the numbers.

I work as a database architect. Part of my job is to document and communicate database schemas, using accepted notations.

Context: We use Microsoft SharePoint and Teradata Database.
Project: [describe]
Audience: [staff, customers, engineers]

Draft a summary or presentation outline. Keep it under 150 words with a clear ask, plus a 2-sentence version for chat.

I work as a database architect. Part of my job is to create and enforce database development standards.

Context: We use Microsoft SharePoint and Microsoft Word.
Area: [web, systems]
Goals: [describe]

Draft KPIs with definitions and targets. Use plain language and headings where they help, and mark anything you had to guess with [CHECK].

I work as a database architect. Part of my job is to test programs or databases, correct errors, and make necessary modifications.

Context: We use SAS and The MathWorks MATLAB; the work draws on engineering and technology, design and computers and electronics.
Database: [type, size]
Symptoms: [slow queries, errors]

List checks, likely causes and fixes, with example queries to diagnose. Give sources I can check and say clearly when you're unsure.

I work as a database architect. Part of my job is to identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.

Context: We use Tableau and Microsoft Power BI; the work draws on engineering and technology, design and computers and electronics.
Data: [paste table]
Question: [what relationships matter]

Analyze correlations and trends with code or formulas. Show your working step by step and give spreadsheet formulas so I can reproduce the numbers.

I work as a database architect. Part of my job is to provide technical support to junior staff or clients.

Context: The work draws on engineering and technology, design and computers and electronics.
Software: [describe]
Common problems: [list]

Write clear fixes and when to escalate. Use plain language, one everyday analogy, and the questions people are most likely to ask with short answers.

I work as a database architect. Part of my job is to demonstrate database technical functionality, such as performance, security and reliability.

Context: We use SAS and The MathWorks MATLAB; the work draws on engineering and technology, design and computers and electronics.
Database: [type, size]
Symptoms: [slow queries, errors]

List checks, likely causes and fixes, with example queries to diagnose. Give sources I can check and say clearly when you're unsure.

I work as a database architect. Part of my job is to review project requests describing database user needs to estimate time and cost required to accomplish project.

Context: We use Tableau and Microsoft Power BI; the work draws on engineering and technology, design and computers and electronics.
Project: [describe]
Inputs: [tasks, rates, materials]

Build an estimate table with assumptions and formulas. Show your working step by step and give spreadsheet formulas so I can reproduce the numbers.

I work as a database architect. Part of my job is to develop load-balancing processes to eliminate down time for backup processes.

Context: We use Microsoft Azure software and Apache Kafka; the work draws on engineering and technology, design and computers and electronics.
Systems and data: [describe]
Requirements: [frequency, retention]

Design a backup and restore procedure with scripts. Propose the approach first, then the code with comments and tests, and point out security risks.

I work as a database architect. Part of my job is to identify, evaluate and recommend hardware or software technologies to achieve desired database performance.

Context: We use SAS and The MathWorks MATLAB; the work draws on engineering and technology, design and computers and electronics.
Need: [what we want to do]
Candidates: [tools]

Compare features, cost, integration and risks in a table, and suggest a trial plan. Give sources I can check and say clearly when you're unsure.

I work as a database architect. Part of my job is to set up database clusters, backup, or recovery processes.

Context: We use Microsoft Azure software and Apache Kafka; the work draws on engineering and technology, design and computers and electronics.
Database: [purpose, platform]
Needs: [data definitions, clustering, backup, recovery]

Draft specifications, data dictionary entries, and backup and recovery procedures with scripts. Propose the approach first, then the code with comments and tests, and point out security risks.

I work as a database architect. Part of my job is to plan and install upgrades of database management system software to enhance database performance.

Context: [Microsoft Azure software or Apache Kafka; what exists already]
Goal: [what it should do, i.e. enhance database performance]
Constraints: [security, performance, style rules]

Propose an approach first, in 5 bullets max. Then write the code with comments, plus tests that prove it works. Point out any security risks.

I work as a database architect. Part of my job is to establish and calculate optimum values for database parameters, using manuals and calculators.

Context: We use Microsoft Azure software and Apache Kafka; the work draws on engineering and technology, design and computers and electronics.
Database: [purpose, platform]
Needs: [data definitions, clustering, backup, recovery]

Draft specifications, data dictionary entries, and backup and recovery procedures with scripts. Propose the approach first, then the code with comments and tests, and point out security risks.

I work as a database architect. Part of my job is to train users and answer questions.

Context: We use Microsoft PowerPoint and Structured query language SQL; the work draws on engineering and technology, design and computers and electronics.
System: [describe]
Users: [describe]

Plan training with hands-on tasks and a cheat sheet. Include timings, a realistic practice scenario from my work, and a short check for understanding with answers.