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.