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