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