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