Let me help your data driven business initiatives succeed I have over 20 year experience delivering solutions through software, systems, and data engineering. With services such as:- Managing the delivery of large-scale data warehouse projects.- Conducting requirements engineering and data source discovery.- Modeling data for use in OLTP and OLAP databases.- Designing and implementing data platforms from the ground up.- Integrating with AI and ML models.- Developing robust and fault tolerant ETL pipelines.- Setting up and managing data lakes.- Automating repetitive data tasks for increased efficiency.- Collaborating with analysts to maximize the value of the data warehouse.- Migrating, upgrading, and modernizing legacy data warehouse systems.- Providing ongoing support and maintenance for data infrastructure.- Scaling high-traffic applications to meet present and future capacity needs.- Performance tuning databases for high-concurrency transaction processing.- Creating personalized customer experiences through data-driven insights.- Leveraging customer data for effective digital marketing strategies.- Optimizing data-intensive workflows for improved performance.- Creating customer-centric content discovery and search systems- Streamlining infrastructure management through automation.

- Greenfield development of SOULCYCLE’s next generation multi-source data platform.- Managed a team of data engineers, data scientists and data analysts.- Personally wrote significant portions of the codebase and served as a technicalescalation point.- Implemented Airflow to orchestrate the execution of Python and PySpark jobs.- Managed a multi-terabyte data lake on Google Cloud Storage and data warehouseresiding in Google BigQuery.- Positioned our Data Platform to be the authoritative source of customer segmentationacross all digital growth marketing platforms.- Served as chief architect of both the data model and data processing infrastructure.- Provided guidance to executives, product engineering and devops teams regardingdatabase technology and data related issues.- Worked with product teams to ensure the proper telemetry data is collected and findnew ways to leverage data to improve customer experiences.- Utilized our data platform to audit connections between commerce systems to achievequicker resolution of transaction issues and reduced friction with accounting processes.- Principal architect to core processing components and one of the named inventors ofthe patented (US20210008412A1) SOULBEAT technology which combines audio data with cycle power meter data to create a customer experience that’s the first of its kind in the boutique fitness industry.- Provided mentorship and career development to junior staff.

Taking some time to focus on outside interests

I oversee database development and operations for Behance.net- MySQL- ElasticSearch- Redshift- Cassandra- PHP- Go- Python- Ownership of the development and operations of all data storage and retrieval platforms that power Behance.net.- Manager of the Behance Data team consisting of an Operational DBA and Business Analyst.- Ensuring the consistency, availability and performance all relational database systems- Implemented Behance’s entire data warehousing, ETL and analytics platform from scratch inside of 2 months.- Developed a Python based platform to manage and self-heal the MySQL infrastructure that powers Behance.net and Adobe Portfolio.- Architect and developer of the search platform for Behance.net powered by Elasticsearch.- Providing oversight and guidance to our operations team with regard to managing Elasticsearch, MySQL and Cassandra platforms.- Working with data scientists to productize and integrate their work as features into existing products which need to operate at web-scale- Providing guidance to developers on the best practices of data access patterns for our backend data stores.- Performing systems optimization and performance tuning using data gathered from monitoring tools such as SumoLogic, Data Dog and New Relic.- Experience with migrating database systems from on-premise and colocation facilities in to the cloud

MySQL Database Administrator.

Database development and operations for some of the largest pay-per-minute video websites on the internet. - Designing MySQL database schemas web applications.- Overseeing production operations for all database systems.- 90% of my time is spent with MySQL and MySQL backed applications the remaining 10% is MS SQL Server.- Analyzing under-performing SQL statements and taking corrective actions through query tuning and/or schema alterations.- Reviewing data access methods used in the application code to identify inefficiencies and providing guidance to web developers to ensure their applications interact with the data tier in the most efficient manner.- As a pet project I developed the methodology used to make us the first in our industry to bring pay-per-minute video to IOS devices (iPhone/iPad) via the mobile browser.- Developing in-house systems management tools for tasks such as auditing and managing 1PB of media files, automatically redistributing database traffic in the event a database server becomes overloaded or fails, identifying and terminating problematic queries, custom monitoring scripts for Nagios, auditing and managing 2000+ domain names.- Generating custom reports for executive management as needed.- Writing stored procedures for MySQL and SQL Server.- Writing scripts in PHP, Python, Bash, SQL and T-SQL to automate database administration tasks.- Developing ETL processes using SQL Server Integration Services to synchronize and migrate data between disparate systems and formats.- Managing a complex MySQL replication scheme for a read intensive streaming media website which receives over 500 million queries per day.- Experience in developing database schemas for online retail, streaming media, OLAP and online socialization websites.- Responsible for 50+ instances of MySQL.- Administration of 20+ SQL Server 2005 and 2008 instances both clustered and stand-alone.

- Supervised a team of 8 systems administrators and systems engineers.- Managed a Solaris based hosted multi-media news solution responsible for delivering results from the 2004 General Election to every major media outlet.- Defined technical requirements for projects based on input and feedback from business unit stakeholders and development staff.- Engineered a highly available and fault tolerant server/infrastructure solutions for distributed news and print advertising delivery systems including an off-site disaster recovery location and procedures for maintaining operations in the event of a catastrophic site failure.- Maintained 24x7 availability for 700+ critical Sun Solaris, Linux and Windows servers.- Performed MS SQL Server database administration.- Developed extensive experience in managing clustered MS SQL Server implementations.- Performed system builds and administration of existing server infrastructure.- Implemented and configured hardware based load balancers and networking equipment.