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