Summary
Overview
Work History
Education
Skills
Certification
ADDITIONAL HIGHLIGHTS
Timeline
Generic

Sankar Mandalapu

North Carolina,NC

Summary

Dynamic Snowflake Administrator and Developer with over 14 years of IT experience specializing in database administration, cloud platforms, and enterprise migrations within the banking and healthcare sectors. Expertise in Snowflake platform administration includes security (RBAC), performance tuning, and cost optimization, ensuring efficient management of scalable environments on AWS. Proven ability to automate administrative processes while maintaining high availability, performance, and data security. Committed to leveraging technical skills to drive innovation and enhance operational efficiency in data-driven organizations.

Overview

15
15
years of professional experience
1
1
Certification

Work History

Snowflake Administrator / Developer

Pfizer Inc.
New York, USA
06.2025 - Current
  • Administer and manage enterprise Snowflake environments on AWS, ensuring high availability and security
  • Implement and manage RBAC roles, users, and access control policies across business units
  • Automate user provisioning, warehouse monitoring, and metadata extraction using Python
  • Configure and optimize virtual warehouses, improving query performance and reducing compute costs
  • Implement resource monitors and auto-scaling policies to control Snowflake usage and cost
  • Utilize Snow pipe for automated data ingestion from AWS S3
  • Leverage Streams & Tasks for incremental data processing and automation workflows
  • Perform performance tuning using QUERY_HISTORY, ACCOUNT_USAGE, and query profiling
  • Support Time Travel and Zero-copy cloning for data recovery and environment replication
  • Integrate Snowflake with AWS services (S3, IAM, Lambda)
  • Orchestrated data movement between Fabric OneLake and Snowflake stages
  • Implement CI/CD pipelines for Snowflake objects using GitHub and GitLab CI
  • Designed hybrid architecture combining Fabric for ingestion and Snowflake for analytics
  • Monitor system health and troubleshoot performance bottlenecks
  • Integrated Microsoft Fabric pipelines with Snowflake for data ingestion and transformation
  • Environment: Snowflake, AWS (S3, IAM, Lambda, EC2), Snow pipe, Streams & Tasks, RBAC, Virtual Warehouses, Resource Monitors, Time Travel, Zero-Copy Cloning, Python, SQL, DBT, GitHub, GitLab CI/CD, Terraform, Docker, Snow sight, Snow SQL, QUERY_HISTORY, ACCOUNT_USAGE, Jira, ServiceNow,Microsoft Fabric

Snowflake Administrator / Developer

Infosys Ltd. – Client: Pfizer Inc.
India
01.2021 - 04.2025
  • Managed Snowflake platform operations including security, performance, and cost optimization
  • Designed and implemented automated data ingestion using Snow pipe
  • Built and maintained Streams & Tasks pipelines for scheduled data processing
  • Optimized warehouse workloads, reducing compute cost by ~15%
  • Implemented data sharing and secure access strategies across teams
  • Developed Python scripts for data validation, monitoring, and automation
  • Built DBT models and integrated CI/CD workflows
  • Collaborated with DevOps teams for containerized deployments using Docker
  • Monitored and resolved query performance issues and system bottlenecks
  • Environment: Snowflake, AWS (S3, IAM), Snow pipe, Streams & Tasks, RBAC, Virtual Warehouses, Python, SQL, DBT, GitHub, GitLab CI/CD, Docker, Snow sight, Snow SQL, Performance Tuning Tools, Jira

Senior Oracle Database Administrator (L2&L3 Support)

Infosys Ltd. – Client: National Australia Bank
India & Australia
12.2012 - 12.2020
  • Provided L3 production support for large-scale Oracle environments (9i–19c)
  • Managed Oracle RAC, Data Guard, and Goldengate for mission-critical banking systems
  • Designed and implemented high-availability architecture for a fast payments platform
  • Planned and executed database upgrades and patching with minimal downtime
  • Successfully upgraded payments databases with only 2 minutes of outage
  • Migrated 200+ databases between data centers and platforms (Solaris to Linux)
  • Implemented multi-standby configurations with Fast-Start Failover
  • Performed performance tuning using AWR, ADDM, TKPROF, and SQL Plan Management
  • Built and monitored DR environments; executed switchover and failover operations
  • Managed enterprise monitoring using OEM 13c, including agents and alerting
  • Conducted capacity planning, trend analysis, and root cause analysis
  • Environment: Oracle (9i–19c), Oracle RAC, Data Guard, Golden Gate, RMAN, AWR, ADDM, TKPROF, SQL, PL/SQL, OEM 13c, Unix/Linux (Solaris, AIX, Red Hat), Shell Scripting, Data Pump, SQL
  • Loader

Junior Oracle Database Administrator

Infosys Ltd. – Client: Apple Inc.
India
10.2011 - 11.2012
  • Supported production of Oracle databases across multiple environments
  • Installed and configured Oracle software; created and upgraded databases
  • Performed RMAN backups, restores, cloning, and disaster recovery operations
  • Managed users, schemas, tablespaces, and data file growth
  • Built and maintained physical standby databases
  • Applied Oracle patches and performed database upgrades
  • Monitored database health, storage, and mount points
  • Supported schema refreshes and object deployments using Export/Import utilities
  • Environment: Oracle Database, RMAN, SQL, PL/SQL, Unix/Linux, Data Pump, Export/Import Utilities, OEM, Shell Scripting

Education

Bachelor of Engineering (B.E.) - Electronics & Communication Engineering

Anna University
India
2006

Skills

  • Snowflake Architecture (Virtual Warehouses, RBAC, Snow sight, CLI, APIs)
  • Advanced SQL & Query Optimization
  • AWS Cloud (EC2, S3, RDS, IAM, Lambda)
  • Python for Automation & ETL/ELT Pipelines
  • Database Design & Data Modeling
  • Performance Monitoring & Troubleshooting
  • Infrastructure as Code (Terraform)
  • Data Governance & Security
  • ITSM & Agile (Jira, ServiceNow)
  • High Availability & Disaster Recovery
  • Databases: Snowflake, Oracle (9i–19c)
  • Cloud Platforms: Oracle Cloud Infrastructure (OCI), AWS (EC2, RDS, S3), Azure, Cortex AI
  • Operating Systems: Oracle Linux, Red Hat Linux, Solaris, AIX, HP-UX, Windows
  • Languages: SQL, PL/SQL
  • Tools: RMAN, OEM 12c/13c, AWR, ADDM, TKPROF, Log Miner, TOAD, DBCA, SQL
  • Loader, Exp/Imp, Data Pump
  • DevOps & Data Tools: DBT, GitHub, GitLab CI/CD, Terraform
  • Replication & HA: Oracle RAC, Data Guard, Golden Gate, PostgreSQL Replication
  • Domains: Banking, Healthcare/Pharma, Insurance, Retail, Manufacturing

Certification

  • Oracle Certified Associate (OCA)
  • Oracle Real Application Clusters (RAC) Certification
  • Oracle Cloud Infrastructure (OCI) Certification

ADDITIONAL HIGHLIGHTS

  • Designed canonical data models in Snowflake as a single source of truth
  • Extensive experience with data sharing, tasks, events, and access controls in Snowflake
  • Hands-on experience with OCI Compute, VCNs, subnets, NSGs, load balancers, VPN/IPSec, and Fast Connect

Timeline

Snowflake Administrator / Developer

Pfizer Inc.
06.2025 - Current

Snowflake Administrator / Developer

Infosys Ltd. – Client: Pfizer Inc.
01.2021 - 04.2025

Senior Oracle Database Administrator (L2&L3 Support)

Infosys Ltd. – Client: National Australia Bank
12.2012 - 12.2020

Junior Oracle Database Administrator

Infosys Ltd. – Client: Apple Inc.
10.2011 - 11.2012

Bachelor of Engineering (B.E.) - Electronics & Communication Engineering

Anna University