Carlos Doty

Experience

• 

  Cantor Fitzgerald/eSpeed

  Jan 2000 - now

  Database Administrator
• 

  Franklin Templeton

  Jan 2000 - now

  In my current role, I provide oversight for entire gamut of SQL Server and Azure Cloud operations, encompassing installation, configuration, backup, and recovery, bridging on-premises tools, such as Cohesity and LiteSpeed alongside Azure Cloud storage containers. • Collected data, while employing SSIS packages to connect and systematically extract data from multiple servers, aggregating within central server database - formed cornerstone for generating licensing reports, latest backup insights, and informed projections for future space allocations based on growth trends by leveraging adeptly crafted stored procedures.• Spearheaded management of pivotal ETL initiative, harnessing Azure Data Factory pipelines for seamless data transfer from Azure Data Lake to Managed Instance in public cloud, dedicated to housing data for esteemed high-net-worth clientele.• Devised strategies to uphold integrity of expansive databases within confines of 4 TB business-critical tier storage threshold, while employing index compression and adept space allocation management across diverse table partitions.• Garnered expertise in pivotal aspects, such as AlwaysOn, replication, and log shipping within MS Cluster environments, pivotal components of robust on-premises disaster recovery solutions.• Managed eight instances of substantial and high-visibility cloud databases, ranging from 3TB and beyond, distributed across both business-critical and general-purpose tiers.• Led numerous successful SQL server upgrades spanning from SQL 2000 to 2019, seamlessly directing complex transitions, such as Oracle to Azure cloud migrations.• Executed cutting-edge Azure cloud solutions, catering to IaaS, PaaS, and Managed Instance Azure cloud databases within dynamic 24/7 production landscape.• Exhibited adeptness in backend database administration support for expansive Snowflake data warehouse environments. Show less

  • Lead Data Engineer

    Jun 2008 - now

  • Sr DBA

    Jan 2000 - Aug 2023
• 

  Fiduciary Trust International

  Jun 2001 - now

  Database Administrator