How I always imagined a SQL DBA CV to look

CV in SQL.sql

/*Resume of Adrian Sullivan - Senior SQL Database Administrator*/ 

-- ============================================= 

-- Author:	Adrian Sullivan 

-- Create date:	2014-02-17 

-- Description:	Resume of Adrian Sullivan - Senior SQL Database Administrator 

-- Notes:	For more reading head over to www.linkedin.com/in/adriansullivan 

-- ============================================= 

SET NOCOUNT ON 

IF DB_ID('Adrian Sullivan') IS NULL CREATE DATABASE [Adrian Sullivan]; 

GO 

USE [Adrian Sullivan]; 

GO 

IF OBJECT_ID('[dbo].[Education]') IS NULL  

BEGIN 

  CREATE TABLE [dbo].[Education]([Institute] NVARCHAR(50),[Year] SMALLINT,[Degree] NVARCHAR(50),[Courses] NVARCHAR(50)); 

  INSERT INTO [dbo].[Education] SELECT N'University of Pretoria',2006,'Bcom',M.Major 

  FROM(SELECT'Economics'[Major]UNION SELECT'Business Management'UNION SELECT'Entrepreneurship')M; 

END; 

GO 

IF TYPE_ID(N'Experience') IS NULL EXEC sp_addtype Experience, 'VARCHAR(8000)', 'NULL';  

GO 

IF TYPE_ID(N'Employer') IS NULL EXEC sp_addtype Employer, 'VARCHAR(200)', 'NULL';  

GO 

IF TYPE_ID(N'Position') IS NULL EXEC sp_addtype Position, 'VARCHAR(200)', 'NULL';  

GO 

IF TYPE_ID(N'[dbo].[WorkXP]') IS NULL CREATE TYPE [dbo].[WorkXP] AS TABLE(Id INT IDENTITY(1,1) ,WhatCompany Employer, Work  Position, DailyActivity  Experience, DateStarted DATE, DateEnd DATE); 

GO 

DECLARE @Output VARCHAR(MAX) =''; 

 

WITH Profile (Name, ShortProfile,Nationality,CurrentLocation,PreferredLocation,[ExpectedSalaryAED],NoticePeriodMonth,WillingToRelocate,LumosityScore) 

AS  

( 

    SELECT 'Adrian Sullivan','Male,31,'South African','Johannesburg, South Africa','USA, UAE, Saudi Arabia', 'Negotiable', 1, CAST('TRUE' AS BIT),1414 

) 

SELECT Name,ShortProfile,Nationality,CurrentLocation,PreferredLocation,[ExpectedSalaryAED],NoticePeriodMonth,WillingToRelocate,LumosityScore FROM Profile; 

SELECT 'SQL Server DBA' Skill, 93 [Expertise 0 - 100] UNION SELECT 'SQL Server Developer', 92; 

DECLARE @Summary VARCHAR(850) = 'Adrian’s passions are Microsoft SQL Server and Business Intelligence.  

He has architected, designed and managed enterprise SQL databases and servers for over 7 years and has been professionally involved in IT for over 13 years.  

Having worked in all aspects of IT gives Adrian a unique insight into troubleshooting, architecting and managing Microsoft SQL Databases and has imparted an   

invaluable understanding of how SQL Server integrates in business processes.  

After reaching the pinnacle of what South Africa has offer him, Adrian is looking at plying his skills internationally.  

The GCC region is his destination of choice as he currently works 1 month in a year in Dubai. ' 

SELECT REPLACE(@Summary,' ','') [Adrian's Summary]; 

DECLARE @WorkExperience WorkXP; 

INSERT INTO @WorkExperience (WhatCompany, Work, DailyActivity, DateStarted, DateEnd) 

VALUES ( 

  'MUR Shipping','SQL DBA',N' 

  A Privately owned Dubai Based Shipping Company with around 250 employees servicing 10 offices worldwide. Based in Sandton, Johannesburg. Head Office @ Gold & Diamond Park, Sh Zayed Road, Dubai.   

  /**/ 

  Architecting new SQL deployments in conjunction with Infrastructure to maximize return on investment, not just on our infrastructure, but also on our licensing cost and in turn directly reducing our overall datacenter expenses. 

  Fine tuning SAN allocation for optimizing SQL performance and overall data throughput. 

  Supporting our entire SQL and MySQL Production and Development environments across all our remote offices and datacenters. 

  Introduction custom backup strategies, alerts, automated jobs and custom scripts in order to manage backups in combination with Microsoft DPM backup software. 

  Monitoring important performance counters and system health on all SQL instances using 3rd party tools, custom SQL scripts, custom PowerShell scripts as well as SQL alerts. 

  Devising High Availability Disaster Recovery solutions built on Windows Failover Clustering and AlwaysOn High Availability Groups, testing these systems and incorporating this with our backup strategies in order to maintain Geo-Redundant failover at all times. As well as monitoring these HADR SQL servers with 3rd party tools and alerts 

  Employing alternative DR solutions on older versions of SQL server built on Database Mirroring and Transaction Log Shipping. 

  Exquisitely maintaining Indexes and Statistics with advanced custom scripts utilizing proprietary usage forecasting algorithms developed by myself and SQL agent jobs in order to maximize performance. These have led to an overall SQL performance improvement on our highest usage system of 300%. 

  Automated SQL server deployment with PowerShell. 

  Upgrading Databases in order to make sure that we always have the easiest supportable environment at all times. 

  Database performance optimization by allocating SQL FILEGROUPS across multiple High IO SSD drives factoring in database growth and log file usage. 

  /**/ 

  Technologies: SQL 2005/2008R2/2012. SSRS, SSAS, SSIS, SharePoint 2007/2010/2013, Saperion, VMWare, Hyper-V, XenServer, Visual Studio, SharePoint Designer' 

  , '2010-10-01', GETDATE() 

),( 

  'CFS South Africa','SSRS Developer',N' 

  A Customer Survey Company servicing clients like Barclays and MTN across Africa based in North Riding, Randburg, Johannesburg, South Africa Report Development in SSRS and Excel. 

  /**/ 

  Introducing and maintaining Data Warehouses. 

  Observing data push occurs at scheduled intervals from mobile devices over cellular networks and validating that the data is consistent and accurate.  

  Work closely with customer relationship managers to ascertain client reporting requirements in order to provide the best data in the easiest format. 

  Scripting intricate SQL queries and stored procedures to run reports across multiple databases using Dynamic SQL. 

  Consolidating data for use in forecasting and advising on business processes for clients in order to maximize their perceived value from their clients. 

  Support reporting power users and other members of the BI team. 

  Modelling Dimensional and normalized data warehouses and implementing the best fit for that data set.  

  /**/ 

  Technologies: SQL 2005/2008. SSRS, SSAS and SSIS' 

  ,'2009-07-01','2010-09-30' 

),( 

  'Belay','IT Consultant', N' 

  Now part of EOH, a IT Services and consulting company based in Midrand, Johannesburg, South Africa.  Assessing and understanding client requirements. 

  /**/ 

  Mastering and rapidly implement new concepts, products and solutions with minimal assistance. 

  Offering infrastructure services at various clients and on various projects as a consultant for Belay. 

  Prepare, design and do proposals for new IT Infrastructure projects. Including: Network Design, Server Design and Virtualization, Storage Layout and Software system implementation. 

  Transferring knowledge successfully to clients through formal presentations and informal training. 

  /**/ 

  Technologies: Server 2003/2008, SCVMM, Hyper-V, NAS, SAN, MS DPM ' 

  ,'2008-07-01','2009-06-30'  

), ( 

  'Black Top Surfaces','ICT Manager',N' 

  Road surfacing company. Closed Down. Previously situated in Jet Park, Boksburg, Johannesburg. Manage all Policies, procedures, budgets, projects and reporting to middle- and top management. 

  /**/ 

  Conceptualize and implement all IT projects.  

  Oversee the administration and maintenance of hardware and software for all aspects of the business 

  Initiated and implemented improvements in all areas of IT. 

  Served as primary liaison on all IT-related matters. 

  Respond to and act on upper-management direction. 

  Identified and provided standards for gathering information for use in trend analysis and reports information to company management. 

  Supervised troubleshooting, systems backups, archiving, and disaster recovery 

  Administrated Accounting, Payroll, and Procurement software suites. 

  Security and Active Directory Administrator. 

  Ran all help desk activities at a local and regional level. 

  Procured all software, hardware and other IT supplies. 

  Ensured that company assets are maintained responsibly. 

  Directed all ICT infrastructure and SLAs for, Network and PABX infrastructure and all voice and data communications. 

  /**/ 

  Technologies: Server 2003, SQL 2000, and Exchange 2003 

  References: International Operations Manager Black Top Surfaces' 

  ,'2006-08-01','2008-02-28' 

) 

 

DECLARE @SQL NVARCHAR(4000) ='',@SQL2 NVARCHAR(4000) ='',@Params NVARCHAR(4000),@WorkHistory INT = 1,@MaxWork INT ,@Employer Employer, @Position Position, @Experience Experience, @From Date, @To Date; 

SET @MaxWork =(SELECT MAX(Id) FROM @WorkExperience); 

SELECT Edu.* FROM [dbo].[Education] Edu; 

WHILE @WorkHistory <= @MaxWork 

BEGIN  

  SELECT @Employer = W.WhatCompany ,@Position = W.Work, @Experience = W.DailyActivity, @From = W.DateStarted, @To =  W.DateEnd 

  FROM @WorkExperience W WHERE W.Id = @WorkHistory; 

  SET @SQL2 = ' SELECT * FROM @WorkXPTable WHERE Id = ' +CONVERT(VARCHAR,@WorkHistory)+''; 

  IF @WorkHistory = @MaxWork 

    SET @SQL = @SQL + @SQL2; 

  ELSE 

    SET @SQL =  @SQL + ' ' + @SQL2 +' UNION ALL'; 

  SET @WorkHistory = @WorkHistory + 1; 

END; 

EXEC sp_executesql @SQL, N'@WorkXPTable WorkXP READONLY',@WorkExperience;