Post Job Free

Resume

Sign in

Management Sql Server

Location:
Rio de Janeiro, Brazil
Posted:
November 27, 2018

Contact this candidate

Resume:

Leonardo Salustiano Souza

Estrada do Bananal, ***, Bloco 03, Apto 304 – Rio de Janeiro – RJ – Brazil

Home: +55-21-321*-****

Mobile: +55-21-980**-****

Email:ac0jm1@r.postjobfree.com

Linkedin: https://www.linkedin.com/in/leonardo-souza-itil-762a8532?trk=nav_responsive_tab_profile

I'm a Database administrator (DBA) with extensive experience installing, managing, testing and supporting next-generation database solutions in Oracle Enterprise, MySQL and SQL Server environments.

Proficient in an assortment of technologies, including Oracle 12c, 11g, 10g, 9i, SQL Server 2012 and MySQL 5.7, 5.6.

Work in Group and Good Relationship capabilities.

DBA Skills

Oracle Exadata Administration

Oracle 12c, 11g Database Administration

Performance Tuning & Capacity Monitoring

Data Security, Backup & Recovery

Standby/Failover Administration

Oracle RAC & ASM Administration/Installation

SQL Tuning in an Oracle Environment

OEM 12c Installation & Management

RMAN – Backup & Restore

MySQL Enterprise Backup & Restore

Experience

Company: Venco Consultoria e Serviços de TI S/A. – 12/2017

Position: Senior Database Administrator

Customer: Prudential do Brasil Seguros de Vida S/A

Activities:

- Installation and Management of OLTP and OLAP Databases from Prudential do Brasil Seguros de Vida S/A;

- Oracle 12c and Oracle 11g Database Administrator with ASM at Linux Platforms (Oracle Linux and RHEL);

- Oracle E-Business Suite Database Administrator;

- SQL Server 2016, 2014, 2012 and 2008 Database Administrator with AlwaysOn;

- Oracle Databases Patches Deployment;

- SQL Server Service Packs Deployment;

- Security, Backup and Restore Routines Deployment;

- Backup and Restore Oracle (RMAN and EXPDP);

- Import and Export of Oracle Databases;

- Import and Export of SQL Server Databases;

- Tablespaces and Database Objects Creation and Management;

- Tuning of Queries and Database Parameters;

- OEM Cloud Control 13c and 12c - Installation, Configuring and Management;

- Logs Analysis, Tkprof and IPS Package generation;

- Service Request Opening to Oracle Support;

- Creation and Maintenance of Database Architecture Diagrams;

- Contention Analysis and Solution Proposal;

Company: CTIS Tecnologia S/A. – 04/2013 - Present

Position: Senior DBA

Customer: Agência Nacional de Saúde – ANS (National Health Agency)

Activities:

- Management and Installation of OLTP and OLAP Databases from National Health Agency of Brazil at Oracle Exadata;

- Oracle 12c and Oracle 11g Database Administrator with ASM at Linux Platforms (Oracle Linux and RHEL);

- Mysql Database Administrator – National Health Agency Website – Development and Management of Production Database with Replication;

- Security, Backup and Restore routines deployment;

- Backup and Restore (RMAN);

- Import and Export of Oracle Databases;

- Tablespaces and Database Objects Creation and Management;

- Database and Query Tuning;

- OEM Grid Control 13c and 12c – Install, Configuring and Management;

- Oracle Patches Deployment;

- Logs Analysis, Tkprof and IPS Package generation;

- Service Request Opening;

- Contention Analysis and Solution Proposal;

Company: Central IT Tecnologia da Informação Ltda – 01/2013 – 03/2013

Position: Senior Database Administrator

Customer: Agência Nacional de Aviação – ANAC – (National Aviation Agency)

Activities:

- Install and Management of Security Information from National Aviation Agency at Oracle Enterprise Database 11g;

- SQL Server Databases Management – Treatment and Online Systems;

- Oracle 11g Non ASM Database Administrator at Linux Platform (Red Hat);

- Performance and Tuning Database Analysis;

- Security, Backup and Restore routines deployment;

- Tablespaces and Database Objects Creation and Management;

- Database and Query Tuning;

- Trace and Log Analysis;

- Contention Analysis and Solution Proposal;

Company: CTIS Tecnologia S/A. – 02/2012 – 01/2013

Position: Senior Database Administrator

Customer: Agência Nacional de Saúde – ANS (National Health Agency)

Activities:

- Management and Installation of OLTP and OLAP Databases from National Health Agency of Brazil – Oracle 11g;

- Oracle 11g Database Administrator with ASM at Linux Platforms (Oracle Linux e RHEL);

- Mysql Database Administrator – National Health Agency Website;

- Security, Backup and Restore routines deployment;

- Tablespaces and Database Objects Creation and Management;

- Database and Query Tuning;

- Grid Control – Install, Configuring and Management;

- Logs Analysis, Tkprof and IPS Package generation;

- Contention Analysis and Solution Proposal;

Company: B2BR – Business to Business Informática do Brasil Ltda. – 09/2009 – 02/2012

Position: Database Administrator

Customer: Petrobras

Activities:

- Install, Management and Support of Security Information Database – Oracle 10g;

- Performance and Management of Logs Correlation Database - SIEM;

- Oracle 10g Database Administrator at Linux Platform (Suse Enterprise Server);

- Security, Backup and Restore routines deployment;

- Tablespaces and Database Objects Creation and Management;

- Monitoring and Performance Scripts Creation;

- Query Tuning and database research performance improvement;

- Historical Database Creation (Clones) and Database Migration;

- Management and Maintenance at Novell Sentinel tool, with Oracle 10g Databases;

- Management and Maintenance at Sentinel Log Manager (SIEM) tool, with Postgresql embedded databases.

Company: Oracle do Brasil Sistemas Ltda. – 01/2007 – 09/2009

Position: DBA ATG

Customer: Vale

Activities:

- Oracle 9i Database Administrator at Unix Platform (Sun Solaris) with RAC (Real Application Cluster);

- Tablespaces and Database Objects Creation and Management;

- Database performance monitoring;

- Environment Cloning Scheduling;

- Error Analysis and Workaround deployment at crises;

- Concurrent Program monitoring at Oracle E-Business Suite;

- Impact Analysis and Patch Application;

- Oracle Express Server knowlegment and EDW environment (DataWarehouse);

- Release Planning at Vale do Rio Doce Environments;

- Change Management, according ITIL model;

- Key Performance Indicators – Governance.

Company: Interquadram Informática Ltda. – 09/2005 – 01/2007

Position: Junior DBA

Activities:

- Management, Install, Support and Maintenance of DBMS at SQL Server (2000/2005), Oracle (8i, 9i, 10g) and Informix (7.30, 9.40 and 10);

- Logical/Physical Updating and Data Dictionary Updating with Microsoft Visio;

- Process Automation Tool Development;

- Extract/Convertion Scripts Development using T-SQL and PL/SQL;

- Database Administration Services Execution;

- From-To Routines Executions;

- Internal Service Requests treatment;

- Security, Backup and Restore routines deployment;

- Tablespaces and Database Objects Creation and Management;

- Developers Support, regarding process structures;

- User’s Support and Company’s Developers.

Company: Sofis Informática Ltda – 10/2004 – 09/2005

Position: Support Analyst

Activities:

- Internal System’s Support and Databases at Blood Bank of Rio de Janeiro.

Empresa: Shell Brasil Ltda – 06/2003 – 02/2004

Position: Document Control’s Assistant

Activities:

- EDM: Electronic Document Management: Document Workflow at Oracle Database’s Insert.

Education

Institution: Universidade Estácio de Sá

Post Bachelor: Database Management

Conclusion: April/2016

Institution: UniverCidade

Bachelor: Data Processing Technology

Conclusion: Dec/2004

Certifications and Training

Certification: ITIL Foundation Certificate in IT Service

Management – Feb 2015

Training: Introduction to SQL - Oracle 10g

Duration: 40 hours

Status: Concluded

Knowledge

Database:

- Oracle (12c, 11g, 10g, 9i, 8i)

- Microsoft SQL Server (2012, 2008 R2, 2005, 2000)

- Mysql (5.7, 5.6)

- PostgreSQL

- Sybase 7

- Informix (11.50, 11.10 e 10.00)

Programming Languages:

- Shell Script

- PL/SQL

- SQL (ANSI)

- Transact SQL

- Microsoft Visual Basic (6.0, .NET)

Languages:

- Portuguese (Native)

- English (Fluent)

Operation Systems:

- Linux (x64, Oracle Linux, RHEL, SLES)

- Unix

- Microsoft Windows – Windows 7, Professional and Server, XP

Case Tools:

- Microsoft Visio

Others:

- System Analysis

- Data Modeling (Essential Analysis and UML)



Contact this candidate