AWS Snowflake Database Engineer

Key Required SkillsStrong expertise in AWS database services and Snowflake architecture, plus SQL, automation, and scripting.Position Description (AWS & Snowflake Focus)• Design and manage scalable, secure AWS database solutions using RDS, AuroraDB, DynamoDB, Redshift, ElastiCache, EMR, and Neptune.• Configure, optimize, and integrate EMR clusters with diverse data sources.• Integrate AWS databases with Lambda, S3, EC2, and Glue.• Apply AWS security best practices (IAM, encryption, VPC, security groups).• Implement backup, disaster recovery, high availability, and failover using Multi-AZ and read replicas.• Troubleshoot AWS database and cluster issues.• Architect, implement, and manage Snowflake virtual data warehouses with a focus on performance and micro-partitions.• Write and optimize complex SQL for analysis and reporting.• Optimize Snowflake workloads through clustering, caching, and auto-scaling.• Ensure SSA compliance and support technical communications.• Mentor junior developers.Basic Qualifications (AWS & Snowflake Related)• 7+ years as a Database Architect.• Deep experience with AWS database services and data processing platforms.• Proficient in AWS security, compliance, and troubleshooting.• Skilled in performance tuning, caching, clustering, and auto-scaling.• Proficient with automation/scripting: CloudFormation, Terraform, AWS CLI, Python, Bash, PowerShell.Required Skills — AWS & Snowflake Highlights• Expert in relational/NoSQL design and modeling.• High-level experience configuring, launching, and optimizing EMR clusters.• Advanced SQL performance tuning.AWS Expertise• Proven ability to architect scalable, secure, high-performance AWS database solutions.• Experienced integrating AWS databases with Lambda, S3, EC2, Glue.• Strong in IAM roles, encryption, securing clusters, and monitoring via CloudWatch/CloudTrail.Snowflake Expertise• Skilled in designing, implementing, and managing Snowflake warehouses and micro-partitions.• Strong schema design, normalization, and efficient Snowflake data structures.• Experience with Snowflake ingestion, transformation, and loading.• Knowledge of Snowflake RBAC, encryption, and security best practices.• Integrates Snowflake with BI tools (Tableau, Power BI) and uses Python for pipelines/ML.Desired Skills(unchanged, can minimize if needed)