Description
Apply database principles and tools to support data storage, integration, and retrieval across business systems. Build, update, and maintain databases; ingest, validate, and query data for analysis, reporting, and operations. Assist users, enforce data quality and security, monitor performance, and perform backups, troubleshooting, and upgrades.
- • Develop or maintain scripts and applications that load and transform data into searchable databases for analysis and reporting.
- • Enter, update, or retrieve information from enterprise databases, data marts, or data warehouses.
- • Monitor database performance and perform maintenance, tuning, upgrades, and repairs.
- • Analyze and manipulate data using SQL, scripting, and BI or data processing tools.
- • Collaborate with business users, analysts, and IT staff to define data needs and database requirements.
- • Create data management, validation, and error-checking procedures and user documentation.
- • Design or implement web-based or GUI tools for querying and viewing large datasets.
- • Develop, schedule, and monitor ETL processes for reliable data movement and integration.
- • Document database configurations, changes, data flows, and known issues.
- • Extend and optimize existing queries, stored procedures, scripts, or data access tools as needs evolve.
- • Stay current on database platforms, cloud services, and emerging data technologies.
- • Prepare or support data reports, dashboards, and operational metrics.
- • Test new or updated database software, patches, or tools and provide feedback.
- • Train staff and end users in database tools, data access, and best practices.
- • Write efficient SQL queries and automation scripts for data retrieval and processing.
- • Conduct data quality checks, reconciliations, and audits on inputs and outputs.
- • Communicate with database users about project timelines, priorities, and change impacts.
- • Package and export datasets for sharing, compliance reporting, or data exchange.
- • Perform routine database administration tasks, including troubleshooting, backups, restores, and security updates.
Related specializations
Interview options
Interview options
Interviewee gender
Interviewee accent
Available on paid plans only
Interview time
Source
Tasks & skills:
O*NET occupational data (work activities, skills, knowledge).
Learn more
Sources & Standards:
This site includes information from O*NET by the U.S. Department of Labor, Employment and Training Administration (USDOL/ETA), used under the CC BY 4.0 license. Career Clutch has modified some of this information for student readability. USDOL/ETA has not approved, endorsed, or tested these modifications. O*NET® is a trademark of USDOL/ETA.
Last reviewed: Jan 2026
