| Oracle Data Warehouse Architect !! Location Sacramento, CA !! at Sacramento, California, USA |
| Email: [email protected] |
| From: Anuj, Vyze inc [email protected] Reply to: [email protected] Job Description - Job Description - Oracle Data Warehouse Architect ( Oracle ) Location: MUST be on-site in Sacramento, CA office 2x-3x per week. No Visa Restrictions Candidates can Relocate BUT expenses not covered. Jd Oracle Autonomous Data Warehouse experience (Oracle ADW) & Experience designing other enterprise data warehouses. Experience with migration from on-prem to Oracle ADW Rolling sleeves up and working on a small team. Excellent communication skills Bing on site 2-3 days a week. ETL/ELT experience. Project Scope: Data Assessment and Profiling: Conduct a comprehensive analysis of the existing on-premises data infrastructure. Profile and assess the quality, volume, and structure of the data to identify potential challenges and opportunities for optimization. Migration Strategy Development: Collaborate with cross-functional teams, including IT, data analysts, and business stakeholders, to understand current and future business requirements. Devise a tailored migration strategy that aligns with organizational goals, ensuring minimal disruption to ongoing operations. Architecture Design and Optimization: Design a robust and scalable data architecture within the Oracle ADW environment. Optimize database schema, queries, and performance to capitalize on the capabilities of Oracle ADW. Data Migration Execution: Lead the execution of the migration plan, orchestrating the seamless transition of data from on-premises databases to Oracle ADW. Implement monitoring and validation processes to ensure data integrity throughout the migration. Performance Tuning and Optimization: Continuously monitor the performance of Oracle ADW, identifying and addressing bottlenecks or inefficiencies. Implement optimization techniques to maximize the benefits of Oracle ADW's autonomous capabilities. Training and Knowledge Transfer: Conduct training sessions for internal teams to familiarize them with Oracle ADW functionalities. Facilitate knowledge transfer sessions to empower the organization in managing and maintaining the Oracle ADW environment independently. Expected Outcomes: Enhanced Data Accessibility: Improved accessibility to data for various business units, enabling faster and informed decision-making. Scalability and Performance: Achieved scalability and optimized performance within the Oracle ADW environment, supporting future growth. Cost-Efficiency: Reduced operational costs associated with maintenance and support of on-premises databases. Autonomous Data Management: Leveraged Oracle ADW's autonomous features for efficient and self-optimizing data management. Key Success Factors: Seamless migration with minimal disruption to daily operations. Improved data quality and accuracy post-migration. Successful integration of Oracle ADW into the existing technology stack. Keywords: information technology California |
| [email protected] View all |
| Tue Mar 05 00:14:00 UTC 2024 |