Data Engineer- Oracle Apps

Job InformationJob Type: ContractIndustry: Financial ServicesCity: DurhamState/Province: North CarolinaCountry: United StatesZip/Postal Code: 27701Job DescriptionKey Responsibilities:Application DBA ResponsibilitiesAdminister, monitor, and tune Oracle databases supporting critical applicationsManage database performance (query optimization, indexing, partitioning, and execution plans)Perform database maintenance activities (backups, recovery, patching, upgrades)Ensure high availability, disaster recovery, and data integritySupport application teams in database design and troubleshootingData Engineering & ArchitectureDevelop and maintain data models (dimensional and normalized) to support analytics and reportingBuild and optimize enterprise data warehouse solutions across Oracle and Snowflake platformsEnsure efficient ingestion, transformation, and integration of structured and unstructured dataDesign, develop, and maintain scalable data pipelines and ETL processes using tools such as Informatica and PythonReporting & Analytics SupportSupport and enhance Oracle Analytics Server reporting environmentsCollaborate with BI and analytics teams to ensure data accuracy and usabilityOptimize data structures for reporting performanceCloud & Modern Data PlatformsDevelop and maintain solutions in Snowflake cloud data warehouseImplement best practices for cloud data architecture, cost optimization, and performanceWork with NoSQL technologies (MongoDB) for semi-structured and unstructured data use casesDevelopment & AutomationWrite efficient, reusable, and scalable code using Python and SQLAutomate data workflows, monitoring, and alertingImplement CI/CD practices for data pipelines and database deploymentsData Governance & QualityEnsure data quality, consistency, and security across platformsImplement data validation, cleansing, and lineage trackingAdhere to corporate data governance and compliance standardsRequired 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 administrationTechnical Skills:Strong expertise in: Oracle Database (Application DBA experience required) Informatica (ETL development) Data Warehousing concepts and architectureHands-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 pipelinesExperience supporting high-volume transactional systems (OLTP)Exposure to data governance and security frameworksKey Competencies:Strong analytical and problem-solving skillsAbility to balance development and operational DBA responsibilitiesExcellent communication and stakeholder collaborationDetail-oriented with a focus on performance and reliabilityProactive in identifying and resolving system bottlenecks