Hi,
Please reply back to a...@xtglobal.com along with the resume, contact
details and rate expecting.
*NEED 2 PROFESSIONAL REFERENCES FROM THEIR PROJECTS*
*At least 5 years of experience administering Oracle 10g databases
At least 5 years of experience Unix or Linux operating system (AIX and Suse
preferred)
ASM, RAC and RMAN
SQL and PL/SQL scripts
Shell scripts and Perl would be a plus.*
**
*NEED LOCALS ONLY***
* *
*Description:*
The Oracle Database Administrator will have primary responsibility for
maintaining numerous database schemas in support of an application
development effort.
Installation and upgrade of Oracle products, maintaining the physical
database structure, monitoring and tuning performance, and maintaining
database security.
Production configuration and automation for the software product currently
being developed.
Assist with Customer deployments including data conversion and production
support.
Define new database objects or modifications to existing objects in
accordance to existing database standards.
Track database changes using a source control tool
Use software tools and/or local scripts to monitor performance and space
utilization in order to tune as required. Includes, but is not limited to,
the ability to identify and remove detrimental locking scenarios.
Identify poor performing SQL statements and provide assistance in tuning to
improve performance.
Re-writing SQL statements, creating new indexes and altering existing
indexes.
In conjunction with security and privacy policies, establish and manage
role-based access.
Create, maintain and refresh required Oracle instances/databases/schemas
Install, upgrade, and maintain Oracle software products
Setup, testing, implementation, and maintenance of backup and recovery
strategies using Oracle utilities.
Monitor production systems and coordinate outages to perform maintenance in
order to prevent unplanned downtime.
Act as liaison between application developers and database vendor to report
and resolve problems on a timely basis.
*Additional detail:
*Must be strong at OS commands @ server level
Must be strong in BOTH applications DBA and Production Support DBA
Must have strong SQL skills and SQL tuning
Must have strong PL/SQL and scripting
Must have good experience with ASM
They have weekly patches on two different versions of their software and
that has to be supported from a DBA level.
Interview consists of:
50 technical questions (looking for 80% success)
- backup and recovery
- development
- security
- PL/SQL, SQL, ASM
- troubleshooting
- How would you determine if there is a lock in the DB?
- How would you fix it?
- How do you go about troubleshooting specific database issues?
Team of 4 DBA's internally and two remote DBA's supporting mutliple software
lines.
Need someone with strong command line skills and strong RMAN commands.
Doesn't like candidates who talk about the team doing something. They want
someone who did it themselves. Very much an apps dev DBA that will create
db's for the development teams adding schema, users, accounts, etc. Will
ask about RAC and DataGuard if they have it, but not required. If it's on
the resume it's fair game though. Will ask about ASM which is a primary
requirement.
In the interview they don't tell the candidate when they are wrong because
they don't want them to lose confidence.
Must be strong in development...not Oracle Apps, but SQL, PL/SQL, Perl
scripting, stored procedures, etc. Job only entails about 20% production
support.
______________
Best Regards
*Abhi *| Sr. Recruiter
Xenosoft Technologies Inc, 18170 Dallas Parkway | Ste 201 | Dallas, TX 75287
a...@xtglobal.com | |
www.xtglobal.com, Inc. 500 Fastest Growing Private Companies in America
--
You received this message because you are subscribed to the Google Groups
"Oracle Users" group.
To post to this group, send email to oracle-users@googlegroups.com.
To unsubscribe from this group, send email to
oracle-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/oracle-users?hl=en.
