John Mccormack Email & Phone Number

San Francisco, Ca, Us

• Managed some of the world's biggest and busiest SQL Servers and Managed Instances, ensuring five 9s availability.• Led DBAs in Europe and Asia, guiding them to achieve personal development goals and excel in their roles.• Conducted incident management and resolution, including Root Cause Analysis, to maintain high availability for Docusign's database systems.

Weston, Ma, Us

• Lead a high performing global data operations team• Coach and mentor team members• Design process improvement solutions • Monitor system performance and resolve issues where necessary • Tune queries to reduce SQL Server overhead and improve performance• Passionate about automating manual processes• Design, implement and administer RDBMS solutions for all on premises SQL Servers• Design, implement and administer data technologies hosted on AWS & Azure• Ensure high availability and disaster recovery of Monster's data platform• Mentor team members and provide coaching/training• Develop system maintenance solutions for VLDB’s (5TB+)• Perform code reviews of database changes• Continuous cost optimization in the public cloud

A summary of contracts with various clients.Development DBA where I implemented performance enhancements such as rewriting stored procedures, index consolidation, adding missing indexes and offloading queries to the read replicas. I also consulted with other principal engineers and led a successful proof of concept migration to Azure Managed Instance. Whilst all this work was going on, I was a major contributor to a cost optimization project and saved the company over £400k per year in ongoing costs.Production DBA with responsibilities for backups, high availability and performance. The core systems which were highly transactional used Always On Availability Groups with 1 primary and 2 secondary replicas. The SQL Servers were Azure IaaS and I implemented a number of enhancements such as moving the tempdb to D drive to improve performance.Azure SQL Consultant where I carried out a complete health check and cost optimization review, and made recommendations. Also implemented monthly health checks to track progress and identify and alert on new issues.

Weston, Ma, Us

As a database administrator using SQL Server 2008 R2 - 2017, my main duties involve proactively monitoring production and development database servers to ensure the health of the systems, effective data management and ensuring high availability of our SQL Server databases. I lead large projects including SQL Server upgrades, server migrations/consolidations and releases.As an AWS Certified Cloud Solutions Architect within Monster's Data Platform team, I get the opportunity to work extensively with AWS cloud services. In particular RDS, but also many more services including EMR, ElasticSearch and Athena. I take a proactive role in training the Data Platform team in all aspects AWS.Tasks and responsibilities:Strong T-SQL skillsConfiguration and management of transactional replicationDeploying new instances of SQL Server to Windows Clusters and Virtual MachinesSQL Server Backups and RestoresSSIS package development and support for ETL processesManaging AWS Cloud solutionsAmazon Web Services (AWS) - RDS | EC2 | Cloudwatch | Athena | S3 | IAM | EMR | ElasticSearchIndex MaintenanceDatabase securityPerformance tuningLog ShippingTracing and Trace AnalysisPatching and upgrading SQL Server instancesDatabase refreshesAutomation (including developing self service platform for internal users)Data Warehouse/Mart administrationDatabase DevelopmentRelease managementPro actively identify and implement ways of improving efficiency and solving problems.

London , Gb

Ensuring customer retention through providing 1st class customer services and products which benefits both our customers and our business.

Lead a team of Collections Advisors to ensure that sales targets and other KPIs are achieved and exceeded.Ensuring delivery of a first class customer experience.Ensuring compliance standards are met and maintained.

Windsor, England, Gb

Lead a team of Sales Advisors to ensure that daily sales targets are achieved and exceeded.Ensuring delivery of a first class customer experience.Ensuring compliance standards are met and maintained.

Gogarburn, Gb

Give advice and recommendation to customer’s moving home or re-mortgagingKeep abreast of market conditions and analyse competitor productsEnsuring adherence to compliance standardsMaintain relationship with customer until completionAchieve and exceed set sales targets and consistently cross-sellDeliver 1st class customer service at all times to all customersPass Certificate of mortgage Advice and Practice (CeMap)