Leandro Da Silva Email and Phone Number

Main Projects and Results* Developed a Health Check framework for all managed DBMS services using PowerShell and Python, integrating with Splunk through API calls and using Jenkins Secrets.* Developed automated database process, such as a Database compliance check framework applying auto correction using PowerShell, Pester and Jenkins, using PowerBI as dashboard.* Responsible for managing PostgreSQL environment using Ansible.* Responsible for managing Jenkins instance for the DBA Team.* Working as member of the Data Management team on a project to integrate Guidewire Cloud RDS using CDA Client, developed on Scala and Spark, to load parquet files to our AWS RDS. Also working on required adjustments to the Informatica PowerCenter source mappings.

Responsible for the management of SQL Server and PostgreSQL environments with the following versions:* SQL Server 2016, SQL 2012 and 2008 R2 versions.* PostgreSQL 9.2, PostgreSQL 9.6 and PostgreSQL 11 versions. SQL Server Environment details: * Continuous Deployment (CD) using dpos PowerShell module and Jenkins jobs. * SQL Server Central Management Server * Multi-Server Job (MSX and TSX) * Enterprise Policy Management (EPM) - migrated to dbachecks framework * Unattended SQL Server Installation framework * Linked Servers * Transactional Replication * Availability Groups * SSIS packages jobs using environment configuration * SSRS development and maintenance. * DMZ Servers * Enterprise Password Vault - CyberArk * Jenkins jobs using Powershell code stored in Git * SQL Server customized alerts using WMI Query * Database documentation using Extended Properties * Developed a SQL Server environment dashboard PowerBI Report Server using Extended Properties. * Spotlight monitoring systemPostgreSQL environment details:* Environment being controlled and deployed using Ansible ANXS - PostgreSQL module. Projects:* Migration of SQL Server 2012 databases to SQL Server 2016* Developed a PowerShell framework using dbachecks from dbatools to ensure the compliance with our SQL Server configurations standard.* Developed an environment dashboard using PowerBI Report Server* Automation process to create Sql Server Database using dbatools and Jenkins jobs.

* Responsible for the ETL process using SSIS and Qlik Sense, Dimensional modeling, BI Reports and Dashboards in Qlik Sense, and administration of the Qlik Sense Enterprise Server.* Developed a SQL Server Health Dashboard using Microsoft Power BI and dynamically collect information about the SQL Server using SQL Server system dynamic views (DMVs).* Developed a database alert using Windows Management Instrumentation (WMI).

Senior Database Administrator.DBMS environment with hundreds of servers and high transactional volume.Managed DBMS SQL Server 2000, 2005, 2008 R2, 2012, 2014, Oracle 10g and Oracle 11g.Worked with features of SQL Server such as Failover Clustering, Mirroring, Always On, Transactional replication, Performance Tuning, SSRS, SSIS, SSAS, Partitioned Tables and Indexes and others features.Solved critical issues in SQL Server environment; worked together with team of Microsoft International Engineers.Provided technical support to international team of internal developers, business analyst and project managers in Europe and USA.Main Projects and Results:* Developed new database maintenance by reducing time needed by 77% resulting in better performance for business areas.* Managed migration of a major company database from SQL Server 2005 to SQL Server 2012 raising the compatibility level from 80 to 110 without data loss.

Senior Database Administrator.Managed DBMS SQL Server 2008 R2 and 2012.Worked with features of SQL Server administration such as Failover Clustering, SSRS, Data Compression, Performance tuning, Partitioned Tables and Indexes and others features.Solved critical issues in SQL Server environment.Provided technical support to internal team of developers, business analyst and project managers.Main Projects and Results:* Implemented page compression getting a ratio of 84% gain, allowing lower consumption of disk space as well as the backups and also getting lower consumption data cache.* Performed Fill Factor adjustments reducing waste average in Data Cache from 19% to 11%, keeping the split page at acceptable levels.* Conducted migration project from physical environment to private cloud using Hyper-V 2012 increasing the level of availability and performance of services and enabling the prediction of business growth.

Senior Database consultant in PRODERJ - Center for Information Technology and Communication of the Government of the State of Rio de Janeiro.Managed DBMS SQL Server 2000, 2005, 2008 and 2008R2.Worked with features of SQL Server such as Failover Clustering, SSRS, SSIS, SSAS.Main Projects and Results:* Directed important project of migration of hundreds of servers from SQL Server 2000 to SQL Server 2008 R2, raising level of compatibility without data loss.

Term Contract - Database consultant in COCA-COLA Company of Brazil.Managed DBMS Oracle 10G Grid control and SQL Server 2005.Administered Oracle 10G and SQL Server 2005 OLTP and OLAP environment to resolve performance issues.

Term Contract - Database consultant in Generali Company of Brazil.Managed DBMS SQL Server 2005.Main Projects and Results:* Conducted database environment analysis project to recommend improvements in SQL Server settings, T-SQL queries and data modeling; held performance tuning of critical process resulting in reduction of 9 hours on daily window of production.

Administered SQL Server Database and Infrastructure of Windows and Linux Servers.Administered Windows and Linux servers.Coordinated teams of developers and IT support.Projects and Results:* Conducted project of SQL Server migration from version 2000 to 2008, raising the compatibility level from 80 to 100 without data loss.* Negotiated contracts with suppliers to reduce IT costs by 20%, increasing the quality and availability of service.