JP

Juan Pablo Pucci

partly available

Last update: 01.04.2014

SQL DBA en Ernst & Young

Graduation: not provided
Hourly-/Daily rates: show
Languages: English (Full Professional) | Italian (Full Professional)

Skills

Microsoft SQL Server, ITIL, SQL, Cluster, VMware, IT Management, Windows Server, Java, Business Intelligence, JavaScript, Powershell

Project history

Ernst & Young
SQL Database Administrator
09.2011 - today
– Installation and configuration of SQL Server 2008 & 2005 Database servers
– Proactive & reactive support of MS SQL Server databases.
– Performance monitoring and troubleshooting of databases for large scale, mission-critical applications.
– Implementation and support of SQL Server High Availability features with Replication 2005, 2008 and 2008 R2 (different types of replication: Transactional and Merge).
– Implementation and support of SQL Server High Availability features with Mirroring 2005, 2008 and 2008 R2.
– SQL Server and databases changes and incidents management.
– SQL Server databases Backup and Restore.
– Documentation of processes and procedures.
– Data Access management and security support. Focal point for several internal corporation applications suggesting and helping the applications owners to decide whether the granted privilege is the correct one or if it should be downgraded.
– Windows Server 2003 and Windows Server 2008 Failover Cluster configuration and troubleshooting.
– Focal point of databases migration from EY’s Atlanta’s datacenter to Secaucus datacenter. This role involves from the main planning to the cutover period.
– Databases TDE encryption.
– Database performance and tuning analysis. Helping database application developers to identify performance problems.
– Powershell scripting to generate an automatic HealthCheck tool that reduced monthly maintenance checks activities in 8 hours, enabling the on duty DBAs to spend less time on repetitive tasks and letting him/her foucus on issues that could have been faced.
Accounting
10,001+ employees

BBVA Banco Frances
SQL DBA - WINTEL SA
01.2011 - 08.2011
SQL DBA responsabilities:

– Installation and configuration of SQL Server 2008 & 2005 Database servers
– Proactive & reactive support of MS SQL Server databases.
– Performance monitoring and troubleshooting of databases for large scale, mission-critical applications.
– Implementation and support of SQL Server High Availability features with Replication 2005.
– SQL Server and databases changes and incidents management.
– SQL Server and SSAS databases Backup and Restore.
– Documentation of processes and procedures.
– Data Access management and security support.
– Windows Server 2003 and Windows Server 2008 Failover Cluster configuration and troubleshooting.
– Installation and configuration of SQL 2005 and SQL 2008 Clustering.

WINTEL SA responsabilities:


– Troubleshooting and problem resolution, virtual and physical server configuration and maintenance.
– (SSL) Verisign Certificates renewal and implementation.
– Citrix farms maintenance (intermediate level).
– Windows 2003 Server cluster installation, troubleshooting, problem resolution, configuration and maintenance.
Banking


IBM Global Services
IT Specialist - SQL DBA
04.2010 - 12.2010
– Installation and configuration of SQL Server 2008 & 2005 Database servers.
– Proactive & reactive support of MS SQL Server databases.
– SQL Server and databases changes and incidents management.
– Implementation and support of SQL Server High Availability features with Microsoft Cluster technologies.
– Backup/Restore.
– Documentation of processes and procedures.
– Data Access management and security support.
– Adoption of processes aligned with GDF and corporate strategy methodologies.
– Worked as backup escalation person for specific account issues (Manpower).
– Focal point of databases migration from the customer’s datacenter to IBM’s datacenter for Baxter account. This role involves from the main planning to the cutover period.
– Installation and configuration of SQL 2005 and SQL 2008 Clustering.
Information Technology and Services
10,001+ employees

IBM Global Services
IT Specialist - WINTEL Server Administrator
09.2006 - 04.2010
– Troubleshooting and problem resolution, virtual and physical server configuration and maintenance.
– (SSL) Verisign Certificates renewal and implementation.
– Citrix farms maintenance (intermediate level).
– Windows 2003 Server cluster installation, troubleshooting, problem resolution, configuration and maintenance.
– Veritas Storage Foundation troubleshooting, problem resolution, maintenance and configuration
– Active Directory
Information Technology and Services
10,001+ employees

Local Availability

Only available in these countries: Argentina
I'm available to work per hours in a monthly basis, short or long term projects (80 hrs per month or less)
Profileimage by JuanPablo Pucci SQL DBA en Ernst & Young from BuenosAires SQL DBA en Ernst & Young
Register