Management Sql Server
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:***********@*****.***
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