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