10 Replies Latest reply on Jan 8, 2007 1:16 PM by 548119

    Change of Career : Need your kind advice/help

    542957
      Hi all,

      I need your help/advice in shaping up my career. I have 3+ yrs of experience in
      Backend Pl/Sql Development+Query Tuning Experience. I am a 9i Developer OCP + 9i DBA OCP. Now I want to become a full time Oracle DBA.

      My plan, as of now, is :
      - To do additional certifications (like 10g OCP Upgrade Exam)
      - Join some company as a Junior Oracle DBA here in Singapore and gain valuable Real time DBA work experience.

      1) Kindly please advice me regarding whether this plan is right/valid.
      2) Also I am worried regarding whether there will be growth in DBA field. In other
      words, 10 years from now, Will I still be a DBA or Is it possible to move into
      management positions like DBA Manager etc...

      Kindly please help me.

      Regards,
      Dinesh
        • 1. Re: Change of Career : Need your kind advice/help
          APC
          Now I want to become a full time Oracle DBA.
          Why? Not that there's anything wrong with being a DBA, it just requires a particular frame of mind.
          Join some company as a Junior Oracle DBA here in Singapore and gain
          valuable Real time DBA work experience.
          Generally it is easier to manouveure oneself into a DBA role with an existing employer than it is to get a new company to take one on without any real actual experience.
          10 years from now, Will I still be a DBA or Is it possible to move into
          management positions like DBA Manager etc.
          Partly that's up to you. In my experience people who tend to want to be DBAs are not the sort of people who want to be managers, and, quite frankly, this is generally just as well. However, the people who make great DBAs usually have aptitudes for team work, communication and the other soft kills which are necessary for other jobs too.

          Cheers, APC
          • 2. Re: Change of Career : Need your kind advice/help
            PAB
            then what is better , as plsql developer or as DBA?

            And how you differntiate both of them?

            I think Plsql developer must know some of task of DBA, what you say?

            Message was edited by:
            Pratik Brahmbhatt
            • 3. Re: Change of Career : Need your kind advice/help
              Nicolas Gasparotto
              then what is better , as plsql developer or as DBA?
              That depend for who.

              Nicolas.
              • 4. Re: Change of Career : Need your kind advice/help
                AlokKumar
                Well, it all depends, if you have sufficiend amount of experince as developer, then why thinking being a DBA? you will definatly cement your place in next 10 years, because it's a very long time. If you ask me, I would rather eye to become a V.P.



                hare krishna
                Alok
                • 5. Re: Change of Career : Need your kind advice/help
                  APC
                  Define your criteria for "better": more fun? more money? more job satisfaction? better career development opportunities? more job openings? more glamour?

                  Cheers, APC
                  • 6. Re: Change of Career : Need your kind advice/help
                    AlokKumar
                    This is the right way to analyze "Better".


                    hare krishna
                    Alok
                    • 7. Re: Change of Career : Need your kind advice/help
                      APC
                      I think Plsql developer must know some of task of DBA, what you say?
                      "Specialization is for insects." - Robert A. Heinlein

                      Of course, employers tend to hire specialists rather than generalists.

                      Cheers, APC
                      • 8. Re: Change of Career : Need your kind advice/help
                        PAB
                        thaks lot

                        but can differentiate both of them. means database developer and Administrator.

                        Is DBA's job include developement of procedures
                        • 9. Re: Change of Career : Need your kind advice/help
                          APC
                          Is DBA's job include developement of procedures
                          That depends upon the requirements of each individual workplace. Some places distingusih between production DBAs (monitor live systems) and development DBAs (participate in the building and maintenance of applications). In such cases I wouldn't expect the former to build stored procedures for use in applications but the latter might muck in and help the programmers.

                          Of course, DBAs of any stripe can build stored procedures to run monitoring or housekeeping tasks on the databases under their responsibility.

                          Cheers, APC
                          • 10. Re: Change of Career : Need your kind advice/help
                            548119
                            There are different kinds of DBAs too that specialize in a particular area, but you should know all.

                            There are development DBAs that help prototype and support the DEV environments. This usually involves query tuning, staying abreast of new technologies and educating developers of better ways to do things. Not that you hold their hand, but you work with them.

                            There are tuning DBAs that work with production environment and work on slow queries, slow systems, to make them run faster. There are many ways to tune and that is their job. They are good at finding the root causes and resolving performance issues. ( Or they should be...)

                            There are security DBAs that deal with tightening down Oracle environments (Not so much of these but it is growing as security becomes more specialized, still a regular DBA should be aware of this as well, especially with all the Compliance issues now).

                            Then there is your regular DBA who handles many of the functions above as well as backup and recovery, ensuring that the data is protected and safe should there be a catastrophe. That it is able to recover the DB quickly and efficiently. (Time is money) This DBA will also create user accounts, delete users, add tablespaces, install patches and security updates, update the DDL in production etc... the general administration and maintenance of the Database.

                            As the posters above said, it takes a particular mindset. There tends to be more pressure on production DBAs (especially if a system goes down). Development DBAs get to try a lot of the newer stuff to find out what may work for them and what may not, and Developers get to be more creative in using the Database to solve business issues.

                            As everyone above said, it depends, but find your passion and don't just do it for the money.