Paolo C.

Paolo C.

Senior Database Architect / Administrator

Umbria, Italy
Hire Paolo C. Hire Paolo C. Hire Paolo C.

About Me

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.

Work history

UpStack
UpStack
Senior Database Architect / Administrator
2020 - Present (4 years)
Remote
  • 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

Freelance
Freelance
Database Architect
2019 - Present (5 years)
Remote
  • 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.

Logispin Group
Logispin Group
Head of PMO / Managing Director / Senior DBA
2017 - 2019 (2 years)
Ta' Xbiex, Malta
  • 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.

GoldBet
GoldBet
Senior Project Manager / Product Owner / DBA
2014 - 2017 (3 years)
Roma, Italy
  • Managed various server projects through multiple product lifecycle environments for GoldBet, from development to mission-critical production systems.

  • Independently analyzed, solved, and corrected issues in real-time on projects - providing problem resolution end-to-end on solutions.

  • Provided support for critical production systems and assisted developers with complex query tuning and schema refinement tasks.

Aspasiel
Aspasiel
Database Admin
2007 - 2014 (7 years)
Terni, Italy
  • 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).

Sistematica S.p.A.
Sistematica S.p.A.
Consultant
2005 - 2006 (1 year)
Italy
  • 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.

Central Information Analysis Co. Ltd
Central Information Analysis Co. Ltd
Oracle DB and Betting Applications Consultant
2004 - 2006 (2 years)
Thailand
  • Worked on the design of logical data models and their physical schema design in Oracle database for the client.

  • Developed different PL/SQL Packages, Stored Procedures, Functions, Triggers, SQL statements on various betting applications for the client.

  • Provided support and maintenance for existing solutions; offering critical feedback on data quality issues.

Internet Betting Company
Internet Betting Company
Database & Solution Architect
2002 - 2003 (1 year)
Remote
  • 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.

Internet Betting Company Ltd.
Internet Betting Company Ltd.
Software Projects Manager
2001 - 2003 (2 years)
Remote
  • 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.

Eurobet
Eurobet
Senior Analyst / Programmer
1999 - 2001 (2 years)
Woking, United Kingdom
  • 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.

Portfolio

Database Architect - Transactional Database
Database Architect - Transactional Database

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.

Database Architect - Accounting System
Database Architect - Accounting System

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.

Database Architect - Datahub
Database Architect - Datahub

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
Engineer Data in Google Cloud
Google
2020 - 2020
Oracle Database 11g Administrator Certified Professional
Oracle Database 11g Administrator Certified Professional
Oracle
2011 - Present (13 years)
PMP: Project Management Professional
PMP: Project Management Professional
Project Management Institute
2008 - 2017 (9 years)
Project Manager Professional (Training to PMP certification )
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 Certified Professional DBA 11g, Oracle Database 11g New Features for Administrators
Oracle University
2008 - 2008
Oracle Database 10g Administrator Certified Professional - Version Retired
Oracle Database 10g Administrator Certified Professional - Version Retired
Oracle
2006 - Present (18 years)
Oracle Certified Professional DBA Oracle 9i
Oracle Certified Professional DBA Oracle 9i
Oracle University
2004 - Present (20 years)
Oracle Certified Professional DBA Oracle 8i
Oracle Certified Professional DBA Oracle 8i
Oracle University
2004 - Present (20 years)
Oracle PL/SQL Developer Certified Associate
Oracle PL/SQL Developer Certified Associate
Oracle
2004 - Present (20 years)
Master's Degree in IT Engineering
Master's Degree in IT Engineering
Università di Pisa
1991 - 1999 (8 years)