I've been working as a senior Database Administrator (DBA) for over 20 years; I possess extensive knowledge and experience in managing critical database servers running on all Microsoft SQL Server platforms. I have an excellent command of all SQL Server database administration topics and, even more so, I am genuinely passionate about SQL Server internals.
I'm the certified SQL Server DBA expert you are looking for — I am fully trained, certified and experienced with Microsoft SQL Server and related technologies required to maintain high performance, high availability, secure and reliable database environments. I do make your databases run significantly faster — even faster than light. In this sense, I provide the Best 24x7 Remote SQL DBA Services — a cost-effective way designed to serve your needs of database management. So, are you feeling frustrated by slow database performance? do not hesitate to contact me!
Brief:
- DR Representative for Computer Science & the DR Representative Lead for School of Science at Loughborough University, UK (2020–2022)
- Master (with distinction) in Advanced Computer Science at Loughborough University, England, UK (2018–2019); I won the MSc project prize with the highest mark
- Bachelor degree (with distinction) in Systems Engineering at National University of Trujillo, Peru (2003–2007)
- Senior Microsoft SQL Server database administrator for over 20 years
- Owner/founder of SQLEngineers – a company that provides 24x7 Remote SQL DBA Services, based in Lima, Peru
- Certified database professional since 2005 (official transcript is here — transcript ID: 710696, access code: 71069600)
- Three-time awarded Microsoft Data Platform MVP (Jan 2015 – Jul 2018)
- International Speaker and Technical Writer of SQL Server administration tips for over 12+ years
- Contributor and Author at MSSQLTips.com
I hold the following Microsoft certificates:
- MCSE Data Management and Analytics (issued Aug 2018)
- MCSA SQL 2016 Database Administration (issued Aug 2018)
- MCSA SQL 2016 Database Development (issued Aug 2018)
- MCP Microsoft Certified Professional (renewed 2012, issued Apr 2012)
- MCITP Database Developer on SQL Server 2005 (issued Oct 2008)
- MCTS SQL Server 2008, Implementation and Maintenance (issued Jul 2008)
- MCITP Database Administrator on SQL Server 2005 (issued Dec 2007)
- MCTS SQL Server 2005 (issued Oct 2006)
- MCP Microsoft Certified Professional (issued Sep 2005)
My experience as a Sr. database administrator
My key skills as a database administrator:
- extensive knowledge and experience in managing critical database servers running on all Microsoft SQL Server platforms, from SQL Server 6.5 to SQL Server 2022
- in-depth knowledge and strong experience in database administration of SQL Server —on on-premise, Azure/cloud, and hybrid environments — including:
- installation/upgrade of the database engine and client tools
- allocation system storage and planning future storage requirements for the database system, capacity planning
- database maintenance — indexing, statistics, integrity checks, database deduction
- storage engine, backup/restore operations, FileStream, partitioning very large tables
- optimization/performance tuning of database designs, SQL Queries, in-memory OLTP & OLAP implementations, etc.
- monitoring of performance, including blocking & locking issues, security, data integrity
- security and compliance, audit
- high availability (HA)/disaster recovery (DR) — replication, log shipping, mirroring, Always-On, failover clustering
- troubleshooting of performance, security, and other internals issues
- management of SQL Azure services
- management of Business Intelligence solutions including Reporting Services (SSRS), Integration Services (SSIS), Analysis Services
- development of SSIS Packages.
- in-depth knowledge of database theory, Structured Query Language (SQL), T-SQL, and SQL Server internals
- good understanding of distributed computing architectures (client/server, internet/intranet), underlying Windows operating systems, memory management, storage technologies, disk arrays, NAS/SAN, TCP/IP networking
- great object-oriented programming skills
- excellent communications and teamwork skills
- ability to handle pressure and conflict
- experience leading and mentoring technical staff
- innate ability to take initiative
- a proactive approach to work without close supervision
- high-performance working under the pressure of demanding deadlines
- ability to simplify complex problems and resolve them quickly
- good experience working with ITIL
- good documentation skills.