TIVITDBA SQL Server / Oracle
Aug. 2012 - Oct. 2018Working for Pilkington.
Systems: Mastersaf, Senior, OneSource Global Trade (Softway), JDEdwards. Administration of SQL Server 2000 / 2005 / 2008 R2 / 2012 :
- Creation, monitoring and maintenance of Replication and Log Shipping;
- Migration of SQL Server 2005 from 32 to 64 bits using log shipping to reduce shutdown time;
- Recreation of database to fix corruption problems;
- Creation of scripts to monitoring the database health;
- Backup, restore and maintenance plans;
- Creation of SSIS packages;
- Tuning of queries and indexes;
- Performance monitoring (Enterprise Manager and Performance Monitor); Administration of Oracle 9i /10g / 11g (Windows)
- Creation of scripts to do hot backups;
- Creation of scripts to do RMAN backups;
- Duplication with RMAN;
- Migration of 9i and 10g to 11g;
- Installation and configuration of servers;