Database AdministratorDatabase:It is a place where information is stored and organized in a way that makes easy to manipulate and retrieve. These databases can hold all sorts of information is known as data. Even statistical data can be stored in the databases. Database Administrations:Ensure the stability, performance, integrity, and security of databases. They are also responsible for reporting, integrating with other applications, and making sure of the integrity and accuracy of data across multiple systems. (or) a person who has central control of both the data and the programs that access those data. Role of the Database Administrator (DBA)A database administrator (DBA) is responsible for the planning, maintenance and development of a database. The database approach incorporates the following principles:• data remains consistent across the database;• data is clearly defined;• users access data concurrently, in a form that suits their needs;• there is provision for data security and recovery control (all data is retrievable in an emergency).Typical work activities The work of a database administrator (DBA) will vary according to the nature of the employing organization and the level of responsibility associated with the post. Some of the work may involve specializing in database development or pure maintenance. Responsibilities:• establishing the needs of users;• planning data flows for a new or revised database;• mapping out the ‘conceptual design’ for a planned database in outline;• refining the ‘logical design’ so that it can be translated into a specific data model;• further refining the ‘physical design’ to meet system storage requirements;• testing new systems;• maintaining data standards, including adherence to the Data Protection Act;• writing database documentation, including data standards, procedures and definitions for the data dictionary (‘metadata’);• controlling access permissions and privileges;• training users;• meeting users’ access requirements and resolving their problems;• ensuring that storage, archiving, backup and recovery procedures are functioning correctly;• capacity planning;• working closely with-IT project managers, database programmers and web developers; • providing technical support for outdated ‘legacy’ systems;• communicating regularly with technical, applications, and operational staff, to ensure the database integrity and security;• commissioning and installing new applications. Because of the increasing levels of hacking and sensitive nature of data stored, security has become an increasingly important aspect of the work.plan, design, create, operate, secure, monitor, and maintain databases DBA works with both users and programmers A data administrator is responsible for defining and implementing consistent principles for a variety of data issues, including setting data standards and data definitions; a nontechnical position. Data Warehouse:A single, complete and consistent store of data obtained from a variety of different sources made available to end users in a what they can understand and use in a business context. Data Warehouse AdministrationThis a new role this has sprung up, because of the growth in the data warehouses this person or people serve the purposes of the same kinds of roles as the DA and DVA roles in a regular database roles but the data ware house administrator has to emphasize the integration coordination of all the data across many data sources so this is a person that is doing a whole heck of a lot and has to coordinate and do all sorts of things this is not a simple role this is actually a combination of the data administrator and DBA role this person is typically doing a lot that engaged in political activity to this , that say it lightly so we’ve got situation or role here where this person needs a lot of soft and hard skills so they support DSS applications that manage the data warehouse growth , they established the service level agreements regarding data warehouses and data marts they handle a lot of things so the data warehouse administration is a new and complex role . Roles of Data WarehouseNumerous roles and responsibilities will need to be acceded to in order to make data warehouse efforts successful and generate return on investment. For the technical personnel (application programmer, system administrator, database administrator, data administrator), it is recommended that the following roles be performed full-time by dedicated personnel as much as possible and that each responsible person receive specific Data Warehouse training. The data warehouse team needs to lead the organization into assuming their roles and thereby bringing about a partnership with the business. Management also needs to make actionable plans of these directives and make sure the staff executes on them. Responsibilities:• Monitor all databases and resolve all performance issues in same.• Perform tests and maintain MS SQL Server databases in an MIS environment.• Administer databases and resolve all issues to ensure data accuracy.• Coordinate with business analysts and prepare design for systems.• Manage all architectural issues and recommend alternatives to same.• Administer databases and install required upgrades and patches.• Maintain all required documents for data warehouse.• Evaluate efficient working of project team and provide guidance on process methodology.• Develop and maintain standards of all data warehouse and ETL.• Ensure compliance to all specifications and documents all data warehouse administration activities.• Monitor ETL server and databases and ensure optimal performance.• Coordinate with Quality Assurance and Offshore ETL teams.• Schedule plans for all tasks and maintain an effective database.• Provide assistance to FSE and manage all Law enforcement requests.• Manage and collect all business metadata.• Manage all data integration points and confirm all dimensions. The Data Warehouse Database Administrator will translate the logical database design into a physically implementable design. The specific tasks are:• Deformalizing the models based on potential queries, reporting, and system feeds that will be generated from the tables• Implement, as necessary, some of the entities as domains rather than tables• The addition of timestamp and user ID columns to most tables to identify the person and the time of the row addition or change• The use of standard abbreviations in the table and column names• Assignment of data types, nullability, and defaults for each column• Creating the databases and database objects such as the tables, tablespaces, synonyms, views, triggers, stored procedures, defaults, domains, and indexes The Data Warehouse Database Administrator will maintain the tables as necessary for optimization. The specific tasks may include:• Periodic table reorganization• Structure update with change control The Data Warehouse Database Administrator will ensure recoverability of the Data Warehouse with minimal loss of information. Specific tasks include:• Extensive testing of the backup and recovery processes• Ability to recover databases within the service level agreement• Ability to articulate any data loss encountered • Ensure logging and recoverability of database updates since the last backup• Take frequent backups – full and incremental as needed• Frequent offsite storage of the latest full backup in the event of a natural disaster Representation from the Data Warehouse Database Administration staff will participate on the Decision support steering committee.If the Data Warehouse becomes as a distributed system, a synchronization effort may be needed. The Data Warehouse Database Administrator will be responsible for the metadata management infrastructure. Tasks will include:• Database maintenance for the database(s)• Installation of the repository software, if applicable• Front-end development• User training Only users approved by the data stewards will be granted security privileges on the Data Warehouse. The Data Warehouse Database Administrator will execute the grants or provide the ability for a central security group to do this. Specific tasks include:• Creating security profiles• Assuring new users are approved by the data steward(s)• Assuring new users have taken training• Granting privileges to the data stewards For data that is sourced for the Data Warehouse, the Data Warehouse Database Administrator will, if necessary, code and install the programs to load the data into the Data Warehouse.• The Data Warehouse Database Administrator is the point person for issues of performance within the Data Warehouse environment. Specific tasks follow:• Being first on call for performance issues from the user community• Setting up the governors on the database systems to stop runaway queries• Assist the user community in writing well-performing SQL• Route system and network performance issues to the responsible party• Spotting trends in queries and creating and maintaining summary tables for low-performing queries where possible• Making the end user query tool aware of the summary tables Occasionally, the most expedient way to create or restore consistency to the data in the Data Warehouse is to write insert, update, or delete statements against the database. As the in-house SQL expert, the Data Warehouse Database Administrator will perform these queries.