Summary
Overview
Work History
Education
Skills
Languages
Personal Information
Timeline
Generic

JUAN CAMPANARIO

Danbury,US

Summary

Dynamic Database Team Manager with over 10 years of expertise in database administration and project management. Proficient in overseeing SQL environments, having managed over 5,500 SQL servers globally while ensuring compliance and security. Achieved a compliance rate increase from 50% to 99% by enhancing security KPIs. Adept at collaborating crossfunctionally to drive successful database migrations and disaster recovery strategies. Ready to leverage leadership skills and deep technical knowledge to produce exceptional results in a database management role.

Overview

33
33
years of professional experience

Work History

Sr. Database Administrator

The Hartford Insurance
Hartford
04.2019 - Current
  • Installed and configured SQL Servers across various environments, including production, pre-production, quality assurance, and development.
  • Collaborated with development teams to deploy SQL queries, integration services packages, and SQL Server jobs.
  • Partnered closely with infrastructure teams, including system administrators, storage, change management, and network teams, to deliver systems within budget and on schedule.
  • Administered, upgraded, and maintained 170 SQL instances, hosting approximately 1,900 databases.
  • Implemented daily maintenance routines ensuring comprehensive backups and system integrity.
  • Automated database scripts for the collection of SQL information.
  • Cooperated with development teams to migrate all on-premise SQL instances and databases to AWS.
  • Engaged with application teams to strategize for disaster recovery and high availability, utilizing methods such as clustering, mirroring, and transaction log shipping.

Database Manager and Project Manager

Nestle Global Lead Team
Stamford
06.2015 - 11.2018
  • Oversaw global SQL environments and maintenance for over 5,500 SQL servers worldwide, managing the complete lifecycle of applications from installations and upgrades to configurations, troubleshooting, and decommissioning.
  • Executed installation and configuration of SQL Servers, including clustering, mirroring, and transaction log shipping.
  • Coordinated with multiple IT teams, including data center, storage, Wintel, and Unix teams, to strategize and successfully transition two data centers without major incidents or disruptions.
  • Conducted regular conference calls with global groups to enhance and improve more than 15 security and compliance KPIs, elevating compliance from a low of 50% to an outstanding 98-99%.
  • Formulated standard routines for security and compliance activities related to SQL Servers and led presentations for the SQL Server global community, promoting awareness of current issues and establishing actionable next steps to achieve high maturity levels.
  • Ensured all backup and maintenance scripts remained current and effective.
  • Monitored and tracked SQL Server KPIs, including backup status, SQL version upgrades, maintenance routines, and user management utilizing the SQL Server Inventory system.
  • Developed and enforced database standards and controls for SQL servers.
  • Provided guidance to team members on performance, integrity, and security of databases.
  • Executed security and disaster recovery protocols for the organization.
  • Served as the primary contact for specific projects, such as remediating security and compliance audit points in collaboration with team members across Mexico, Brazil, Spain, Switzerland, Italy, and Australia.
  • Displayed leadership to the DBA team, facilitating regular meetings and goal setting.
  • Established team priorities aligned with departmental projects and delegated project responsibilities to appropriate team members.
  • Assisted database administrators in evaluating system performance, upgrades, and potential improvements.

Senior Database Administrator

Nestle Waters North America
Stamford, USA
06.2000 - 06.2015

Senior Programmer

Iona College
New Rochelle, USA
05.1992 - 06.2000

Education

Master of Business Administration (MBA) - Management Information Systems

Iona University
New Rochelle
05.1990 - 05/1992

Bachelor of Arts (BA) - Computer Science

Iona University
New Rochelle
09.1986 - 05/1990

Skills

  • T-SQL Store Procedures
  • PowerShell
  • SQL Server Reporting Server
  • Command Shell
  • Windows
  • SQL Server Reporting Services
  • Analysis Services
  • Integration Services
  • Clustering
  • Mirroring
  • Replication
  • Transaction log shipping
  • Leadership
  • Mentoring
  • Database Administration
  • AWS
  • Automation
  • Performance Tuning
  • Backup and Restore
  • High Availability
  • Disaster Recovery
  • Database Security
  • Monitoring
  • Root Cause Analysis
  • Prioritization
  • Communication
  • Organizational
  • Collaboration

Languages

Spanish

Personal Information

Title: Database Manager

Timeline

Sr. Database Administrator

The Hartford Insurance
04.2019 - Current

Database Manager and Project Manager

Nestle Global Lead Team
06.2015 - 11.2018

Senior Database Administrator

Nestle Waters North America
06.2000 - 06.2015

Senior Programmer

Iona College
05.1992 - 06.2000

Master of Business Administration (MBA) - Management Information Systems

Iona University
05.1990 - 05/1992

Bachelor of Arts (BA) - Computer Science

Iona University
09.1986 - 05/1990
JUAN CAMPANARIO