Data Engineer- Oracle Apps 181451
Durham, NC, United States1mo ago
Key details
- Location
- Durham, NC, United States
- Work style
- Onsite
- Level
- Senior
- Job type
- Contract
- Experience
- 7–10 yrs
- Function
- Data & ML
- Focus area
- Data engineering & Analytics
- Posted
- 1mo ago
Skills
airflowawsazureci/cdcloud computingdata architecturedata governancedata modelingdata pipelinesdata qualitydata structuresdata validationdata warehousingdatabase administrationdatabase designdatabase managementdbtdevopsdisaster recoveryetlgcpinformaticamongodbnosqloracleoracle databasepythonquery optimizationsnowflakesql
About the role
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
How well do you match this job?
Skills
Experience
Level
Title
Location
Salary
Freshness
Similarity
Free account needed to apply or save. It takes a minute, and we'll bring you right back to this job.