onsite
Senior Data Lead - AWS Aurora, PostgreSQL, Python - HCLTech
Software Engineer
Lead the design, implementation, and operation of scalable data platforms on AWS, focusing on Amazon Aurora PostgreSQL, Python‑based pipelines, and robust data ingestion and governance.
About the role
Key Responsibilities
- Architect, build, and maintain high‑performance data platforms using Amazon Aurora PostgreSQL and related AWS services.
- Develop, optimize, and support Python and SQL based ETL/ELT pipelines for batch and near‑real‑time data ingestion.
- Manage Aurora/RDS lifecycle tasks including provisioning, patching, backups, upgrades, and high‑availability configurations.
- Monitor database health and performance with CloudWatch, implement tuning, indexing, and replication strategies.
- Enforce security, access control, audit logging, and compliance using IAM, S3, and AWS security controls.
Requirements
- 5+ years of hands‑on experience with Amazon Aurora PostgreSQL (or RDS) administration and performance tuning.
- Strong programming skills in Python and solid SQL expertise for data transformation.
- Proven experience designing and operating ETL/ELT pipelines on AWS.
- Deep familiarity with AWS services such as IAM, CloudWatch, S3, and related security best practices.
- Ability to troubleshoot production issues, optimize performance, and drive data governance initiatives.