Data Engineer - Oracle Apps 181451

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