Performance

Speeding up T-SQL queries and reports
 

Multi Terabyte databases

Tune backups and SQL server performance of 1TB databases and bigger.

SQL server virtualized

Knowledge and skills to deploy your SQL Server instance and databases on VMware.

Virtualizing a Windows machine is easy. But virtualizing a SQL Server instance (in the right way) it is not. 

Thanks for visiting my site!

 

I've been working as a DBA since early 2000s. And I've had the opportunity of manage several "flavors" of Windows Operating Systems since then, now including Windows 2016.

 

My job is my biggest passion. And I feel blessed of being able to make my living doing what I like the most: administering and designing SQL databases.

I am currently living in Houston, Texas. During my leisure time I enjoy reading non-fiction books or riding my motorcycle.  

Jose Campo

Sr. SQL Server DBA

 

Phone:

281-653-6944

 

Email:

info@josecampo.com

 

Address:

10924 Grant RD #216
Houston, Texas 77070

Certifications
  • MCP on SQL 2014

  • MCP on SQL 2012

  • MCTS on SQL2005 and SQL2008

  • CompTIA Network+

  • CompTia A+

  • MCSA on Windows 2003

EXPERIENCE
SKILLS

Index design and tuning.

T-SQL tuning

Proficient in SSIS

Windows Clusters, Log Shipping.

SQL Server on VMware

Fully bilingual: English and Spanish

EXPERTISE
 
 
 
 

CTUIT

  • Administer and Manage 1k+ databases, including a SQL failover instance running on top of VMware.

  • Performed storage testing on Dell Compelent SAN and Nimble SAN using SQLIO

  • Monitored database performance using RedGate Monitoring, TSQL commands, DMVs and custom scripts.

  • Deployed and configured RedGate Backup Pro on a two node Cluster.

  • Designed and implemented SQL server backup strategy for 1k databases and over of 3TB of data.

  • Responsible for the planning and monitoring of the database organic growth for our clients.

  • Conducted root cause analysis for database incidents.

  • Troubleshooted and resolved production database and Windows Server issues.

  • "On call"  DBA (provided 24/7 support for the SQL servers)

  • Optimized T-SQL queries and stored procedures.

  • Evaluated and implemented industry wide security standards for MSSQL and Windows Servers hosting databases.

2012-2016

SQL Server DBA

2006-2012

IT Developer Engineer/SQL DBA

Hewlett Packard

  • Administer and supported mission critical databases for Hewlett Packard, including internal payroll databases and HP portal websites.

  • Handled Databases of up to 3TB in size.

  • Technical lead for SQL DBAs in the AMERICAS region.

  • Installed, administered and configured Microsoft SQL server software on in-house servers.

  • Monitored performance of the SQL servers, including tuning TSQL queries and Index design and implementation.

  • Primary DBA for more than 100 Projects across regions (AMERICAS, APJ, EMEA)

  • Planned and executed SQL server upgrades such as Service Packs and Hotfixes.

  • Participated in meetings impacting physical design of databases.

  • Installed and configured database tools and performance monitoring software.

Kemtah Group, Inc. 

  • Windows Administrator for HP Puerto Rico Windows 2003 Active Directory Domain

  • Implemented and managed a SQL 2000 failover instance on a two node Windows CLuster.

  • Setup and configured Compaq Proliant Servers for the HP manufacturing line.

  • "On call" (provided 24/7 support for the Windows and SQL servers of the HP manufacturing line.

  • Conducted root cause analysis for database incidents.

  • Monitored performance for the SQL servers. Performed tuning of T-SQL code and stored procedures.

2003-2006

Senior Windows Admin/SQL DBA (HP contractor)

 
CONTACT ME

© 2017 Designed by Jose Campo. 

Jose Campo

Sr. SQL Server DBA

Phone:

281-653-6944

 

Email:

info@josecampo.com