Adriano A. Pereira

Sybase DBA

acqs71@r.postjobfree.com

443-***-****

Summary

-Database engineer with solid professional experience in three major database vendors

-15+ years of SAP Sybase ASE database administration experience

-6+ years of SAP Sybase Replication Server architecture and administration experience

-Database performance and tuning expertise

-5+ years of Oracle administration experience (Certification Oracle 10g / 2006)

-2+ years of Oracle Exadata experience (ASM, RAC and performance tuning using smart scan capabilities)

-1+ year of Oracle 12c and multi-tenant architecture

-7+ years of MS SQL Server administration experience, including MS ETL and BI solutions

-Solid experience deploying DBMS on clustered or virtualized environments; Veritas Cluster Server (VCS), Solaris Containers/Zones, EMC VPLEX Architecture, Oracle RAC, Microsoft Cluster Server, MS VMWare

-Experience building DR database environment; EMC Cloning (BCV/snapshot), SAP Sybase Replication Server, Oracle Data Guard, Project Lead

-Experience as a Project and Team Lead

Employment

Investment Financial Institution located in Maryland, USA (2008 – 2015) - Sybase DBA

•Lead Sybase DBA in a 24x7 HA environment

•Provide support, administration and maintenance to multiple Investments and Core Trading Sybase ASE databases

•Worked in the migration of large Sybase and SQL Server DW databases to Oracle 11g Engineered System

•Performed multiple database installs, upgrades and patching (SAP Sybase ASE 15.7, ASE 15.0, Sybase RS 15.0, Sybase RS 15.7, Oracle 11g, MS SQL Server 2008 R2, MS SQL Server 2012)

•Involved in POC for Oracle Engineered System and Oracle 12c environments

•Lead performance and tuning Sybase DBA, T-SQL performance recommendation, database optimization or infra-structure (network, storage) benchmarks performance related (CPU, Cache utilization, IO throughput, etc)

•Involved during the Sybase DR environment configuration and during periodic DR exercises

•Involved in the Investments Oracle DR physical standby database using Data Guard

•Implement and maintain database maintenance plans and schedules according to existing SLAs

•Implement monitor and alert scripts used within several tools (OEM, Foglight, BMC Patrol, Perl/Shell scripts)

•Coordinate, implement and manage auditing and database security police, promoting and documenting SOC-1 standards, requirements and procedures

•Developed BI and reports in-house solution accessing DBA repository providing database related historical information, using MS BI tools (SSRS, SSIS, SSAS)

Skills applied: SAP Sybase ASE 15.7, ASE 15.0, ASE 12.5, SAP Sybase Replication Server 15.7, Sybase RS 15.5, Oracle 10g, Oracle 11g, Oracle 12c, Oracle Engineered System, Oracle Tenant Architecture, Oracle Golden Gate, Oracle Data Guard, Oracle RMAN, Oracle ASM, Oracle OEM, MS SQL Server 2008 R1/R2, MS SQL Server 2012, Unix Solaris 10/Solaris 11, Windows Server 2008/2012, IBM Tivoli Storage Manager TSM, EMC, Vmax3, Flash Memory, Microsoft SSIS, SSAS, SSRS, Autosys Scheduler, Unix Shell Scripts, Perl Scripts, MS Powershell, MS Project Manager, MS Vision, SAP Power Designer Data Modeler, BMC Patrol, Dell Foglight/Spotlight, Foglight Performance Analizer, Embarcadero DBArtisan, SAP Business Objects 6.5, BO X, BO XI, Informatica Power Center 8.x/9.x, Veritas Cluster Server, Solaris Containers/Zones, Vplex-3, Oracle RAC, Microsoft Cluster Services, Project Lead

Consult Informatica - Brazil (2006 – 2008) - Database Administrator

•Lead multi-database DBA team (Sybase ASE, Sybase IQ, Sybase Replication Server, Oracle)

•Worked on multiple database migration projects from Sybase to Oracle

•Performed installs and configuration of new SAP Sybase ASE and Oracle 10g instances and required disk storage design

•Coordinate the deployment of database Management Security Polices, create access roles, implement data auditing features, security vault, data-disclosure polices

•Responsible for developing and conducting multiple training sessions for database developers in Sybase T-SQL development and Oracle PL/SQL development; including best practices and performance techniques

•Performed performance analysis and troubleshooting at several database, Unix or storage levels during critisit events

•Performed several database server installs, upgrades and patching

Skills Applied: Sybase 11.9.2, Sybase 12.0, Sybase 12.5, Sybase 15, Sybase IQ 12.x, Sybase IQ 15.x, Sybase SQL Anywhere, Oracle 9i, Oracle 10g, Oracle RMAN, MS SQL Server 2000/2005/2008, MS SQL Server 2003, Unix Solaris 9/10, Linux RedHat, Unix/Linux shell scripts, Sybase Power Designer, CA Erwin Data Modeler, Vision, MS Project, MS SSIS, MS SSRS, MS SSAS, Project Lead

HSBC Bank Brazil (2005 – 2006) - Sybase DBA

•As a Senior Sybase DBA with a major role in the integration process during the acquisition process of Lloyds Bank UK by HSBC Bank (Sybase ASE 12.0, ASE 12.5, ASE 15.0)

•Worked on the integration of all global databases systems into the Corporate security polices, implementing access roles, auditing mechanism, develop and maintain audit/security reports

•Performed install, configuration and monitoring of new Sybase ASE and Sybase Replication Server instances, during the transition process to the HSBC environment

•Performed performance analysis and troubleshooting at database, OS or storage levels during performance events impacting database overall performance

•Primary Sybase IQ DBA responsible to support multiple DW projects (Sybase IQ 12, IQ 15)

•Responsible to review and optimize ETL processes pulling diversified legacy data from DB2 and loading into Sybase IQ for BI purposes

Skills applied: Sybase 11.9.2, Sybase 12.0, Sybase 12.5, Sybase 15, Sybase Replication Server 12.x, Sybase IQ 12.x, Sybase IQ 15.x, Unix IBM AIX 9/10, Linux, Unix/Linux shell scripts, Sybase Power Designer, IBM DB2 UDB 8.2, SQL Backtrack, Tivoli Storage Manager, BMC Patrol.

ICI – Instituto Curitiba de Informatica (2001 – 2005) - Sybase DBA

•DBA responsible for the daily database support activities (Sybase ASE instances with Replication Server)

•Review, implement and maintain Corporate Security Police, access roles, auditing processes, data security and data disclosure polices

•Responsible for troubleshooting, upgrades, performance tuning on major production databases

•Performance and tuning on stored procedures, triggers and ah-hoc queries in Production or during UAT phase

•Responsible to coordinate the first Data Warehouse implementation on the major customer General install, setup and monitor several production database servers

•Implement ETL solution for data integration between MS SQL Server, Sybase ASE and Sybase IQ instances

Skills applied: Sybase 11.9.2, Sybase 12.0, Sybase 12.5, Sybase IQ 12.x, Sybase IQ 15.x, Sybase SQL Anywhere, SQL Server 2000, MS SQL Server 2005/2008, Unix HP-UX, Linux Susi, Unix/Linux shell scripts, Sybase Power Designer

Pluma S.A - Brazil (1994 - 2001) - Database Developer / DBA

•Maintain daily database administration duties, such as backups, regular maintenance, monitoring, troubleshooting, upgrades

•Develop and maintain stored procedures, triggers, views

•Work in multiple upgrades from Sybase ASE 10 to 11.5, 11.9.2 and 12.0

•Maintain database maintenance scripts (index rebuild, updates stats, backups, et)

•Develop and maintain ETL programs for data migration from DB2/mainframe to Sybase ASE

Skills applied: Sybase 10.x, Sybase 11.0. Sybase 11.92, Sybase 12.0, IBM AS/400, Linux, Windows NT, Windows Server 2003, Visual Basic 3.0/6.0, Crystall Reports, Clipper Summer, Clipper 5.0, analysis, development, Novell Netwrk, HTML, ASP, JavaScript

Major Education

BS Information Technology

Uniandrade University Brazil, 1993

Contact this candidate