Job Title: Oracle PL/SQL Developer / DBA – Golden Gate
Location: Las Vegas, Nevada & Irving, Texas (Hybrid)
Job Type: Contract / Full-Time
Job Overview
We are seeking an experienced Oracle PL/SQL Developer / DBA with GoldenGate to support and enhance mission-critical enterprise database environments. The ideal candidate will have strong hands-on experience with Oracle databases, replication technologies, high availability architectures, and performance optimization in large-scale production environments.
This role involves supporting complex Oracle ecosystems, ensuring high availability, data integrity, security compliance, and seamless replication across environments.
Key Responsibilities
- Design, develop, and optimize PL/SQL procedures, packages, triggers, and performance tuning.
- Administer and support Oracle 10g, 11g, and/or 12c environments in production and non-production.
- Configure, monitor, and support Oracle GoldenGate replication and data synchronization.
- Manage Oracle Data Guard for disaster recovery and high availability.
- Monitor systems using OEM Grid Control, Enterprise Manager Repository (EMREP), and OMS.
- Support and maintain Oracle RAC and ASM environments.
- Work on Oracle Exadata technology stack for high-performance workloads.
- Implement and maintain security and compliance standards including encryption, auditing, authentication, PCI, GLBA, and SOX.
- Support and troubleshoot Oracle Streams and database replication technologies.
- Perform data modeling and database design using tools such as Oracle Data Modeler, Erwin, Toad, Visio, etc.
- Collaborate with application teams supporting .NET-based applications.
- Perform patching, upgrades, backups, recovery, capacity planning, and performance optimization.
- Participate in on-call support and production issue resolution.
Required Skills & Experience
- 12+ years of experience in Oracle PL/SQL Development and Database Administration.
- Strong experience with:
- Oracle 10g / 11g / 12c
- Oracle GoldenGate replication
- Oracle Data Guard
- OEM Grid Control, EMREP, OMS
- Oracle RAC and ASM
- Oracle Exadata platform
- Experience with Oracle Streams and replication technologies.
- Solid background in database security and compliance:
- Encryption, Auditing, Authentication
- PCI, GLBA, SOX standards
- Strong data modeling and schema design skills.
- Hands-on experience with DM tools:
- Oracle Data Modeler, Erwin, Toad, Visio, or similar.
- Understanding of or experience supporting .NET applications.
- Ability to troubleshoot complex production issues and optimize performance.
- Strong documentation and communication skills.
- Oracle Certification (OCP or higher).
- Experience supporting large-scale enterprise environments.
- Knowledge of Linux/Unix environments and shell scripting.
- Exposure to cloud migration or hybrid infrastructure.
- ITIL or production support experience.