NELSON VIGGIANI --- SQL DBA

Full-Name: NELSON VIGGIANI

Contact numbers: - 423-***-****

Email address: aceq42@r.postjobfree.com

Current Location: (Chattanooga-TN )

Availability: 2 weeks or before

Work Status: US CITIZEN

Years of experience : 18

PROFESSIONAL SKILLS

. 18 years of SQL Database experience with SQL Server 6.5 / 7.0 / 2000 /

2005 / 2008 / 2008R2 (Production - Development - Administration)/SQL

2012 - SQL 2014

. Knowledge of database design and normalization

. Strong skills in writing efficient T-SQL code (Queries and Stored

Procedures)

. Dynamic SQL

. Views, Stored Procedures, Functions

. Security, Backup/Restore

. Experience with SQL Server 2005 migrations (code and data)

. Skills to allow for the import/export of data via internal or external

data sources, txt, csv and other ODBC enabled systems.

. Experience with the .NET,SQL 2005 and DTS SSIS SSRS

. ETL (Extract Transform Load) processes like transform data from Excel

to SQL, Txt to SQL, Oracle to SQL, AS400 to SQL and vice versa

. Idera, DBartisan, Embarcardero,Quest (tools)

PROFESSIONAL EXPERIENCE

USXPress Enterprise Inc - Chattanooga- TN - May/2012 to present

SQL Senior DBA - Permanent Position

. Migration From Polyserve Cluster to Microsoft Cluster

. SSRS integrated with application and/or SSRS reporting services

. SSIS packages to migrate data

. DBA Administration JOBS, Procedures, Views, Performance, Security

. Log Shipping / Replication

. Migration From 6.5 to Sql 2008 R2

. Migration From 2000 to Sql 2008 R2

. Migration From Sql 2005,2008 to SQL 2012 HA

. Setup and configure Microsoft Cluster, Nodes T1 T2 and T3 with 120

Databases balanced between then.

. Replication as Merge, Transactional and snapshot

. Tsql scripts programming

. Log shipping setup for SSRS reports

. SQL 2012 configuration Always ON

. Disaster Recovery

. Documentation

. Support Sharepoint connection

. Create Jobs to control drive space with Alerts to cell phone and

emails

. Control SQL Security with Active Directory groups

. Manage 18 TB data between 45 servers

FIRST SERVICE RESIDENTIAL INC Mar/2011 - May/2012

SQL Senior DBA - Permanent Position

. ETL Migration from MYSQL to SQL 2008 R2

. SSRS integrated with application and/or SSRS reporting services

. SSIS packages to migrate data

. SSIS packages to escalated data

. DBA Administration JOBS, Procedures, Views, Performance

. C# Visual Studio 2008/2010 Programming

. Tsql programming

. SSMA

. SQL YOG

. Responsible for 27 SQL servers - DEV - QA and PROD

. Backups/Restore- Jobs -

. Disaster Recovery Plan

. Data Warehouse

. Setup and Configure Microsoft Clustering, 2 Nodes

FLORIDA POWER & LIGHT - Dez/2010 to Feb/2011

Database Analyst - Contract Position

. ETL from SAP to Oracle 10g using oracle scripts

. ETL from Excel to Oracle 10g using sql loader

. Reports using Crystal Reports, Excel and Charts

. Tsql scripts programming

Oceania Cruise Lines/ Regent Seven Seas Cruises - April/2010 to Nov/2010

Database Administrator 2005 /2008 - Contract Position

. Consulting Program Analyst, Database SQL 2005 and 2008

. SQL Server databases, data warehouses, ETL (Extract Transform Load)

processes like Extract data from Excel to SQL, Txt to SQL, Oracle to

SQL,SQL to Great Plains database

. Using SSIS packages to read excel, txt, xml files massage the data to

load it into SQL

. Data Marts reporting

. Migration from Crystal reports to SSRS reporting Services

. TSQL scripts programming

. SSIS packages -Financial, Marketing, Accounting dept. and reports,

manipulate data with SSIS to load it into another SQL database

. Build SQL scripts to load financial excel reports from the vessels

into SQL database via SQL Procedures, Build SSIS packages to FTP Files

from the Vessels to the headquarters to be loaded later on via stored

procedures.

. Responsible for detailed database assessment and preparing

recommendations document. Heavily involved in analyzing and providing

recommendations and solutions for back up strategy, SQL Security,

Tables and Indexes. Responsible for assessment of existing database

services infrastructure.

. Help Building Data Warehouse solution, build and Maintain Intranet Web

Pages and reporting

Johnson & Johnson - (BRAZIL) -Oct/2009 - Dec/2009

System Analyst Senior/SQL DBA - Contract Position

SQL Server Support for USA, India, Europe and Japan

Managing 554 SQL Servers with a Database Team of 12 person's

Migrating SQL 2000 to SQL 2005 and 2008

. Work with the DB, Development, and QA teams to set up and maintain

various development, testing

Building data Warehouse Importing Data from different sources and

transforming the data into a SQL DW using ETL (Extract Transform

Load) sources like Excel, Txt, Oracle

Using SSIS to load and manipulate it into the SQL Database.

Replication and Mirroring

DBACORP (BRAZIL) -Contract Nov/2008 -

Jul/2009

Consulting Database Administrator 2000 / 2005 /2008

. Knowledge of SQL 6.5/7.0/2000/2005/2008 and its components including

SSIS, SSRS

Implement, and maintain backup and restore operations, replication,

log shipping, database mirroring, and clustering

. Transact-SQL skills and the ability to create complex queries, stored

procedures, triggers, user-defined functions, views, and other

database objects

. Knowledge of SQL Server administrative tools, including SQL Server

Management Studio, SQL Server Profiler, SQL Server Agent, SQL Server

Surface Area Configuration, Database Engine Tuning Advisor

. TSQL programming /develpment

. Database communication mechanisms such as ODBC, ADO.NET, and TCP SQL

Server databases, ETL (Extract Transform Load) processes like

transform data from Excel to SQL, Txt to SQL, Oracle to SQL, AS400 to

SQL and vice versa Using SSIS to load these

. Files into a Insurance Database and then run procedures to update

those data, Building Data Warehouse and OLAP cubes, Openquery

. Working with Business Intelligence Development Studio (or SSIS

templates in Visual Studio)

. Work with the DB, Development, and QA teams to set up and maintain

various development, testing

. Replication using SQL 2005

Eways Informatica Ltda (BRAZIL) Contract Position

Jun/2008 - Nov/2008

Consulting - Database SQL 2005 /2008

. Transact-SQL skills and the ability to create complex queries, stored

procedures, triggers, user-defined functions, views, and other

database objects knowledge of SQL Server administrative tools,

including SQL Server Management Studio, SQL Server Profiler, SQL

Server Agent, SQL Server Surface Area Configuration, Database Engine

Tuning Advisor

. Database communication mechanisms such as ODBC, ADO.NET, and TCP SQL

Server databases, ETL (Extract Transform Load) processes like

transform data from Excel to SQL, Txt to SQL, Oracle to SQL, AS400 to

SQL and vice versa, Building Data Warehouse and OLAP cubes.

. Working with Business Intelligence Development Studio (or SSIS

templates in Visual Studio)

. Reporting Services with SQL 2005

Centro Inform tica Automa o de Santa Catarina- CIASC BRAZIL Aug/2007 -

April/2008

Contract Position

. Consulting Program Analyst, Database SQL 2000 e 2005 and Reports using

SSIS-Reporting Services

. SQL Server databases, data warehouses, ETL (Extract Transform Load)

processes like transform data from Excel to SQL, Txt to SQL, Oracle

to SQL, AS400 to SQL,Sybase do SQL and vice versa,Using SSIS packages

to massage the data.Openquery

LeasePlan USA - Georgia - USA Mar/2006 -

Jun/2007

Database Administrator - SQL Server 2000 and SQL Server 2005 - Permanent

Position

. Manage of 47 servers.

. Migration from SQL 2000 to 2005

. Programmer using Visual Basic and C# / 2005 / Dot Net

. Working with Business Intelligence Development Studio (or SSIS

templates in Visual Studio)

. TSQL programming / development

. Reporting Services with SQL 2005

. SQL Server databases, data warehouses, ETL (Extract Transform Load)

processes like transform data from Excel to SQL, Txt to SQL, Oracle

to SQL, AS400 to SQL,Sybase do SQL and vice versa usin SSIS packages

to load validate into SQL DataWarehouse. Using Openquery to run

scripts from AS400 to SQL to process it and return back to AS400

. Replication

Southern Wine & Spirits - USA - Florida

Oct/2005 - Mar/2006

Contract Position

. Database Administrator/Consulting

. SQL 2000 and 2005

. Procedures,Jobs,DTS,Triggers

. Working with Business Intelligence Development Studio (or SSIS

templates in Visual Studio)

. Backups and Maintenances

. Replication

Maritime Telecommunications Network - USA Florida Apr/1995 -

Oct/2005

Database Administrator - SQL Server 6.5 / 7.0 / SQL Server 2000 - Permanent

Position

. Transact-SQL skills and the ability to create complex queries, stored

procedures, triggers, user-defined functions, views, and other

database objects

. Knowledge of SQL Server administrative tools, including SQL Server

Management Studio, SQL Server Profiler, SQL Server Agent, SQL Server

Surface Area Configuration, Database Engine Tuning Advisor

. TSQL programming/SP programing

. Database communication mechanisms such as ODBC, ADO.NET, and TCP SQL

Server databases, ETL (Extract Transform Load) processes like

transform data from Excel to SQL, Txt to SQL, Oracle to SQL, Data

Warehouse and OLAP cubes

. Programmer using Visual Fox Pro, Visual Basic, C# 2005

Chasquitour Travel - USA Florida - Permanet Position Jan/1991 -

Mar/1995

Commercial Manager

Fox Pro Programmer

RCA Victor - S o Paulo Brazil - Permanent Position Sep/1980 -

Oct/1990

Manager of General Ledger (8 people)

EDUCATION

1990 - Business Administration - Faculdade Armando lvares Penteado -

Brazil

OTHERS COURSES

2002 - Crystal Reports, 40 hours in Boston - USA

2003 - SQL Server 2000, 40 hours Microsoft Corporation in Florida USA

2004 - SQL Server 2000, 40 hours Microsoft Corporation in Florida USA

2005 - SQL Server 2000, 40 hours Microsoft Corporation in Florida USA

2006 - SQL Server 2005, 40 hours course 2779A Microsoft Corporation in

Georgia USA

2006 - SQL Server 2005, 40 hours course 2780A Microsoft Corporation in

Georgia USA

2012 - SQL Server 2012, 40 hours course Performance Tuning - Design

Internals & Architecture in Georgia-USA

2012 - SQL Server 2012, 40 Hours course AlwaysOnHighAvailability and

Disaster Recovery Solutions, in Georgia-USA

Linguistics: English, Spanish, Italian, Portuguese

Salary Expectations - $110,000 YEAR - W2

Contract Rate - $65.00/hour[pic][pic][pic]

Contact this candidate