Data Engineer- Oracle Apps 181451

Key ResponsibilitiesApplication 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: