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
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
