Expert Oracle Data Architect
On-siteAlpharetta, Georgia, United States
Job Summary
Design, develop, and maintain high-performance OLTP and OLAP databases using Oracle technologies, ensuring transactional integrity, concurrency, and real-time processing. Optimize database performance through indexing, partitioning, and query tuning while creating logical and physical data models for both environments. Develop ETL processes to consolidate data into enterprise-level warehouses and integrate sources to support reporting and business intelligence. Collaborate with stakeholders to translate requirements into technical specifications, provide mentorship to junior architects, and implement data governance frameworks for security and compliance.
Required Qualifications
- Expert Oracle Data Architect
- Minimum of 8-10 years of experience in data architecture
- Strong focus on Oracle OLTP databases
- Proven experience in designing and implementing large-scale OLTP systems
- Proven experience in designing and implementing data warehouses
- Expertise in data modeling
- Expertise in ETL processes
- Expertise in data integration
- Proficiency in Oracle Databases preferably in Cloud
- Proficiency in Oracle Data Integrator (ODI)
- Proficiency in Oracle Exadata
- Strong SQL programming skills
- Strong PL/SQL programming skills
- Familiarity with data warehousing tools and technologies such as ADW
- Familiarity with data warehousing tools and technologies such as Snowflake
- Experience with performance tuning and optimization of Oracle OLTP and OLAP databases
- Excellent problem-solving and analytical skills
- Strong communication and interpersonal skills
- Ability to work independently and as part of a team
- Attention to detail and a commitment to data quality
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.