Sql Server Data

Fábio Alves Peres Negrão

Rua Guiratinga, *** – apto 112 Vila Mariana – São Paulo – SP

+55-11-296*-****/98207-5006 ************@*****.*** Professional Summary

Professional with more than 15 years of experience in SQL SERVER, and acting in versions 7.0 to 2016. Extensive knowledge in tuning techniques, always seeking the best practices. Solid knowledge in Reporting Services, Integration Services and Analysis Services. Extensive experience in contingency projects and high-availability database Always-On Cluster and others technologies such as: data replication, Mirroring Database, Log Shipping, SSDT, BCP, DTS, SAC, BIDS, Microsoft Visual Studio, SQL Azure, Profiler, Data Profiler, Perfmon, Powershell, (RTO-RPO), JSON and XML. Skill-Set

General Skills:

• Good interpersonal skills with a customer service focus

• Resolve conflict, and a collaborative team approach to problem solving.

• Work independently, possess strong problem-solving skills and have a willingness to work with new technologies.

• Strong analytical, interpersonal, technical and communication skills.

• Organized and able to plan and execute tasks with an attention to detail.

• Understand requirements and communicate solutions that help meet the goals of projects or issues.

• Work in a team-oriented, collaborative environment.

• Strong troubleshooting and problem solving skills.

• Experience with TFS, SCOM, SCCM and Perfmon.

• Redgate Tools: SQL Data Compare, SQL Compare, and SQL Monitor.

• Strong understanding and usage of Microsoft Visual Studio (2008-2015).

• Release cycle SLDC, managing multiples DB environments: DEV, Test, QA and Production.

• Strong understanding about SCRUM and Agile methodology. SQL SERVER:

• Assist with user acceptance testing and implementing new database functionality.

• Ensure SQL agent jobs, scheduled tasks, ETL processes and services run successfully.

• Support of production systems for database problem resolution and recovery as well as assistance with production applications, including Emergency off-hour support.

• Fluent in T-SQL and writing efficient, fast-performing queries/stored procedures.

• Moderate ability to manage Analysis Services (SSAS).

• Moderate knowledge to manage Data Profiler and Data Quality.

• Strong Experience with:

• Database replication, log shipping, mirroring.

• Installing, Configuring and Managing SQL SERVER Services and others services in regards to Microsoft SQL SERVER package.

• Monitoring systems to ensure uptime and identify issues proactively.

• SQL Server Reporting and Integration Services (SSRS/SSIS).

• Database monitoring and database performance tools.

• Data design, data migration/conversion/transformation and concepts of relational database design.

• HA+DR technologies on SQL SERVER – Cluster Always-ON.

• Writing complex SQL queries, views, stored procedures, triggers, jobs, and functions, CTEs and CLR (views, stored procedures, Functions and triggers), OLTP Tables, CDC.

• Maintaining data integrity in all databases.

• Recommending and Applying table index and stored procedure changes bases on usage patterns.

• Providing technical support and guidance to the developers and report writers regarding proper database setup and usage.

• Tuning, monitoring, configuring and upgrading databases as needed.

• Identifying Bottlenecks and solving them.

• Working with VLDB and low offline tolerance environments.

• Profiler to retrieve information about running objects on SQL SERVER.

• Designing Database Servers Architecture (Software, Hardware)

• Raid architecture and Storage SAN (specially NETAPP, IBM and EMS).

• Working with OLTP and OLAP, Plan Guide, ColumnStore and RowStore, OLTB Tables in Memory, Temporal Tables, Fulltext Search resources and FileStream.

• Working with XML and JSON data types.

• Great Ability to:

• Troubleshoot code and provide fixes in a time-sensitive manner.

• Use DMV for management of SQL SERVER resources.

• Install, configure and manage SQL SERVER on Windows Core.

• Identify, resolve and document performance bottlenecks and database issues.

• Develop, maintain and administer ETL jobs using SSIS package.

• Review SQL code and recommend optimizations while enforcing best practices.

• Develop scripts and processes to automate tasks.

• Create and maintain documentation and standard operating procedures for all databases.

• Use SSDT, SAC, Data Profiler, BIDS and SQL Azure, PowerShell, DTS, BCP.

• Use Buffer Pool Extensions and Resource Governor. Windows Server:

• Strong experience with Install, Manage and Configure:

• Window SERVER 2000 – 2012 R2.

• Windows 2012 R2 core.

• Hyper-V

Linux (UBUNTU e RED HAT):

• Great hability to install, configure, monitor and manager SQL SERVER 2016. Other tools:

• Word, Excel, PowerPoint, Access, Visio and Project. Experience

SQL Server DBA, 08/2010 to 08/2016

DB Security - São Paulo, Brazil

• Involved with various projects for big companies from different areas.

• Perform analysis on Applications in order to find out Performance issues.

• Worked with:

• SQL SERVER 2000, 2005, 2008, 2008 R2, 2012 and 2014.

• Virtual Environments build on: VMware and Hyper-V.

• Data Modeling – Erwin, Enterprise Architect, BIDS and SSDT.

• Support to development department (Analysis, Training and Help).

• Management and monitoring:

Reporting Services(SSRS), Analysis Services(SSAS) and Integration Services(SSIS) – 2008 to 2014.

Backup/Routines routines.

• Responsible for Implanting, Managing and Monitoring:

• SQL SERVER 2014 Always ON Cluster for HA+DR projects, including remote replicas or on cloud for Windows AZURE.

• Data Replication on SQL SERVER, including replication for other DB servers, such as: Oracle and MySQL.

• Log Shipping and Mirroring Database.

• Database Users, role and schemas Administration.

• Responsible for:

• Managing critical environments with low fault tolerance.

• Performance Analysis for SQL SERVER (CPU, disks, Memory, SAN and SQL SERVER performance counters).

• Best practices Analysis and performing necessary changes: Stored Procedures, Triggers, Functions(UDFs), including CLR Procedures, CLR Triggers and CLR Functions.

• Developing solutions in database architecture.

• Providing Improvement for processes of night routines.

• Analyzing Databases Servers Environment and elaborating Capacity, Planning and Performance documentation.

• Designing and migrating new production Database environment for SQL SERVER.

• Designing new Database servers Architecture (Software, Server Hardware and Storage).

• Coordinating and monitoring Stress test on the Database Servers

• Managing multiples DB environments: DEV, Test, QA and Production.

• Installing, Configuring and Managing SQL SERVER 2012 core.

• Implanting Partitioning table/index, FileStream and FULLTEXT Search.

• Implanting Buffer Pool Extentions.

• Building ETL packages on Integration Services (SSIS).

• Desiging Reports on Reporting Services (SSRS).

• Installing and Configuring SQL SERVER, SSIS, SSRS, SSAS.

• Migrating SQL SERVER versions: 2000, 2005, 2008, 2008 R2, 2012 and 2014.

• Built programs in VB.NET and C#.NET for monitoring routines in database.

• Used Performance Monitor (PerfMon) and Profiler for monitoring performance environment issues.

• Used PowerShell for management of SQL SERVER.

• Made use of Red Gate tools: SQL Data Compare, SQL Compare, and SQL Monitor.

• Attending Meetings (local or international) for Upload Database updates to QA and Production environments.

• Used SCOM, TFS and SCCM.

• Worked with SCRUM and Agile methodology.

• Attending DBA Team Meetings and Project Scrum Meetings. Note:

• All the projects were 100% successfully accomplished.

• Performance projects were very well done to improve performance at least 70%.

• Down time for management of virtual SQL SERVERs with Powershell, speally scripting.

• Increased awareness of clients towards their SQL SERVER environments by submitting documents Capacity, Performance and Planning.

SQL SERVER DBA, 02/2009 to 08/2010

Livraria Saraiva - São Paulo, Brazil

• Management, monitoring and troubleshooting data replication (Replication Transactional, and Merge Replication and Bidirectional) - replication environment involving more than 250 SQL SERVER servers.

• Managed SQL SERVER in versions 07, 2000, 2005, 2008 and 2008 R2

• Used to be the DBA lead.

• Administration Backup/Restore routines

• Support to development and DBA team.

• User, Roles and Schemas Administration.

• Perform analysis on Applications in order to find out Performance issues.

• Responsible for Deploying, Managing and Monitoring:

• SQL Server 2008 R2.

• Reporting Services(SSRS), Analysis Services(SSAS) e Integration Services(SSIS).

• Virtualized Environment on Windows 2008 R2 and Hyper-V for SQL Server.

• Also Responsible for:

• Tuning analysis in SQL Server.

• Implementing of virtualized environment on Windows 2008 R2 and Hyper-V for SQL DBs.

• Migrating SQL SERVER 2000, 2005 and 2008 to 2008 R2.

• Built and Manage DW environment.

• Managing critical environments with low fault tolerance.

• Desiging Database architecture solutions to high availability: Cluster + Virtualization Servers SQL SERVER.

• Identifying Performance issues on DB environments, and applying improvements if needed.

• Elaborating Database Documents: Data Modeling (Erwin and Enterprise Architect), Performance Issues.

• Construction of ETL Packages in Integration Services.

• Application Development in .NET for monitoring database processes.

• Implement Dashboards in SSRS to monitor the entire DB environment.

• Managing DBA team (production and architecture project).

• Designing and Deploying Partitioning Table/Index and Fulltext search.

• Designing and Deploying Reports on SSRS.

• Designing and Deploying ETL packages on SSIS.

• Perfoming improvements on very complex T-SQL objects (Stored Procedures, Functions, Views).

• Built T-SQL objects: Stored Procedure, Functions and Views.

• Built programs in VB.NET and C#.NET for monitoring routines in database.

• Used the tool: Red Gate tools: SQL Data Compare, SQL Compare, SQL Monitor.

• Used Performance Monitor (PerfMon) and Profiler for monitoring performance environment issues. Note:

ü All the projects were 100% successfully accomplished. ü Performance projects were very well done to improve performance at least 85%. ü Due to DW implementation, all the managers and directors could have all the management spreadsheets delivered in a matter of few seconds. Previously, the same spreadsheets demanded several hours or days to be delivered.

ü After the new DB monitoring system implemented, we could have better manage and decrease reaction time to issues and some cases predict and prevent the to happen. SQL Server DBA, 01/2008 to 01/2009

Consoft Consultória - São Paulo, Brazil

• Administration Backup/Restore routines.

• Administration of Database User, Roles and Schemas.

• Provided Support to development team.

• Data modeling - IBM InfoSphere Data Architect.

• Responsible for:

• Implementation of Reporting Services 2008 and Integration Services 2008.

• Elaborating various reports in Reporting Services.

• Monitoring database processes.

• Developing of T-SQL objects: Stored Procedure, Functions and Views.

• Migrating SQL Server 7, 2000 and 2005 to 2008 on Cluster Environment.

• Tuning T-SQL (stored procedures, Functions).

• Reviewing Data modeling to improving performance.

• Reviewing App issues with Dev team.

• Managing and monitoring Data Replication Routines.

• Implementing new Data Replication Routines.

Note:

ü All the projects were 100% successfully accomplished. ü Performance projects were very well done to improve performance at least 83%. ü No more Data Replication Issues.

Education

Graduated in

2005/Dec

FASP São Paulo – SP

Graduated as Bachelor at Computer Science

Idioms

English - Fluent

Spanish - Basic

Courses

Management of Windows Server 2008 Year: 2009

Management of SQL SERVER 2008 Year: 2009

Management of Hyper-V 2008 Year: 2010

Management of SQL SERVER 2014 Year: 2015

Management of SQL SERVER 2016 Year: 2016

Courses in the USA

Database Security - Imperva - April-2015 - San Francisco FortiDB - Fortinet - Jan-2015 - Miami

Certifications

Microsoft Certified Technology Specialist in SQL SERVER 2008 – MCITP MC ID: 8124958 Microsoft Certified Solutions Associate in SQL SERVER 2012 – MCSA MC ID: 8124958 First Certificate in English – FCE – Cambrigde University

Contact this candidate