Oracle Programmer Career Guide and Counseling

Question: Related to Oracle Programmer? I want to know whats the role of Oracle Programer(PL/SQL) or Oracle forms or reports, in the software projects. Can U explain it with a project.

Answer: Dear Friend, An Oracle Programmer i.e. PL/SQL developer's role in a project is as follows, Whether the project type is a NEW development or MAINTENANCE project; developer always assigned with a sub-programs or sub-modules of the project. for example, if ACCOUNTS related software module is being developed then may a developers will be assigned for Cheque Deposit Entry (a sub-module). May other developer will be assigned the Receipt sub-module. And as these sub-modules are completed then they are integrated and a module is formed. Hope this would help you.

Question: Any one know the scope of studying Oracle PLSQL as a Programmer in other platform? i am .net programmer, like to switch to database line.. especially oracle... i want to know the scope of that and the good institute or self resource to earn OCP ... thanks in advance

Answer: All you really need is a copy of oracle and the O'Reilly book on packages. While you can do procedures and functions in PL/SQL I find Packages add a lot more structure to what you are doing. That is all I started with, and I was writing business applications in it. (A good editor like Toad is a big help too. You can get by without it, but it is a pain to do so) -Dio

Question: Lawyer, Doctor, Oracle programmer or bussinessman? I have a question. I am a pre med major becasue my father thinks that doctors make a lot of money but i hate biology and cannot stand sight of a lot of blood. I love history and i was thinking i should try being a lawyer but my father says that i cannot become a lawyer because i do not have an american accent. I came to this country four years ago. Now he wants me to become an oracle dba programer like him but i don't want to sit in front of a computer the whole day spoil my eyesight and most of the popel in the computer professsion get carpal tunnel syndrome or something like that. So first he want me to ebcome a doctor now a programer i want to be either a bussiness major or a pre law major. whcih do you think should i do?

Answer: I'm trying to become a doctor for my own reasons. Not my parents reasons.

Question: How much can i typically earn as a C#, VB6, Oracle, XML or XSLT programmer?

Answer: It depends on experience. Have a look on job sites, like monster.com.

Question: i want to settle as oracle programmer .? i have learned oracle9i ,d2k .known i am in greate confusion state as fresher i will get an chance or not. i want way i have to proceed.

Answer: Check out jobs section in http://www.dotnetspider.com/

Question: I'm looking for Consulting jobs as a programmer( SQL, Oracle, VBA, Access, Excel)?

Answer: There are companies that specialize in placing consultants in jobs. My sister does that. You will need to find a company that does it and they will get a fee for placing you by the company that went to them, so you are not out anything and can have a steady flow of work after you establish yourself. Do a search pretending you want to hire a consultant to do what you do and then contact the companies you find that offer your service and tell them you are available. They will "screen" you and then find you jobs if you meet their requirements. That is why the companies go to them so they can be sure they have a legitimate worker. Good Luck.

Question: I want to get a job in abroad for Visual Foxpro programmer i m doing Oracle now. What will be the easiest way? I am from Pakistan

Answer: Oracle and FoxPro same in fucntion but totally different syntax.. buy a book about FoxPro.. if your know how to use Oracle it's easier to you to learn FoxPro

Question: What are the roles and responsibilities of Database Programmer? I'm new to Database Oracle. Please someone help me in this matter.Please someone write a project in Oracle db and what are the roles and responsibilites of database programmer . I would appreciate if someone answer to my question.

Answer: Normally the Database Administrator (DBA) is responsible for issues like installation, sizing and general performance tuning. A database architect is usually the one who designs the database. Even the application design is generally designed by another position. A database programmer is usually a lower level job responsible only for coding and unit testing database programs. In the case of Oracle, the language would be PL-SQL which could be implemented either as scripting or stored procedures. There might also be some database design work and the programmer would need to do some tuning to make sure that his or her own programs run at acceptable speeds. That said, the exact duties of the programmer vary from company to company. And once words like "Senior" or "Lead" get tacked onto the front it usually means more design and/or team leadership duties are added as well.

Question: Extremely good programmer in C, Java, Oracle + excellent scores in Microbiology = Future? Pls advise.? Bioinformatics seems to be a good option, but I don't want to get into extreme research or extreme software development... something in betwn????

Answer: There are so many specialized software applications that are used by biologists, ranging anywhere from statistical analysis programs to DNA stuctural analysis programs. Try to think back over your microbiology classes and ask yourself "What thing or things did I do that could be made easier if I had had specialized software" Also, you should try to familiarize yourself with software that is already available and try to determine if there is anything that they DON'T provide that there seems to be a need for. Also, many of these applications are first-person released (not through a software company) so you could contact them and ask them about their experiences with developing their software. Here is a freebie to start you off: http://ddsdx.uthscsa.edu/dig/itdesc.html

Question: i m arsalan mf cobol programmer and i want to connect my cobol application with oracle database how could i do

Answer: ARSALAN MS will this help Your Pro*COBOL program must log on to Oracle before querying or manipulating data. To log on, you use the CONNECT statement, as in EXEC SQL CONNECT :USERNAME IDENTIFIED BY :PASSWD END-EXEC. where USERNAME and PASSWD are PIC X(n) or PIC X(n) VARYING host variables. Alternatively, you can use the statement EXEC SQL CONNECT :USR-PWD END-EXEC. where the host variable USR-PWD contains your username and password separated by a slash (/). The syntax for the CONNECT statement has an optional ALTER AUTHORIZATION clause. The syntax for CONNECT is shown here: EXEC SQL CONNECT { :user IDENTIFIED BY :oldpswd | :usr_psw } [[AT { dbname | :host_variable }] USING :connect_string ] [ {ALTER AUTHORIZATION :newpswd | IN {SYSDBA | SYSOPER} MODE} ] END-EXEC.

Question: How do I become a Freelance Programmer/Developer? I need an extra income and I was wondering if I can maybe try this freelance programming job. I've been an Oracle developer for more than 4 years now. Do you know which sites are credible enough to gain me a prospective client or maybe work with a team? Thanks for all your help!

Answer: Well go to this page on the site below and go to the heading of 'work at home job boards'. I have four listed there. They are legitimate job boards that have freelance jobs as you describe. They are not the bidding type freelance websites where you have to bid for a job. You may as well check out the rest of the site as it is for independent contractors/virtual assistants and it will be relevant to you as well.

Question: Is Manchester a good place to study and work? My spouse and me plan to move to manchester (UK) next year. My spouse will study for PHD at the university of manchester and I will work (I am a programmer - Oracle Apps Dba). Is it a good place to live, study and work? Where is a good and safe place to live in manchester with good transportation link to university? Thanks in advance!

Answer: Yes! Manchester is a great place to live. There are some rough bits - avoid Moss Side, Wythenshaw and Longsight, but also some nice areas like Chorlton, Didsbury. Prestwich in the north is also good and quiet (and near the tram line) But yes, I lived in Manchester for three years and loved it - there are loads of nice places in town to go, and plenty of cultural attractions such as the Cornerhouse, The Lowry, the Museum of Science & Industry and festivals such as the upcoming International Festival taking place as well. Plenty of decent IT jobs going as well, especially in all the new businesses round the Salford Quays redveloped area.

Question: What is the going rate for a freelance programmer? Specializing in Oracle databases and Oracle development products, Also Visual Basics.

Answer: VB not that much, Oracle £35 ph basic.

Question: Average # of hours in a workweek in the US for programmer? Ok, someone I know is considering moving from Europe to the US, but is concerned after reading about the long hours some (most) Americans work. So, question: Software engineer, Oracle & Java, programming, testing, etc... Average # work hours for those with similar positions? Salary or hourly (w/overtime)? Thanks!!

Answer: most of the ones I know .....average50 to 60

Question: What's your perception of the current job-market for entry-level programmer/developers? I'm talking about fresh out of university--BS / Computer Information Systems, no experience, Java and Oracle certified. Also, any advice for getting that first job and the much needed experience?

Answer: There is a lot of opportunities in the market these days worldwide for programmers or developers in JAVA and Oracle.You have an added benefit of being certified.But first you must decide in which domain you want to start job i.e. in JAVA and Oracle only or any other programming language of your interest..But overall for IT developers there is a lot of scope in the market today. In joining any job you should stick to job which can give you work in your area of interest...i.e. your programming language of interest.

Question: Kind of ORACLE certifications.. what is the best ? Kind of ORACLE certifications.. what is the best ? I want to work as programmer on Oracle and/or Database administratot .. And also.. where is the cheapest way to get a Oracle Certification ?? God bless a lot

Answer: 10g DBA 1z0-312 ： Oracle Application Server 10g: Administrator II 1z0-046 ： Oracle Database 10g: Managing Oracle on Linux for DBAs 1z1-046 ： Orcale database 10g:Managing Orcale on Linux for DBAs 1z0-095 ： Oracle 9i and 10g OCM Course Attendance Exam 1z0-043 ： oracle database 10g:administration ii 1z0-042 ： oracle database 10g:administration i 1z0-040 ： oracle database 10g:new features for adminsitrators