Summary
Overview
Work History
Education
Skills
Timeline
Generic

Ranjith Vadde

Austin

Summary

Principal Database Engineer and Data Architect with expertise in developing and maintaining high-SLA operational databases. Demonstrated ability to design robust database architectures while balancing technical feasibility and cost considerations. Skilled in creating POCs with emerging technologies and implementing effective solutions aligned with business needs. Extensive experience designing ETL data pipelines for structured and unstructured data integration into data lakes and warehouses.

Overview

16
16
years of professional experience

Work History

Principal Data Architect

XeoMatrix
08.2023 - Current
  • Designed and developed Matillion ETL pipelines to extract the SQL Server data into Google Big Query.
  • Architect the GCP environment and designed DataLakehouse on Big Query.
  • Designed and developed Matillion ETL pipelines to extract the data from multiple MYSQL dumps into a centralized database in Google Big Query.
  • Python scripting to download daily backup from SFTP location and restore on GCP VM Instance.
  • Developed Google functions Python code to load data from API Data sources incrementally.
  • Designed and developed Matillion ETL pipelines to extract data files from cloud storage and put them into a centralized database in Google Big Query using Medallion architecture.
  • Involved in Presales and scoping engagements for over 100 clients and designed their data strategy.
  • Architect and delivered data engagements for over 30 Clients, which enabled Clients to make decisions using data insights.

Principal Database Engineer/ Data Architect

Pitney Bowes
03.2022 - 07.2023
  • Led 5 Database DevOps Engineers from onsite and offshore as part of the Global E-commerce team, which handles more than 10 Operational databases.
  • Scaled SQL Server P2P Instances to handle data of 15 TB and auto-archive data of older than 3 months.
  • Redesigned the self-hosted SQL Server Database on AWS to handle the API requests at the average response time of 150ms and at the same time, application writes at 500 MB/Sec.
  • Designed and developed a modern data warehouse in Snowflake with over 200k savings and developed Snaplogic data pipelines to migrate existing data from SQL Server Data Warehouse.
  • Developed Snaplogic data pipelines to pull data from Kafka topics into the Snowflake database, and this reduced load on the operational SQL Server database.
  • Developed Complex Stored procedures and TSQL scripts on very large datasets with optimized code.
  • Developed stored procedures, functions, and tasks in Snowflake to load the data incrementally and use SQL scripts for analytical reports.
  • Developed Power BI analytical reports like latency and comparison reports to gauge the application's performance.
  • Optimized the reads on the SQL Server database using Redis Cache.
  • Experience working with Confluent Kafka and the ability to read and search the messages on the topic.
  • Implemented Database CI/CD using the Azure DevOps and Visual Studio Database project, which can handle the high availability architecture of Peer-to-Peer replication.
  • Upgraded SQL Server 2017 instance to SQL Server 2019 with zero downtime and no impact on the performance of the application.
  • Managed and migrated Mongodb Atlas Azure to Mongodb Atlas AWS as part of cloud infrastructure consolidation.
  • Developed shell scripts to update the MongoDB data periodically for custom batch updates.
  • Mongo Database tuning by analyzing queries and optimized with new indexes.
  • Developed code and maintained Azure SQL Server, Azure SQL Managed Instance.
  • Migrated Azure SQL database to Azure Managed SQL instance using BACPAC file export and import.
  • Document the database design artifacts and SOPs in Confluence.
  • Worked with Data Scientists to help them understand the data and review the output of machine learning models.

Lead SQL Server/MYSQL/Mongo Database DevOps Engineer

Pitney Bowes
03.2018 - 02.2022
  • Worked as a Lead Database DevOps Engineer to support Global Shipping Ecommerce product with databases on SQL Server, Oracle MYSQL and MongoDB hosted on AWS EC2 machines and Microsoft Azure.
  • Designed and developed the SQL Server database active-active solution to support zero downtime deployment and server patching by leveraging the P2P replication multi-master topology.
  • Developed the out-of-the-box solution to implement Partition Purge in Peer-2-Peer replication topology.
  • Migrated a few non-critical SQL Server databases to Amazon Aurora MYSQL RDS using AWS DMS.
  • Implemented DBAtools, an open-source PowerShell module in migrating existing SQL Server Instance to newer version of SQL Server Instance.
  • Designed and developed database solutions to enable zero-downtime database server migration from company-hosted instance to AWS EC2 Cloud.
  • Developed SQL scripts to set up P2P replication to automate the database deployment.
  • Developed SQL scripts to set up Always ON high availability to automate the database deployment.
  • Developed Terraform scripts to spin up database virtual machines with disk allocation and SQL Server Installation.
  • Implemented custom SQL Server database monitoring by implementing TIG Stack (Telegraf, InfluxDB, and Grafana).
  • Migrated Azure SQL Databases to Azure Managed Instance to improve the performance of the application.
  • Upgrading MongoDB version 3.6 to 4.2 with zero downtime patching hosted on self-managed AWS EC2 instances.
  • Participate in on-call rotation to support database uptime and maintenance activities.
  • Participate in annual budget allocation for database infrastructure and redesign the database infrastructure for cost savings and high availability.
  • Participate in Interviews to hire new Database Engineers.

Senior SQL Server Database Engineer

Pitney Bowes
03.2017 - 02.2018
  • Worked as Database developer DBA to support legacy and parcel tracking applications.
  • Migrated existing SQL Server 2012 Servers to SQL Server 2016 with minimal down time.
  • Developed SQL scripts to fix the data caused by application bugs.
  • Worked with application developers to implement Redgate Database Source Control as part of Database Life Cycle Management (DLM) to streamline the Database deployments and CI/CD with Jenkins.
  • Implemented Partitioning on operational database and refactored queries to use the partition key to improve the performance of the application.
  • Played a key role in Organization structural changes in database production operations team as part of DevOps DBE implementation.
  • Improved Database operations with industry standard Ola’s Database maintenance jobs and redesigned the DR strategy to have minimal impact to application.
  • Implemented Resource Governor in Production SQL Server systems to reduce the blocking to applications caused by developers and product support team.

Programmer Analyst

Sparity Inc.
01.2012 - 02.2017
  • Worked as Database developer DBA to support legacy and new tracking applications.
  • Design and develop SQL scripts for database deployment process using SQLCMD, BCP method to reduce the deployment time.
  • Maintained DB Schema and Code Change Management using SVN for legacy applications and GITLAB using SourceTree client tool.
  • Developed SSIS package to create archival process to purge the data through weekly scheduled SQL agent job.
  • Designed and Implemented Peer-to-Peer replication by replacing existing Identity key with custom primary key logic using SEQUENCES.
  • Developed custom scripts using BCP to resolve the data issues in replication and optimized the existing replication topology.
  • Develop scripts for schema and data migration with minimum downtime requirements.
  • Optimized existing SQL stored procedures to reduce the locking and blocking and identified existing Ad hoc SQL routines used in Entity Framework to convert them into stored procedures.
  • Designed and implemented migrating database applications to AWS EC2 cloud infrastructure and baselining, optimizing to match existing application SLA.
  • Troubleshoot and fix the application errors and performance issues on production instances.
  • Implemented Partitioning on reporting databases and automated auto archival of data through Sliding Window Partitioning/SQL job.
  • Developed SSIS package to push transactional data from operational database to reporting database.

SQL Server Developer

SilkRoad Technologies
05.2011 - 12.2011
  • Worked as Database developer to support HR applications.
  • Designed and implemented Data marts using Dimensional modeling for Client’s KPI reporting requirements.
  • Designed ETL SSIS packages to load data into Data warehouse on a daily basis to perform the Incremental Historical data load from Source to Staging Environment and into the Enterprise Data warehouse.
  • Designed and implemented functionality to add User Defined Custom fields to existing reports.
  • Tuned the performance of SQL Server Instances and Queries using System DMVs, Profiler, and Extended Events (XE).
  • Developed Unit Testing framework and created Stored Procedures for Unit testing and implemented code to track the results to analyze the performance.
  • Automation via scripting tools such as PowerShell (in addition to T-SQL).
  • Created Table Partitioning and Filegroups for improved ETL and Query performance.
  • Troubleshooting & Resolving SharePoint 2010 / SQL Server 2012 Reporting Services (SSRS) /Kerberos Authentication issues.
  • Designed Standard Tabular type reports, including Drill down and Drill through functionality and Visual presentations such as Charts using SSRS and SharePoint PerformancePoint service.
  • Created interactive reports with SSRS using the report parameters, query parameters, Filters and Expressions.
  • Designed Dashboards and Scorecards using SharePoint PerformancePoint Services 2010.
  • Assessed and Implemented 3rd Party Tools for ETL (Pragmatic Works: BI XPress, Task Factory and BI Documenter).
  • Created Azure based Proof of Concept to showcase MS Power BI: SharePoint 2013, Power Pivot, Power Query, etc.

Programmer Analyst

Tekforce Corporation
San Francisco
08.2009 - 04.2011
  • Worked as Database developer with Client/Business Analysts to define data requirements for Enterprise Analytical reporting needs.
  • Design and development of automated routines (scripts etc.) to facilitate the Application development and deployment process.
  • Maintained DB Schema and Code Change Management using TFS and RedGate’s SQL Compare.
  • Ownership of databases for maintenance, monitoring, backups, restores, policy management, automation and enhancing performance of existing development and QA database systems.
  • Developed SQL routines for complex, enterprise-level application development tasks involving hierarchical tree structures.
  • Created SSIS Templates for developing SSIS Packages and configured for dynamic deployments into Development, Testing and Production Environments.
  • Integrated SharePoint 2010 with SSRS 2012 and administered Site Collection security for Report Access.
  • Developed several HR Headcount and Government Compliance Crosstab Reports using SSRS Tablix design.

SQL Developer (Intern)

Die Hard Fans Inc.
01.2009 - 07.2009
  • Worked on Back End SQL Server Database of CounterPoint SQL POS software for updating Product Catalog, Rates, Referrals and Promotions.
  • Developed custom TSQL stored procedures to enhance existing functionality.
  • Designed Custom reports to track Retail sales based on metrics like month wise, store wise and promotional period.
  • Created Scheduled maintenances and backups to the database as part of disaster recovery.
  • Implemented triggers and stored procedures to enforce business rules.
  • Created Custom Excel ad hoc Reports and Pivot Data by pulling data from SQL Server.
  • Installed Security Patches to SQL Server 2005.
  • Fixed SQL Server configurations, collations, permissions, and performance issues.

SQL Server Developer

AT&T Services Inc.
  • Worked with Client/Business Analysts to define data requirements for tracking milestone target dates and other metrics for leveraging IT Metrics Reporting by providing real time information about projects and their releases.
  • Designed reports which will track milestone dates and send advanced notifications to the respective leads and identified corporate hierarchy to send notifications of missed target dates and escalate on user actions.
  • Installed and Maintained SQL Server 2008 Instances (DB & SSRS).
  • Designed and implemented a Star Schema Data mart using the Kimball approach for Client’s KPI reporting requirements.
  • Developed complex ETL processes via SSIS packages and stored procedures to populate a relational reporting Data Mart.
  • Implemented ETL tasks via Linked-servers and SSIS to query Access, Oracle 10g and MySQL data sources.
  • Created SSIS packages for transferring data from various data sources like Oracle, MS Access, Excel, Text files, CSV files to SQL Server Database destination.
  • Converted Access Macros, VBA code and Access Queries to TSQL views, stored procedures, and other SQL Objects.
  • Installed Deployed 64 Bit Attunity Connector for Oracle data sources to improve load performance.
  • Assisted with Performance tuning using Profiler traces, DMVs and 3rd party tools.
  • Designed, improved, and Maintained SSIS 2008 Packages for DB Maintenance and ETL.
  • Developed complex dynamic SSRS 2008 (Parameterized Matrix Multilevel) Reports.
  • Refactored existing Stored Procedures to use Table-Valued Parameters introduced in SQL Server 2008.
  • Documented all ETL and data warehouse processes and flows.

Education

Self Study - Google ClEnterprise Data Architecture Design Patterns, Azure Databricks, Data Science And Machine Learning

UPSKILL
Austin, TX
03-2025

Microsoft Certified Solutions Associate: SQL Server 2012 - Querying Microsoft SQL Server 2012, Implementing a Data Warehouse with Microsoft SQL Server 2012, Administering Microsoft SQL Server 2012 Databases

San Francisco, CA
04.2013

Masters - Computer Science

NorthWestern PolyTechnic University
Fremont, CA
12.2008

Masters - Computer Science

California State University, East Bay
Hayward, CA
12.2007

Skills

  • SQL Server development and administration
  • Big data technologies
  • Problem-solving aptitude
  • Cloud Database Solutions
  • Critical thinking
  • NoSQL databases
  • Effective communication
  • Teamwork and collaboration
  • Data lineage
  • Performance tuning
  • Data modeling
  • ETL development
  • Cloud computing
  • Data architecture
  • Cross-functional collaboration
  • Distributed systems understanding
  • Data acquisitions
  • Architecture planning
  • Security protocols
  • Secure data retention
  • Performance tuning and high availability
  • Business intelligence and ETL
  • Data analysis and reporting
  • Data visualization with Power BI and Tableau
  • Azure DevOps and CI/CD practices
  • T-SQL and C#Net programming
  • DAX and MDX query languages
  • PowerShell scripting and Python programming
  • Database management systems: MySQL, PostgreSQL, Oracle, MariaDB, DB2, MongoDB, Redis
  • Cloud platforms: AWS, Microsoft Azure, Google Cloud Platform
  • Version control with GitLab and VSS
  • Data integration tools: SSIS, SAP BO Crystal Reports

Timeline

Principal Data Architect

XeoMatrix
08.2023 - Current

Principal Database Engineer/ Data Architect

Pitney Bowes
03.2022 - 07.2023

Lead SQL Server/MYSQL/Mongo Database DevOps Engineer

Pitney Bowes
03.2018 - 02.2022

Senior SQL Server Database Engineer

Pitney Bowes
03.2017 - 02.2018

Programmer Analyst

Sparity Inc.
01.2012 - 02.2017

SQL Server Developer

SilkRoad Technologies
05.2011 - 12.2011

Programmer Analyst

Tekforce Corporation
08.2009 - 04.2011

SQL Developer (Intern)

Die Hard Fans Inc.
01.2009 - 07.2009

SQL Server Developer

AT&T Services Inc.

Self Study - Google ClEnterprise Data Architecture Design Patterns, Azure Databricks, Data Science And Machine Learning

UPSKILL

Microsoft Certified Solutions Associate: SQL Server 2012 - Querying Microsoft SQL Server 2012, Implementing a Data Warehouse with Microsoft SQL Server 2012, Administering Microsoft SQL Server 2012 Databases

Masters - Computer Science

NorthWestern PolyTechnic University

Masters - Computer Science

California State University, East Bay

Similar Profiles

CREATE PROFILE
Ranjith Vadde