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.
- 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.