SQL Server DBA


• 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.

Key Skills
  • SQL Server 2000 - 2016
  • Windows 2012 R2
  • Oracle 9i - 11g
  • Powershell
  • Java

Work Experience

SQL Server DBA

SAGE Publishing1.5 Years

3-Month Contract - Extended) Achievements • Trained local and offshore team members to automate manually-run monthly reports using SSRS. • Automated and documented several large, repetitive file distribution operations using SSIS. Responsibilities • Investigate potential problems and issues raised by business users, owning the issue through to resolution. • Monitor system health, troubleshoot SQL Agent jobs, respond to alerts and identify opportunities for optimisation. • Communicate regularly with users, business analysts and technical staff to ensure issues are resolved in a timely manner. • Ensure security and privacy policy follows best practices. • Manage day-to-day activities such as monitoring performance and availability of the servers and the integrity of the backups. • Initiate and own projects to apply improvements in the SQL Server environments. • Assist in the development of efficient SQL code.

Infrastructure Engineer (SQL Server DBA)

Transport for London2 Years

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.

SQL Server DBA

Slaughter and May10 months

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.

Senior SQL Server and Oracle DBA

CGI Group4 Years

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.

Oracle DBA

Eos1.5 Years

Achievements • Development and Production DBA. • Created and maintained environments (Oracle on HP/UX) for a number of Internet startups. • Performed production releases and support.

Oracle DBA

CSG International5 Years

Achievements • Created and maintained development environments (Oracle on HP/UX) for the development of cable TV/telephony billing systems • Performed production releases and support.