• SQL Server DBA since 2006 - holds MCITP and MCTS Microsoft certifications since 2010. • MCSA and MCSE certification in progress. • Previously certified Oracle DBA (OCP). • Wide range of DBA core skills - planning, installation, configuration, development, maintaining, performance tuning and troubleshooting. • Aims to maintain and improve all core skills; keen to expand into NoSQL and cloud-based solutions. • Main experience is with OLTP/LOB databases, with Data Warehousing exposure. • Professional attitude; a contributive team member; provide mentoring, documentation and training. • Out of hours support. Primary Technologies and Platforms • SQL Server 2000 - 2016 (Database Engine, T-SQL SSIS, SSRS). • Windows 2003 - Windows 2012 R2. Other Technologies and Platforms • Oracle 9i - 11g, Powershell, Java, Perl, Unix/Linux (Solaris, Red Hat AS, Ubuntu), Windows 2016. SQL Server Skills Installation and Configuration Capacity management. Disk Alignment & Formatting. Upgrading and Migrating from SQL Server 2000 to SQL Server 2016. Benchmarking. Performance Tuning SQL Profiler/SQL Trace/Extended Events/Perfmon/Logman. Optimizer behaviour: indexing, statistics and hints. Partitioning, indexed views, filtered indexes. Security Logins, Server/Database Roles, Credentials and Proxies. TDE and column encryption. Test data obfuscation. Troubleshooting Connection Failures/Networking. Performance Deterioration. Disaster Recovery and High Availability Multi-subnet Clustering. Mirroring and AlwaysOn Availability Groups. Backup and Restore Strategies. Database Corruption Scenarios. Monitoring SQL Agent Alerts (Events, WMI and Performance Counters). Policy Management. Proactive Management. Replication Transactional and Merge. Development T-SQL, SSRS, SSIS.
Achievements • Rewriting queries behind very high-profile failing management reports ('Silver Award'). • Writing an inventory and alerting tool using Powershell and SSRS. Responsibilities • Ensure the production estate is available and performing well. • Diagnose and fix the root causes of production system failures. • Performance tuning. • Provide T-SQL help for data warehouse and Business Objects developers. • Configuration analysis and improvement. • Conduct peer reviews. • Out of hours support.
Responsibilities • Ensure that the Autonomy WorkSite document management system was available and performant. • Document WorkSite backup, fail over and restore procedures for Operations staff. • Plan and implement application upgrades.
Achievements • Successfully headed and delivered various projects at several client sites including Hiscox and RBS. • Consulting on client sites. • Standardised installation best practices and checklists. • Designed, authored and implemented inventory, performance and alerting applications, originally written in Perl, then redesigned in Powershell, SSIS, TSQL and SSRS • Deputised for the team leader. • Interviewed several prospective candidates for the team. • Liaised with various project managers to ascertain new project requirements. • Integral member of the out of hours on call team. Responsibilities • Monitoring and maintaining over 200 SQL Server instances hosting OLTP, DSS and OLAP applications across development, testing and production environments. • Planning, installing and configuring installations, with consideration to capacity planning, high availability and security. • Performance tuning using SQL Profiler, Extended Events, Perfmon and Logman. • Troubleshooting development and production problems. • Migrations and upgrades, with attention to deprecated features and application/interface compatibility. • Backup and disaster recovery strategies. • Writing SSIS packages and SSRS reports for ETL and estate monitoring. • Out of hours support.
Achievements • Development and Production DBA. • Created and maintained environments (Oracle on HP/UX) for a number of Internet startups. • Performed production releases and support.
Achievements • Created and maintained development environments (Oracle on HP/UX) for the development of cable TV/telephony billing systems • Performed production releases and support.