Oracle Database Administrator Henderson, NV

Overview

Oracle Database Administrator job at ADPMN Inc. Henderson, NV.

Job Title:

Oracle Database Administrator.

Location:

Las Vegas, NV. Duration: 6 Months.

• Develop and maintain Oracle databases to ensure data integrity, security, retention, and recoverability.
• Design, build, test, and deploy database solutions that align with project objectives, technology architecture standards, and departmental best practices.
• Design and implement database strategies, administer enterprise-wide data architecture, implement complex data structures, and provide daily management of corporate databases.
• Create and administer database objects from design to deployment, maximizing system availability, efficiency, integrity, recoverability, and supportability.
• Evaluate patch releases from Oracle and patching requests from development; communicate constraints, issues, and deployment timelines.
• Manage changes across development, test, QA, and production environments; deploy approved changes to production.
• Provide 24x7 on-call support, including driving root cause analysis, preventative action follow-through, and participation in weekly operations reviews.
• Provide proactive database monitoring and issue resolution; perform database and PL/SQL optimization, performance tuning, and query optimization.
• Participate in projects involving enterprise system enhancements; implement and support high-availability architectures (standby Data Guard, RAC, hot standby databases, etc.).
• Collaborate with development project teams to design and implement database solutions meeting business requirements; participate in project design and Oracle database design decisions; refine and troubleshoot designs.
• Create and maintain documentation about the database and data architecture; support nightly ETL processing; perform capacity planning and regular management reviews.
• Attend project kick-offs and design reviews to size new environments, recommend infrastructure solutions, and provide cost/resource estimates.
• Develop and implement database security policies and procedures in line with corporate objectives.
• Perform other duties as assigned.

• BS/BA degree in a related technical discipline.
• More than 3 years of Oracle DBA experience on Oracle Database 10g, 11g, and/or 12c.
• Knowledgeable in multiple operating systems including Microsoft Windows and Linux.
• Experience with RMAN backup with RMAN Catalog.
• Experience using Oracle Data Guard (10g/11g/12c).
• Experience using OEM Grid Control, EM Rep, and OMS.
• Experience with monitoring tools such as Toad, Spotlight, or equivalents.
• Strong skills in PL/SQL and UNIX/Linux shell scripting; strong SQL and PL/SQL design, development, tuning, and debugging.
• Experience with Oracle Security Administration.
• Ability to maintain a positive attitude under high demands and short deadlines; ability to prioritize heavy workload with minimal supervision.