I am an Oracle Certified Professional and have around 13 years of experience in the IT field. I have around 6 years of Oracle Administration on Unix servers. I have vast knowledge of oracle's working/internals and have worked on various projects and environments in various capacities, starting from a programmer, application developer/designer and now as a Oracle Administrator.
I have worked on various versions os Oracle such as 7.x, 8.x, 8i and 9i.
I have fair knowledge of Unix as well. I have worked on enterprise servers such as E10K and on storage devices such as EMC.Some amount of knowledge of the operating system is essential for a DBA.
If you have problems installing or setting up a Database, I could help you there. I could walk you through creating a database and also help you setup the right logical structures and physical structures.
If you want to know why your databases performs slow or in a way that you are not familiar with or never seen it perform before, I could have the explanation.
I also have good programming knowledge and have helped mentor and train sevaral programmers (on oracle frontends/powerbuilder). I am good at SQL and PL/SQL and have worked on several projects writting and helping developers write stored procedures and triggers. If you are stuck with writting a stored procedure or trigger , you should try and give me a call, you could have your problems solved in no time.
To sum up my expertise:
Installation and setup of Oracle RDBMS server on Unix as well NT servers.
Create a Database and schemas (physical and logical) for holding logical structures, setting up the database with proper logging, rollbacks etc.
Troubleshoot installation and database creation.
Monitor and analyze the performance of a database.
Analyze scripts that create schema (third party application normally provide scripts for database and schema creations) for errors and troubleshoot them and
ensure that logical structures created through scripts have proper storage parameters.
Ensure that the database and application are secure and maintain data integrity.
Help troubleshoot oracle database errors (rollback segment problems/ sort area size problems/ error messages in alert logs and trace files).
Help design logical (table) structures for an application.
Provide expert advice on new features in various versions of oracle and how you could apply them.
Help resolve application problems arising from stored procedures or triggers (PL/SQL).
Help tune the application SQLs.
and many more
Looking forward to talking to you and resolving your oracle issues.
|