Will “Database Analyst” be Replaced By Robots? 🤔

Unknown Chance of Automation

Sadly, the research paper did not provide any information about this occupation. Maybe have a look at our directory?

Job Description

Design strategies for enterprise database systems and set standards for operations, programming, and security. Design and construct large relational databases. Integrate new systems with existing warehouse structure and refine system performance and functionality.

Job Details

The SOC (Standard Occupational Classification) code is 15-1199.06

☝️ Information based on the reference occupation “Database Architects”.

Also Known As…

Tasks for “Database Analyst”

Identify, evaluate and recommend hardware or software technologies to achieve desired database performance.
Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
Develop data models for applications, metadata tables, views or related database structures.
Provide technical support to junior staff or clients.
Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
Set up database clusters, backup, or recovery processes.
Monitor and report systems resource consumption trends to assure production systems meet availability requirements and hardware enhancements are scheduled appropriately.
Develop load-balancing processes to eliminate down time for backup processes.
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.
Plan and install upgrades of database management system software to enhance database performance.
Create and enforce database development standards.
Develop and document database architectures.
Design databases to support business applications, ensuring system scalability, security, performance and reliability.
Develop or maintain archived procedures, procedural codes, or queries for applications.
Demonstrate database technical functionality, such as performance, security and reliability.
Document and communicate database schemas, using accepted notations.
Identify and correct deviations from database development standards.
Test changes to database applications or systems.

Related Technology & Tools

Copy machines
Laser facsimile machines
Personal computers
Load balancers

Microsoft Visual Studio
Pentaho Kettle
Spring Framework
Oracle Java
IBM Rational System Architect
IBM WebSphere
Ruby
IBM Domino
Hewlett Packard LoadRunner
Microsoft Excel
Integrated development environment IDE software
Oracle Data Guard
MicroStrategy
Apple Macintosh OS
Microsoft ActiveX
SMSi Twister Data Integrator
Apache Oozie
Cloudera Impala
Symantec
Teradata Database
Python
Citrix
Apache Solr
Microsoft Access
Flat File Checker
Data modeling software
Dynamic hypertext markup language DHTML
IBM InfoSphere DataStage
C++
IBM Rational Data Architect
Oracle Data Integrator
Talend Data Fabric
Interface Computers Data Loader
Sybase
Enterprise JavaBeans
Common business oriented language COBOL
Apache Cassandra
SAP
Perl shell
Scriptella
IBM AIX
CA Technologies ERWin Data Modeler
Qlik Tech QlikView
Application server software
Oracle Designer
C shell
Microsoft Visio
Microsoft .NET Framework
Extensible markup language XML
Intel Data Migration Software
Apache Hadoop
Oracle JDBC
IBM DB2
Apache Pig
SAP Business Objects
Microsoft SQL Server Reporting Services
SAP Sybase Replication Server
Apache Avro
Apache Hbase
Nagios
Apache Hive
SAP Sybase Adaptive Server Enterprise
Customer information control system CICS
Cisco IOS
Quest SQL Optimizer for Oracle
Relational database management software
Oracle Enterprise Manager
Amazon Kinesis
CA Erwin Data Modeler
Jitterbit
Oracle WebLogic Server
Unified modeling language UML
Oracle Jdeveloper
Perforce Helix software
C#
Tableau
Microsoft SharePoint
Talend Big Data Integration
Oracle Fusion Applications
Oracle Real Application Cluster RAC
SAP Sybase PowerDesigner
MySQL
Microsoft PowerShell
Swift
Apache Flume
Oracle Hyperion
Bash
Microsoft SQL Server
Microsoft Active Server Pages ASP
Microsoft Windows
Oracle Solaris
Informatica PowerCenter
Adeptia ETL Suite
KornShell
Apache Sqoop
Splunk Enterprise
NoSQL
Data Recovery Software SQL Server Data Recovery
Apache HTTP Server
Linux
SPSS
Oracle Migration Workbench
Epic Systems
ESRI ArcGIS software
IBM InfoSphere Warehouse
PostgreSQL
Microsoft Visual Basic Scripting Edition VBScript
Apache Spark
Adobe Systems Adobe Acrobat
CloverETL
Oracle Business Intelligence Enterprise Edition
IBM Cognos Impromptu
Structured query language SQL
Apatar
Red Hat Enterprise Linux
Microsoft Exchange Server
Puppet
HiT Software Allora
Oracle JD Edwards EnterpriseOne
Coglin Mill RODIN
Multidimensional Expressions MDX
WisdomForce DatabaseSync System
Microsoft Visual Basic
Job control language JCL
Rapid-I RapidMiner
Red Hat WildFly
Veritas NetBackup
Oracle Golden Gate
Transact-SQL
PHP: Hypertext Preprocessor
Infobright Community Edition ICE
Practical extraction and reporting language Perl
Hewlett Packard HP-UX
SAS Data Integration Studio
Talend Open Studio
Advanced business application programming ABAP
IBM Content Manager
Oracle Recovery Manager
Oracle PL/SQL
SAS
MongoDB
UNIX
Oracle Application Server
Altova MapForce
SAP Crystal Reports
R