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.
