Overview
Work History
Education
Skills
Certification
Timeline
Generic

Peter Marquie

Ossining,NY

Overview

14
14
years of professional experience
1
1
Certification

Work History

Remote Data Systems Administrator II

Olo
06.2022 - 09.2024
  • Managed two Snowflake accounts and implemented policies around user and application access, leading to security requirements being met
  • Led database optimization initiatives, improving AWS Redshift performance, which improved data ingestion pipelines and eliminated customer complaints
  • I brought two Snowflake accounts into IaC by reverse-engineering the accounts using Python to create the resources Terraform used to establish and maintain the state when applied
  • Implemented and managed pipelines from PostgreSQL to Snowflake using Fivetran, resulting in automatic and continuous data updates
  • Headed up a Fivetran MAR discrepancy investigation, resulting in refunds and a customized contract benefiting Olo
  • Implemented data lineage and observability monitoring with Monte Carlo across all pipelines, resulting in data accuracy, reliability, trust, and faster problem resolution
  • Enhanced Google Looker data availability from hours to minutes by converting Persistent Derived
  • Tables to incremental loading
  • Collaborated with key clients and internal teams to resolve issues, leading to contract renewals and alignment with business objectives.

Consultant, DBA IV, Manager

Booker Software, Inc. / Mindbody Online, Inc
03.2018 - 02.2022
  • Administration, Performance Tuning and Migration Specialist
  • As the lead DBA, I planned and migrated the Booker database infrastructure from the Rackspace data center to AWS and Azure with zero downtime
  • Achieved DB migration with zero downtime using out-of-the-box SQL Server tools
  • Mentored junior DBAs to the next level in preparation for the cloud migration effort, resulting in him managing the code and scripts and performing the migration from OnPrem to AWS and the Azure microservices integration
  • Supported multiple TB+ databases for production, development, testing, and staging on SQL Serverand 2019 on Windows in AWS and Azure
  • Immediately made responsible for performance tuning a critical reporting services server that resulted in Booker meeting customer SLAs by delivering report files
  • Designed and successfully deployed a replication configuration to replicate specific data from
  • Rackspace Datacenter and AWS to an Azure Microservice running a SaaS SQL application, resulting in faster searches
  • Provided technical leadership to the outsourced global development team through project leadership, technical documentation, and outage management.

Director of Databases / Independent Consultant

Choice Logistics, Inc
10.2016 - 03.2018
  • Responsible for modernizing the database infrastructure and implementing operational best practices, improving uptime and service availability
  • Engaged in performance tuning the SQL Code, database configurations, and ORM code, resulting in cost savings when less expensive instances were implemented and were able to manage the load
  • Designed four AlwaysOn SQL farms configured to automatically failover, resulting in minimal (TTL-related) downtime during failover
  • Was able to work with developers to design and implement a native replication of data from the UNIX database into SQL Server
  • Fostered a positive and supportive working environment that resulted in a team-oriented approach to projects, troubleshooting, and issue resolution using a blameless approach
  • Created a SCRUM project to track resulting tuning efforts from consulting with SREs to identify areas of code that can be optimized.

Director of Databases and Release Management

Everyday Health, Inc
09.2014 - 10.2016
  • Directly responsible for the data management behind the Parenting and Pregnancy application What to
  • Expect When Expecting and the website property
  • Hands-on manager for a team of multi-discipline dbas and consultants in India and the US who manage
  • MSSQL, MySQL, Couchbase, Sync Gateway (Couchbase Mobile), and Hadoop databases
  • Provided technical leadership to the outsourced global development team through project leadership, technical documentation, and outage management
  • Instructed team members to develop and maintain installation and configuration procedures, including server-build documents and checklists for future builds
  • Established, documented, and successfully implemented database and code release best practices, resulting in more successful releases
  • Established SOPs for DB and Web releases that included code reviews and test environments to validate code ideas and performance
  • Responsible for the company’s database infrastructure while managing a team of DBAs and
  • Consultants with disciplines ranging from MSSQL, MySQL, Couchbase, and Hadoop
  • Provided technical guidance and successfully implemented and upgraded the Couchbase and Sync
  • Gateway infrastructure upgrades
  • Led a DBA team to downgrade the SQL non-production environments to Developer Edition
  • As a result, the company saved $1.2MM in licensing costs
  • Managed and executed the successful upgrade of the SQL Servers to 2014 from 2008R2
  • Implemented Change Control policies to streamline the agile workflow and accommodate timely releases
  • Successfully led a team of DBAs to remediate the database infrastructure security, making the DBs compliant
  • Mentored team members with advanced projects like Always On and in-place upgrades of the SQL server farms
  • Fostered a positive and supportive working environment that resulted in a team-oriented approach to projects and problems.

Independent Consultant - Performance Tuning Analyst / Upgrade and Migration Specialist

Morgan Stanley
04.2012 - 07.2014
  • Strong working understanding of the physical and logical Architecture of SQL Server Management relative to advanced troubleshooting and performance tuning in both the OLTP & OLAP environments
  • Proven experience in maintenance of SQL Servers in VLDB environments and resolving database performance issues using strategic indexes on tables over 3 billion rows
  • Involved in SQL Query tuning DOCUMENTUM and KOFAX document database systems and provided tuning recommendations to vendors
  • Recommendations improved application performance and reduced batch job times, I/O, and CPU utilization, resulting in an on-the-spot job offer
  • Using system DMVs, a tuning process was created that captures the worst-performing queries and stores the performance statistics of the procedures for later replay and comparison after tuning actions
  • Designed and created a tuning process that captured Wait-States & Performance Monitor Counters to quickly find the Root Cause of performance slow-downs
  • Designed and maintained data Partitioning solutions for large tables, indexes, & Risk monitoring & control
  • A key member of the DBA team was tasked with migrating 4,000+ SQL servers to multiple data centers around the U.S., remaining ahead of schedule
  • A key member of the DBA team tasked with building 5,000+ SQL Server clusters for Morgan’s SQLEnterprise Service Adoption, requiring extensive contact with application and development teams to facilitate the successful upgrade to SQL 2008.

Vice President, Systematic Trading Engineering Group Manager

Citibank
, N.A.
11.2010 - 04.2012
  • Designed, built, and supported low latency trading systems that span a broad array of technologies with a near 100 percent uptime rate
  • Managed day-to-day support and administration of Microsoft SQL Servers, MySQL, Netezza database appliances, and Oracle databases across multiple trading systems and regions, including US, EMEA, and APAC
  • Managed a team that successfully designed and implemented high-availability SQL Server, MySQL, and Oracle production systems
  • Oversaw the operation of global end-of-day trading data archive processing to data warehouses across all regions; ensure timely execution and reliability of the processes supporting regulatory reporting requirements
  • Ensured team members' adherence to standard operating procedures for all database-related activities by implementing controls, checklists, and verification processes
  • Worked closely with CATE and CTI Database Teams to ensure STI policies adhere to Citibank’s standards
  • Identified business/technology requirements unique to Electronic Trading that require deviations in policy, worked with Risk & Control Teams to determine adequate compensating controls and managed supporting processes
  • This resulted in the early adoption of the FUSION/IO in-memory platform to deliver <3ms commit time to the database, satisfying our most demanding client’s needs
  • Drove partnerships between the DBA, development teams, and business leads/managers to ensure alignment of database solutions with business requirements
  • Worked closely with systems, storage, and network managers to ensure smooth integration/management of database technologies
  • Proven negotiation skills, experience working under pressure, meeting aggressive deadlines, and making effective decisions
  • As a result, I was promoted after 11 months on the job
  • The promotion directly resulted from my performance during the August 2011 market turbulence, during which we did not experience a single outage because of the actions I directed and executed.

Education

A.S - Management Information Systems

University of Phoenix

United States Air Force

Skills

  • SKILLS SUMMARY
  • Accomplished Senior Database Administrator with over 15 years of experience optimizing database
  • Performance, leading cloud migrations, and managing global teams Adept at leveraging cutting-edge
  • Technologies to improve operational efficiency and drive cost savings A proven leader skilled in
  • Mentoring and aligning database solutions with business objectives
  • Key Achievements
  • Cost Optimization Succes: Reduced AWS hosting costs by 20% through optimization efforts
  • Migration Excellence: Led team to achieve 100% SLA compliance for database migrations
  • Data Accuracy Enhancement: Increased data pipeline accuracy to 999% with monitoring
  • Improvements
  • Licensing Cost Reduction: Saved $12 million annually by optimizing database licensing
  • SKILLS
  • Database Management & Cloud Technologies:
  • SQL Server (AlwaysOn, Replication, Log shipping, Performance tuning), AWS Redshift, Snowflake
  • PostgreSQL
  • High Availability: Availability Groups, Log Shipping, Azure Failover Groups
  • Cloud Migrations: On-Prem to AWS/Azure, Multi-AZ Configurations
  • Atlas MongoDB in AWS
  • Snowflake hosted in AWS
  • Performance Optimization & Automation:
  • Query Tuning, Indexing, Partitioning
  • Tools: SQL Sentry, DPA, New Relic, Solar Winds, Azure App Insights
  • IaC with Python & Terraform
  • Data Engineering & Integration:
  • Pipelines: FiveTran, AWS Glue, Kinesis, Snowflake, PostgreSQL
  • Data Observability: Monte Carlo
  • Incremental Data Loading (Google Looker)
  • Snowflake Managed Accounts (Reader Accounts)
  • GitHub workflow
  • Agile methodologies
  • Tableau Administration
  • Google Looker
  • Leadership & Compliance:
  • Team Mentoring and Development
  • Compliance Expertise: SOC, PCI, SOX
  • Managing Global Teams and On-Call Rotations
  • SYSTEMS PROFICIENCY
  • DBMS
  • MS SQL, AWS Redshift, Snowflake, Netezza Database Appliance
  • Programming Languages
  • SQL, Powershell, Terraform, Python

Certification

  • On Essentials: Data Lake Workshop
  • Snowflake Hands-On Essentials: Data Engineering Workshop
  • Hands-On Essentials: Collaboration, Marketplace & Cost Estimation Workshop
  • Hands-On Essentials: Data Application Builders Workshop
  • Hands-On Essentials: Data Warehousing Workshop

Timeline

Remote Data Systems Administrator II

Olo
06.2022 - 09.2024

Consultant, DBA IV, Manager

Booker Software, Inc. / Mindbody Online, Inc
03.2018 - 02.2022

Director of Databases / Independent Consultant

Choice Logistics, Inc
10.2016 - 03.2018

Director of Databases and Release Management

Everyday Health, Inc
09.2014 - 10.2016

Independent Consultant - Performance Tuning Analyst / Upgrade and Migration Specialist

Morgan Stanley
04.2012 - 07.2014

Vice President, Systematic Trading Engineering Group Manager

Citibank
11.2010 - 04.2012

A.S - Management Information Systems

University of Phoenix

United States Air Force
  • On Essentials: Data Lake Workshop
  • Snowflake Hands-On Essentials: Data Engineering Workshop
  • Hands-On Essentials: Collaboration, Marketplace & Cost Estimation Workshop
  • Hands-On Essentials: Data Application Builders Workshop
  • Hands-On Essentials: Data Warehousing Workshop

Similar Profiles

CREATE PROFILE
Peter Marquie