p.
p1 {margin: 0.0px 0.0px 10.0px 0.
0px; font: 11.0px ‘Times New Roman’; color: #000000; -webkit-text-stroke: #000000}p.p2 {margin: 0.0px 0.0px 10.0px 0.0px; font: 12.
0px ‘Times New Roman’; color: #000000; -webkit-text-stroke: #000000}p.p3 {margin: 0.0px 0.0px 0.
0px 0.0px; font: 11.0px ‘Times New Roman’; color: #000000; -webkit-text-stroke: #000000}p.p4 {margin: 0.0px 0.0px 0.
0px 0.0px; font: 11.0px ‘Times New Roman’; color: #000000; -webkit-text-stroke: #000000; min-height: 12.
0px}p.p5 {margin: 0.0px 0.0px 10.0px 0.0px; text-align: justify; font: 11.0px ‘Times New Roman’; color: #000000; -webkit-text-stroke: #000000}p.p7 {margin: 0.
0px 0.0px 0.0px 0.0px; text-align: justify; font: 11.
0px ‘Times New Roman’; color: #000000; -webkit-text-stroke: #000000}p.p8 {margin: 0.0px 0.0px 10.0px 0.0px; text-align: justify; font: 12.
0px ‘Times New Roman’; color: #000000; -webkit-text-stroke: #000000}p.p9 {margin: 0.0px 0.0px 0.0px 49.5px; font: 12.0px ‘Times New Roman’; color: #000000; -webkit-text-stroke: #000000; min-height: 15.
0px}p.p10 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.
0px ‘Times New Roman’; color: #000000; -webkit-text-stroke: #000000; min-height: 15.0px}p.p11 {margin: 0.0px 0.
0px 0.0px 40.5px; font: 11.0px ‘Times New Roman’; color: #000000; -webkit-text-stroke: #000000}p.
p12 {margin: 0.0px 0.0px 0.0px 40.5px; font: 11.0px ‘Trebuchet MS’; color: #000000; -webkit-text-stroke: #000000; min-height: 12.
0px}p.p13 {margin: 0.0px 0.0px 0.0px 0.0px; line-height: 18.
0px; font: 16.0px Arial; color: #222222; -webkit-text-stroke: #222222; background-color: #ffffff}p.p14 {margin: 0.0px 0.0px 0.0px 0.0px; line-height: 18.
0px; font: 12.0px ‘Times New Roman’; color: #222222; -webkit-text-stroke: #222222; background-color: #ffffff; min-height: 15.0px}p.p15 {margin: 0.0px 0.0px 10.0px 0.0px; text-indent: 36.
0px; font: 11.0px ‘Trebuchet MS’; color: #000000; -webkit-text-stroke: #000000; min-height: 12.0px}li.li1 {margin: 0.0px 0.
0px 10.0px 0.0px; font: 11.0px ‘Times New Roman’; color: #000000; -webkit-text-stroke: #000000}li.li3 {margin: 0.0px 0.0px 0.
0px 0.0px; font: 11.0px ‘Times New Roman’; color: #000000; -webkit-text-stroke: #000000}li.li6 {margin: 0.0px 0.0px 10.0px 0.
0px; text-align: justify; font: 11.0px ‘Trebuchet MS’; color: #000000; -webkit-text-stroke: #000000}li.li8 {margin: 0.0px 0.0px 10.0px 0.0px; text-align: justify; font: 12.0px ‘Times New Roman’; color: #000000; -webkit-text-stroke: #000000}span.
s1 {font-kerning: none}span.s2 {font: 10.9px Symbol}span.
s3 {font: 12.0px ‘Times New Roman’; font-kerning: none}span.s4 {font: 11.0px ‘Times New Roman’; font-kerning: none}span.s5 {font: 11.
0px Symbol}span.s6 {font: 12.0px ‘Times New Roman’; -webkit-text-stroke: 0px #222222}span.s7 {font: 12.
0px ‘Times New Roman’}span.s8 {font-kerning: none; background-color: #ffffff}ol.ol1 {list-style-type: decimal}ol.ol2 {list-style-type: lower-alpha}ul.
ul1 {list-style-type: disc}Database Administrator:Database administrator : A database administrator, known as DBA , Who has to maintain the data of the organization and provide security to the DB. This position in organization requires an skills on RDBMS and also strong skills on data base quires.The DB runs on the hardware platform so DBA should also known the installations and commands also.We Have Different Types Of DBA In Realtime :Administrative DBA: keeps up the servers and databases and keeps them running.
Stressed over fortifications, securities, patches and replications. Main activity is to maintaining the database and s/w program, but not really in developing. Development DBA: Development mostly into developing the sql , stored procedures. This is like a programmer but should concentrate on SQL.Hw should also known the DBA.Data architect: Architect who built the frame of the entire project and provides the problems to the solutions and and guides the his team.
Data warehouse DBA:The Data Warehouse DBA is who collects the all data and merges into one single files and resizes it.And also he will use some tools to clean up data and for also synchronization. Roles of Database administrator (DBA): The main roles of database administrator is to ensure the data is available, protected and easy to access.A DBA installs and configure of database. The system administrator sets up the hardware and deploy OS for the DB server, and then the DBA installs the database and configures it for the use. Every-time we usually get the update for s/w so it needs to be maintained.If there is a need of new servers we have to deploy all the data into it as like the old one.Data extraction: This mainly involves ETL tool which is Extract Transform Load, in organizations will get lots of data which is really nothing to use.
So what ETL does is it extract all the data from server and transform it into small pieces by deleting unnecessary spaces and files finally loads into new DB. -DBA needs to be specialized in handling the large amount of data ,because we usually get large amount of data in many forms like audio,vedio,images.-He needs to maintain the backup data in case of loss or damage.- it also involves the storing of data from hackers.-DBA has to provide the authentications for new employees only that way new employees in org can able to access the data.He should be aware of the capacity of the database that how much he should allocate tp different servers.DBA should always consider about the performance and maintain of the servers.and also have to take care of updates.
Definition and accountabilities:Exploration and product information technology is a distinctive division whose purpose is to provide digital capabilities through people, technologies and processes, to deliver the current organizational needs of the people and transformational opportunities to meet business objectives. This globally diverse team works together to plan and implement digital solutions for all kinds of E and P. The key accountabilities of a data warehouse administrator are towards continuous improvement, escalate and fix problems, communicating with the staff and customers, creating the future, minimal indulgences in legal commitments, making and keeping of good ones. It’s a physical repository where relational data are specifically organized to provide enterprise-wide, cleansed data in a standardized format.“The data warehouse is a collection of integrated, subject-oriented databases designed to support DSS functions, where each unit of data is non-volatile and is relevant to moment in time. Database Warehouse Administrator:Data warehouse administrator responsible for the activities data warehouse.
SQL,PLSQL is the main languages includes to code the DW and tasks includes saving, tracking ,changes, monitoring data systems.Has to monitor the data & activities in data warehouse. Administering warehousing services, including query services & services.Supporting the warehouse users.DIFFERENCES BETWEEN OF DATABASE ADMINISTRATOR & DATA WAREHOUSE ADMINISTRATOR:Database administrator:DBA manages data of users in an organization.His work is mot dependent DBMS.Responsible for creating elements, names and relationships with database .
Specification of organized data is being done hereSecurity and validation of DB.Reviewing the requirements and providing solutions.Code tables and passing the data into that .Data warehouse administrator;He ought to have the information of DBMS He should know how to create and looks after framework.
His work is subject to DBMS. Needs To store and deal with the data in the DB. Breaking down the information volumes and space necessity