Sql Server Ms

Curriculum Vitae Darren John FULLER

Address: Sunshine Coast, QLD, Australia

Email: *************@*******.***

Telephone: Home: +61 (0)7 5478 6272, Mobile: +61 (0-448-***-***

Citizenship: Australian and British (dual citizen)

IT Experience: Since 1992

QUALIFICATIONS: MCITP Database Administrator 2008

MCTS SQL Server 2008

Microsoft Certified Systems Engineer (MCSE)

Bachelor of Business - Computing and Management, Queensland University of Technology, 1992

LinkedIn Profile: http://au.linkedin.com/in/darrenjfuller

Technical Strengths

Database Administration: SQL Server 2016, 2014, 2012, 2008 R2, 2008, 2005, 2000, 7, 6.x & Systems Administration: Windows 2012, Win 2008 R2, Win 2008, Win 2003, Win 2000, Win NT

SharePoint Administration: SharePoint 2013, SharePoint 2010

SSRS reports, SSIS packages

Production & development, large mission-critical environments, up to 1TB database size, hundreds of SQL instances, thousands of databases, thousands of users

Troubleshooting, DBMS optimisation & performance tuning, application tuning

Programming in T-SQL, PowerShell, Visual C#, .Net, Visual Basic, VBScript, UNIX scripting

Career Highlights

Received certificate and organisation-wide recognition for outstanding achievements during implementation of a records management system. As a result, saved the project from termination and achieved $30,000 cost saving.

Received recognition and letter from secretary of a government department for efforts during the upgrade of a critical payments system. Achieved savings in time, money and public relations.

Personal Strengths

Methodical and logical approach to work

Flexible & adaptable

Ability to thoroughly analyse and solve problems

Possess a measure of creativity to see ways to get things to work

Work well with others as a team member

Communicate effectively with clients, users, technical support and vendors

Highly motivated and adaptable with a keenness to investigate new technologies and tools and improve technical skills

Completed x10 Ironman Triathlons (3.8km swim,180km cycle, 42.2km run) Lanzarote Spain, Switzerland, Port Macquarie, Western Australia & Cairns

Technical Expertise

DBMS:

MS SQL Server 2016, 2014, 2012, 2008 R2, 2008, 2005, 2000, 7, 6.x (32-bit & 64-bit), SQL Server Failover Clustering (FCI), SQL Server Reporting Services (SSRS), SQL Server Replication, SSIS, DTS, SQL Server Analysis Services (SSAS), OLAP cubes, SQL Server Log Shipping & Mirroring, ORACLE 7.3.4, 8i 8.1.7, 9i, 10g, 11g, Informix Online 5.0.3 & 7.20, Progress 7 & 8, IMS/VS DB/DC 4.1, Huron ObjectStar, MS Access

Languages:

SQL, Visual C#, Windows PowerShell, Agile Scrum methodology, VB.NET, Visual Basic, Visual Studio.NET, UNIX scripting, ASP, ASP.NET, HTML, VBScript, COBOL

Operating Systems:

AWS, Microsoft Azure Cloud, Windows Server 2012, Server 2008 R2, Server 2008, Server 2003, Windows 2000, Windows NT 3.x & 4, MS Cluster Service, MS Failover Clustering, VMware ESX Server, vSphere, VMware vCenter LabManager 4.0, UNIX, Linux Fedora, CITRIX

Packages:

Microsoft Excel, SharePoint 2013, SharePoint 2010, BizTalk Server 2009/2010, TFS, Altiris 7.0 SP5 Server Management & Monitoring, Symantec Management Platform 7.1 64-bit, MS Office SharePoint Server 2007, BEA WebLogic Server 8.1.4 JRockit, ERwin/ERX, ONYX CRM, JDEdwards OneWorld, Symantec Backup Exec System Recovery, CorVu, Crystal Reports, MS Visual SourceSafe, Maximo

Mainframe:

MVS/ESA, JES2, TSO/ISPF, DL/I, DBRC, CLIST, IBM JCL, OIM, NetMaster, BTS, ACF2, TELON, Via Centre, Fileaid, IRMALAN

Experience

Sep 2017 – Present

Contract Role: MS SQL Server DBA, iSentia, media monitoring & analytics, Sydney, NSW, Australia

Responsible for maintenance & performance of SQL Server estate & general troubleshooting.

Configure new snapshot replication subscriber for publication

Review & execution of scripts into production environment

Configure archiving of data - write SQL & create jobs

Re-establish mirroring

Set-up & re-establish log shipping

Analyse poor performing stored procedure - increase sp_configure 'max full-text crawl range' option, create indexes, change cursor declaration to local fast forward

Construct SQL queries to extract data to csv files from SQL database using SQLCMD

A large proportion of estate is provisioned into AWS

SSRS development - modify report & SQL query to include new columns, redesign report

April 2017 – May2017

Contract Role: MS SQL Server DBA, Powerlink Queensland, electricity transmission, Virginia, Brisbane, QLD, Australia

1000s end-users, SQL instances (SQL2000, SQL2005, SQL2008, SQL2008R2, SQL2012, SQL2014, SQL2016), SQL clustering, availability groups; responsible for backup/restore, integrity, maintenance & performance of SQL Server estate & general troubleshooting.

Troubleshoot availability groups out-of-sync

Investigation of SSIS packages in Visual Studio & SQL Server Data Tools

Configuration of SSRS

Migration of databases from SQL 2008 R2 to SQL 2014 (Clustered & availability groups)

Investigation of SQL licencing

August 2014 – April 2016

Contract Role: MS SQL Server DBA, UBS Bank, global bank, Zurich, Switzerland

1000s end-users, 1000s SQL instances (SQL2000, SQL2005, SQL2008, SQL2008R2, SQL2012, SQL2014), up to 1.5TB database size; responsible for backup/restore, integrity, maintenance & performance of SQL Server estate for all sections of the bank e.g. investment bank, wealth management, asset management. A member of around 12 SQL DBAs responsible for approximately 3500 instances of SQL Server.

Administration and configuration of MS SQL Server running failover clustering, database mirroring, log shipping & replication.

Manage & troubleshoot SQL alerts including database corruption, job failures & configuration issues

Backup & recovery, integrity, performance tuning & optimisation, troubleshooting

Participated in migration project to move SQL instances from old versions to newer versions

Member of SQL consolidation project to minimise licencing costs.

Member of project to move on premise SQL instances to PAAS & IAAS in Hewlett Packard cloud

Regular 24x7 support & on-call duties

January 2007 – June 2014

Permanent Role: MS SQL Server DBA, SharePoint Administrator, Sunshine Coast Regional Council (Maroochy Shire Council), local government, Nambour, QLD, Australia

3000 end-users, 100 SQL instances, 800 databases (SQL2K, SQL2K5, SQL2K8, SQL2K8 R2, SQL2K12) up to 0.5 TB database size; accountable for mission-critical applications including: financials (Technology One), payroll (Chris21), asset management (Maximo), document management (FileNet), property/rating (Technology One) & GIS/SIS (ESRI ArcGIS), BizTalk, TFS source control & project tracking. Responsible for all SQL instances required for major projects to consolidate, migrate & upgrade systems from merger of three separate organisations.

Provide planning, configuration, maintenance, backup/recovery and capacity management of corporate SQL databases, SSIS packages, SSRS reports, SSAS cubes & log shipping

Monitor, optimise and troubleshoot systems, databases and SQL Server services to ensure maximum performance and availability across development, test, UAT and production platforms

Code and execute SQL & PowerShell scripts and perform database integrity checking

Analyse and implement MS SQL Server migrations (SQL2K à SQL2K8), upgrades and service packs

Install, configure, monitor, maintain SharePoint environment

Perform corporate application installations and upgrades

Prepare technical documentation, provide mentoring and technical support to development team members and customers

Assist developers on Windows Azure SQL Database Cloud DB

June 2006 – November 2006

Contract Role: MS SQL Server DBA, UBS Investment Bank, global investment bank, Zurich, Switzerland

Two separate engagements with this employer. Asked to return in a similar role (please see above).

1000s end-users, 200 SQL instances (SQL7.0, SQL2K, SQL2K5), up to 1TB database size; responsible for database platform running critical Swiss stock exchange system. Part of a global database team supporting Microsoft database products/platforms. Main responsibilities included:

Administration, installation and configuration of MS SQL Server in a standalone and clustered environment

Build systems to strict security standards, backup and recovery solutions, performance monitoring and tuning, troubleshooting, capacity planning, patching and security management

24x7 support for critical financial customer and on-call rotation observing a “Follow the Sun” model

Monitoring of Sybase and Oracle alerts and issues

Install, configure and troubleshoot MS Reporting Services and resolve related IIS issues

August 2002 – June 2006

Contract Role: MS SQL Server DBA, Virgin Media (NTL), large telecommunications provider, Hampshire, UK

A leading UK telecommunications service provider. Activities include television, radio, satellite broadcasting, cable and Internet services.

1000s end-users, 100 SQL instances (SQL6.0, SQL6.5, SQL7.0, SQL2K), up to 0.5 TB database size; responsibilities included two mission-critical systems: ONYX CRM and subscriber billing system. Involved in various projects to provide virtual ISP services to large European clients. Responsible for database platforms for project to migrate and consolidate 3 million internet, telephony and TV subscribers from legacy systems to in-house developed web portal platform.

Provide production, development, UAT and testing DBA expertise and system administration services across the company’s large mission-critical SQL Server. Monitor alerts for Oracle and Sybase databases, which operate 24x7

Troubleshooting, performance tuning, SAN and Cluster Service management

Formulation of disaster recovery and high availability strategies for clustered, virtual, SQL platforms, upgrading, sizing and hardware requirements

SQL programming and VB developer support, scripting, stored procedures, triggers, VBScript, DTS

Monitoring database and OS activities and performance delivery to production systems including: SQL replication (including SQL publisher & Oracle subscriber), e-commerce, call centre, CRM, billing, data warehouse and web servers

SQL migrations: SQL6.0àSQL6.5, SQL6.5àSQL7.0, SQL7.0àSQL2K

Provide DBMS security, data modelling and documentation of all aspects of DBA functions

Provide out of hours on call support

April 2002 – July 2002

Contract Role: MS SQL Server DBA, Superpartners, large financial institution, Melbourne, VIC, Australia

1000 end-users, 24x7 operation, 100 SQL instances (SQL6.0, SQL6.5, SQL7.0); responsible for six mission-critical systems.

Provide SQL Server database administration services and operational support

Review current systems (including data mart), documented and implemented recommendations to ensure optimal performance, integrity and protection

Troubleshoot various performance issues with payment receipting and e-commerce systems

Provide extensive mentoring and skills transfer to existing Oracle DBAs. Recommended 3rd party DBA software

January 2002 – April 2002

Contract Role: MS SQL Server DBA, DBCT, large shipping terminal, Mackay, QLD, Australia

One of the largest coal export ports in the world. The terminal serves the mines of central Queensland with a throughput capacity of 40 million tonne per annum.

150 end-users, 24x7 operation; responsible for three mission-critical systems JDEdwards OneWorld ERP, MineTrak and Corvu Business Intelligence

Provide SQL Server database administration consultancy as part of a major project to upgrade all IT systems

Review, investigate and document backup and recovery strategies, high availability, integrity and performance of IT systems

Implement recommendations e.g. log shipping processes, SQL Mail, housekeeping tasks, server re-build documentation and management reporting strategy

Provide support, troubleshooting and performance tuning

October 1998 – December 2001

Contract Role: MS SQL Server DBA, Virgin Media (NTL), large telecommunications provider, Hampshire, UK

Two separate engagements with this client. Asked to return in a similar role as part of a mission-critical project (see above Aug 2002 – June 2006).

July 1997 - October 1998

Permanent Role: MS SQL Server & Informix DBA, Maroochy Shire Council, Regional Shire Council, QLD, Australia

Two separate engagements with this employer. Asked to return in a similar role (please see above).

Responsible for backup & recovery, availability, integrity, performance optimisation & tuning, capacity planning, baselines, database security for all mission critical SQL Server database systems & for large critical GEMS financial system running on Informix & DG/UX (Data General Unix).

April 1993 - July 1997

Permanent Role: Database Administrator, Dept of Veterans’ Affairs, federal government department, Canberra, ACT, Australia

Responsible for the design, implementation, support and administration of production MS SQL Server systems/databases (SQL4.21, SQL6.0, SQL6.5)

Participated in the analysis phase of a large project to provide a data warehouse

Conducted migration of SQL Server databases and applications from v6.0 to v6.5

Implemented the migration of mission-critical Centura (Gupta) SQLBase databases and applications from v5.1.4 to v6.1.2 Australia-wide

Developed standards, procedures, security, strategies and support for MS SQL Server and Centura (Gupta) SQLBase environment

Provided out of hours on call support

COBOL and SAS application development, JCL coding and maintenance, IMS database administration within IBM mainframe environment

Further Relevant Training

Core Solutions of Microsoft SharePoint Server 2013, Microsoft Official Course (DDLS Feb 2014)

SQL Server 2008 Internals & Query Tuning Workshop (Kalen Delaney & Wardy IT Solutions Mar 2012)

Microsoft Certified IT Professional (MCITP) Database Administrator 2008 (18 Aug 2011)

Microsoft Certified Technology Specialist (MCTS) SQL Server 2008 Implementation and Maintenance (12 May 2011)

Dell SAN Management (Dell Enterprise Training & Certification Oct 2008)

Implementing Microsoft Office SharePoint Server 2007, Microsoft Official Course (DDLS Oct 2007)

Designing a Reporting Solution Architecture Using Microsoft SQL Server 2005 Reporting Services, Microsoft Official Course (DDLS May 2007)

Microsoft Certified Systems Engineer (MCSE). Comprising preparation and examination in NT Server 4, NT Workstation 4, NT Server 4 Enterprise, Networking Essentials, SQL Server 6.5 System Administration and SQL Server 6.5 Design and Implementation. (cbt systems, New Riders 11 Sep 1998)

Contact this candidate