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