Phil Mccormack Email and Phone Number

⦁ Design/Install/Configure/Setup- Implement Mainteance For High-Availability Azure/AWS Clusters On IaaS/PaaS.⦁ Rollout Ola Hallegren Maintenance Jobs Across Dev/UAT/Prod Fleet.⦁ Project Aligned DBA… Tasks..Design/Build/Migrate Data/Handover⦁ Analyse/Monitor Performance And Tune Configurations/Databases/Indexes/Queries.⦁ Azure Portal/Monitor To Analse Azure Metrics/Logs and Query Store.⦁ BAU Level 3 DBA Ticket Resolution/Troubleshooting.

⦁ Project Alligned DBA…Tasks..Design/Build/Migrate Data/Handover⦁ SQL Performance Tuning, Wait Analysis, Analyse Locks/Deadlocks..⦁ Assist/Develop AG Server/DB application scenarios.⦁ Test and Deploy Numerous Different Application Database Changes/Rollouts.⦁ BAU Level 3 Support DBA.⦁ Manage SSIS and SSRS/Reporting Instances/Databases/Data Warehouses.⦁ Support 2500 SQL Physical-On-Prem/VM/Cloud/Azure SQL Servers/Instances.

⦁ High-level Sev 1,Performance Tuning,SQL Profiler and Windows Performance Monitor.⦁ Software Vendor Management/Consulation⦁ Support/Manage 1000 SQL Physical/VM/Cloud/Azure SQL Servers/Instances.⦁ Support 12-15 Highly Available NSW Health/Hospital Apps.⦁ VLDb Prod Migartion On Prem To Azure VM's(25Tb)⦁ VLDB App MigrationSQL2012->2016(40Tb)Prod+UAT+Test..16 Servers.⦁ Install , Maintain , Troubleshoot , Administration SQL 2000,2005,2008,2012,2014,2016. ⦁ On-going… Show more ⦁ High-level Sev 1,Performance Tuning,SQL Profiler and Windows Performance Monitor.⦁ Software Vendor Management/Consulation⦁ Support/Manage 1000 SQL Physical/VM/Cloud/Azure SQL Servers/Instances.⦁ Support 12-15 Highly Available NSW Health/Hospital Apps.⦁ VLDb Prod Migartion On Prem To Azure VM's(25Tb)⦁ VLDB App MigrationSQL2012->2016(40Tb)Prod+UAT+Test..16 Servers.⦁ Install , Maintain , Troubleshoot , Administration SQL 2000,2005,2008,2012,2014,2016. ⦁ On-going AG Allways On support and troubleshooting.⦁ CapacityPlanning, On-going Server Audits, and Healthchecks. Show less

⦁ Support SQL Issues As Required. Short-term contract.⦁ Assist design of migration target servers.⦁ Migrate/Install/Setup Target Servers.

⦁ Management, Configuration, and Maintenance of 80-100 Enterprise Wide SQL Servers 2000-2016, On-prem Physical and Virtual as well as Azure cloud VM’s and Azure SQL Databases.⦁ Performance Tuning, Wait Analysis. Capacity Planning.⦁ Major app data archival and extensive performance analysis – wait analysis and query tuning.⦁ SQL Server migration, including Databases and Server objects…inc Logins, Jobs, Alerts, Maintenance Tasks & Linked Servers.

⦁ Develop/Design SSIS package to monitor/maintain the DR failover capabilities of 14-18 server-pairs using only log-shipping to keep DB’s in sync, i.e. ensuring that server objects and logins are kept in sync. To facilitate failover. ⦁ Direct liaison and reporting to the project manager.

⦁ DB Optimization (Indexes, Defrag, Configuration, Statistics, Integrity Checks).⦁ T-SQL (SP’s, functions and triggers) and Powershell.⦁ Query Monitoring and Analysis.⦁ SSRS, SSIS Package development and troubleshooting. Data Warehouse Support and Matching Indexing and partitioning.⦁ ETL Processing and Data Warehousing.⦁ Migration to and setup/admin SQL 2012 & 2014 Availability groups and Replicas.⦁ Performance Tuning, Wait Analysis. Capacity Planning.⦁ SQL… Show more ⦁ DB Optimization (Indexes, Defrag, Configuration, Statistics, Integrity Checks).⦁ T-SQL (SP’s, functions and triggers) and Powershell.⦁ Query Monitoring and Analysis.⦁ SSRS, SSIS Package development and troubleshooting. Data Warehouse Support and Matching Indexing and partitioning.⦁ ETL Processing and Data Warehousing.⦁ Migration to and setup/admin SQL 2012 & 2014 Availability groups and Replicas.⦁ Performance Tuning, Wait Analysis. Capacity Planning.⦁ SQL Monitoring Alerting Using Enterprise Wide Tools (Idera SQLdm & Nimsoft & SQL Spotlight,Redgate) Show less

⦁ Over 6 years’ experience in SQL Database Administration, Systems Analysis, Design, Development and Support in Production, QA, Reporting Services, Development environments & Replication and Cluster environments.⦁ Supporting many blue-chip financial and mining clients. Including AMP, BHP, Rio Tinto, Powercorp and OneSteel. ⦁ Responsible for 24 X 7 on-call support. ⦁ Performance Monitor, SQL Profiler and optimising queries, tracing long running queries and… Show more ⦁ Over 6 years’ experience in SQL Database Administration, Systems Analysis, Design, Development and Support in Production, QA, Reporting Services, Development environments & Replication and Cluster environments.⦁ Supporting many blue-chip financial and mining clients. Including AMP, BHP, Rio Tinto, Powercorp and OneSteel. ⦁ Responsible for 24 X 7 on-call support. ⦁ Performance Monitor, SQL Profiler and optimising queries, tracing long running queries and deadlocks.⦁ Installation, configuration, migration , troubleshooting & analysis of hundreds of SQL 2012, SQL 2008 R2, SQL 2008 and SQL 2005 servers and clusters.⦁ Designing DR solution, High Availability of database servers using Clustering, Database mirroring, replication and Log Shipping. ⦁ Migration of databases and SSIS ETL and DTS packages. ⦁ Security Auditing & Implementation inc authentication modes, roles and permissions.⦁ Implementing different types of Replication Models Inc. Snapshot, Merge and Transactional according to business requirements.⦁ Troubleshooting SQL Issues by using SQL Tools, Traces, Statistics and Index Tuning Wizard. Show less