Database Administration/Management |
Database Administration is the function of managing and maintaining database management systems (DBMS) software. Mainstream DBMS software such as Oracle, IBM DB2 and Microsoft SQL Server need ongoing management. As such, corporations that use DBMS software often hire specialized IT (Information Technology) personnel called Database Administrators or DBAs.Types of database administration. There are three types of DBAs:
- Systems DBAs (sometimes also referred to as Physical DBAs, Operations DBAs or Production Support DBAs)
- Development DBAs
- Application DBAs
Depending on the DBA type, their functions usually vary. Below is a brief description of what different types of DBAs do:
Systems DBAs usually focus on the physical aspects of database administration such as DBMS installation, configuration, patching, upgrades, backups, restores, refreshes, performance optimization, maintenance and disaster recovery.
Development DBAs usually focus on the logical and development aspects of database administration such as data model design and maintenance, DDL (data definition language) generation, SQL writing and tuning, coding stored procedures, collaborating with developers to help choose the most appropriate DBMS feature/functionality and other pre-production activities.
Application DBAs are usually found in organizations that have purchased 3rd party application software such as ERP (enterprise resource planning) and CRM (customer relationship management) systems. Examples of such application software includes Oracle Applications, Siebel and PeopleSoft (both now part of Oracle Corp.) and SAP. Application DBAs straddle the fence between the DBMS and the application software and are responsible for ensuring that the application is fully optimized for the database and vice versa. They usually manage all the application components that interact with the database and carry out activities such as application installation and patching, application upgrades, database cloning, building and running data cleanup routines, data load process management, etc. While individuals usually specialize in one type of database administration, in smaller organizations, it is not uncommon to find a single individual or group performing more than one type of database administration. |
| |
|
Our Solutions |
Software Quality Assurance and Validation
| |
Vigiboss has developed a range of software quality services to help your organization deliver defect-free software, |
| |
For More >> |
Software Application Development
| |
Customer-specific solutions design and development including CRM, SCM, ERP, content management systems, enterprise portals, |
| |
For More >> |
Software Web Design and Development
| |
Vigiboss creates web design for sites within a minimal time frame. We are ready to provide |
| |
For More >> |
Database Administration/Management
| |
Database administration is the function of managing and maintaining database management systems (DBMS) software. |
| |
For More >> |
Data Warehouse/Business Intelligence
| |
A data warehouse is a repository of an organization's electronically stored data. Data warehouses are designed to facilitate reporting and analysis
|
| |
For More >> |
Enterprise Resource Planning
| |
ERP, which is an abbreviation for Enterprise Resource Planning, is principally an integration of business management |
| |
For More >> |
Content Management Software
| |
A content management system (CMS) is a collection of procedures used to manage work flow in a collaborative environment |
| |
For More >> |
Software Engineering Solutions
| |
Software Engineering Solutions (SCM) is the task of tracking and controlling changes in the software.
|
| |
For More >> |
Architecture/Technology
| |
Technical architecture defines the "technologies" that are required to support an organization's automation environment
.
|
| |
For More >> |
Project Management
| |
Project management is that discipline that employs skills and knowledge to achieve project goals through various project activities. |
| |
For More >> |
IT Consulting
| |
Is an umbrella term describing the entire field of consulting relating to technology; covering internet, hardware and software.
.
|
| |
For More >> |
|
|
