Q. i need to learn data recovery, but i need a good program too..
A. It depends on the type of data you are trying to recover. I had a bad experience last week where our exchange server database got corrupted and wouldn't mount. The backups were corrupted too.
I managed to get some pretty good results with products from Nucleusdatarecovery.org. Don't let the .org deceive you though... the tools aren't free. We managed to parse and recover quite a few mailboxes out of our 40+ GB database file.
First big lesson in data recovery is to BACK UP YOUR DATA. Regularly. Look up the Tao of Backup. Good advice, as long as you don't mind the marketing. As far as backup utilities go, Veritas is a good program for commercial use. For home use, I use Windows Live OneCare. It backs up most of my docs, settings, music, and other files that are really hard to replace.
I managed to get some pretty good results with products from Nucleusdatarecovery.org. Don't let the .org deceive you though... the tools aren't free. We managed to parse and recover quite a few mailboxes out of our 40+ GB database file.
First big lesson in data recovery is to BACK UP YOUR DATA. Regularly. Look up the Tao of Backup. Good advice, as long as you don't mind the marketing. As far as backup utilities go, Veritas is a good program for commercial use. For home use, I use Windows Live OneCare. It backs up most of my docs, settings, music, and other files that are really hard to replace.
What are the duties of a Database Administrator?
Q. I need to complete a Career report and need to interview a Database Administrator but not sure what questions to ask. Can anyone help me with this? Thanks.
A. Here are some of the duties go:
- establishing the needs of users;
- planning dataflows for a new or revised database;
- mapping out the 'conceptual design' for a planned database in outline;
- considering both 'back end' organisation of data and 'front end' accessibility for end users;
- 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.
AS for the questions, you will not be able to interview a DBA if you're not one. Anyways, the technical questions should be mostly related to the RDBMS which the interviewee is supposed to know. There are other generic questions that you can ask, but only the strictly technical ones related to the RDBMS which he will use will tell you how proficient he is and how well he knows the tricks to getting stuff done.
Anyways, here's a link to some of the technical questions you can ask:
http://vyaskn.tripod.com/iq.htm
http://www.techinterviews.com/?p=42
http://www.geekinterview.com/Interview-Questions/Oracle/Database-Administration
Hope this helps
- establishing the needs of users;
- planning dataflows for a new or revised database;
- mapping out the 'conceptual design' for a planned database in outline;
- considering both 'back end' organisation of data and 'front end' accessibility for end users;
- 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.
AS for the questions, you will not be able to interview a DBA if you're not one. Anyways, the technical questions should be mostly related to the RDBMS which the interviewee is supposed to know. There are other generic questions that you can ask, but only the strictly technical ones related to the RDBMS which he will use will tell you how proficient he is and how well he knows the tricks to getting stuff done.
Anyways, here's a link to some of the technical questions you can ask:
http://vyaskn.tripod.com/iq.htm
http://www.techinterviews.com/?p=42
http://www.geekinterview.com/Interview-Questions/Oracle/Database-Administration
Hope this helps
Can anyone tell me about database administrators and what they do?
Q. If anyone is an DBA (database administrator) please tell me how many years of school you went through, what classes you took, and if you enjoy doing it. I enjoy computers in every form of the sense, so please any input would be greatly appreciated.
A. A database administrator (DBA) is a person responsible for the design, implementation, maintenance and repair of an organization's database. They are also known by the titles Database Coordinator or Database Programmer, and is closely related to the Database Analyst, Database Modeler, Programmer Analyst, and Systems Manager. The role includes the development and design of database strategies, monitoring and improving database performance and capacity, and planning for future expansion requirements. They may also plan, co-ordinate and implement security measures to safeguard the database.Employing organizations may require that a database administrator have a certification or degree for database systems
The duties of a database administrator vary depending on job description, corporate and Information Technology (IT) policies and the technical features and capabilities of the DBMS being administered. They include disaster recovery (backups and testing of backups), performance analysis and tuning, data dictionary maintenance, and database design.
Roles of the DBA include:
Installation of new software â It is the job of the DBA to install new versions of DBMS software, application software, and other software related to DBMS administration. It is important that the DBA or other IS staff members test new software before it is moved into a production environment.
Configuration of hardware and software with the system administrator â In many cases the system software can only be accessed by the system administrator. In this case, the DBA works closely with the system administrator to perform software installations, and to configure hardware and software so that it functions optimally with the DBMS.
Security administration â One of the main duties of the DBA is to monitor and administer DBMS security. This involves adding and removing users, administering quotas, auditing, and checking for security problems.
Data analysis â The DBA analyzes data stored in the database and makes recommendations relating to performance and efficiency of that data storage. This includes the effective use of indexes, enabling "Parallel Query" execution, or other DBMS specific features.
Database design (preliminary) â The DBA can be involved at the preliminary database-design stages, eliminating many problems that might occur. The DBA knows the DBMS and system, can point out potential problems, and can help the development team with special performance considerations.
Data modeling and optimization â By modeling the data, it is possible to optimize the system layouts to take the most advantage of the I/O subsystem.
Responsible for the administration of existing enterprise databases and the analysis, design, and creation of new databases.
Data modeling, database optimization, understanding and implementation of schemas, and the ability to interpret and write complex Structured Query Language (SQL) queries.
Proactively monitor systems for optimum performance and capacity constraints.
Establish standards and best practices for SQL.
Interact with and coach developers in SQL scripting.
The duties of a database administrator vary depending on job description, corporate and Information Technology (IT) policies and the technical features and capabilities of the DBMS being administered. They include disaster recovery (backups and testing of backups), performance analysis and tuning, data dictionary maintenance, and database design.
Roles of the DBA include:
Installation of new software â It is the job of the DBA to install new versions of DBMS software, application software, and other software related to DBMS administration. It is important that the DBA or other IS staff members test new software before it is moved into a production environment.
Configuration of hardware and software with the system administrator â In many cases the system software can only be accessed by the system administrator. In this case, the DBA works closely with the system administrator to perform software installations, and to configure hardware and software so that it functions optimally with the DBMS.
Security administration â One of the main duties of the DBA is to monitor and administer DBMS security. This involves adding and removing users, administering quotas, auditing, and checking for security problems.
Data analysis â The DBA analyzes data stored in the database and makes recommendations relating to performance and efficiency of that data storage. This includes the effective use of indexes, enabling "Parallel Query" execution, or other DBMS specific features.
Database design (preliminary) â The DBA can be involved at the preliminary database-design stages, eliminating many problems that might occur. The DBA knows the DBMS and system, can point out potential problems, and can help the development team with special performance considerations.
Data modeling and optimization â By modeling the data, it is possible to optimize the system layouts to take the most advantage of the I/O subsystem.
Responsible for the administration of existing enterprise databases and the analysis, design, and creation of new databases.
Data modeling, database optimization, understanding and implementation of schemas, and the ability to interpret and write complex Structured Query Language (SQL) queries.
Proactively monitor systems for optimum performance and capacity constraints.
Establish standards and best practices for SQL.
Interact with and coach developers in SQL scripting.
Powered by Yahoo! Answers
