*Summary:
*
* *
- *Seven years* of experience as an *Oracle DBA* (*8i,9i ,10g&11g*).
- Supported multiple environments on* Linux, HP –UX and Solaris*
platforms.
- Provided *24x7 support* for mission critical projects as a *production
support DBA*
- Experience in taking *Hot* *Backup* and *Cold Backup* as well as
immense experience in taking logical backups by using oracle utility *
exp/imp* and *Data Pump*.
- Developed or modified some Oracle backup and recovery scripts. Used
Oracle backup utility *RMAN *to implement Oracle backup and disaster
recovery. Experience in advanced recovery methods like *PITR *and*
TSPITR.*
- Experienced in *Configuring and Maintaining Standby databases (Data
Guard)* in Oracle 9i and 10g.
- Extensive experience in logical and physical design of oracle database.
- Efficient in SQL query optimization using *TKPROF report, Explain plan*
.
- Good understanding of Installation and configuration of 10g *Real
Application Clusters (RAC)* on multiple nodes.
- Experience in managing very large databases in *data warehousing*
environment.
- Widely used *Oracle Enterprise Manager* (*OEM*) for administering
databases.
- Created and managed database object like tables, views, sequences,
synonym, index, trigger, user, roles, DB link and*Materialize view*
(M-view).
- Used *Automatic workload repository (AWR)* to collect statistics
and *automatic
database diagnostic monitor (ADDM)* to monitor and analyze statistics and
provide advisory services.
- Used *SQL*Loader* to load data into database table.
- Patched oracle databases using *OPatch* Utility.
- Extensively worked on *Oracle partitioning* to improve the performance.
- Extensive experience in using *Oracle Grid Control* for monitoring
database activities.
- Experience in UNIX administration, *Shell scripts*, Crontab.**
- Worked on the advanced features of Oracle 10g such as *Automatic
Storage Management(ASM), Automatic Shared Memory Management(ASMM) and
Automatic Segment Space Management (ASSM).*
- Experience in managing security through *grants, roles, privileges and
profiles*.
- Experience in SQL query, *PL/SQL package, function, stored procedure,
triggers* to implement business logics of oracle database.**
- *24x7 production support DBA* working on a primary/ secondary pager
rotation; and supported on holidays, weekends and beyond regular hours.**
* *
*Core Competencies:*
Operating Systems
Linux,, Solaris, HP-UX, AIX, Windows
Programming Languages
C,C++, PL/SQL, Unix Shell Programming
RDBMS
Oracle 8i/9i/10g/11g
Tools
SQL*PLUS,SQL*Loader, RMAN, Export/Import, Data Guard, OEM, Data Pump, TOAD,
SQL Navigator
*CERTIFICATIONS:*
* *
*Oracle 10g DBA Certified Professional*
*
*
*
Best Regards
SINGH
Sr. Technical Analyst || SALES - IT Staffing || SV IT Inc
Phone # 347-545-9052 || Fax # 516 977 0618
E Mail: [email protected] || G-mail: [email protected]
URL: www.svitinc.net
SV IT Inc is an Equal Opportunity Employer. Qualified applicants will
receive consideration for employment without regard to race, color,
religion, sex, national origin, ancestry, citizenship, disability, age,
military or veteran status, and other characteristics. We help our clients,
employees & partners compete and win!
*
--
--
You received this message because you are subscribed to the Google Groups
"oraapps" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/oraapps?hl=en.
