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