John Dunleavy Email & Phone Number

Washington, DC, US

Minneapolis, MN, US

• Oversaw simultaneous client engagements, providing data architecture guidance and technical leadership for 5–10 customer accounts at a time.
• Led the data product migration of many on-premise data warehouses to Snowflake Cloud on Google Cloud, AWS, Azure, ensuring successful migrations supporting PowerBI and Tableau dashboards.
• Architected and managed modern data platform loading processes including streaming solutions with Kafka and or Snowpipe, improving operational efficiency by at least 40%.
• Setup automated CIS Security Benchmark checks utilizing custom Python solution and alerts for when critical security items occur.
• Secured platform with Functional RBAC roles, SSO, Multifactor, PrivateLink and Network policies.
• Proactively identified and articulated best practices and improvements to customers on how to best leverage their Cloud Data Platform.

Newtown Square, Pennsylvania, US

• Worked on complex multi-year conversion on-premise Data Warehouse over to Azure Cloud and cloud-based Snowflake and Synapse Datamart.
• Designed and implemented data pipelines using Snowflake, Azure Data Factory, and Azure Synapse.
• Setup multi-region DR and HA platform for Snowflake Datamart consisting of failover groups, Azure blob storage accounts, integration accounts and Snowpipe on Azure blob storage and queues.
• Created Zero copy clones on Snowflake databases and structures, including functional roles and data masking.
• Azure provisioning of accounts into Snowflake and setting up of security model using Azure RBAC roles, APIM, and replicated Azure active directory groups into functional/technical Snowflake roles.
• Designed and deployed Azure Data Factory for data transformations and ETL.

Craigavon, County Armagh, GB

• Provide Leadership and Mentoring for Data Analytic team comprised of DBAs and ETL Developers
• Perform reviews, and design (IDP) career development plans for all DBAs and ETL Developers
• Design and develop Extract Transfer and Load (ETL) Code to migrate and integrate data from disparate data sources related to specific projects as well as the data warehouse
• Manage team code standards, integrity of production code base, and other ETL developers on specific projects; enforce proper source control and re-usability of extract and load code as well as various standard.
• Manage the process of identifying opportunities for new architectural initiatives; make recommendations on increasing scalability and robustness of platforms and solutions within IT
• Establish policies and industry leading practices for optimizing data throughput/accessibility; create and maintain business intelligence and data warehousing design principles using industry leading practices

Craigavon, County Armagh, GB

• Hired and groomed Database Team of 4 DBAs and a group of Remote DBAs.
• Provide Leadership and Mentoring
• Develop and maintain over 128 SQL Servers through all phases of SDLC
• Plan, recommend and implement capacity, growth and changes for SQL architecture.
• Maintain system resources of database servers to ensure production systems meet high availability requirements.
• Ensure that database related hardware enhancements are scheduled and implemented in a timely manner.

Craigavon, County Armagh, GB

• Provide primary DBA support for installation, upgrading and maintaining the SQL environments.
• Plan, recommend and implement capacity, growth and changes for SQL architecture.
• Maintain system resources of database servers to ensure production systems meet high availability requirements.
• Ensure that database related hardware enhancements are scheduled and implemented in a timely manner.
• Develop, maintain a data archive strategy.
• Manage the changes to the architecture in compliance with company Configuration and Change Management SOPs and industry best practices.

• Provided support for all SQL Servers development through production.
• Designed and executed migration for 2 main production databases from SQL Server 2000 to SQL Server 2008 which also included move to new SAN and servers running on Windows 2008 server.
• Implemented new code deployment method saving 6 hours per environment/ per release using Red Gate SQL Compare and Data Compare.
• Developed data warehouse using SSAS, MDX queries and linked servers to provide seem-less integration into current object oriented architecture.
• Installed SSRS and designed reporting structures to satisfy all reporting needs.
• Developed trending and Diagnostics platform to monitor production database environments utilizing Idera's Diagnostics Manager.

• Provided production level support for all SQL Servers and over 150 applications.
• Helped setup and coordinate TFS (Team Foundation Server) for all development deployments.
• Implemented Idera's Compliance Manager and Idera's SQL Secure to analyze and assist in auditing 33 Production Financial Database servers to become SOX compliant.
• Implemented new disaster Recovery strategies utilizing Idera SQLSafe, Double Take and EMC Cloning.
• Developed trending and Diagnostics platform to monitor database environment utilizing SQL Sentry Event Manager and Idera's Diagnostics Manager.
• Developed SQL 2005 implementation plan and strategy for upgrading SQL Server 2000 servers to SQL Server 2005.

Conshohocken, PA, US

• Provided production level support for originally 67 SQL Servers, and 9 Oracle Servers.
• Assisted with implementation of the SAN migration to consolidate the number of SQL servers down to 12.
• Updated all servers to latest service packs and patches.
• Developed Database Standards to ensure developers and programmers were following best practices and good coding standards.
• Responsible for the promotion of database objects throughout the different environments.
• Set up Reporting Services.

Chicago, IL, US

• Worked with a diverse team of DBA's, analysts, lawyers, and healthcare industry specialists in organizing and structuring data for analysis, which was then used for expert testimony in multi $billion class action.
• Ran the data centers primarily for the Healthcare/Litigation Divisions.
• Developed the Data Acquisition and Management Protocol (DAMP) for which all data is acquired, scrubbed, profiled, and imported into data centers.
• Developed Disaster Recovery and off-site data plans for all Healthcare databases and file servers utilizing SQL LITESPEED and Veritas BACKUP EXEC/NETBACKUP used in the BALTIMORE, VIENNA, ATLANTA AND WASHINGTON DC.
• Responsible for system maintenance and performance tuning of over 500 databases (some of which are 5 TB in size.)
• Often called upon for individual tasks in other divisions when performance tuning needs arise

Ashburn, VA, US

• Built first Homeland Security database.
• Worked on Government Department of Defense initiatives tracking hardware for Government contracts.

Bachelor'S Degree, Management Science Information Systems

High School Diploma

Oracle 10G Dba