| Data Architect :: Hybrid onsite- Santa Clara, CA :: Contract at Remote, Remote, USA |
| Email: [email protected] |
| From: Vikas Kumar, Tanisha Systems [email protected] Reply to: [email protected] Role: Data Architect Location: Hybrid onsite- Santa Clara, CA Type: Contract Mandatory Areas Must Have Skills Data Architect Skill 1 4+ Years of Exp in Data Architecture Skill 2 7+ Years of Exp in Modelling Data lake Skill 3 7+ Years of Exp in Modelling Data warehouse Skill 4 8+ Years of Exp in SQL programming and query optimization Data Architect with expertise in modeling data lake and data warehouse environments, as well as extensive experience in database analysis, optimization, and query performance optimization. The ideal candidate will have a strong understanding of database table retrievals, partitions, indexing, and query optimization techniques. Responsibilities: Design and implement logical and physical data models for data lake and data warehouse environments. Collaborate with stakeholders to gather requirements and translate them into effective data models. Develop and maintain data architecture standards and best practices for data lake and data warehouse implementations. Design and implement data partitioning strategies to enhance query performance on large datasets. Define and implement appropriate indexing strategies to optimize data retrieval operations. Analyze database performance and identify areas for optimization, including query tuning, index optimization, and database configuration tuning. Collaborate with database administrators and developers to optimize database performance and resolve performance issues. Conduct thorough database analysis to identify and resolve bottlenecks and performance challenges. Perform capacity planning and recommend hardware/software upgrades to support data architecture requirements. Stay up-to-date with emerging trends and technologies in data architecture, data management, and query optimization. Requirements: Bachelor's degree in Computer Science, Information Systems, or a related field (Master's degree preferred). Proven experience as a Data Architect, specifically in modeling data lake and data warehouse environments. Strong understanding of database table retrievals, partitions, indexing, and query optimization techniques. Proficiency in data modeling tools such as ERwin or PowerDesigner. Expertise in SQL programming and query optimization. Experience with data warehousing platforms such as Oracle, SQL Server, Clickhouse or any columnar database. Strong analytical and problem-solving skills with the ability to analyze complex database performance issues. Excellent communication and collaboration skills to work effectively with cross-functional teams. Ability to prioritize and manage multiple projects simultaneously. Knowledge of emerging trends and technologies in data architecture and query optimization. Thanks & Regards Vikas Kumar Technical Recruiter Tanisha Systems Inc. Mob: 212-729-6543 Ext 304 Email: [email protected] Web: www.tanishasystems.com Address : [99 Wood Ave South Suite # 308, Iselin, NJ 08830] Keywords: California New Jersey |
| [email protected] View all |
| Mon Mar 18 21:42:00 UTC 2024 |