| Snowflake DBA at Snowflake, Arizona, USA |
| Email: [email protected] |
| From: Zara, TechRakers [email protected] Reply to: [email protected] Client - P acific Investment Management Company Llc (PIMCO) Snowflake Database Engineer/Architect 6 Month contract Hybrid in Newport Beach, CA or Austin, TX Skills: 5+ as a Snowflake DBA years spent in high volume of data companies optimizing databases for ingestion DBA background Snowflake AWS Cloud Infrastructure Dev OPS and CICD Job Description Responsibilities: Data Ingestion Optimization: Implement and manage efficient data ingestion methods into Snowflake, handling high volumes of small files for near real-time querying. Utilize Snowflake features and services to minimize cost and maximize performance. Cross-Cloud Data Sharing: Architect and execute a secure, efficient, and cost-effective data sharing solution between AWS and Azure, ensuring minimal latency and adherence to data security and privacy standards. Warehouse and Data Management: Optimize the use of Snowflake warehouses (LoadWarehouse, ReportWarehouse, AdHocWarehouse) for cost and performance. Manage schemas and tables effectively, considering data archiving and partitioning strategies. Materialized Views and Snowpipe Efficiency: Enhance the performance and cost-effectiveness of materialized views and Snowpipe configurations. Ensure that data ingestion and querying processes are optimized for efficiency and reduced latency. Search Optimization: Implement search optimization techniques to improve query performance, focusing on frequently accessed data. Cost Management and Monitoring: Continuously monitor data ingestion, storage, and querying costs. Leverage Snowflake features and pricing models to minimize expenses while maintaining high performance. Continuous Improvement: Regularly assess and optimize data ingestion, storage, and analysis processes based on performance data. Stay up-to-date with Snowflakes latest features and best practices to drive continuous improvement. Qualifications: Bachelors degree in Computer Science, Information Technology, or related field. Proven experience as a Snowflake Database Administrator or similar role. Deep understanding of Snowflakes architecture, data sharing capabilities, and cost management features. Experience with cloud platforms, preferably AWS and Azure, and cross-cloud data sharing methodologies. Strong analytical and problem-solving skills, with the ability to optimize data processes for performance and cost. Excellent communication skills, with the ability to collaborate effectively with cross-functional teams. Keywords: California Texas |
| [email protected] View all |
| Fri Mar 22 21:29:00 UTC 2024 |