• Provide primary data engineer for real-time production support, ensuring minimal downtime of mission-critical data pipelines. • Rotate the role and on call requirements. • Monitor, troubleshoot, and optimize data pipeline failures, query performance bottlenecks, and data discrepancies using AWS CloudWatch, Redshift, and PostgreSQL. • Automate Root Cause Analysis (RCA) reporting, reducing resolution time by 30%+ through proactive alerting and system monitoring. • Implement best practices in IAM roles, encryption, and regulatory compliance (HIPAA, GDPR) to ensure data security and governance. • Design, develop, and maintain scalable ETL pipelines using AWS Glue, Lambda, Redshift, S3, and PostgreSQL. • Optimize query performance through partitioning, indexing, query tuning, and materialized views, achieving significant performance improvements. • Implement CI/CD pipelines for automated deployments using AWS CodePipeline, Terraform, and CloudFormation to improve system stability and deployment efficiency. • Support streaming data pipelines using Kafka, Kinesis, or Spark Streaming for real-time data ingestion and processing. • Assist in scaling, performance tuning, and automation to optimize data platform efficiency. • Collaborate with business intelligence teams and analysts to develop high-quality data models that support analytics and decision-making. • Build interactive dashboards and reports using Power BI, Tableau, or Looker to enable real-time insights for stakeholders. • Automate data validation, cleansing, and quality checks, ensuring 99.9%+ data accuracy across critical business functions.