Hello every one...May i know what is the difference between Data Base Administrator and Data Base Developer...? which one is the best field..?
The database administrator (DBA) should know something of database design, and in a small shop the DBA might handle both the administration and the data design. But since both areas (database administration and database design) require a lot of different and extensive knowledge and experience, best results can be had when there are experts in both areas. The DBA will work closely with the system administrator and may in fact also be an SA. The database designer will work closely with the software developers, as the data structure is integral to the software application. Of course, the database administrator and the database designer must coordinate with each other throughout the project. The DBA works with the RDBMS (relational database management system) itself and should know how to install and configure the RDBMS application. The DBA will work with the SA on tuning the system to best support the database engine and the database usage. The DBA and SA will work on sizing, storage, and backup management. The DBA is ultimately responsible for backups and everything else to do with data integrity (at the database level). The DBA will monitor data handling operations and either make database-level changes to improve performance or, through analysis, capture information to pass back to the data designer or development staff for their use in improving their usage of the database. The database designer should understand something of software development and applications structure. The designer will learn from the applications designers the data types, quantities, relationships, and desired operations (searches, sorts, updates, etc.) and work with the developers to design a structure/schema that will meet the requirements of the software application in terms of function and performance and at the same time assure data integrity. The designer will be considering matters such as unique keys, primary and foreign keys, data types, counters, naming, table relationships, search and sort elements, database normalization, search and sort efficiency, and data integrity.
hi seotomocthomas, A database developer writes and modifies databases. Data in a database can be reorganized, dispersed, and accessed in a number of ways. Databases are important to companies and organizations, because they contain records or files, such as sales transactions, product catalogs and inventories, and customer profiles. A database administrator (DBA) is responsible for the performance, integrity and security of a database. Additional role requirements are likely to include planning, development and troubleshooting. The work of a database administrator (DBA) varies according to the nature of the employing organisation and the level of responsibility associated with the post. The work may be pure maintenance or it may also involve specialising in database development.