p.p1 verification of extract, transform, and load operations.Install,

p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px ‘Helvetica Neue’; color: #454545}
p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px ‘Helvetica Neue’; color: #454545; min-height: 14.0px}
p.p3 {margin: 0.0px 0.0px 2.0px 0.0px; font: 14.0px ‘Helvetica Neue’; color: #454545}
li.li1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px ‘Helvetica Neue’; color: #454545}
span.s1 {text-decoration: underline ; color: #e4af0a}
span.s2 {color: #e4af0a}
span.s3 {font: 10.0px Menlo}
span.s4 {font: 12.0px ‘Helvetica Neue’; color: #e4af0a}
ul.ul1 {list-style-type: disc}

A database administrator (DBA) directs or performs all activities related to maintaining a successful database environment. Responsibilities include designing, implementing, and maintaining the database system; establishing policies and procedures pertaining to the management, security, maintenance, and use of the database management system; and training employees in database management and use.

We Will Write a Custom Essay Specifically
For You For Only $13.90/page!

order now

In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for reporting and data analysis, and is considered a core component of business intelligence. DWs are central repositories of integrated data from one or more disparate sources.

A database administrator’s responsibilities can include the following tasks:13

Installing and upgrading the database server and application tools.Allocating system storage and planning future storage requirements for the database system.Modifying the database structure, as necessary, from information given by application developers.Enrolling users and maintaining system security.Ensuring compliance with database vendor license agreement.Controlling and monitoring user access to the database.Monitoring and optimizing the performance of the database.Planning for backup and recovery of database information.Maintaining archived data.Backing up and restoring databases.Contacting database vendor for technical support.Generating various reports by querying from database as per need.Managing and monitoring data replication

Data warehouse administrators are responsible for the day-to-day activities of running a computer data warehouse
Data warehouse administrators generally serve as supervisors within a data warehouse and oversee other technicians to ensure that everything runs smoothly.Administer data warehouse systems including maintenance and verification of extract, transform, and load operations.Install, configure, troubleshoot, and maintain data warehouse systems.Handle customer requests for querying information.

Datawarehouse administrator roles and 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