Resume Upload

Share this Job

Go Back

Oracle DBA,Loc: Las Vegas,Nevada

2017-03-22 17:43:49

Job Type: Full Time only
Budget $: 100,000 - 200,000

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.