Data Engineer (Oracle Apps)

Compunnel, Inc.; Merrimack (NH); On-site; USD 120,000 - 180,000; Full time

Job summary

Compunnel, Inc. is seeking a Senior Data Engineer with Application DBA expertise to design, build, optimize, and support enterprise data platforms.

This role combines advanced data engineering with hands-on database administration, ensuring high availability, performance, and scalability of critical data systems. The candidate will develop data models, build data warehouses across Oracle and Snowflake, and implement efficient ETL processes using Python and SQL.

Qualifications

• Bachelor’s degree or equivalent experience.
• 7+ years of experience in data engineering and database administration.

Responsibilities

• Design, build, optimize, and support enterprise data platforms.
• Administer, monitor, and tune Oracle databases; ensure high availability and performance.
• Develop and maintain data models and data pipelines across Oracle and Snowflake.
• Support reporting environments and collaborate with BI teams to ensure data quality.

Skills

Oracle Database

Informatica

Data Warehousing

Snowflake

Oracle Analytics Server

Python

SQL

NoSQL MongoDB

Education

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

Tools

Azure

AWS

GCP

Job description

We are seeking a highly skilled Senior Data Engineer with Application DBA expertise to design, build, optimize, and support enterprise data platforms. This role combines advanced data engineering with hands‑on database administration, ensuring high availability, performance, and scalability of critical data systems. The ideal candidate brings deep experience in data warehousing, ETL development, and database management, along with a strong foundation in modern cloud data platforms.

Key Responsibilities

Application DBA Responsibilities

• 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

Cloud & Modern Data Platforms

• 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)
• Informatica (ETL development)
• 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

Key Competencies

• 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