Bezons
Respected Database Administrator with numerous years of experience,having administered Sql server and Oracle database using Oracle 9i, 10G,11G as a major databases and DB2 as minor database under AIX, Sun Solaris,HPUX and Windows platforms.
My main duties :
Install,patch and maintain all Oracle software installation RAC and non-RAC 10g 11gr1 and 11gr2 and Upgrade database and Grid Infrastructure
Deployment of Oracle RAC using extended RAC methods for our critical application.
Configuration of active data guard for reporting environment.
Installed and Configured Oracle 10g Application Server and Grid Control to monitor and maintain Oracle 10g RAC Database and Oracle 10g Application Server.
Configuration and maintaining of all RMAN Backups and recovery.
Create procedure and implement Security ,backup and recovery of the data warehouse.
Created PL/SQL package and procedures for extracting and transforming data for data warehouse project.
Migrate Microsoft SQL Server to Oracle database.
Perform Microsoft SQL Server backups and restore.
Maintained Microsoft SQL Server Security.
Created Microsoft SQL Server databases.
Monitor Microsoft SQL Server performance of database.
Monitor Microsoft SQL Server nightly jobs for data warehouse ETL.
Creation of UNIX shell script to extract ADDM and AWR report from database. Compress and email daily to monitor health of databases.
Performance and tuning of all SQL and PL/SQL
Interpret ASH, AWR and AWRSQL reports for identifying performance bottlenecks and give recommendation on rewrite of SQL and PL/SQL to improve performance.
Mes compétences :
Dba oracle
Itil v3
SQL Server
Netbackup
Unix/Linux
MySQL
As400
Postgresql
Pas de formation renseignée
