What skills are requied to become a Oracle DBA ?

	What skills are requied to become a Oracle DBA ? I am from Electronics background and working as a trainer in a Pvt company but now I want to change my career to IT field. I am having some basic knowledge of SQL programming, that's why i decided to go for a Oracle DBA. Is knowledge of LINUX is must for a DBA? Asked By: Naveen Gupta - 9/8/2012

Best Answer - Chosen by Asker
A number of Oracle professionals mistakenly believe that the Oracle DBA skills are purely technical. In reality, the Oracle DBA must be an "ace" of all IT functions, because he or she has ultimate responsibility for overall database design, database implementation, backup, and recovery. Excellent communications as well as technical skills are required for the DBA's close involvement in all phases of project development. Also see my notes on: How to become an Oracle DBA Oracle DBA Job Responsibilities - database administrator job How to become an Oracle Guru How to become an Oracle Applications DBA. The fact computing resources are displacing human resources has a profound impact of the job duties of the Oracle DBA. We see that Oracle instances are becoming consolidated onto large server with 32 and 64 CPUs, and as a result less DBA staff is required. At the same time we see broadening DBA responsibility as the surviving DBAs need to manage schema design, security, and other mission-critical data management tasks. The surviving Oracle DBA’s will find themselves with many new job roles. They will be relieved of the tedium of applying patches to multiple servers, constantly re-allocating server resources, and tuning many servers. Remember, knowledge of Oracle database systems is not enough. An Oracle DBA must have skills in operating systems and computer-science theory. That is why employers like to hire Oracle DBAs who also have skills in computer science, information systems, or business administration. For an example of Oracle DBA job skills, see the BC job opportunities page. Other Oracle DBA job skills include the following: Excellent communication skills - The Oracle professional is the central technical guru for the Oracle shop. He or she must be able to explain Oracle concepts clearly to all developers and programmers accessing the Oracle database. In many shops, the Oracle DBA is also a manager and is required to have excellent communication skills for participating in strategic planning and database architectural reviews. Formal education – Many employers require Oracle professionals to have a bachelor’s degree in computer science or information systems. For advanced positions such as an Oracle DBA, many employers prefer a master’s degree in computer science or a master’s in business administration (MBA). Real-world experience - This requirement is the catch-22 for newbie’s who possess only an OCP certificate. A common complaint of people who have OCP certificates but no job experience is that they cannot get experience without the OCP, and they cannot get a job without experience. This is especially true in a tight job market. Knowledge of database theory - In addition to mastering the technical details required for the OCP exams, the successful Oracle professional must have an understanding of database and data warehouse design. This includes intimate knowledge of data normalization theory and knowledge of star schema design, as well as object-oriented modeling with Unified Modeling Language (UML) and knowledge of other database design methodologies such as CORBA and J2EE. Basic Oracle DBA Skills Because the Oracle professional is often called-upon to perform critical projects in the IT department, a broad background is often desirable. Much of this basic IT knowledge is taught in academic Computer Science and Information Technology programs. Non-Oracle job skills include: · System Analysis & Design skills – Many Oracle professionals must take an active role in the analysis and design of new database systems. Hence, knowledge of data flow diagrams, data dictionary techniques, CASE tools, Entity-relation modeling and design techniques, enhance the Oracle professional’s scope of ability. · Database Design skills – Many Oracle jobs require knowledge of database normalization theory, STAR schema design, and data modeling techniques. · Physical Disk Storage skills – Understanding of disk hardware architecture, RAID implementation, cache controllers, and disk load balancing are beneficial to any Oracle professional. · Data Security skills – An understanding of relational database security including role-based security is useful, especially for US Government positions. · Backup and Recovery skills – Many backup and recovery methods involve third-party software (Veritas, Legato, ADSM), and the candidate should have real-world experience implementing backup and recovery methods. · Change Control Management skills – In many cases the Oracle professional is charged with the task of implementing change control and insuring that changes to the production database are properly coordinated. Knowledge of third-party change control tools such as the UNIX Source Code Control System (SCCS) is beneficial. Answered By: Avishek - 9/11/2012

Additional Answers ()

Sql Answered By: @nand - 9/10/2012

Good Knowledge of SQL is all what is needed. No need of linux knowledge. Answered By: sweetmulga - 9/8/2012

IMO yes, you need some knowledge of the operating system(s) on which Oracle databases are running. Most of the deployments are on Linux or Unix variants (AIX, Solaris, HP-UX, etc). But many are also on Windows. A DBA's job does not exist in isolation. As a DBA you will need to interact with the operating system when it comes to installing and configuring database environments. Answered By: kenzo2047 - 9/8/2012

Some of the people I've worked with in the field who were Oracle DBA's also had a solid Linux background. They were charged with not only maintaining the Oracle databases, but also managing the linux servers that hosted them. This is especially important when applying patches and troubleshooting server performance. I'm not saying you can't a DBA job without Linux knowledge. But it never hurts to learn a few more skills. Answered By: J P K - 9/8/2012

Submit your answer or comment to this question

Other Career Questions

	What are the jobs associated with the video game business? I'd like to get an education and career that has something to do with video games. Whether it be testing, programming, design, etc. I do not know of all the certain jobs you can get that would put me in the video game career direction. What are all of the jobs you know of and what are their differences? Also, what are a few good colleges for this career and what kind of degrees should I be getting? 4 answers - Asked By: GamerS - 1/18/2012

	What skills / software knowledge do I need for Graphic Design Jobs? I'm planning to study Illustrator and InDesign, but wondered if there are any other software applications I need to familiarise myself with in order to apply for most graphic design jobs, ie. Flash, Quark Express, and so on. 4 answers - Asked By: Dawn - 3/27/2009

	What education do i need to get a decent job in computer science? I am going to be a junior in high school, and i'm looking for colleges to attend that provide computer science-programming & design degrees. I have been searching and I'm still not for sure what to go into when i finish my education with computer science. 3 answers - Asked By: Jess - 6/12/2006


Content is not owned or controlled by Monster. Any content concerns should be addressed with Yahoo! Yahoo! Does not evaluate or guarantee the accuracy of any Yahoo! Answers content. Yahoo! Disclaimer.

Popular Questions

	Is this normal for an interviewer to do this? So today I went in for an interview and I was going in for the 2nd interview by the head chief executive. now this is where it got weird, so she asked me about my previous jobs and said how much she liked that product over that product. then she started talking about her daughter? an her divorce ...then how she didn't finish college because she was making more money doing what she did for this company ... then she talked about how her teenage daughter is a handful... I just played it cool thinking she was using some sort of psychology thing to trick me into saying something stupid. the interview ended and she seemed happy an I was escorted to the door... now I'm freaking confused? is this normal behavior for an executive? like it felt like she was going to burst into tears at one point and tell me her life problems... is this normal? was she trying to see how I react or something? 6 answers - Asked By: Clone - 11/7/2012

	How do I get a job with Dodgy work history and no experience? Basically- no degree, although I have tried completing one in the past and stopped because of physical and mental health issues which were overwhelming to deal with along with going to classes full time. I'm not stupid and I am quite articulate. I am 23 and have only worked for about two years retail in high school and stopped working to go to university. I worked a few months in 2010 retail after I dropped out but it was only a seasonal position, and the only reason why I have not been able to constantly work is because of mental health issues. I had also tried going back to community college during my free time since i left university in 2008/9 and I had panic attacks while in community college, which made my anxiety worse from then on. Well recently I met a good doctor and he prescribed me some meds that are stabilizing my moods and I feel the best I've felt in years, and I'm ready to work. Thing is, I don't know how to get a job now since I've spent literally years being depressed and anxious doing nothing. I don't really have anything to put on my resume, and I never finished my AA degree either. All I've done is cashiering and although I do the job well and I get promoted easily when I do these jobs because I'm a hard worker and I try to go above and beyond what they ask of me,which is the attitude I have no matter what kind of work I'm doing as long as I'm getting paid. But I hate cashiering because it's too easy and I want a job that is more interesting. Any suggestions for me on how to get a job that is NOT Retail with the type of background I have right now? I also realize I have to go to college to get certain types of jobs, I am talking about what I can do right here right now. 1 answer - Asked By: Alex Prieto - 10/14/2012

	Why honesty, hard work and dedication have no place at work? Recently I have overlooked for a project at work and I am unable to accept it why? I am hard working, dedicated, maintain a very professional decorum, very cordial with my colleagues and bosses, give respect to one and all. Still people who take the p***, argue with managers, gossip mongers have been selected for some very responsible positions at work. I seriously can't get my head around it why, why unprofessional people who have no work ethics being selected over me, whereas I have a track record of excellent performance and never shy away from any work my manager ask me to do? I am at my lowest point and not getting hold of my manager to ask the question why not me, why them who can't even bother? I am feeling like a complete loser, giving years to this place, building my performance, trust and this is how I get rewarded. Why my life is so shit, anything I wish for turns to dust? 1 answer - Asked By: network7 - 11/6/2012

	What do you say when they ask what you want to be paid? ? Wen you apply at a job and they ask how mch you want as a salary what do you say? 2 answers - Asked By: Colette - 11/24/2011

	I have applied for over 100 jobs I have gotten no calls for a job interview, what can i do? As stated in my question I've applied for multiple jobs and gotten no job interview, you name a place I've applied there. I've said i will work ridiculous hours from like 12am to 5am and nothing. I've said I am willing to work weekends public holidays everything and I have gotten nothing back I am so desperate for money it's not funny. 9 answers - Asked By: Jamie - 1/9/2012

	What to wear to a job interview VS a career fair? So I have a nice white button up shirt, business skirt and pants, and a suit jacket. I'm applying for a software development job and I'm very short and can look young so I'm trying to look adult, yet professional. I'm also attractive so I'm trying not to look too sexy. For the career fair I'm thinking of wearing just my nice shirt and a skirt with low heels. My reasoning being it's approachable and attractive without going overboard since the career fair hosts are mostly younger male recent grads. I want to be remembered but not intimidating. For my interviews I was thinking pants, suit jacket (power suit). My reasoning being it'll be older execs and HR people (mostly women) so less sexy with the pants but more powerful with the suit jacket. What do you think?! 2 answers - Asked By: Beast - 9/23/2012

	What is NOC Engineer ?. What are his responcibilites ? 1 answer - Asked By: vishal - 2/23/2006

	What questions should I ask at a job interview for a healthcare recruiter position? I have an interview tomorrow with a healthcare recruiting firm and I want to have a few good questions to ask about the job/industry, but it will be a new field for me and I'm not sure what to ask about. Any suggestions? 1 answer - Asked By: stephinrado - 5/8/2006

	How can l find a job in the pharmacitical field as a sales and marketing manager,in south africa? L want to study medicine and work as a doctor but l am limited due to luck of required monyes. however l swtched on to anther career but still within my career interests as a care giver, but this is somthing to do with sales and marketing in the pharmcitical industry. 2 answers - Asked By: tonnydanabwembya - 12/24/2005

	Job description of supply and logistics manager? I am applying for a job of supply and logistics manager so I need to know more about the this job 1 answer - Asked By: waelasfour - 6/19/2006

	I am a student who is working at Deloitte during this summer. What is the dress code during the summer? Being a student my budget is limited so any help regarding specific retail outlets to go to would be very helpful. I am working in downtown toronto for Deloitte (accounting firm) and the summers are very hot here in Canada. Any specific advice on what clothing items this MALE student should wear to work would be helpful. The dress code is "business casual". As if any student knows what that means. 2 answers - Asked By: kamol_yason - 5/3/2006

	What is the difference between a nurse practitioner and an ARNP? Is there any difference between a "nurse practitioner" and an "advanced registered nurse practitioner"? 1 answer - Asked By: lucysmom - 3/27/2006

	Why does NCO-RMH in Manila give delayed paychecks to their resigned employees. it's a call center company? I was told by the people in the HR department that our checks have to come from Pensylvannia. Does it normally take that long? I mean more than two months for a paycheck that i worked hard for.? 1 answer - Asked By: nightshades9678 - 8/28/2006

	I want to become an Escrow Officer, does anyone know how to go about it? What kind of training will I need? I know that Escrow is within Title industry in Texas. What would be the best way to get my foot in the door. I am assuming I will have to start as an Escrow assistant and work my way up, but I would really like to find out more about this career path. How does an officer usually get licensed? Are there classes we need to take and exam to take? Any response is appreciated. 2 answers - Asked By: schang25 - 2/10/2006

	I want to become an events/party planner. Does anyone know how I would begin my own business in this field? I am in the process of planning my own wedding and I am having a fantastic time doing so. I have always enjoyed planning things: group vacations for my friends and I, road trips, etc... I could be described as a slight control freak and I am a perfectionist. I know I would exceed, and enjoy my career, if I were to make this a possibility. How do I do it? How do I get my name out there? How much do event planners charge for their services? I have a lot of questions, and hope that people who are self employed would be able to give me some pointers on getting my business up and running. Thank You in advance for your time and help. 2 answers - Asked By: Careerdriven - 4/24/2006

	Debenhams job application/interview help? I'm applying online for a job at Debenhams. It's just a temporary part time job but I have no previous retail experience, just in customer service, and I am finding some of the questions rather difficult. Our commitment to training and development encourages our people to grow their futures with us. If successful in joining our team, how will you become an expert at what you do? and At Debenhams, our people make all the difference to our customers. If you were a Stock Movement Adviser with us, how would our customers know that you are focused on their individual shopping experience? Any help in answering these questions would be greatly appreciated, many thanks! 1 answer - Asked By: Mac - 9/7/2012

	What does marketing communications means to a manager? 1 answer - Asked By: Gotti girl - 7/23/2006

	How much does an Electrical Engineer make? I'm thinking of completing an Electrical Engineering degree and was wondering what people are making just out of college and those that have been in the field 5+ yrs. The main careers I am looking at are Design Engineer and Technical Sales Engineering. Any input from people with those jobs would be great! 3 answers - Asked By: MacDadRaj - 3/23/2006

	Professionally I am an "Accountant", what is the better course for me? I am 25 years old, resides at Mumbra. Working at Vikhroli in a Pvt. Ltd. Co. as a "Sr. Accountant". My duty hour is 9.00 a.m. to 6.00 p.m. and I draw a salary of Rs. 8,000/- only & I want to know is there any updated courses which is related to my profession and which is not so expensive and has a demand. Please advice me. 2 answers - Asked By: ammu - 1/27/2007

Monster Communities

Teaching Community: Where teachers meet and learn.
ArtBistro: Create and connect.
Excelle: Networking for the career-minded woman.
Nursing Link: Where nurses call the shots.
More Monster Communities

Monster Partners

Scholarships: Scholarships, financial aid and more ways to pay for school.
Education.org: Find top campus and online degree programs.
Military.com: Military portal for the US Army, Navy, Air Force, Marine Corps and Coast Guard.
Financial Aid: Scholarships & financial aid.
Staffing for Government Jobs: Staffing and hiring solutions for federal government agency jobs.
More Monster Partners

Job Hunt Strategy

Six Ways to Make a Recruiter Hate You

If you want to blow your chances with recruiters -- and, by extension, with the companies they work for -- here are six perfect ways to do so.

Resumes & Cover Letters

Rev Up Your Resume to Relocate

Hoping to relocate? Get the ball rolling on landing the right job in the right location with these expert resume and cover letter tips.

Interviewing

100 Potential Interview Questions

Interview questions can run the gamut. You probably won't face all 100 of these, but you should still be prepared to answer at least some of them.

Salary & Benefits

10 Questions to Ask When Negotiating Salary

Most of us aren't natural negotiators, but asking these 10 questions during salary negotiations can help you get everything you deserve.

Attracting Candidates

Facebook for Employers: Make Friends, Not Fans

Recruiting? Go where the talent is. See why recruiters have befriended social networks.

Employee Sourcing

Employment Index

November Monster Employment Index Grows 13% Year-Over-Year, Tenth Consecutive Month of Positive Annual Growth.

Interviewing Candidates

Improving Interview Skills: Learn from the Experts

What’s the key to a great interview? According to experts: Practice, practice, practice.

Workforce Planning

Enhance your Small Business Marketing Strategy with Social Media

Social media. It’s everywhere. But how can it help you? Learn how to utilize social media even monetize it.

For Seekers

Campus and Online Degrees: Advance your career and earn more with an online degree.
Free Salary Wizard: What are you worth? Find out and negotiate a better salary.
Research Careers: Get information on jobs and career paths to help guide your choices
Questions & Answers: Find answers to all your career related questions -- powered by Yahoo! Answers
Resume Distribution Service: Our distribution service puts your resume right in the hands of recruiters.
Resume Writing Services: Our experts will craft a keyword-rich resume that stands out in the crowd.
More Career Resources

For Employers

Career Ad Network: Target your job posting to more candidates on thousands of websites.
Hire Right Background Checks: Explore our background check packages to improve the quality of your hires.
Hiring Home Page: Find the best candidates for your business with Monster hiring solutions.
Job Postings: Find the right solution for your hiring needs. Starting at $99.
Power Resume Search: Monster's new search technology precisely matches people with your jobs.
Resource Center: Find staffing insights, labor trends, HR best practices and more.
Target Post: Connect with skilled, hourly and administrative candidates for only $99.

Social Media

Jobs on Twitter: Find jobs in your area and industry.
Monster Careers: Tune into our career advice and discussions tackling a wide range of topics and industries.
Monster Corporate & PR: Stay up-to-date on the latest news. Get the 'Who', 'What', 'When', and 'Why' on all things Monster related.
Monster Customer Service: Got a Monster question? We've got the answer. Whether you're a job seeker or employer, we can help you find the answers you need.
Monster for Employers: Find advice on hiring.
Follow Us: Check out our many pages and stay connected with the latest industry news, events, career advice and job openings.

Are You An Employer?