How a database administrator can use AI, task by task

I work as a database administrator. Part of my job is to modify existing databases and database management systems or direct programmers and analysts to make changes.

Context: We use Microsoft Azure software and Apache Kafka; the work draws on computers and electronics, telecommunications and engineering and technology.
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 administrator. Part of my job is to test programs or databases, correct errors, and make necessary modifications.

Context: We use Oracle Database; the work draws on computers and electronics, telecommunications and engineering and technology.
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 administrator. Part of my job is to provide technical support to junior staff or clients.

Context: The work draws on computers and electronics, telecommunications and engineering and technology.
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 administrator. Part of my job is to test changes to database applications or systems.

Context: We use Microsoft Azure software and Apache Kafka; the work draws on computers and electronics, telecommunications and engineering and technology.
System: [application, network, data processing]
Risks: [what could fail]

Write test cases covering function, performance and security, with expected results and scripts. Propose the approach first, then the code with comments and tests, and point out security risks.

I work as a database administrator. Part of my job is to specify users and user access levels for each segment of database.

Context: We use Microsoft Azure software and Apache Kafka; the work draws on computers and electronics, telecommunications and engineering and technology.
System: [network, application]
Threat or change: [describe]

Propose security controls and configuration steps with tests. Propose the approach first, then the code with comments and tests, and point out security risks.

I work as a database administrator. 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 computers and electronics, telecommunications and engineering and technology.
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.

I work as a database administrator. Part of my job is to plan, coordinate, and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.

Context: We use Microsoft Azure software and Apache Kafka; the work draws on computers and electronics, telecommunications and engineering and technology.
System: [network, application]
Threat or change: [describe]

Propose security controls and configuration steps with tests. Propose the approach first, then the code with comments and tests, and point out security risks.

I work as a database administrator. Part of my job is to develop data models describing data elements and how they are used, following procedures and using pen, template, or computer software.

Context: We use Tableau and Apache Spark; the work draws on computers and electronics, telecommunications and engineering and technology.
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 administrator. 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 administrator. Part of my job is to identify, evaluate and recommend hardware or software technologies to achieve desired database performance.

Context: We use Oracle Database; the work draws on computers and electronics, telecommunications and engineering and technology.
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 administrator. Part of my job is to develop standards and guidelines for the use and acquisition of software and to protect vulnerable information.

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 administrator. 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 Apache Spark; the work draws on computers and electronics, telecommunications and engineering and technology.
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 administrator. Part of my job is to revise company definition of data as defined in data dictionary.

Context: We use Microsoft Azure software and Apache Kafka; the work draws on computers and electronics, telecommunications and engineering and technology.
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.