Gianmarco Iapoce
Cloud & Data Engineer at GOSP - Generali Operations Service Platform- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Oracle Database 12c Administrator Certified Associate
OracleApr, 2016- Nov, 2024
Experience
-
GOSP - Generali Operations Service Platform
-
Italy
-
IT Services and IT Consulting
-
200 - 300 Employee
-
Cloud & Data Engineer
-
Jan 2023 - Present
Key responsibilities: Operating in a multi cloud environment ( AWS, GCP, Azure ) In charge of AWS infrastructure and data analytics projects. Data analytics pipeline building and maintenance with Aws Glue, Lakehouse, Quicksight lambda automation with Pyhton, Nodejs, Go, Rust Automation of infrastructure deployment with Iac technologies: Terraform Architectural design Development of internal tools ( Angular ) Key responsibilities: Operating in a multi cloud environment ( AWS, GCP, Azure ) In charge of AWS infrastructure and data analytics projects. Data analytics pipeline building and maintenance with Aws Glue, Lakehouse, Quicksight lambda automation with Pyhton, Nodejs, Go, Rust Automation of infrastructure deployment with Iac technologies: Terraform Architectural design Development of internal tools ( Angular )
-
-
-
CRIF
-
IT Services and IT Consulting
-
700 & Above Employee
-
Cloud/Data Architect - Team Leader
-
Jun 2020 - Dec 2022
Key responsiblities: As a team leader I'm responsible for planning, performance evaluation of my teammates, cost monitoring, spending review Among my main technical achievements are: Build a near real time data pipeline to ingest data from Matomo platform ( Internet traffic statistics ) into an AWS data lake with Debezium,Kafka technologies Rearchtitecing data layer from a nosql based solution (Mongodb) to a SQL solution (Mysql) I implemented a fully automated process to provision customized AMI with Packer and Ansible I installed and configured a centralized logging system with ELK stack: Elasticsearch,Logstash,Kibana I designed and implemented a blue green deployment strategy both for ec2-based and containerized infrastructure with Jenkins I designed a cross-region Disaster Recovery strategy using AWS CloudEndure for replication of resources Management of Kubernetes clusters ( EKS ): patching, upgrading, monitoring Management of CI/CD chains with Jenkins and Gitlab CI Management of mongodb databases Management of a monitoring system based on Grafana/Prometheus stack Show less
-
-
-
Docebo
-
Canada
-
Software Development
-
700 & Above Employee
-
Cloud & Data Engineer
-
Jul 2017 - Jun 2020
I designed and implemented a data lake infrastructure to feed Business Intelligence processes and Artificial intelligence algorithms using a number of AWS services such as: EMR, RDS, S3, Athena, Lambda functions, Fargate. I built a completely automated pipeline to update the datalake infrastructure with Gitlab Ci and Terraform. I constantly assist the AI team to design their data pipeline with Apache Spark and Kubernetes I'm currently in charge of designing the infrastructure for a business intelligence tool that may offer our customers insights on the effectiveness and ROL (Return of Learning) of their learning plans Designed an ETL to ingest data into Snowflake from AWS S3 Designed a data warehouse service with Amazon Redshift Spectrum and Google Big Query Utilized Amazon Firehose to stream application data to s3 for further inspection and analysys through Amazon Athena and Amazon EMR (Apache Presto) Exstensive use of AWS Glue to build ETL pipeline from rds instances to S3 Buckets Orchestrating data pipeline with Apache Airflow In charge of infrastructure management, particularly rds, DynamoDB, Elasticache, Ec2/Ecs,s3 services. Tasks automation via go/Python scripts and amazon sdk. Extensive use of lambda functions to create serverless infrastructures. Developed a backend API with Nodejs and Mongodb. Continuos integration and deploy with Jenkins and Amazon Code Pipeline Automation of infrastructure deploy with Terraform Show less
-
-
-
Fujitsu
-
IT Services and IT Consulting
-
700 & Above Employee
-
Senior IT Engineer
-
Jun 2013 - May 2017
Key responsibilities: Implement a NoSQL solution with Mongodb 3.2 in high-availability configuration(replicaset) Implement a virtualized Oracle architecture with Oracle VM 3.3 technology Upgrading all Oracle Databases to Oracle 12c release Perform Oracle Database Administration during all phases of development, system test and production cycles. Implement Sql Server AlwaysOn solutions for high-availabilty Architect new solutions to complex environments that are efficient and low-cost. Organize, install, and assess enterprise relational database management system (RDBMS) software across multiple database environments. Troubleshoot Oracle RDBMS running on any Unix and Windows platforms Create, track and report metrics for capacity planning. Analyze current capacity and provide recommendations. Participate with database capacity planning, benchmarks. Routine tasks include database design, creation, maintenance, backup/recover, and performance tuning. Provide hands-on training to less experienced DBAs. Ensure all aspects of Oracle database security control measures are correctly implemented with proper ongoing maintenance. Conduct periodic review and confirm of database accounts to meet audit requirements Show less
-
-
-
Vodafone
-
United Kingdom
-
Telecommunications
-
700 & Above Employee
-
Oracle specialist - Db architect
-
May 2012 - May 2013
Key responsibilities: Design and install complex 11gR2 RAC infrastructure ( even 6 nodes RAC ) with ASM/OCFS technology on various type of OS including Linux, HP-UX, AIX, Oracle Solaris. Design and install RAC and non-RAC high performance databases Design and implement DATA GUARD and GOLDEN GATE infrastructures Develop and implement RMAN scripts to backup prod/preprod databases Document database configuration and infrastructure. Key responsibilities: Design and install complex 11gR2 RAC infrastructure ( even 6 nodes RAC ) with ASM/OCFS technology on various type of OS including Linux, HP-UX, AIX, Oracle Solaris. Design and install RAC and non-RAC high performance databases Design and implement DATA GUARD and GOLDEN GATE infrastructures Develop and implement RMAN scripts to backup prod/preprod databases Document database configuration and infrastructure.
-
-
-
Hewlett Packard Enterprise
-
United States
-
IT Services and IT Consulting
-
700 & Above Employee
-
Database administrator Unix sysadmin
-
Jun 2010 - May 2012
Key responsibilities: Oracle Database Administration of Production and non-Production environments on various types of OS, including HP-UX, Linux Red-Hat, Windows Fine-tuning of production database to solve performance issues of various kind (parallel query, poor performing procedures….). Planning and implementing database upgrading from 9.2.0.8 release to 11.2.0.3 Ensure backup integrity perfoming periodical backup and restore tests on dedicated servers Deliver databases capacity plans via scheduled procedures Install, configure and administer MySql 4.x,5.x database on Linux Red-Hat platforms Managing geographical cluster implemented on a HP-UX environment with Service Guard technology Show less
-
-
-
Zurich North America
-
United States
-
Insurance
-
700 & Above Employee
-
database administrator
-
Sep 2008 - Jun 2010
Key responsibilities: Oracle Database Administration of Production and non-Production environments on AIX platform Identifying and implementing preventative measures to avoid performance issues or downtime to the Production database environments Assist development teams during build, test and rollout phases of projects Diagnose and resolve Production performance issues, where possible Proactively monitor the database systems to ensure secure services with no downtime. Identify and resolve issues around rogue/corrupt data in the schemas Create and implement scripts to automate manual tasks, such as database monitoring, schema validation, reports, etc. Document database configuration and infrastructure. Oracle AS Administration and Troubleshooting Oracle Forms environment administration SQL Server Database Administration and troubleshooting Train colleagues on database related topics. Show less
-
-
-
TIM
-
Italy
-
Telecommunications
-
700 & Above Employee
-
database administrator - unix system administrator
-
Sep 2007 - Sep 2008
Key responsibilities: install, manage, monitor and troubleshoot production or development database servers; install Oracle 10g/11g RAC environments on Linux Red Hat and Linux Suse platforms; upgrade Oracle databases to 10.2.x or 11.1.x releases; monitor database performances with Oracle Grid technology, statspack, PL/SQL procedures developed by me; install, manage and troubleshoot Oracle Application Server 10g, both with Infra or Middle-Tier configuration. compile, patch, install MySQL server (release 3.x,4.x,5.x), configure high redundancy solutions (master-slave or master-master replica), migrate production systems from MySQL 4.x to 5.x; administer Linux cluster with Lifekeeper software; day-to-day mantainance of linux and sun servers (account creation, disks and file systems management, networking…). Show less
-
-
-
Vodafone
-
United Kingdom
-
Telecommunications
-
700 & Above Employee
-
Database administrator
-
Feb 2007 - Sep 2007
Key responsibilities: install, manage, troubleshoot oracle databases (releases 8.x,9.x,10.x) on many different Unix operating systems (Sun Solaris, HP-UX, Tru64) within a 24x7 production environment; develop, test, and implement the appropriate backup procedures with RMAN technology, participating to complex restore operations; work closely with platform, and IT application groups to optimize database design, application build and deployment process; benchmark, load test, and optimize SQL queries; work out capacity plans to monitor the growth of databases; participate in large storage engine migrations; control and monitor user access to databases and maintain database security; carry database duty phone to provide 7x24 support coverage Show less
-
-
-
Nielsen
-
United States
-
Technology, Information and Media
-
700 & Above Employee
-
Database-system administrator
-
May 2006 - Feb 2007
Key responsibilites: install, manage, upgrade and troubleshoot Oracle databases 8.x, 9.x, 10.x, in a datawarehouse environment; allocate storage and develop plans for future storage requirements; manage partitioned and sub-partitioned tables and indexes, snapshots and all datawarahouse-related oracle’s technologies; regularly monitor and periodically conduct random tests of restoration from backups generated within the environment; control access permissions and privileges on databases; develop processes and procedures for ensuring dev/qa environments are in sync with production; perform database tuning for optimal performance to meet Business SLAs; day-to-day administration of AIX operating system (account creation, networking…); monitor AIX operating system’s performances with IBM monitoring tools (NMON, TOPAS); manage and allocate storage with LVM (Logical Volume Manager) technology; install and manager VMWARE partitions with VMWARE ESX technology. Show less
-
-
-
-
Database-system administrator
-
May 2004 - May 2006
Key responsibilities: administer and troubleshoot an Active directory infrastructure (accounts, group policy, replica…); install, administer and recover a Microsoft cluster; implement RAID solutions on IBM servers (x335, x445); install, administer, troubleshoot Oracle Application Server 10g; install, administer and troubleshoot oracle databases 9.x in a Windows environment; patch oracle datatabases to the last available release: 9.2.8; monitor database systems including stored procedures, tables, execution times; implements batch procedures to backup oracle databases to tape; meeting users' access requirements and resolving their problems; training users; Show less
-
-
-
-
network engineer
-
Nov 2003 - May 2004
Key responsibilities: design and deploy network layouts monitor, perform and resolve network capacity issues. analyse and troubleshoot complex and advanced network problems. support and maintenance of switched network environment support and maintenance of LAN network environment support the day-to-day operations network team. install and configure network hardware (cisco routers, switches). Key responsibilities: design and deploy network layouts monitor, perform and resolve network capacity issues. analyse and troubleshoot complex and advanced network problems. support and maintenance of switched network environment support and maintenance of LAN network environment support the day-to-day operations network team. install and configure network hardware (cisco routers, switches).
-
-
Education
-
1995 - 2000
Seconda Università degli Studi di Napoli
Community
