Completion requirements
Recall the summary report on database administrators that you read earlier in Unit 1 (1.3.4). Pay attention to the tasks, skills, knowledge, and abilities. What is the importance of a DBA? What are some strengths and weaknesses of organizations that do and do not have DBAs?
Technology Skills
- Access software - Access management software; Citrix cloud computing software
- Accounting software - Fund accounting software
- Administration software - Redgate SQL Server
- Analytical or scientific software - IBM SPSS Statistics; Minitab; SAS statistical software; The MathWorks MATLAB
- Application server software - Docker; Red Hat OpenShift; Red Hat WildFly; Spring Boot
- Backup or archival software - Acronis Recovery Expert; EMC NetWorker; HP DataProtector; Veritas NetBackup
- Business intelligence and data analysis software - Apache Spark; MicroStrategy; Oracle Business Intelligence Enterprise Edition; Qlik Tech QlikView
- Cloud-based data access and sharing software - Microsoft SharePoint
- Cloud-based management software - Amazon Web Services AWS CloudFormation; IBM WebSphere; Splunk Enterprise
- Cloud-based protection or security software - SolarWinds
- Clustering software - Cluster server software; Oracle Real Application Cluster RAC
- Communications server software - IBM Domino
- Computer aided design CAD software - Autodesk Revit; Dassault Systemes CATIA
- Computer based training software
- Configuration management software - Chef; Perforce Helix software; Puppet; VMware
- Content workflow software - Atlassian JIRA
- Customer relationship management CRM software - Blackbaud The Raiser's Edge; Oracle Eloqua; Salesforce software
- Data base management system software - Amazon DynamoDB; Elasticsearch; MongoDB; Oracle PL/SQL
- Data base reporting software - Microsoft SQL Server Reporting Services SSRS; Oracle Reports; Oracle SQL Plus; SAP Crystal Reports
- Data base user interface and query software - Apache Hive; Blackboard software; MySQL; Oracle JDBC
- Data mining software - Google Analytics
- Desktop communications software - Skype
- Desktop publishing software - Microsoft Publisher
- Development environment software - Apache Ant; Apache Kafka; Common business oriented language COBOL; Go
- Electronic mail software - IBM Notes; Microsoft Exchange; Microsoft Outlook
- Enterprise application integration software - Atlassian Bamboo; Extensible markup language XML; Microsoft SQL Server Integration Services SSIS; Oracle Fusion Middleware
- Enterprise resource planning ERP software - Microsoft Dynamics GP; NetSuite ERP; Oracle Hyperion; Oracle JD Edwards EnterpriseOne
- Enterprise system management software - IBM Power Systems software
- Expert system software - Ansible software; Apache Mahout
- File versioning software - Apache Subversion; Git
- Financial analysis software - Delphi Technology; Oracle E-Business Suite Financials
- Geographic information system - ESRI ArcGIS software; Geographic information system GIS software
- Graphical user interface development software - Salesforce Visualforce
- Human resources software - Human resource management software HRMS; Oracle Learning Management; Oracle Taleo
- Industrial control software - Supervisory control and data acquisition SCADA software
- Information retrieval or search software - Data validation software; LexisNexis
- Manufacturing execution system MES software - CA Easytrieve Report Generator
- Medical software - Epic Systems
- Metadata management software - CA Erwin Data Modeler; Data modeling software; IBM Rational Data Architect; Pentaho Kettle
- Multi-media educational software - Nearpod
- Network conferencing software - LogMeIn GoToWebinar
- Network monitoring software - Nagios; Wireshark; Zabbix
- Network security and virtual private network VPN equipment software - Virtual private networking VPN software
- Network security or virtual private network VPN management software - Database security software
- Object or component oriented development software - Advanced business application programming ABAP; Apache Groovy; jQuery; Scala
- Object oriented data base management software - Hibernate ORM; IBM Informix; PostgreSQL; Transact-SQL
- Office suite software - Microsoft Office
- Operating system software - Microsoft Windows Server; Oracle Solaris; Red Hat Enterprise Linux; UNIX Shell
- Portal server software - Apache HTTP Server
- Presentation software - Microsoft PowerPoint
- Process mapping and design software - Microsoft Visio; Visual Paradigm DB Visual ARCHITECT
- Program testing software - Database testing software; Hewlett Packard LoadRunner; JUnit; Selenium
- Project management software - Confluence; Microsoft Project; Oracle Primavera Enterprise Project Portfolio Management
- Requirements analysis and system architecture software - Database capacity planning software; Unified modeling language UML
- Sales and marketing software - Marketo Marketing Automation
- Spreadsheet software - Microsoft Excel
- Storage networking software - Amazon Simple Storage Service S3; Storage area network SAN software
- Transaction security and virus protection software - Encryption software; McAfee; NortonLifeLock cybersecurity software
- Transaction server software - Customer information control system CICS
- Video conferencing software - Cisco Webex; Google Meet; LogMeIn GoToMeeting
- Web page creation and editing software - Adobe Systems Adobe Dreamweaver
- Web platform development software - Backbone.js; Google AngularJS; Microsoft ASP.NET Core MVC; Spring Framework
- Word processing software - Microsoft Word
Hot Technology - a technology requirement frequently included in employer job postings.