Pankaj Chahar
Domain Consultant @Tata Consultancy Services
Signup · Get unlimited contacts
WORK HISTORY
Domain Consultant @Tata Consultancy Services
Lead database reliability and DevOps for Aviva Insurance, covering PostgreSQL, Redshift, Teradata, DynamoDB, MSSQL, and Oracle.• Architected automation solutions that improved uptime and delivered £900K+ annual savings through EC2/RDS/Redshift scheduling, certificate automation, and storage optimisation.• Designed and led rollout of PostgreSQL on Snowflake, including migration blueprinting, performance parity validation, and Terraform/Python automation.• Directed Teradata → Redshift migration, including schema mapping, workload analysis, S3 staging, and COPY optimisation.• Built CI/CD pipelines using Jenkins, Groovy, ADO, and Git; implemented IaC using Terraform and Ansible.• Delivered major performance improvements, reducing PostgreSQL/Redshift query latency by 50%.• Mentored engineers and drove adoption of SRE, observability, and cloud‑native best practices.
EDUCATION
S S Public School Agra
All india higher secondary school examination, Mathematics and Computer Science
Hindustan Institute of Technology & Management
Bachelor of Technology (B.Tech.), Computer Science
AGRA COLLEGE, AGRA
Postgraduate, Journalism and Mass Communications
SKILLS
ABOUT PANKAJ CHAHAR
Database & DevOps Lead | AI FDE | FinOps | PostgreSQL • Redshift • Teradata • AWS | Cloud Migrations | Automation & SRE |Certified by : Teradata|Oracle|Tableau|NSE 1 & 2|IBM Cloud|Alibaba|GCP|Azure|Informatica|AWS|Aviatrix ACE |k8s |SSYB|SCRUM|AIML|USA VISA | UK Work VISA|SUMMARY:Strategic and hands‑on Database & DevOps Lead with 12+ years of experience building high‑reliability, automation‑first data platforms across PostgreSQL, AWS, Redshift, Teradata, and distributed systems. I specialise in designing scalable architectures, leading cloud migrations, and driving performance engineering for mission‑critical workloads.At TCS UK, I lead database reliability and DevOps for UK’s largest Insurance, delivering automation solutions that improved uptime, reduced operational toil, and generated £900K+ annual savings through cost‑optimisation and cloud‑native engineering.My expertise spans PostgreSQL on Snowflake, Teradata‑to‑Redshift migrations, IaC (Terraform, Ansible), CI/CD (Jenkins, ADO), and AWS services including RDS, EC2, Lambda, CloudWatch, SSM, and EventBridge. I have deep experience in performance tuning, workload management, and building resilient data ecosystems.Recognised by AWS and IBM for innovation in automation and observability, I thrive in roles that blend architecture, leadership, and hands‑on engineering. I enjoy mentoring teams, driving SRE best practices, and delivering measurable business impact.UK GMS Work Permit (Dec 2027)| USA B1 Visa (May 2026)Onsite experience in the USA & UK for integration & project transitionI’m passionate about cloud‑native data platforms, distributed databases, and building engineering cultures that prioritise reliability, automation, and continuous improvements.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.