Career Details
15-1242.00 - Database Administrators
Administer, test, and implement computer databases, applying knowledge of database management systems. Coordinate changes to computer databases. Identify, investigate, and resolve database performance issues, database capacity, and database scalability. May plan, coordinate, and implement security measures to safeguard computer databases.
Key Facts

Tasks

Core
- Develop standards and guidelines for the use and acquisition of software and to protect vulnerable information.
- Modify existing databases and database management systems or direct programmers and analysts to make changes.
- Test programs or databases, correct errors, and make necessary modifications.
- Plan, coordinate, and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
- Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems, such as the installation of new databases.
- Train users and answer questions.
- Specify users and user access levels for each segment of database.
- Develop data model describing data elements and how they are used, following procedures and using pen, template, or computer software.
- Review procedures in database management system manuals to make changes to database.
- Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.
- Write and code logical and physical database descriptions and specify identifiers of database to management system, or direct others in coding descriptions.
- Review workflow charts developed by programmer analyst to understand tasks computer will perform, such as updating records.
- Revise company definition of data as defined in data dictionary.
Generic
- 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.
- Provide technical support to junior staff or clients.
- Test changes to database applications or systems.
Supplemental
- Select and enter codes to monitor database performance and to create production database.
Knowledge

- 89%Knowledge of circuit boards, processors, chips, electronic equipment, and computer hardware and software, including applications and programming.
- 66%Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar.
- 65%Knowledge of transmission, broadcasting, switching, control, and operation of telecommunications systems.
- 62%Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications.
- 60%Knowledge of administrative and clerical procedures and systems such as word processing, managing files and records, stenography and transcription, designing forms, and other office procedures and terminology.
- 60%Knowledge of media production, communication, and dissemination techniques and methods. This includes alternative ways to inform and entertain via written, oral, and visual media.
- 59%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.
- 59%Knowledge of principles and methods for curriculum and training design, teaching and instruction for individuals and groups, and the measurement of training effects.
- 57%Knowledge of relevant equipment, policies, procedures, and strategies to promote effective local, state, or national security operations for the protection of people, data, property, and institutions.
- 55%Knowledge of principles and processes for providing customer and personal services. This includes customer needs assessment, meeting quality standards for services, and evaluation of customer satisfaction.
- 53%Knowledge of human behavior and performance; individual differences in ability, personality, and interests; learning and motivation; psychological research methods; and the assessment and treatment of behavioral and affective disorders.
- 52%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.
- 51%Knowledge of laws, legal codes, court procedures, precedents, government regulations, executive orders, agency rules, and the democratic political process.
- 50%Knowledge of raw materials, production processes, quality control, costs, and other techniques for maximizing the effective manufacture and distribution of goods.
Tools

- Desktop computers
- Mainframe computers
- Notebook computers
- Hard disk drives
- Redundant array of independent disks RAID systems
- Tape libraries
Technology

- Ab InitioHOT
- Delphi Technology
- Ellucian Banner ERPHOT
- Fund accounting software
- Informatica Corporation PowerCenterHOT
- Microsoft DynamicsHOT
- Microsoft Dynamics GPHOT
- NetSuite ERPHOT
- Oracle E-Business Suite Financials
- 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
- Database cloning software
- EMC NetWorker
- HP DataProtector
- IBM ADSTAR
- Oracle Data Guard
- Storage management software
- Systems and data disaster recovery software
- VERITAS NetBackup
- ADO.NET
- Amazon DynamoDBHOT
- Amazon Elastic Compute Cloud EC2HOT
- Amazon RedshiftHOT
- Amazon Web Services AWS softwareHOT
- Apache CassandraHOT
- Apache HadoopHOT
- Apache HiveHOT
- Apache HTTP ServerHOT
- Apache PigHOT
- Apache SolrHOT
- Apache SparkHOT
- Apache Sqoop
- ASG Technologies ASG-Zeke
- Blackbaud The Raiser's Edge
- Blackboard software
- BMC Software Change Manager
- CA Erwin Data Modeler
- CA IDMS
- Catalog navigation software
- Cluster server software
- 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
- Google AnalyticsHOT
- Greenplum Database
- Hibernate ORM
- IBM Cognos ImpromptuHOT
- IBM DB2
- IBM Informix
- IBM Interactive System Productivity Facility ISPF
- IBM Rational Data Architect
- Index tuning software
- Informatica Big Data
- LexisNexis
- MapR Converged Data Platform
- MariaDB
- Micosoft SQL Server Analysis Services SSAS
- Microsoft AccessHOT
- Microsoft SQL ServerHOT
- Microsoft SQL Server Reporting ServicesHOT
- MicroStrategyHOT
- MongoDBHOT
- 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 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
- ReCrystallize Crystal Reports
- Relational database management softwareHOT
- Salesforce softwareHOT
- SAP Adaptive Server Enterprise
- SAP Crystal ReportsHOT
- SAP Replication Server
- SentryOne SQL Sentry
- Structured query language SQLHOT
- TableauHOT
- Teradata Active Enterprise Data Warehouse
- Teradata DatabaseHOT
- Transact-SQLHOT
- Visual Paradigm DB Visual ARCHITECT
- Adobe Systems Adobe Dreamweaver
- Adobe Systems Adobe Flash
- Microsoft ExcelHOT
- Microsoft PowerPointHOT
- Microsoft Publisher
- Microsoft VisioHOT
- Microsoft WordHOT
- Advanced business application programming ABAPHOT
- AJAXHOT
- Apache AntHOT
- Apache GroovyHOT
- Apache KafkaHOT
- Apache Maven
- Apache StrutsHOT
- Apache TomcatHOT
- Atlassian BambooHOT
- Backbone.jsHOT
- BMC Software Control-M
- C
- C#HOT
- C++HOT
- Cascading Style Sheets CSSHOT
- Chef
- 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
- 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 Designer
- Oracle Fusion MiddlewareHOT
- Oracle JavaHOT
- Oracle JavaServer Pages JSPHOT
- Perforce Helix software
- PHP: Hypertext PreprocessorHOT
- Practical extraction and reporting language PerlHOT
- Prolog
- PuppetHOT
- PythonHOT
- RHOT
- Red Hat Ansible Engine
- Restructured extended executor REXX
- RubyHOT
- Ruby on RailsHOT
- Salesforce VisualforceHOT
- SAP PowerBuilder
- ScalaHOT
- SeleniumHOT
- Spring FrameworkHOT
- SwiftHOT
- Unified modeling language UMLHOT
- VMWareHOT
- Ansible softwareHOT
- Apache Mahout
- ConfluenceHOT
- Human resource management software HRMS
- Marketo Marketing AutomationHOT
- Microsoft OfficeHOT
- Microsoft ProjectHOT
- Microsoft SharePointHOT
- Oracle Learning Management
- Oracle Primavera Enterprise Project Portfolio ManagementHOT
- Oracle TaleoHOT
- Apache Subversion SVNHOT
- Atlassian JIRAHOT
- GitHOT
- Apple macOSHOT
- BashHOT
- DOS shell script
- Hewlett Packard HP-UX
- Job control language JCL
- Kornshell
- LinuxHOT
- Microsoft WindowsHOT
- Microsoft Windows ServerHOT
- Oracle SolarisHOT
- Red Hat Enterprise LinuxHOT
- Shell scriptHOT
- Ubuntu
- UNIXHOT
- UNIX ShellHOT
- Autodesk RevitHOT
- CA Easytrieve Report Generator
- Dassault Systemes CATIAHOT
- Epic SystemsHOT
- IBM SPSS StatisticsHOT
- MinitabHOT
- Safe Software FME
- SASHOT
- StataCorp Stata
- Supervisory control and data acquisition SCADA softwareHOT
- 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
- Computer based training software
- Nearpod
- Database security software
- Encryption software
- McAfee
- SymantecHOT
- Virtual private networking VPN softwareHOT
- DockerHOT
- GitHubHOT
- Oracle WebLogic ServerHOT
- Red Hat OpenShiftHOT
- Red Hat WildFlyHOT
- Skype
- Spring BootHOT
- 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.
The Bachelor of Professional Studies (BPS) in Cybersecurity degree program provides combines highly technical, hands-on curriculum in labs and virtual environments with invaluable collaboration with government agencies, private companies and the military experts fighting every day on cyberspace’s front lines.
The major puts students in the middle of the exploding information revolution where they study technological advances such as object-oriented software, communication networks, multimedia systems, information security and artificial intelligence. Students will learn about computing technologies used by today’s professionals and how to use these technologies to solve real-world problems. Students will learn to analyze problems, design solutions, implement solutions using multiple computing technologies, test and install those solutions, and communicate those solutions to others in written and verbal presentations.
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 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 curriculum is designed to prepare individuals to work with young children in safe and healthy environments that are supportive of children's individual physical, cognitive, and social-emotional development. Job opportunities include employment as assistant teachers, teachers, group leaders, or family child care providers in programs for young children.
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: The curriculum is designed for individuals who seek full-time employment in the graphic design field. Job opportunities include graphic designer, art director, illustrator, production artist, package designer and web content developer, among others in the graphic design marketplace.
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 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 based on the standards of the American Council on Exercise (ACE) and prepares students to become knowledgeable fitness professionals in health clubs, recreation departments, and fitness facilities in private, commercial, corporate, or government settings. Emphasis is placed on preparing students to sit for a nationally recognized certification exam in Personal Training.
PurposeThe curriculum is designed to prepare students for diverse career options within the field of photography and digital imaging. Coursework will stress both technical and aesthetic elements, enabling students to solve a wide range of visual problems with imagination and originality.
The computer science curriculum integrates theory and practice by including foundational topics that underpin the discipline and by emphasizing the value of abstraction and good engineering design in project development. Elective courses provide an opportunity for deeper study in areas of interest. An important part of the curriculum is the inclusion of professional practice activities such as research experience, teamwork, oral communication and technical writing, and project development. While being sensitive to changes in technology, the curriculum also seeks to prepare students for lifelong learning to enable them to meet future challenges.
A student expecting to major or minor in computer science should enroll in CSCI 111-CSCI 112 in the first year. If credit is given for one or both of these courses, then a student should enroll in CSCI 211 or CSCI 210. A student interested in future graduate studies should complete the two calculus sequences, MATH 131-MATH 132. A student interested in computer hardware is encouraged to select PHYS 210 to meet one of the collegiate science requirements.
Cybersecurity is a computing-based discipline that involves the creation, operation, analysis, and testing of secure systems, networks, and applications to protect against a variety of digital threats. The cybersecurity curriculum is based on national standards and builds on a computer science foundation. The curriculum emphasizes four main areas of cybersecurity: information security, software security, network security, and system security. Mindful of the rapid changes in technology, the curriculum seeks to prepare students for lifelong learning to enable them to meet future challenges. A student expecting to major in cybersecurity should complete CSCI 111 and CSCI 112 in the first year.
Capstone experiences offered by the Department of Computer Science include CSCI 401, CSCI 403, and CSCI 485, all of which are available to majors in cybersecurity.
Cybersecurity is a computing-based discipline that involves the creation, operation, analysis, and testing of secure systems, networks, and applications to protect against a variety of digital threats. The cybersecurity curriculum is based on national standards and builds on a computer science foundation. The curriculum emphasizes four main areas of cybersecurity: information security, software security, network security, and system security. Mindful of the rapid changes in technology, the curriculum seeks to prepare students for lifelong learning to enable them to meet future challenges. A student expecting to major in cybersecurity should complete CSCI 111 and CSCI 112 in the first year.
Capstone experiences offered by the Department of Computer Science include CSCI 401, CSCI 403, and CSCI 485, all of which are available to majors in cybersecurity.
The computer science curriculum integrates theory and practice by including foundational topics that underpin the discipline and by emphasizing the value of abstraction and good engineering design in project development. Elective courses provide an opportunity for deeper study in areas of interest. An important part of the curriculum is the inclusion of professional practice activities such as research experience, teamwork, oral communication and technical writing, and project development. While being sensitive to changes in technology, the curriculum also seeks to prepare students for lifelong learning to enable them to meet future challenges.
A student expecting to major or minor in computer science should enroll in CSCI 111-CSCI 112 in the first year. If credit is given for one or both of these courses, then a student should enroll in CSCI 211 or CSCI 210. A student interested in future graduate studies should complete the two calculus sequences, MATH 131-MATH 132. A student interested in computer hardware is encouraged to select PHYS 210 to meet one of the collegiate science requirements.
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.