Description

You will manage and optimize Oracle database environments across development, test, QA, and production stages.

Responsibilities

• Evaluate Oracle patch releases and manage deployment timelines and constraints.
• Own change management and the deployment of approved changes to production environments.
• Provide 24x7 rotational on-call support, including performing Root Cause Analysis (RCA) and preventative actions.
• Implement and support high availability architectures including Data Guard, RAC, and hot standby databases.
• Perform database and PL/SQL optimization, including performance tuning and query optimization.
• Design and implement database solutions in collaboration with development teams to meet business requirements.
• Develop and implement database security policies and procedures.
• Monitor database health proactively and manage nightly ETL processing.

Required Skills

• Over 6 years of experience working with Oracle Database 10g, 11g, and/or 12c.
• Proficiency in SQL, PL/SQL design, development, tuning, and debugging.
• Experience with database backups using RMAN with RMAN Catalog.
• Hands-on experience with Oracle Data Guard.
• Experience using OEM Grid Control, Emrep, and OMS.
• Proficiency in UNIX/Linux Shell Scripting.
• Working knowledge of Microsoft Windows and Linux operating systems.
• Experience with Oracle Security Administration.
• Strong troubleshooting, analytical, and organizational skills.

Preferred Skills

• Oracle Certified Professional (OCP) status.
• Experience supporting Oracle RAC environments and ASM.
• Experience with Oracle Streams, database replication, or data modeling tools like Erwin or Oracle Data Modeler.
• Knowledge of security compliance including Encryption, Audit, PCI, GLBA, or SOX.
• Experience supporting .NET applications.

Key Skills

Education

Any Graduate