Required Skills

Oracle DBA technically adept DBA SQL performance tuning UNIX environment

Work Authorization

  • Us Citizen

  • Green Card

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 13th Nov 2020

JOB DETAIL

Oracle DBA, Hands-on, technically adept DBA, capable of performing required DB tasks

• SQL performance tuning

• Deep knowledge with Oracle 10g/11g databases, strong RAC/clustering experience, OEM, CDC,RMAN, Oracle Grid and Data Guard experience required.

• Migrating the schemas using traditional exp/imp and Oracle Data pump utilities

• Strong troubleshooting/performance tuning skills required. Must be able to improve SQL performance results through use of hints or outlines. Ability to diagnose problems and triage/resolve issues across various tiers (application, network, database, server, or storage tiers).

• Ability to implement automation to reduce manual administrative tasks through use of jobs, shell scripts, PL/SQL, cron job, or other techniques..

• Must demonstrate proficiency in UNIX and be able to administer Oracle databases running in Solaris and RHEL.

• High level experience with writing shell scripts

• Very good understanding of how memory, CPU, Disks work on the UNIX environment

• Oracle Recovery with Archiving, Oracle Export and Import Utilities

• Demonstrate experience with backups, recovery, performance tuning and optimization on oracle OEM, statspack, AWR experience needed

• Experience of execution plans and how to use them to optimize/improve query costs and create new indexes

• Monitoring database performance during application performance testing and recommending database changes

• Experience backing up databases from one environment and restoring them in other database environments • Experience with upgrading oracle databases from oracle 10g to 11g.

• Provides input regarding technical design and development of applications using existing and emerging technology platforms.

• Implementation of security standards and roles Deploy/ migrate code across multiple tiers

Company Information