Paulo Eduardo Matioli De SOUZA
Oakville, ON
************@*****.*** 647-***-**** www.linkedin.com/in/pmatioli
Improve Robustness & Serviceability of Products Enhance Automation Drive for Results
Extensive experience with Oracle and Netezza Analytics databases, operating systems, hardware, and systems management for large IT infrastructures. Design, manage, and maintain database / server security and infrastructure solutions. Collaborative problem solver, effectively assessing incidents and performing root cause analysis. Meet complex requests within tight deadlines.
Dedicated and persuasive technical leader who communicates well with nontechnical audiences. Strong individual and team contributor, building trusted relationships with colleagues, management, and customers. Self-dedicated learner, quickly adapting to new technology for changing organizational needs.
Expertise in:
Disaster Recovery Service Delivery Team Leadership Project Management
Technical Skills
Databases:
Oracle Database 9i, 10g, 11g, 12c; Netezza 6.0.8, 7.x; Postgresql
Servers:
Unix; Linux; AIX; Windows Server 200x
Script Languages:
Bash; Shell; KSH; VBScript; JScript; SQL; PowerShell
High Availability:
ASM; Data Guard; RAC; HA-Cluster; Netezza Replication Services / PTS
Backup:
RMAN; nzbackup; nzrestore; pg_dump; pg_restore; TSM; NetBackup
Hardware:
IBM Xseries; Dell; HP; IBM Netezza TwinFin; Striper; Mako
Storage:
SAN; NAS; DAS
Virtualization / Cloud:
VMware, Citrix, Amazon AWS, Hadoop, Apache Spark
Professional Experience
Citi Canada
Senior Data Warehouse Netezza DBA, Citi Canada Mississauga, ON 2016 – Actual
Acting as Senior Netezza (PureData for Analytics) DBA for the global trade data warehouse team. Support the Cloudera Hadoop clusters and assist migration of historical data from Netezza to Cloudera Hadoop over ETL / NZSQL. Investigate code issues and provide advice on best performance based on query plan analysis for large fact tables. Collaborate with engineering and support teams in order to resolve major application issues and provide data in time for financial and trade reports.
Proactively identify major hardware/software issues from all Netezza appliances, preventing performance issues during business hours and increase productivity.
Closely working with data architectures on the data security and new data warehouse solutions.
Assisted developers in query performance tuning and parametrization following the SDLC methodology.
Developed shell scripts to properly monitor and support data warehouse environment over different platforms.
IBM CANADA LTD.
IBM PureData / Netezza DBA Support, IBM Canada, Markham, ON 2015 – 2016
IBM PureData / Netezza DBA Support, IBM, Sao Paulo, Brazil 2014 – 2015
Served on global team that troubleshot and diagnosed hardware or software (HW / SW) failures of Data Warehouse Analytics appliance reported by external / internal customers. Assisted customers with security, upgrades, backups, and query performance.
Worked closely with developers to identify and implement enhancements, improving product robustness and serviceability.
Resolved incidents, focusing on root cause analysis, prevention, and knowledge transfer.
Paulo Eduardo Matioli De Souza ************@*****.*** Page Two
IBM (continued)
Increased customer satisfaction rates 50% by following up with customers via phone, ensuring agreement on resolution of issues before closing each case.
Published 20+ internal / external IBM Technotes (related to IBM Netezza appliance), providing support team with on-hand resolutions for major issues.
Supported global customers, recommending best solutions for day-to-day HW / SW issues and major incidents.
Senior Oracle Database Administrator (DBA), IBM, Campinas, Brazil 2011 – 2014
Led team and oversaw day-to-day activities and projects for multiple customers and industries, as DBA subject matter expert (SME). Served as Oracle SME on SOX, corporate, and customer security / compliance audits. Implemented new solutions for financial and retail market projects. Supported 200+ Oracle instances in high-availability environment.
Led project to upgrade 150+ Oracle instances (from Oracle 10g to 11g), involving multiple technology teams. Developed step-by-step process for DBA team, creating efficiency and attaining schedule requirements.
Upgraded SAP BW environment from Oracle 10g to 11g, with no impact to production data consistency and meeting deadlines.
Recognised by leadership for best performance DBA (2013), as measured by KPIs. Promoted to DBA SME for biggest retail account, Whirlpool, based on achieving best performance of the year.
Recognised by Whirlpool as best DBA leader (2013) due to successful project implementations, configuring monitoring tool (Tivoli) rules for Oracle Databases, and improving customer satisfaction with closed tickets 85%.
Senior Windows Server Systems Engineer, IBM, Campinas, Brazil 2005 – 2011
Provided 3rd-level support for server environment of DOW Chemical Company, composed of physical machines running on IBM and DELL hardware (approximately 4K Windows Servers (32-bit / 64-bit) and virtual machines running on VMware ESX infrastructure, spread across 57+ countries.
Resolved security and compliance audit failures by creating script automation to identify and fix policy issues.
Developed Topcall / Kofax document for use by entire support team.
Implemented automation scripts, improving server support 70%.
Served as script SME leader for client, automating majority of manual tasks across multiple servers.
Migrated 2K+ servers from Windows 2000 and NT to Windows 2003, ensuring quality of processes across IBM server deployment QA model.
Additional Related Experience
MICROSOFT CORPORATION, Sao Paulo, Brazil
Support Analyst MSII
Education
Bachelor of Science (BSc), Information Technology, Metrocamp, Campinas, Brazil
Canadian Equivalency: Bachelor Degree (4 year), Credential Evaluation and Authentication Report, WES, Reference # 2605923 / lcr
Professional Development
Big Data Hadoop Foundations, BigData University (online), 2016
Big Data Spark Foundations, BigData University, (online), 2016
Certified IT Specialist, The Open Group CITS, Sao Paulo, Brazil
IBM Certified IT Specialist Level 1
Oracle Database: Oracle Certified Associate (OCA)
Oracle Database: Oracle Certified Professional (OCP)
Oracle Data Guard Administration 11g, Oracle University, Sao Paulo, Brazil
Oracle Database Performance, Diagnostic, and Tuning 9i-11G, Nerv, Sao Paulo, Brazil
ITIL Foundation Certified in IT Service Management v3, EXIM, Sao Paulo, Brazil