About Percy Reyes

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!  

Besides my passion for database query processing and distributed database systems, I am also working on cryptography —  focused on the mathematical side of cryptography, that's cryptographic Boolean functions, algorithmic cryptanalysis, number theory, and other algebraic aspects of cryptography — I did a Master in Advanced Computer Science at Loughborough University in England in 2018, where I am also currently doing a PhD in Computer Science (cryptography). 

I've been writing about SQL Server administration issues on my blog since 2005 — nowadays I mostly write for MSSQLTips.com; you can access all my published articles here. In this blog, I mostly share my thoughts and knowledge on cryptography.

Brief:

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.
HELLO, I'M PERCY REYES! — a book lover, healthy lifestyle lover... I've been working as a senior SQL Server Database Administrator (DBA) for over 20 years; I'm a three-time awarded Microsoft Data Platform MVP. I'm currently doing a PhD in Computer Science (cryptography) at Loughborough University, England — working on cryptographic Boolean functions, algorithmic cryptanalysis, number theory, and other algebraic aspects of cryptography. READ MORE