Oracle DBA,Loc: Las Vegas,Nevada

100,000 - 200,000

Job Description:

Job Description:
  • The primary objective of the Oracle Database Administrator (DBA) is to develop and maintain the corporate Oracle databases ensuring data integrity, security, retention, and recover-ability of the data.
Summary of Essential Job Functions:-
  • All aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup and recovery.
  • Responsible for evaluating patch releases from Oracle and patching requests from development, and communicating constraints, issues, and timelines for deployment.
  • Change management including maintenance of multiple development, test, QA, and production environments. Responsible for deploying approved changes to production
  • 24x7 rotational on-call support, including driving Root Cause Analysis (RCA), Preventative action follow-though, and participation in weekly operations reviews.
  • Proactive database monitoring and issue resolution
  • Database and PL/SQL optimization including performance tuning, query optimization and supportability.
  • Actively participate and contribute to projects involving enterprise systems enhancements.
  • Implementation and ongoing support of high availability architecture (standby logical/physical Data Guard, RAC, Veritas, hot standby databases, etc)
  • Work with development project teams to design and implement database solutions to meet business requirements.
  • Participate in project design and Oracle database design decisions. Refine and troubleshoot the design.
  • Create and maintain appropriate documentation about the database and the data architecture.
  • Support of the nightly ETL processing
  • Regular proactive capacity planning and tending reviews of all oracle databases. Producing weekly, monthly management reports.
  • Project Estimation process - including attending project kick-offs and design reviews as necessary to appropriately size new environments, recommend infrastructure solutions and deliver associated cost and resource effort estimates
  • Develop and implement Database security polices and procedures, in line with corporate objectivesJob RequirementsPosition Requirements
  • Must have 5+ years Oracle DBA working experience on Oracle 10g and/or Oracle 11g.
  • Must be knowledgeable and experienced on the different versions of Oracle (10g, 11g) on multiple operating systems (UNIX, Linux).
  • Experienced in Database backup using RMAN with RMAN Catalog.
  • Must be experienced using Oracle 10g and/or Oracle 11g Data Guard.
  • Must be experienced using OEM Grid Control, Emrep and OMS. Experienced with tools such as Toad, Spotlight, or other Monitoring tools.
  • Strong skills in PL/SQL and UNIX/Linux Shell Scripting
  • Strong SQL and PL/SQL Design, Development, Tuning and debugging skills
  • Experience with Oracle Security Administration
  • Ability to maintain a positive attitude while working with high demands and short deadlines
  • Ability to prioritize heavy workload with minimum supervision.
  • Highly adaptable with ability to work in a fast paced demanding environment
  • Must have excellent communications and interpersonal skills.

Share Profile