luca albertini

Database performance tuning, HA Architectures, Replication, Backup and Recovery, Oracle Cloud Control Oracle Engineered Systems (Exadata OVM) Oracle Engineered Systems (ODA- Oracle Data Appliance)

Database performance tuning, HA Architectures, Replication, Backup and Recovery, Oracle Cloud Control Oracle Engineered Systems (Exadata OVM) Oracle Engineered Systems (ODA- Oracle Data Appliance)

* DBA Architect – * Define and document drafting "DevOps Approach for DWH environments". * Objectives of the document: * Perform the capacity planning * Perform database reorganization as required to assist performance and ensure maximum uptime of the database. * Perform standardization to ensure that all application design and code is produced with proper integrity, security and performance. * Control migrations of programs, database changes, reference data changes and menu changes through the development life cycle.

* DBA - Project "Reorganization Architecture DB Live" DHL Express * Reorganization of backup policies "DB Live" : analysis and development of procedures for centralized backup using RMAN, scripting, shell, batch, schedule task * Installing and Configuring RMAN instance of Windows NT server, creation and configuration backup tasks on remote instance, network configuration for writing on NAS, configuration and test individual instances (Windows and Linux). * Preparation and execution of test Recovery and Restore

* DBA * Project "TLR * Telriscaldamento" A2A Spa * Managing DEVELOPMENT database environments * Analysis functional and technical requirements, design and drawing ER model (tools used Erwin DataModeler) * Development support, creation SQL scripts and PL/SQL, stored procedures, packages

* Database Administrato of Development and Test environments. * Tuning & performance (generation statspack, AWR Report, SQLTrace), monitoring, maintenance, ordinary and extraordinary activity. * Technical support OPERATION, impact assessment, ordinary and extraordinary database administration, Backup policies implementation, installation and upgrade Instances (9i, 10g) * Support the development, create SQL scripts and PL / SQL, stored procedures, packages

* Project "WISP" WIND Telecommunications Spa * Implementing Application "WISP - Reporting for the reconciliation of retail sales of Insolvency client TI (Telecom Italy)" ORACLE-platform Java * Analysis of the functional and technical requirements, design and drawing ER model (tools used Erwin DataModeler), package development, stored procedure, analysis and development methodology ETL for load from external systems. * Implementing logic of automatic loading monthly data (data provided through text files) using SqlLoader, performance evaluation.

* Project " ENEL Power Plant" Enel Spa * Application re-engineering EPP (ClientServer / Access Visual Basic) on ORACLE platform-Visual Studio (Web oriented). * Technical and functional requirements analysis, design and drafting new ER model (optimization and evolution of) development package, StoredProcedure, business logic to application. * Analysis and development of tools to interface Reporting (Business Object), optimization and tuning.

* DBA - Database administrator production. * Migrating from Oracle db versions 9i to 10g - 11g * Monitoring of production environments using sql and oracle 11g Grid and 12C Cloud. * SQL & Performance Tuning (Single Instance and RAC Architecture) * Ordinary and extraordinary maintenance of ORACLE db. * Create and run scripts sql / plsql, creation and adaptation of scripts / shell for monitoring databases, comparison of benefits due to the migration of hardware platforms with oracle db, in single node architecture, and RAC. * Analysis and reorganization of data structures, space optimization. * Pre and post upgrade support for migrating from Oracle Database 10G to 11g * Installation and configuration DataGuard * Installation and configuration OGG (Oracle Golden Gate)

* DBA - Database administrator production. * Monitoring of production environments using sql and oracle 11g grid. Analysis and resolution of issues related to tuning/performance of queries. * Ordinary and extraordinary maintenance of ORACLE instances. * Create and run scripts sql/plsql, creation of scripts/shell for monitoring databases, comparison of benefits due to the migration of hardware platforms with oracle db, in single node architecture, and RAC. * Performance Tuning and Oracle / Siebel * Analysis and reorganization of data structures, storage optimization

Focal point of the DBA group of 3 persons Managing database environments TEST and Pre-Production, technical support to development, tuning & performance (use and interpretation Statspack and AWR, maintenance, ordinary and extraordinary activity, refresh, installation/creation DATABASE server-SUN or WINDOWS OS, backup and recovery, planning activities, developing SQL scripts and PL/SQL. Performing Restore and Recovery Test for KPI mesurament, configuration and management environment for Stress Test session , support in performance and tuning.

* DBA - Database administrator production. * Migrating from Oracle db versions 9i to 10g - 11g - 12c. * Pre and post upgrade support for migrating from Oracle Database 10G to 11g * Monitoring of production environments using sql and oracle 11g Grid and 12C Cloud. * SQL & Performance Tuning (Single Instance and RAC Architecture) * Ordinary and extraordinary maintenance of ORACLE db. * Create and run scripts sql/plsql, creation scripts/shell for monitoring databases, comparison of benefits due to the migration of hardware platforms with oracle db, in single node architecture, and RAC. * Analysis and reorganization of data structures, space optimization. * Installation and configuration DataGuard * Installation and configuration OGG (Oracle Golden Gate) * Maintenance Backup strategy with RMAN * Restore and Recovery strategy with RMAN * Installation and configuration DELPHIX environments : creating and configuring replication environments including PRODUCTION and DEVELOPMENT/QA/TEST. Perform Tuning&Performance, troubloshooting.