Contract

Zohorecruit; North Carolina; On-site; USD 120,000 - 170,000; Full time

Job summary

Zohorecruit in Durham, NC is seeking an experienced Data Engineer and Database Administrator to administer and optimize Oracle databases, build and maintain enterprise data warehouse solutions, and develop robust data pipelines. You will collaborate with analytics teams and ensure data quality and performance across Snowflake and Oracle Analytics Server.

Ideal candidates bring 7+ years in data engineering and database administration, strong SQL, Python, and NoSQL (MongoDB) experience, plus

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent experience) with 7+ years in data engineering and database administration.
• Strong expertise in Oracle Database with Application DBA experience.
• Deep knowledge of data warehousing concepts and architecture.
• Hands-on Snowflake experience; Oracle Analytics Server integration and reporting.

Responsibilities

• Administer, monitor, and tune Oracle databases supporting critical applications.
• Manage database performance (query optimization, indexing, partitioning, and execution plans).
• Perform database maintenance (backups, recovery, patching, upgrades).
• Ensure high availability, disaster recovery, and data integrity; support application teams in design and troubleshooting.

Skills

Oracle Database

Data warehousing

Snowflake

Oracle Analytics Server

Python

SQL

NoSQL MongoDB

Azure/AWS/GCP

dbt

Airflow

CI/CD

OLTP

Data governance

Education

Bachelor’s degree in Computer Science, Information Systems, or related field

Tools

Snowflake

MongoDB

Informatica

Python

SQL

Oracle Analytics Server

Job description

Durham, United States | Posted on 09/29/2026

• Administer, monitor, and tune Oracle databases supporting critical applications
  
• Manage database performance (query optimization, indexing, partitioning, and execution plans)
  
• Perform database maintenance activities (backups, recovery, patching, upgrades)
  
• Ensure high availability, disaster recovery, and data integrity
  
• Support application teams in database design and troubleshooting
  

Data Engineering & Architecture

• Develop and maintain data models (dimensional and normalized) to support analytics and reporting
  
• Build and optimize enterprise data warehouse solutions across Oracle and Snowflake platforms
  
• Ensure efficient ingestion, transformation, and integration of structured and unstructured data
  
• Design, develop, and maintain scalable data pipelines and ETL processes using tools such as Informatica and Python
  

Reporting & Analytics Support

• Support and enhance Oracle Analytics Server reporting environments
  
• Collaborate with BI and analytics teams to ensure data accuracy and usability
  
• Optimize data structures for reporting performance
  
• Develop and maintain solutions in Snowflake cloud data warehouse
  
• Implement best practices for cloud data architecture, cost optimization, and performance
  
• Work with NoSQL technologies (MongoDB) for semi-structured and unstructured data use cases
  

Development & Automation

• Write efficient, reusable, and scalable code using Python and SQL
  
• Automate data workflows, monitoring, and alerting
  
• Implement CI/CD practices for data pipelines and database deployments
  

Data Governance & Quality

• Ensure data quality, consistency, and security across platforms
  
• Implement data validation, cleansing, and lineage tracking
  
• Adhere to corporate data governance and compliance standards
  

Required Qualifications

Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent experience) and 7+ years of experience in data engineering and database administration

Technical Skills

• Strong expertise in:
  
• Oracle Database (Application DBA experience required)
  
• Data Warehousing concepts and architecture
  
• Hands-on experience with:
  
• Snowflake
  
• Oracle Analytics Server (reporting and integration)
  
• Python
  
• SQL (advanced querying and performance tuning)
  
• NoSQL databases (MongoDB preferred)
  

Preferred Qualifications

• Experience with cloud platforms (Azure, AWS, or GCP)
  
• Familiarity with modern data stack tools (dbt, Airflow, etc.)
  
• Knowledge of DevOps and CI/CD pipelines
  
• Experience supporting high-volume transactional systems (OLTP)
  
• Exposure to data governance and security frameworks
  
• Strong analytical and problem-solving skills
  
• Ability to balance development and operational DBA responsibilities
  
• Excellent communication and stakeholder collaboration
  
• Detail-oriented with a focus on performance and reliability
  
• Proactive in identifying and resolving system bottlenecks