<Li> Development DBAs: 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 . </Li> <Li> Application DBAs: 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 . </Li> <P> 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 . </P> <P> The degree to which the administration of a database is automated dictates the skills and personnel required to manage databases . On one end of the spectrum, a system with minimal automation will require significant experienced resources to manage; perhaps 5 - 10 databases per DBA . Alternatively an organization might choose to automate a significant amount of the work that could be done manually therefore reducing the skills required to perform tasks . As automation increases, the personnel needs of the organization splits into highly skilled workers to create and manage the automation and a group of lower skilled "line" DBAs who simply execute the automation . </P>

How database management system is helpful in maintaining processing database in corporate industry