Sql Server Database Specialist

Leonardo Pedroso Costa

Orlando – FL G.C. Holder

Mobile: +1-917-***-****

Skype: leobrizola

E-mail: *********@****.***

Blog: www.sqleo.com.br

Objective

Work as Database Engineer

Summary

IT professional with extensive experience (12 years) in database administration MySQL, AlloyDB CouchDB, MongoDB, Cassandra, PostgreSQL and SQL Server, performance analysis, deployment, and cluster administration (Windows and SQL. Managed and trained stakeholders in the area of data and systems development, in addition to lecturing and writing technical articles of relevance in the area in which it operates.

Education

Fev/2007 – Dec/201

B.A. in Information Systems

FAMINAS BH

Technical Certifications

PostgreSQL 12 Associate

DP-300: Azure Database Associate

MCSA e MCSE – SQL Server 2019

ITIL V4 Foundations

Professional Experience

Database Specialist at Ria Money Transfer

April/2023 – Current – Location: CA, US

Install/upgrade/administer SQL Server, AlloyDB, CouchDB, Cassandra, MongoDB and PostgreSQL

Performance Tuning, Replication, Backup, Restore and Monitoring scripts

Creating AlloyDB instances on GCP and clusters based on your workload requirements.

Dailys, CCBs, Code Review, Weekly On Call and international team across 4 continents

Copy databases from Production do Read Only and Non Production environments

Monitoring and analyzing AlloyDB usage on GCP and costs to optimize spending.

Managing security and applying patches to fix vulnerabilities and outdate systems

Applying regular updates and patches provided by Google Cloud to keep the database service secure and efficient.

Database Specialist at Zazmic

October/2022 – March/2023 – Location: CA, US

Install/upgrade/administer SQL Server, CouchDB, AlloyDB, Cassandra, MongoDB and PostgreSQL

Configuring multi-region deployments if necessary to provide high availability and resilience against regional outages.

Performance Tuning and Troubleshooter specialist using Linux and Cassandra environments

Backup, restore, permissions, java configs and tuning on Cassandra 3x versions

Upgrade, Deploy, Manage, Indexes, Partions on Cassandra DBs

Regularly consulting Google Cloud's documentation and staying up-to-date with the latest AlloyDB features and best practices

Database Specialist at HARTB

May/2021 – October/2022 – Location: Brazil

Install/upgrade/administer SQL Server, CouchDB, Cassandra, MongoDB and PostgreSQL

Performance Tuning and Troubleshooter specialist using Windows and SQL Server systems

Deploy SQL Server instances and automate repeatedly tasks using Powershell and T-SQL scripts

Deploy cloud environments using Mongo Atlas, Azure SQL Database, RDS Databases and CouchDB

Managing highly transactional standalone and clustered SQL Server instances both in-house and in managed datacentres, Always On, Database Mirroring, Apache Kafka, Mongo Miror

Performance and Tuning of SQL using index tuning, MongoDB Charts, PerfMon, DMVs and DMFs

Implement Application and database installation, configuration, upgrades, backups and restores.

Use of TraceFlags -T1117, -T1118, -T2371, -T610, -T835, -T1222, -T3226, -T4199 for tuning and administrative jobs.

Database Specialist at Capgemini

Jan/2016 – May/2021 – Location: Brazil

Install/upgrade/administer SQL Server between 2005 and 2016, Oracle Database 12c and 11gR2 software deployed on Oracle Linux/RedHat (PostgreSQL, MongoDB, CouchDB and MySQL)

Deploy Cassandra and MongoDB instances at Anvisa and EPL environments

Advanced indexing and best practices applied to the client environment

Managing highly transactional standalone and clustered SQL Server, MongoDB and Oracle instances both in-house and in managed datacentres

Performance tuning of queries, reports and stored procedures, including index maintenance and optimization using DataBases As a Service on AWS, Azure and GCP

Implement Application and database installation, configuration, upgrades, backups and restores.

Interact with the other departments to understand and identify informational needs, problems and requirements. Works with other members of the IT organization to deliver applications, data warehouse and custom reporting solutions to address those needs.

Senior Database Administrator at +2X Tecnologia em Dobro Jul/2014 - Dec/2015 – Location: Brazil

Creating and monitoring all maintenance jobs (Backup/Restore, Indexing, Database Consistency Checks, batch jobs, ETL Processes, Production Jobs) on all databases and creating relation-ships

(Primary Key and Foreign Key) across the tables.

Ensuring highest availability and performance of managed NOSQL Cassandra, CouchDB, MongoDB

Performance and Tuning of SQL Server using index tuning, profiler, PerfMon, DTA, DMVs and DMFs

Designing and implementing new SQL Server standalone and clustered installations

Provide customers with backup and recovery capability. Maintain nightly backups and recover loss data from backups using RMAN

Senior DBA at WEBGCI

Jul/2013 – Jul/2014 – Brazilian Company

Designed Backup and Restore strategies to perform PIECEMEAL RESOTRE during disaster.

Implemented Daily maintenance jobs

Troubleshooting performance issues and provide recommendations for optimizations

Implementation of Tape (TSM) and Disk backups across all environments

Installation and configuration of SQL Server 2008R2 & 2012 clusters

Created and maintained various databases for Production, Development and

Testing environments using SQL Server 2008R2, 2012, 2014 and 2016.

Created and designed databases, application tables, indexes, triggers, stored procedures and views

Database Administrator at Takenet

May/2011 – Dec/2012

Managing and supporting the telecomute OLTP platform and back office systems in 24/7, multi geographic market, retail environment

Performance tuning of queries, reports and stored procedures, including index maintenance and optimization.

Optimized Query Performance, Session Performance and Reliability

Documented SQL standards, change control and other required processes

Capacity planning for new and replacement databases servers

Designing and developing archiving solutions

Publications

Technical articles at: www.sqleo.com.br

Authored Book: SQL Server Além do Conceito Vol 2: https://www.amazon.com/SQL-Server-Al%C3%A9m-Conceito-Portuguese- ebook/dp/B01FVH1F3C/ref=sr_1_1?keywords=SQL+Server+Al%C3%A9m+do+C onceito+-+Volume+2&qid=163*******&sr=8-1

Article to SQL Magazine: https://www.devmedia.com.br/melhores-praticas-com- transaction-log-e-tempdb-no-sql-server-2008-revista-sql-magazine-103/25666

Contact this candidate