Vish Subramanian
CLARKSBURG,MD
Summary
Responsive expert experienced in monitoring database performance, troubleshooting issues and optimizing database environment. Possesses strong analytical skills, excellent problem-solving abilities, and deep understanding of database technologies and systems. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills.
Overview
22
22
years of professional experience
1
1
Certification
Work History
Lead Data Engineer (Infra)
COSTAR GROUP (HOMES.COM)
1 2017 - Current
- Led a cross-functional team in executing cloud migration initiatives, overseeing deployment of multiple Aurora RDS instances, managed SLA’s and upgrades
- Managed data pipelines to extract, transform, and load data from various sources in cloud and in premise using technologies such as KAFKA, DMS, AWS Glue into Snowflake and databricks (DLT’s) using SQL and Python
- Collaborated with data scientists, analysts, and business users to understand data requirements and optimize data models , algorithms for quality, security, and governance for GDPR /SOX compliance
- Integrated data into Costar Enterprise data models from various sources Kafka, dynamo DB utilizing state driven infrastructure utilizing Terraform
- Optimized Databricks (DLT’s) and processing workflows to ensure optimal performance, scalability, and efficiency
- Built End to End architecture for BI /Analytics in Power BI and ThoughtSpot
- Created and maintained data mapping documentation, training/onboarding documentation, established best practices and oversaw CI/CD deployments in Azure Devops
- Interacted with Business Stakeholders, Business Data Architect, and Data Manager to develop mapping specification documentation and translate non-technical concepts into technical data infrastructure
- Preparing charter, specification documents, executing / aligning with stake holders specs
- Provided guidance and recommendations to leadership regarding data solutions and made critical decisions to ensure understandable information dissemination across the organization.
Lead Engineer in core product team
COMMVAULT
01.2017 - Current
- Played a pivotal role in the comprehensive database re-design as a key member of the core product engineering team for Metallic, a Commvault product
- Elevated the ETL framework, effectively consolidating data from diverse sources for cloud reporting purposes
- Utilized SQL, Python, Sqoop, Flume, and H2 Cache to design workflows, SIEM reports, and dashboards, enhancing data visualization and analysis capabilities
- Provided direct support for customer SQL Server production issues, actively participating in calls to address concerns promptly, resolved escalated SAAS/Azure issues through advanced troubleshooting and optimization techniques, ensuring seamless operation of cloud environments
- Led the creation of a proactive troubleshooting framework, proactively monitoring and maintaining the health of cloud environments
- Guided the establishment of code review guidelines and identified performance bottlenecks, optimizing code for efficiency and reliability
- Championed the transition of several C++ code to SQL, leveraging SET-based operations
- Evaluated data insights and comparisons from Rubrik, providing comprehensive reports for sales and product teams to facilitate informed decision-making.
Solutions Architect
INTERNATIONAL MONETARY FUND
06.2009 - 12.2016
- Orchestrated operational support for TGSIK Division and Joint Library production servers, developing charters, disaster recovery plans, and server migration strategies
- Played a pivotal role in server consolidation initiatives and outage-interval server moves, ensuring seamless operations and minimal downtime
- Provided mentorship to offshore teams, effectively managing escalations, and ensuring timely issue resolution
- Configured and maintained SQL Clusters, Always on Availability Groups, and standalone SQL Servers to ensure optimal performance and reliability
- Developed and implemented comprehensive disaster recovery plans, conducted patch management, and optimized T-SQL queries to enhance database performance and security
- Collaborated with development teams to establish audit procedures and enhance table security, ensuring compliance with industry standards and regulations.
Solutions Architect
WIPRO
04.2005 - 06.2009
- Member of Wipro Solutions delivery team ,worked with several esteemed clients including US Bank, Washington Mutual, Capital One Auto, Credit Suisse, and Microsoft Corporation in client premise as consultant
- Spearheaded comprehensive database operations for diverse clients, implementing best practices and effectively managing incidents
- Orchestrated server migration processes, facilitated handoff routines, and maintained offshore support environments to ensure seamless operations
- Managed remote operation management, change control processes, and adherence to SLAs, while providing training and support to team members.
System Analyst Developer
INNOVA SOLUTIONS (NESS TECHNOLOGIES)
11.2004 - 04.2005
- DB Development SQL, Visual C++, VB, support performing Click Stream Analysis, Site traffic analysis for Sage metrics (Nielsen Ratings)
Engineer /Developer Programmer
SATYAM COMPUTERS
04.2002 - 05.2004
- Primary Database Developer involved in DB Design, Development (SQL and Erwin) and support of https://events.microsoft.com/ for Client Microsoft R & D, setting up Localization.
Education
Master’s in leadership -
Northeastern University
Bachelor’s in computer science - undefined
Madras University
Skills
SQL Server
Aurora PostgreSQL
Snowflake
DynamoDB
Databricks (Unity Catalog)
SQL Server
Aurora PostgreSQL
Snowflake
DynamoDB
Databricks (Unity Catalog)
AWS
Azure (Devops, Apps, Fabric)
SQL
Terraform
Python
YAML
PowerShell
Certification
AWS Certified Solutions Architect – Associate
Timeline
Lead Engineer in core product team
COMMVAULT
01.2017 - Current
Solutions Architect
INTERNATIONAL MONETARY FUND
06.2009 - 12.2016
Solutions Architect
WIPRO
04.2005 - 06.2009
System Analyst Developer
INNOVA SOLUTIONS (NESS TECHNOLOGIES)
11.2004 - 04.2005
Engineer /Developer Programmer
SATYAM COMPUTERS
04.2002 - 05.2004
Lead Data Engineer (Infra)
COSTAR GROUP (HOMES.COM)
1 2017 - Current
Master’s in leadership -
Northeastern University
Bachelor’s in computer science - undefined
Madras University