Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic

Shrijit Sowale

Cumming,GA

Summary

Results-oriented Director of Database Operations and Engineering with over a decade of experience in innovating data management and enhancing performance optimization. Expertise includes managing complex database environments with a focus on automation, process optimization, and ensuring high availability and security. Proven ability to deliver scalable database architectures in both cloud and on-premises settings, utilizing SQL, Python, Shell scripting, and advanced technologies like Snowflake and PostgreSQL. Committed to fostering teamwork while implementing cutting-edge data solutions.

Overview

16
16
years of professional experience
1
1
Certification

Work History

Director

Morgan Stanley
Atlanta, GA
09.2022 - Current
  • Spearheaded the monitoring and optimization of Snowflake, Greenplum, PostgreSQL and Azure PostgreSQL databases, ensuring high availability and top performance across diverse cloud environments.
  • Automated database management tasks using Python, Ansible, and Bash significantly enhance infrastructure provisioning and deployment efficiency on Microsoft Azure.
  • Engineered and optimized ETL pipelines within Snowflake, seamlessly integrating with Airflow for orchestration and DBT for robust data transformation.
  • Developed a cost allocation framework for Snowflake, driving cloud cost transparency and optimizing usage based on team consumption.
  • Designed and optimized data models to improve query performance and storage efficiency in Snowflake.
  • Automated data workflows utilizing Snowflake's integrations with DBT and Airflow, ensuring timely and accurate data delivery.
  • Managed Snowflake cost optimization through strategic resource usage and a comprehensive cost allocation framework across teams.
  • Ensured data security by configuring encryption, access control, and compliance measures to protect sensitive data in Snowflake.
  • Improved system performance through query optimization, result caching, and clustering, reducing query times and enhancing system reliability.
  • Established real-time monitoring and alerting with Snowflake/PostgreSQL native tools and Grafana, proactively identifying and resolving performance issues.
  • Facilitated data sharing across teams using Snowflake's features, providing real-time access to critical datasets for informed decision-making.
  • Responsible for all backup, recovery, and upgrading of all PostgreSQL/Greenplum databases. Developed playbook using Ansible/Python to upgrade databases in parallel.
  • Led a global team of 10, fostering collaboration, mentoring, and promoting best practices to enhance overall team productivity.

Senior DBA

Morgan Stanley
Montreal, Quebec
03.2016 - 09.2022
  • Led deployment and management of PostgreSQL and Greenplum databases, ensuring high availability, performance, and fault tolerance through streaming replication, logical replication, and failover configurations.
  • Optimized query performance and reduced latency by 40% through SQL tuning, indexing, and advanced query optimization.
  • Automated performance monitoring and maintenance tasks using Shell scripts and Python, streamlining operations and reducing manual overhead.
  • Developed and optimized ETL pipelines and data workflows, integrating PostgreSQL and Greenplum with Airflow for efficient data movement.
  • Proactively managed database performance and troubleshooting with WT/Sockeye, Grafana, and Prometheus, ensuring system health, and preventing outages.

Database Consultant

Deem Corporation
Bengaluru, India
03.2015 - 03.2016
  • Led automation, orchestration, and DevOps initiatives within the Predix cloud environment for the client, General Electric, streamlining workflows and improving operational efficiency.
  • Managed and maintained PostgreSQL & GreenPlum instances, ensuring reliability and optimal performance.
  • Implemented real-time monitoring and performance tracking for cloud instances using Grafana, Sensu, and Vistara.
  • Analyzing Tables & Schemas, collecting system statistics, reorganizing tables and rebuilding indexes.
  • Experience in OEM, AWR, ADDM, and ASH for proactive monitoring, diagnosing, analyzing, and resolving database issues.
  • Responsible for technical and administration aspects of 10G/11/12C databases (RAC/non RAC) including installation, configuration, patching, upgrade using various database admin tools on Linux/Solaris/HP-UX/AIX platforms.

Senior DBA

Informatica
Bengaluru, India
07.2013 - 03.2015
  • Configured PostgreSQL Streaming Replication and Pgpool for load balancing, enhancing performance and scalability across multiple environments.
  • Managed advanced monitoring tools such as PgBadger, Grafana, Kibana, and Nagios, driving system performance improvements and operational efficiency.
  • Led PostgreSQL database upgrades, migrations, and backup/recovery processes, ensuring smooth transitions and data integrity across diverse platforms.
  • Designed and implemented ETL pipelines and data warehouse solutions, leveraging Greenplum and PostgreSQL procedural languages for optimized data integration.
  • Established replication with pglogical and PostgreSQL Logical Replication for enhanced data redundancy and high availability.
  • Optimized complex SQL queries and reporting using advanced techniques to ensure data accuracy, integrity, and performance.
  • Utilized backup tools like Barman, pgBackRest, and gpdump for data reliability, managing databases over 1.5 TB in high- availability environments.
  • Developed and executed disaster recovery plans, ensured 24/7 availability, and automated routine tasks (backups, re- indexing, vacuuming) for seamless operations.

Consultant

Capgemini Technology Services
Bengaluru, India
06.2009 - 07.2014
  • Spearheaded database optimization projects, reducing SQL bottlenecks, and improving system stability and performance by 25%.
  • Implemented advanced encryption and security protocols, ensuring compliance with industry standards.
  • Implemented automation for database maintenance workflows, cutting manual intervention by 40%.
  • Proficient in managing Oracle Database versions from 9i to 12c across Linux and Solaris systems.
  • Creating physical standby databases and configuring high availability using RAC in 10g and 11g environments.
  • Responsibilities involved installation, patching, cloning, upgrading, migrating, along with user management, database refresh, resolving technical issues reported by clients, and all other maintenance tasks.
  • Cloning the databases using RMAN for UAT servers from the production databases.
  • Exposure to ITIL processes, and infrastructure services quality and practices followed in the IT industry.

Education

Bachelor of Engineering - Computer Science

Raisoni College of Engineering
Nagpur
06-2004

Skills

DATABASE OPTIMIZATION & PERFORMANCE TUNING

POSTGRESQL / ORACLE / SNOWFLAKE
SPLUNK
SHELL SCRIPTING TERRAFORM JENKIN ANSIBLE
DATABASE MIGRATION

Snowflake, Greenplum, Python, scripting, Perl

AZURE CLOUD

VERSION CONTROL USING GIT

Certification

  • Microsoft Certified : Azure Administrator Associate(Az-104)
  • Snowflake SnowPro Core Certified

Languages

English
Professional
Hindi
Professional
Marathi
Professional

Timeline

Director

Morgan Stanley
09.2022 - Current

Senior DBA

Morgan Stanley
03.2016 - 09.2022

Database Consultant

Deem Corporation
03.2015 - 03.2016

Senior DBA

Informatica
07.2013 - 03.2015

Consultant

Capgemini Technology Services
06.2009 - 07.2014

Bachelor of Engineering - Computer Science

Raisoni College of Engineering

Similar Profiles

CREATE PROFILE