Oracle Database Administrator || 6+ Months || Raleigh, NC
Pankaj Trivedi
Hi Partners,
Here is the open requirement with our client. Kindly go through the complete job description and let me know if you have anyone available for this role.
Location: Raleigh, NC
Duration: 6+ months
Rate: Market
Interview Type: In-person Required
Description:
The primary responsibility of
this position is the administration of Oracle databases. Duties include all
database administration and database design activities as they apply to Oracle,
and the ability to work in a project-based, team-oriented environment.
Required Skills:
· Minimum of (7) years of recent experience as an Oracle Database Administrator in a 24x7 Solaris environment; skills with Oracle Enterprise Edition RDBMS 10g and 11g.
· Expert with installation, configuration, and patch management of Oracle 10g and 11g; SQL (DML and DDL) and PL/SQL; assist development staff with writing PL/SQL Stored Procedures, Functions, and Packages; Ability to create/replace insert/update/delete triggers.
· Managing and implementing database/schema changes, including creating/altering tables, constraints, indexes, grants, and sequences; able to write DDL and DML via command line tools (SQL*Plus, Toad, etc.) as well as GUI tools (OEM, Oracle SQL Developer, etc).
· Oracle Recovery Manager (RMAN) via both the command-line and OEM;Oracle Automatic Storage Management (ASM)(10g and 11g); Oracle Enterprise Manager (OEM) Grid Control (10g and 11g); Oracle Data Guard.
· Quest Software TOAD for Oracle (including DBA module).(TOAD Team Coding is a plus).
· Database change control; coordinate and implement database/schema changes to various environments (Development, Test, Training, QA, and Production).
· Coordinate and implement schema changes to various environments (Development, Test, Training, QA, and Production).
· Assist various projects with performance tuning PL/SQL Stored Procedures and SQL statements. Experience using Explain Plan
· Ability to assist other teams in stress-testing applications, locating bottlenecks, and recommending solutions.
· Willing to provide after-hours support.
· Excellent interpersonal communication skills.
Desired Skills:
•Experience with Oracle Real Application Clusters; UNIX commands and shell scripting and Solaris 10; database/schema design and data modeling tools; CA ERwin (7.x or higher); scheduling and propagating messages to/from legacy systems via Oracle Advanced Queuing and Oracle Message Gateway;and SAN environments.
Regards,
Pankaj Trivedi
YIM: Pankaj.fcsltd
GTalk: Pankaj.staffing