Oracle 雇佣或租用DBA(32页)+.ppt

Hiring (or being hired as) An Oracle DBAPresentation 66 Michael R. Ault Introduction The DBA market is being saturated with both jobs and candidates -- How do you match one to the other? The interview process is critical to hiring, or being hired as a DBA As a Senior Consultant for DMR-Trecom I have had to develop an interview strategy to separate the “wheat from the chaff” Topics of Discussion What is a DBA? What levels are there in the DBA job and what are their qualifications? Interview Tools Does certification mean anything? What Is A DBA?According to the DBA manual duties include: Installing and upgrading the ORACLE Server and application tools. Allocating system storage and planning future storage requirements for the database. Creating primary database storage structures (tablespaces) once developers have designed an application. What is a DBA? (cont.) Creating primary database objects (tables, views, indexes) once application developers have designed an application. Modifying the database structure, as necessary, from information given by application developers. Enrolling users and maintaining system security. What is a DBA (cont.) Ensuring compliance with Oracle License agreements. Controlling and monitoring user access to the database. Monitoring and optimizing the performance of the database. Planning for backup and recovery of database information. What is a DBA (cont.) Maintaining archived data on appropriate storage devices. Backing and restoring the database. Contacting Oracle Corporation for technical support Plus many other duties Distilled Version:To be a “Full Charge” DBA you must know: Installation Configuration management Security Monitoring and Tuning Backup and Recovery Trouble Shooting Vendor Interface Personality Traits of a Good DBAA good DBA exhibits: Self Confidence Curiosity Tenacity Tactful Self starter Detail oriented Trait One: Self ConfidenceWithout it: They will constantly ask about decisions both major and mi