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