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…
- Database Architects
- Technical Operations Vice President
- System Engineer
- Information Technology Architect (IT Architect)
- Information Modeling Engineer Specialist
- Information Architect
- Database Consultant
- Database Architect
- Data Officer
- Data Architect
- Data Administrator
- SQL Server Developer
- SharePoint Architect
- Management Analyst
- Knowledge Architect
- Infrastructure Architect
- Information Engineer
- Database Modeler
- Database Engineer
- Database Designer
- Database Design Analyst
- Data Warehouse Architect
- Data Modeler
- Data Manager
- Data Base Design Analyst
- Data Analyst
Tasks for “Database Analyst”
- Develop or maintain archived procedures, procedural codes, or queries for applications.
- Create and enforce database development standards.
- Identify, evaluate and recommend hardware or software technologies to achieve desired database performance.
- Provide technical support to junior staff or clients.
- Design databases to support business applications, ensuring system scalability, security, performance and reliability.
- Develop load-balancing processes to eliminate down time for backup processes.
- Demonstrate database technical functionality, such as performance, security and reliability.
- Document and communicate database schemas, using accepted notations.
- Set up database clusters, backup, or recovery 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.
- Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
- Monitor and report systems resource consumption trends to assure production systems meet availability requirements and hardware enhancements are scheduled appropriately.
- 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.
- Plan and install upgrades of database management system software to enhance database performance.
- Identify and correct deviations from database development standards.
- Test changes to database applications or systems.
- Develop and document database architectures.
Related Technology & Tools
- Personal computers
- Copy machines
- Load balancers
- Laser facsimile machines
- Oracle JD Edwards EnterpriseOne
- Coglin Mill RODIN
- Adeptia ETL Suite
- Apache Solr
- Transact-SQL
- Interface Computers Data Loader
- PHP: Hypertext Preprocessor
- Customer information control system CICS
- Oracle Data Integrator
- IBM Rational Data Architect
- Oracle PL/SQL
- Adobe Systems Adobe Acrobat
- Microsoft PowerShell
- Informatica PowerCenter
- Apache Avro
- IBM InfoSphere DataStage
- Oracle Hyperion
- Apache Cassandra
- Ruby
- Flat File Checker
- SAP Sybase PowerDesigner
- Teradata Database
- Application server software
- Hewlett Packard LoadRunner
- IBM Cognos Impromptu
- Epic Systems
- SAP Crystal Reports
- IBM AIX
- Infobright Community Edition ICE
- UNIX
- Apache Hbase
- KornShell
- Amazon Kinesis
- Common business oriented language COBOL
- Symantec
- Job control language JCL
- C#
- Practical extraction and reporting language Perl
- Perl shell
- Talend Data Fabric
- Oracle Jdeveloper
- Microsoft Exchange Server
- Advanced business application programming ABAP
- R
- Oracle JDBC
- Apache Pig
- SAP Sybase Replication Server
- NoSQL
- Oracle Solaris
- Apatar
- Quest SQL Optimizer for Oracle
- Microsoft Visio
- SAS Data Integration Studio
- Oracle WebLogic Server
- Oracle Designer
- C shell
- Red Hat Enterprise Linux
- SAS
- ESRI ArcGIS software
- WisdomForce DatabaseSync System
- Microsoft Excel
- Altova MapForce
- Talend Open Studio
- Microsoft ActiveX
- Structured query language SQL
- HiT Software Allora
- Oracle Application Server
- Oracle Enterprise Manager
- Relational database management software
- Qlik Tech QlikView
- Scriptella
- Intel Data Migration Software
- Apache HTTP Server
- CA Technologies ERWin Data Modeler
- Red Hat WildFly
- Enterprise JavaBeans
- Apache Hive
- Cisco IOS
- MySQL
- Microsoft SharePoint
- CA Erwin Data Modeler
- SMSi Twister Data Integrator
- MicroStrategy
- Oracle Real Application Cluster RAC
- Apache Spark
- Rapid-I RapidMiner
- Veritas NetBackup
- IBM WebSphere
- Talend Big Data Integration
- Data modeling software
- Microsoft SQL Server
- SAP Business Objects
- Apache Flume
- Dynamic hypertext markup language DHTML
- Swift
- Microsoft Active Server Pages ASP
- PostgreSQL
- SPSS
- Extensible markup language XML
- Citrix
- IBM Content Manager
- Puppet
- Pentaho Kettle
- Oracle Fusion Applications
- Microsoft Visual Basic
- Perforce Helix software
- Apple Macintosh OS
- Tableau
- Apache Hadoop
- Nagios
- Hewlett Packard HP-UX
- IBM Domino
- Jitterbit
- Apache Sqoop
- IBM Rational System Architect
- MongoDB
- IBM DB2
- Unified modeling language UML
- Oracle Data Guard
- Microsoft SQL Server Reporting Services
- Multidimensional Expressions MDX
- Sybase
- Oracle Migration Workbench
- CloverETL
- Oracle Golden Gate
- Splunk Enterprise
- SAP
- IBM InfoSphere Warehouse
- Bash
- Oracle Business Intelligence Enterprise Edition
- Microsoft .NET Framework
- Oracle Java
- Microsoft Windows
- Linux
- Integrated development environment IDE software
- C++
- Python
- Microsoft Access
- Spring Framework
- SAP Sybase Adaptive Server Enterprise
- Microsoft Visual Basic Scripting Edition VBScript
- Apache Oozie
- Cloudera Impala
- Data Recovery Software SQL Server Data Recovery
- Oracle Recovery Manager
- Microsoft Visual Studio