Career Details
15-1243.00 - Database Architects
Design strategies for enterprise databases, data warehouse systems, and multidimensional networks. Set standards for database operations, programming, query processes, and security. Model, design, and construct large relational databases or data warehouses. Create and optimize data models for warehouse infrastructure and workflow. Integrate new systems with existing warehouse structure and refine system performance and functionality.
Key Facts

Tasks

Core
- Provide technical support to junior staff or clients.
- Set up database clusters, backup, or recovery processes.
- Identify, evaluate and recommend hardware or software technologies to achieve desired database performance.
- Plan and install upgrades of database management system software to enhance database performance.
- Identify and correct deviations from database development standards.
- Document and communicate database schemas, using accepted notations.
- Develop or maintain archived procedures, procedural codes, or queries for applications.
- Develop load-balancing processes to eliminate down time for backup processes.
- Develop data models for applications, metadata tables, views or related database structures.
- Design databases to support business applications, ensuring system scalability, security, performance and reliability.
- 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.
- Demonstrate database technical functionality, such as performance, security and reliability.
- Create and enforce database development standards.
- Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
- Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
- Develop and document database architectures.
Generic
- Develop data model describing data elements and how they are used, following procedures and using pen, template or computer software.
- Develop methods for integrating different products so they work properly together such as customizing commercial databases to fit specific needs.
- Establish and calculate optimum values for database parameters, using manuals and calculator.
- Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.
- Review project requests describing database user needs to estimate time and cost required to accomplish project.
- Test programs or databases, correct errors, and make necessary modifications.
- Train users and answer questions.
- Work as part of a project team to coordinate database development and determine project scope and limitations.
- Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.
Knowledge

- 92%Knowledge of circuit boards, processors, chips, electronic equipment, and computer hardware and software, including applications and programming.
- 79%Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar.
- 72%Knowledge of design techniques, tools, and principles involved in production of precision technical plans, blueprints, drawings, and models.
- 72%Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications.
- 67%Knowledge of the practical application of engineering science and technology. This includes applying principles, techniques, procedures, and equipment to the design and production of various goods and services.
- 54%Knowledge of principles and methods for curriculum and training design, teaching and instruction for individuals and groups, and the measurement of training effects.
- 52%Knowledge of business and management principles involved in strategic planning, resource allocation, human resources modeling, leadership technique, production methods, and coordination of people and resources.
- 52%Knowledge of transmission, broadcasting, switching, control, and operation of telecommunications systems.
Tools

- Copy machines
- Laser facsimile machines
- Desktop computers
- Mainframe computers
- Notebook computers
- Personal computers
- Hard disk drives
- Redundant array of independent disks RAID systems
- Tape libraries
- Load balancers
Technology

- 3M Post-it App
- Adobe Systems Adobe Dreamweaver
- Google DocsHOT
- Google Sites
- Microsoft ExcelHOT
- Microsoft PowerPointHOT
- Microsoft Publisher
- Microsoft VisioHOT
- Microsoft WordHOT
- Ab InitioHOT
- Ellucian Banner ERPHOT
- Informatica Corporation PowerCenterHOT
- Microsoft DynamicsHOT
- Microsoft Dynamics GPHOT
- NetSuite ERPHOT
- Oracle Fusion ApplicationsHOT
- Oracle HyperionHOT
- Oracle JD Edwards EnterpriseOneHOT
- Oracle PeopleSoftHOT
- Oracle PeopleSoft FinancialsHOT
- SAPHOT
- SAP Business ObjectsHOT
- Access management software
- Amazon Simple Storage Service S3HOT
- Amazon Web Services AWS CloudFormationHOT
- CitrixHOT
- IBM Domino
- Storage area network SAN software
- Acronis Recovery Expert
- BMC Software Recovery Manager RMAN
- Data Recovery Software SQL Server Data Recovery
- Database cloning software
- EMC NetWorker
- HP DataProtector
- IBM ADSTAR
- Intel Data Migration Software
- Oracle Data Guard
- Oracle Recovery Manager
- Storage management software
- Systems and data disaster recovery software
- Veritas NetBackup
- Adeptia ETL Suite
- Advanced business application programming ABAPHOT
- AJAXHOT
- Apache AntHOT
- Apache GroovyHOT
- Apache KafkaHOT
- Apache Maven
- Apache SparkHOT
- Apache StrutsHOT
- Apache TomcatHOT
- Atlassian BambooHOT
- Backbone.jsHOT
- BMC Software Control-M
- C
- C#HOT
- C++HOT
- Cascading Style Sheets CSSHOT
- Chef
- CloverETL
- Common business oriented language COBOLHOT
- Computer Associates Log Analyzer
- Database capacity planning software
- Database testing software
- Deployment software
- DjangoHOT
- DrupalHOT
- Dynamic hypertext markup language DHTML
- Eclipse IDEHOT
- Enterprise JavaBeans
- Ext JS
- Extensible HyperText Markup Language XHTML
- Extensible markup language XMLHOT
- GoHOT
- Google AngularJSHOT
- Hewlett Packard LoadRunner
- Hypertext markup language HTMLHOT
- IBM InfoSphere DataStage
- IBM WebSphereHOT
- Integrated development environment IDE softwareHOT
- JavaScriptHOT
- JavaScript Object Notation JSONHOT
- Jitterbit
- jQueryHOT
- JUnitHOT
- Jupyter Notebook
- LAMP Stack
- Microsoft .NET FrameworkHOT
- Microsoft Active Server Pages ASPHOT
- Microsoft ActiveX
- Microsoft ASP.NETHOT
- Microsoft ASP.NET Core MVCHOT
- Microsoft AzureHOT
- Microsoft PowerShellHOT
- Microsoft SQL Server Integration Services SSISHOT
- Microsoft Visual BasicHOT
- Microsoft Visual Basic for Applications VBAHOT
- Microsoft Visual Basic Scripting Edition VBScriptHOT
- Microsoft Visual Basic.NET
- Microsoft Visual C# .NET
- Microsoft Visual StudioHOT
- Node.jsHOT
- Oracle Application Express APEX
- Oracle Data Integrator
- Oracle Designer
- Oracle Fusion MiddlewareHOT
- Oracle JavaHOT
- Oracle JavaServer Pages JSPHOT
- Oracle Jdeveloper
- Perforce Helix software
- PHP: Hypertext PreprocessorHOT
- Practical extraction and reporting language PerlHOT
- Prolog
- PuppetHOT
- PythonHOT
- Quest SQL Optimizer for Oracle
- RHOT
- ReactHOT
- Red Hat Ansible Engine
- Restructured extended executor REXX
- RubyHOT
- Ruby on RailsHOT
- SAP PowerBuilder
- SAS Data Integration Studio
- ScalaHOT
- SeleniumHOT
- SMSi Twister Data Integrator
- Spring FrameworkHOT
- SwiftHOT
- Talend Open Studio
- Unified modeling language UMLHOT
- VMWareHOT
- ADO.NET
- Altova MapForce
- Amazon DynamoDBHOT
- Amazon Elastic Compute Cloud EC2HOT
- Amazon Kinesis
- Amazon RedshiftHOT
- Amazon Web Services AWS softwareHOT
- Apache Avro
- Apache CassandraHOT
- Apache Flume
- Apache HadoopHOT
- Apache Hbase
- Apache HiveHOT
- Apache HTTP ServerHOT
- Apache Oozie
- Apache PigHOT
- Apache SolrHOT
- Apache Sqoop
- Apatar
- ASG Technologies ASG-Zeke
- Blackbaud The Raiser's Edge
- Blackboard software
- BMC Software Change Manager
- CA Erwin Data Modeler
- CA IDMS
- CA Technologies ERWin Data Modeler
- Catalog navigation software
- Cloudera Impala
- Cluster server software
- Coglin Mill RODIN
- Concurrency control software
- Couchbase Server
- Customer information control system CICS
- Data definition language DDL
- Data dictionary software
- Data entry softwareHOT
- Data manipulation language DML
- Data mapping software
- Data modeling software
- Data transformation services DTS software
- Data validation software
- Database design software
- ElasticsearchHOT
- Embarcadero Technologies DBArtisan
- FileMaker Pro
- Flat File Checker
- Google AnalyticsHOT
- Greenplum Database
- Hibernate ORM
- HiT Software Allora
- IBM Cognos ImpromptuHOT
- IBM DB2
- IBM Informix
- IBM InfoSphere Warehouse
- IBM Interactive System Productivity Facility ISPF
- IBM Rational Data Architect
- IBM Rational System Architect
- Index tuning software
- Informatica Big Data
- Informatica PowerCenter
- Interface Computers Data Loader
- LexisNexis
- MapR Converged Data Platform
- MariaDB
- Micosoft SQL Server Analysis Services SSAS
- Microsoft AccessHOT
- Microsoft SQL ServerHOT
- Microsoft SQL Server Reporting ServicesHOT
- MicroStrategyHOT
- MongoDBHOT
- Multidimensional Expressions MDX
- MySQLHOT
- NoSQLHOT
- Object database management system ODBMS
- Oracle Business Intelligence Enterprise EditionHOT
- Oracle Eloqua
- Oracle Enterprise Manager
- Oracle Enterprise Manager Cloud Control
- Oracle Golden Gate
- Oracle JDBCHOT
- Oracle Migration Workbench
- Oracle PL/SQLHOT
- Oracle Real Application Cluster RAC
- Oracle Reports
- Oracle softwareHOT
- Oracle SQL Loader
- Oracle SQL Plus
- Pentaho Kettle
- PostgreSQLHOT
- Qlik Tech QlikViewHOT
- Quest Central
- Quest SharePlex
- Rapid-I RapidMiner
- ReCrystallize Crystal Reports
- Relational database management softwareHOT
- Salesforce softwareHOT
- SAP Adaptive Server Enterprise
- SAP Crystal ReportsHOT
- SAP PowerDesigner
- SAP Replication Server
- Scriptella
- SentryOne SQL Sentry
- Structured query language SQLHOT
- TableauHOT
- Talend Big Data Integration
- Talend Data Fabric
- Teradata Active Enterprise Data Warehouse
- Teradata DatabaseHOT
- Transact-SQLHOT
- Visual Paradigm DB Visual ARCHITECT
- WisdomForce DatabaseSync System
- Adobe Systems Adobe AcrobatHOT
- Apache Subversion SVNHOT
- Atlassian JIRAHOT
- GitHOT
- IBM Content Manager
- Ansible softwareHOT
- Apache Mahout
- ConfluenceHOT
- Google DriveHOT
- Microsoft OfficeHOT
- Microsoft ProjectHOT
- Microsoft SharePointHOT
- Oracle Primavera Enterprise Project Portfolio ManagementHOT
- Apple macOSHOT
- BashHOT
- C shell
- Cisco IOS
- DOS shell script
- Hewlett Packard HP-UX
- IBM AIX
- Job control language JCL
- KornShell
- LinuxHOT
- Microsoft WindowsHOT
- Microsoft Windows ServerHOT
- Oracle SolarisHOT
- Perl shell
- Red Hat Enterprise LinuxHOT
- Shell scriptHOT
- Ubuntu
- UNIXHOT
- UNIX ShellHOT
- Application server software
- DockerHOT
- GitHubHOT
- Oracle Application Server
- Oracle WebLogic ServerHOT
- Red Hat OpenShiftHOT
- Red Hat WildFlyHOT
- Skype
- Spring BootHOT
- Autodesk RevitHOT
- CA Easytrieve Report Generator
- Epic SystemsHOT
- IBM SPSS StatisticsHOT
- Infobright Community Edition ICE
- MinitabHOT
- Safe Software FME
- SASHOT
- StataCorp Stata
- Test data generator software
- The MathWorks MATLABHOT
- Cisco Systems Webex
- ESRI ArcGIS softwareHOT
- Geographic information system GIS softwareHOT
- Google Meet
- IBM NotesHOT
- LogMeIn GoToMeeting
- LogMeIn GoToWebinar
- Microsoft ExchangeHOT
- Microsoft OutlookHOT
- Database security software
- Encryption software
- McAfee
- SymantecHOT
- Virtual private networking VPN softwareHOT
- IBM Power Systems software
- Splunk EnterpriseHOT
- NagiosHOT
- Redgate SQL Server
- SolarWinds
- WiresharkHOT
- Zabbix
Certifications

Licensing

Related Programs

Clicking on the Degree programs in the list below will take you away from the Careers page.
Purpose: The curriculum is designed primarily for students who wish to transfer to a four-year college or university to complete a baccalaureate degree in computer science. The curriculum emphasizes the study of the science of computing and the use of computing in a scientific setting.
Purpose: This curriculum is designed for those who seek employment in the field of Cybersecurity (information assurance), for those who are presently in IT or a security field and who desire to increase their knowledge and update their skills, and for those who must augment their abilities in other fields with knowledge and skills in information security. The curriculum is mapped to the NSA/DHS Knowledge Units necessary for NOVA's designation as a Center of Academic Excellence.
Purpose: This curriculum is designed for those who seek employment in the field of information technology, for those who are presently in that field and who wish to increase their knowledge and update their skills, and for those who must augment their abilities in other fields with knowledge and skills in information technology.
Credit for Prior Learning: Students in this program may be eligible for credit for prior learning. See an academic advisor or counselor for further information.
Purpose: This curriculum is designed for those who seek employment in the field of cloud computing, for those who are presently in that field and who desire to increase their knowledge and update their skills, and for those who must augment their abilities in other fields with knowledge and skills in cloud computing.
Credit for Prior Learning: Students in this program may be eligible for credit for prior learning. See an academic advisor or counselor for further information.
Purpose: This curriculum is designed for persons who plan to transfer to a four-year college or university to complete a baccalaureate degree program in information technology.
Purpose
Prepares students for entry-level positions or transfer pathways in computing, software development, and artificial intelligence. Students gain foundational programming, data structures, and algorithmic problem-solving skills with optional specialization in General CS, AI, or Data Science & Machine Learning.Purpose: This program is designed as an enhanced competency module to provide expertise in security to networking specialists. This curriculum will prepare networking specialists for employment as network security specialists or Internet security specialists. This program also helps prepare students for the Security+ and the CISSP certification exams.
Purpose: This program is designed to prepare students for entry-level employment in data centers or companies that support data center function as a technician, operator and/or technologist. Coursework will prepare students to earn the DICSI Installer 2 (Fiber Optic) and OSHA 10 industry credentials.
Recommended prerequisites: There are no required prerequisites for this certificate. It is recommended that the student possess a proficiency in high school English, high school algebra and geometry, and possess the ability to utilize hand tools and instrumentation.
Purpose: This program prepares the student to design and implement traditional/legacy stand-alone and client-server applications using procedural and object-oriented development techniques. Upon completion, graduates are prepared to study for one of the following industry certifications: MCP-Programming or the Sun Certified Programming for Java 2.
Purpose: This program is designed to provide students with skills that support the newest capabilities and advances in digital data analytics. These new features in digital data analytics technology enable the data analyst to collect, analyze and make data accessible for making business decisions. This program focuses on training data analytics specialists who can provide these advantages to their employers and stay on the leading edge of technology. Upon completion, graduates are prepared to study for data analytics exams such as CompTIA Data+, Microsoft Certified: Data Analyst Associate and Google Data Analytics Certificate. Credit for Prior Learning: Students in this program may be eligible for credit for prior learning. See an academic advisor or counselor for further information.
Purpose: This curriculum is designed for those who seek employment in the field of cloud computing, for those who are presently in that field and who desire to increase their knowledge and update their skills, and for those who must augment their abilities in other fields with knowledge and skills in cloud computing.
Credit for Prior Learning:Students in this program may be eligible for credit for prior learning. See an academic advisor or counselor for further information.
Purpose: This program is designed to provide students with skills that support the newest capabilities and advances in database technology. These new features in database technology enable databases to increase in scale and provide higher security and greater reliability. This program focuses on training database technologists who can provide these advantages to their employers and stay on the leading edge of database technology. Upon completion, graduates are prepared to study for some of the exams for the Oracle Database Administrator Certified Associate.
Credit for Prior Learning: Students in this program may be eligible for credit for prior learning. See an academic advisor or counselor for further information.
Purpose: This program prepares students for entry-level employment in data centers and related industries that require technicians/technologists trained in engineering technology, information technology, fiber optics, electronics, and data processing. Coursework will prepare students to earn the A+ Hardware, A+ Software, Network Troubleshooting, ETA FOI (Fiber Optic), and OSHA 10 industry credentials. Recommended prerequisites: There are no required prerequisites for this certificate. It is recommended that the student possess proficiency in high school English, high school algebra, and geometry and possess the ability to utilize hand tools and instrumentation.
Purpose: This program is designed for individuals seeking employment in a technical support center and for those persons employed who wish to update their skills in the help desk field. This curriculum will prepare students for employment as help desk specialists/technicians, desktop support specialists, and technical support specialists. Upon completion, graduates are prepared to study for the A+ Software, A+ Hardware, Network+, Security+ and AWS Certified Cloud Practitioner exams.
Credit for Prior Learning: Students in this program may be eligible for credit for prior learning. See an academic advisor or counselor for further information.
Purpose:This program is designed for individuals seeking employment in either a mobile application software development firm or large organization with a mobile application development team as well as for those persons already employed who wish to update their skills in mobile application development and testing. This curriculum will prepare students for employment as junior mobile application developers as well as quality assurance test engineers for native mobile applications. Upon completion, graduates are prepared to study for the Google Associate Android Developer certification.
Computer Science courses required for the Computer Science degree are available at the Chesapeake and Virginia Beach campuses.
Admission to the Engineering program requires satisfactory completion of the following high school units or their equivalents: four units of English; four units of mathematics (two units of algebra, one unit of plane geometry, one unit of advanced mathematics or trigonometry and solid geometry); one unit of laboratory science; and one unit of social studies.
Students desiring to enter the A.S. in Engineering program must provide proof of having a strong foundation in math and science and be eligible to take ENG 111. Additional information is available online at tcc.edu (search keyword "Engineering").
Engineering courses required for the Engineering degree are available at the Chesapeake and Virginia Beach campuses.
TCC is an Oracle Academic Initiative (OAI) Partner and an authorized Oracle training site. The courses in this program prepare students for the examinations leading to Oracle Certified Associate (OCA) and Oracle Certified Professional (OCP) industry certifications.
TCC is an Oracle Academic Initiative (OAI) Partner and an authorized Oracle training site. The courses in this program prepare students for the examinations leading to Oracle Certified Associate (OCA) and Oracle Certified Professional (OCP) industry certifications.
The courses in this program prepare students for the examinations leading to industry certifications as a Cisco Certified Networking Associate (CCNA).