Gusora wrote:Possibly think differently and consider ISEB Software Testing ( or ITIL foundation) ; you might find more opportunity for industry re-entry in a testing role. You may find it hard for people to accept anything you haven't done commercially before. And know what you say you know well. If you have previous done unix and are offering it then esnure your unix command line and editting is up to scratch. These are thoughts ... they are not hard and fast rules. And others know and advise better than I do. View the positions being offered and check which ones have little of no gap on your current knowledge.
A bit of Oracle career advice needed :)
I live in the UK and currently work in a non-IT role. My last IT and Oracle position was just over 10 years ago as a PL/SQL developer which I held for 4 years. I'm now 47 and would like to get back into an Oracle job. I am aware I will need to update my certifications for SQL and PL/SQL. I imagine if I am lucky enough to be in with a shout for an Oracle position it would be a junior role.
Couple of questions:
Considering my age have I left it too late especially considering the employment situation and the abundance of IT graduates looking for work?
As I said I will be updating my SQL and PL/SQL certifications but am looking at developing a third string to my bow. Should I be looking at Java, Python or ? (suggestions please).
Any suggestions would be appreciated
Considering my age have I left it too late especially considering the employment situation and the abundance of IT graduates looking for work?I would say not. If you worked in PL/SQL for four years, then you should be able to study the topics for and earn the Oracle PL/SQL Developer Certified Associate within a matter of months. IT graduates looking to work have not shown that they can program in PL/SQL. In your situation I would concentrate on getting the OCA and then the Oracle Advanced PL/SQL Developer Certified Professional.
Should I be looking at Java, Python or ? (suggestions please).Several times in my Oracle career I've taken a course in Java thinking I'll use it. Haven't yet. Don't think I will in the future. I have a former coworker that gushes about Python. Good for him. Never needed it myself and most hiring managers would think you were referring to a large scaly thing. I'm a developer and DBA which I have found quite useful. If you take 1Z0-051 and 1Z0-144, then you are just one test from the DBA OCA -- 1Z0-052. I'd suggest that before anything non-Oracle. Even if you never work as a DBA, knowing the basics can be a valuable asset.
they were always looking for people with complementary Oracle skills e.g. Java, C++, Forms Developer...Hiring managers will throw everything (including the kitchen sink) up against the wall to see what sticks. None of them expect to get all of it. Concentrate on core Oracle skills while you are searching. Keep an eye on Indeed.com for jobs in your area. Every couple of weeks I'll run a search for PL/SQL jobs in my area to see what the market looks like locally. If you see a recurring skill come up in multiple unrelated job postings, then you might consider trying to learn it. There are many things that I have picked up over the years. Pretty much all except the core skills have become rusty through disuse. I can code a bit in C. I wrote some really cool shell scripts a few years back. I've done some minor Java coding. Did some Visual Basic in a former life. Used to know some SQL Server. Once upon a time could use Informatica pretty well.
Gusora wrote:Okay so there is no way you'd accept testing.
I couldn't imagine going into a testing role having done it for a short time and absolutely hating it or at least the person managing the testing team who at the time had the management skills of an amoeba.
I have no problem getting up to speed on Unix/Linux and its something I would be very much embrace. I know probably most servers running Oracle use a Unix variant.
Is there a Unix scripting language you would recommend?
Gusora wrote:Consider ISBN-13: 978-0470404836. The paperback edition should have a cdrom. I think that 2nd edition is the latest. Unlike an oracle cert it lasts 5 years. That said the main value may be to force practice of some linux skills. I'm not sure the cert. would be valued b employers, but the practice might help a bit. It probably won't cover some detailed reg-expressions awk/grep/sed you might get asked at interview. Oracle does have the 1z0-402/1z0-403 exams but 1z0-403 is (early) RHEL 4 orientated so a lot irrelevant in this 64-bit OEL5/6 days. Anyway buying the book is cheap, going for the exam is more expensive. Please consider other reviews rather than taking a recommendation from me.
Thanks for highlighting the LPIC-1 cert which I was unaware of and is certainly something I would be happy to include as a core skill since I have in the past been a keen Linux user. Before I start googling around can you recommend a book for doing LPIC?