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