Senior Oracle DBA with MongoDB, Delphix & Snowflake Experience

Job Description: Senior Oracle DBA with MongoDB, Delphix & Snowflake Experience

Location: Manhattan New York -On-site

Experience Level: 10+ Years

Employment Type: Contract

Position Summary

We are seeking a highly skilled and seasoned Senior Database Administrator (DBA) with 10+ years of hands-on enterprise database experience. The ideal candidate will be the technical anchor for our core relational databases while playing a pivotal role in managing and scaling our modern data platforms, including MongoDB, Delphix, and Snowflake.

In this on-shore role, you will collaborate closely with engineering, DevOps, and architecture teams to ensure high availability, optimal performance, robust security, and seamless data virtualization across hybrid and multi-cloud environments.

Key Responsibilities

• Oracle Database Administration:
• Design, install, configure, upgrade, and patch enterprise Oracle databases (Oracle 19c/21c) across high-availability environments (RAC, Data Guard).
• Perform proactive performance tuning, SQL optimization, capacity planning, and resource management.
• Implement and test robust backup and recovery strategies using RMAN and enterprise backup solutions.
• Modern Data Platform Management (MongoDB, Delphix, Snowflake):
• MongoDB: Administer MongoDB enterprise clusters, monitor replica sets, manage sharding, ensure data security, and optimize query performance.
• Delphix: Manage data virtualization pipelines, provisioning virtual databases (VDbs), masking sensitive data, and streamlining CI/CD data delivery for development teams.
• Snowflake: Oversee Snowflake data warehouse operations, manage warehouse sizing, user roles, security, data sharing, and cost optimization.

• Security, Compliance & Automation:
• Enforce database security policies, implement auditing, and ensure compliance with industry standards (SOX, GDPR, HIPAA, etc.).
• Automate routine administrative tasks, monitoring alerts, and deployment processes using scripting languages (Python, Bash, Ansible).
• Incident & Problem Management:
• Provide 24/7 escalation support for critical database incidents, root-cause analysis (RCA), and disaster recovery drills.

Required Qualifications & Skills

• Experience: Minimum 10+ years of progressive experience in database administration, with a strong focus on enterprise Oracle environments.
• Core Oracle Expertise: Deep, hands-on knowledge of Oracle RAC, Data Guard, RMAN, ASM, Enterprise Manager (OEM), and advanced SQL/PL-SQL tuning.
• Cross-Platform Competency: Proven production experience managing:
  
  
• NoSQL databases (MongoDB Enterprise).
• Data virtualization/masking tools (Delphix).
• Cloud data warehousing (Snowflake).
• Infrastructure & Cloud: Working knowledge of Linux/Unix OS, shell scripting, automation tools (Ansible/Terraform), and cloud platforms (AWS, Azure, or Google Cloud Platform).
• Soft Skills: Strong analytical, troubleshooting, and communication skills with the ability to lead technical discussions and mentor junior team members.

Preferred Qualifications

• Oracle Certified Professional (OCP) or relevant cloud/database certifications (Snowflake SnowPro, MongoDB Certified DBA).
• Experience in CI/CD pipeline integration and agile development environments.