Paolo is a Senior Database Architect with expertise in database administration, programming and project management. He has experience with Oracle ( OCP certified ), Postgres, SQL Server, MySQL administration, wallet systems and document management tools - having administered over 200 Databases for three different clients. He is also a capable PL/SQL and Python programmer and expert in advanced features like partitioning, replication, VPD, flashback and other Oracle solutions for DWH projects.
Delivers data warehouse and ETL solutions as part of an agile team using advanced machine learning techniques to improve performance and processes.
Helps build and improve infrastructure, application and performance development and ensures tight security including data encryption, security groups, and environment scanning.
Ensures high-quality deliverables and implements DevOps and security best practices in fast-paced environments
Leads tasks on data management, security, and migration and provides direction for a team of database administrators and specialists on projects.
Provide database architecture expertise on projects; examining clients current data management systems and identifying opportunities to enhance performance on solutions.
Design, model, document, and guide the logical and conceptual relationship of data and database changes for complex applications on projects for clients.
Actively participated in architecture discussions - proposing solutions to system and product changes across different teams on projects.
Took ownership of complex issues on projects, resolve advanced-level issues, handled customer escalations and worked with clients on matters related to application configuration.
Encouraged cross-team collaboration on projects and managed communication with internal and external developers/community/merchants.
Offered DBA expertise and services to Aspasiel's development teams; handling database design, database generation, coding, and database production support.
Provided accurate and creative solutions to user problems of varying complexities on projects for Aspasiel.
Worked on protocol documents for the migration of database solutions to Aspasiel's Software-Defined Data Center (SDDC).
Worked closely and shared ideas with fellow architects and developers as the Project Manager for the design and development of an online betting platform.
Provided technical leadership in all phases of the project from discovery and planning through implementation to delivery.
Developed and shared software quality best practices with the project team.
Led the client's application development team, being the technical voice advocating technical direction and encouraging innovation on the project.
Contributed to the evolution of the client's physical and logical database architecture design, web application and stored procedures design and programming.
Wore many hats on the project; utilizing different tools, technologies and platforms across many technology stacks.
Designed, coded and led a team to build and evolve a sports betting web application and a bet-exchange web application.
Conducted quality assurance activities such as peer reviews on solutions; working on program code and technical documentation - whilst remaining abreast of industry trends.
Independently analyzed and resolved complex technical issues or business problems on the project for the client.
Worked on Eurobet's first web betting application; handling the design and coding of the web interface, payment systems and other modules of the solution.
Identified requirements and implemented solutions for the renewal of both the eurobet.com and eurobet.co.uk web interface.
Wrote specifications for programs of low to moderate complexity for implementation on the Eurobet project.
Handled the architect, implementation and provision of support for a transactional database that comprises of 1500+ betting shops, Oracle RAC (HA)-based architecture with the capacity to process 100,000+ transactions per minute.
Worked on the implementation of an accounting system for a network of 1500+ betting shops; covering the PMO role, handling database design, administering the database and developing the commission module.
Worked on a Datahub solution and a PL/SQL SAP (BP) interface for the processing of transactions on a complex wallet/account system for betting shops. Handled the integration of the new system for 1700 betting shops with the SAP BP accounting system; merging data from 5 different solutions - overseeing design, development and support on the project.
Education
Engineer Data in Google Cloud
Google
2020 - 2020
Oracle Database 11g Administrator Certified Professional
Oracle
2011 - Present (13 years)
PMP: Project Management Professional
Project Management Institute
2008 - 2017 (9 years)
Project Manager Professional (Training to PMP certification )
Istituto Italiano di Project Management
2008 - 2008
Oracle Certified Professional DBA 11g, Oracle Database 11g New Features for Administrators
Oracle University
2008 - 2008
Oracle Database 10g Administrator Certified Professional - Version Retired