TECHNICAL SKILLS:

• Bilingual: English, French
• DATABASE ADMINISTRATION
• Bash Shell Scripting,
• Rman, SQL
• Performance tuning
• Unix, Linux
• Upgrade, Patching and Migration
• Dataguard
• OEM, Toad, SQL developer
• TDE security
• Windows, SQL server
• Backup and recovery
• Migration, Datapump
• Golden gate, RAC
• Oracle 10G, 11G, 12c, Exadata
• RAC, PL/SQL
• Shell scripting, DBMS scheduler

SUMMARY:

• I am a 6 years Oracle database administrator (9 year on IT field) with hands - on experience in daily administration of production Oracle 11g, 12c databases as well as installation and configuration of both standalone and Oracle Real Application Cluster (RAC) databases, backup and recovery using Oracle Recovery Manager (RMAN), database migration and refresh using Oracle Data Pump, Oracle database replication using Oracle Golden Gate and Data Guard. I Extensively used Oracle 12c Cloud Control for configuration and monitoring. Also responsible for patching and upgrades, database troubleshooting and supporting development efforts with deployment to production. Managed database schemas, roles, users and objects.
• In addition, I am also a very good team player, self-motivated person, dedicated in any work environment and excellent in documentation. documentation.

PROFESSIONAL EXPERIENCE:

Confidential - Irving, Texas

Oracle DBA & SQL server DBA

• Check the connectivity of each SQL Server on the network, and make sure all SQL Server instances are up. Ensure that all databases hosted on SQL Server instances are online. I plan, design, analyses, and provide technical support for data communications network or group of networks in the company.
• Monitor scheduled job by managing SQL Server Agent jobs is a key DBA responsibility, as they are crucial to any SQL Server environment.
• Verify successful database backup by backing up databases on a regular basis, check for database backups and validate that they have been successfully created and saved in a secure location.
• Monitor disk space, check the amount of free space available on each SQL Server and make sure you are not low on disk space
• Performed quarterly and major releases by applying new object in PROD, STE environment.
• Batch jobs maintenance, in charge of dependency implementation, object recompilation.
• Maintaining and analyzing all scheduled job, responsible of performance tuning of the databases.
• 24/7 production support.
• Excellent experience in Installation, configuration, Maintenance of Oracle 12C, 11g, 10g on Operating Systems Linux, AIX and Windows platforms.
• Experienced in configuring and monitoring of multimode 11g RAC using SRVCTL, ASMCMD Handled RAC Node hangs and node eviction issues.
• Created & Modified ASM disk groups, Managed ASM disk failures, replace failed ASM disk with a new disk and Migrated Application data from NON-RAC to RAC environment.
• Migrated and upgraded single instance database to multiple instance databases using data pump and Migrated databases from Non-ASM file system to ASM file system using RMAN.
• Used RMAN for incremental and cumulative backup/restore, setup, configuration and maintenance of standby databases (Oracle Data Guard) to ensure disaster recovery, high availability and data protection.
• Installed, configured, monitored and troubleshooted lags or process abending in Oracle 11g/12c Golden Gate for non RAC and RAC databases to ensure real time replication of data.
• Installed Veridata to compare data between source and target and which are replicated using Goldengate.
• Used Golden Gate in combination with Active Data Guard and RAC 12c Container databases to achieve maximum availability and the Highest Fault tolerant database system.

Confidential - Peoria, IL

Oracle/SQL DBA

• Excellent experience in Installation, configuration, Maintenance of Oracle 12C, 11g, 10g on Operating Systems Linux, AIX and Windows platforms.
• Experienced in configuring and monitoring of multimode 11g RAC using SRVCTL, ASMCMD Handled RAC Node hangs and node eviction issues.
• Created & Modified ASM disk groups, Managed ASM disk failures, replace failed ASM disk with a new disk and Migrated Application data from NON-RAC to RAC environment.
• Migrated and upgraded single instance database to multiple instance databases using data pump and Migrated databases from Non-ASM file system to ASM file system using RMAN.
• Used RMAN for incremental and cumulative backup/restore, setup, configuration and maintenance of standby databases (Oracle Data Guard) to ensure disaster recovery, high availability and data protection.
• Installed, configured, monitored and troubleshooted lags or process abending in Oracle 11g/12c Golden Gate for non RAC and RAC databases to ensure real time replication of data.
• Installed Veridata to compare data between source and target and which are replicated using Goldengate.
• Used Golden Gate in combination with Active Data Guard and RAC 12c Container databases to achieve maximum availability and the Highest Fault tolerant database system.
• Configured and used Oracle Enterprise Manager 12c (OEM 12c) to monitor oracle databases running on multiple servers
• Generate and review AWR/ADDM/ASH reports, trace queries & transactions and utilize OEM (SQL Tuning Advisor) during performance optimization tasks
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases
• Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.
• Performed monthly and annual performance reports for trend analysis and capacity planning.
• Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
• I used Exadata for database deployments that require very large amounts of data, I also used it to supports oracle data guard and oracle golden gate as the primary mechanism for maintaining standby sites.
• I also used Oracle Exadata database machine to facilitate the deployment solution for hosting the Oracle Database that delivers the highest levels of database performance available.
• Check the connectivity of each SQL Server on the network, and make sure all SQL Server instances are up. Ensure that all databases hosted on SQL Server instances are online. I plan, design, analyses, and provide technical support for data communications network or group of networks in the company.
• Monitor scheduled job by managing SQL Server Agent jobs is a key DBA responsibility, as they are crucial to any SQL Server environment.
• Verify successful database backup by backing up databases on a regular basis, check for database backups and validate that they have been successfully created and saved in a secure location.
• Monitor disk space, check the amount of free space available on each SQL Server and make sure you are not low on disk space

Confidential - deerfiell, il

Oracle DBA

• Successfully installed and configured Oracle 11.2.0.5 databases on LINUX and AIX platforms.
• Monitored and maintained different databases and application servers using TOAD, Oracle Enterprise Manager (OEM) 11g and 12cGrid Control.
• Loading data from flat files to database using SQL*Loader, External Tables.
• Involved in the installation, configuration and extended support to Oracle 11g, 12c two Node RAC (Real Application Cluster) with ASM file system on LINUX and AIX platforms.
• Involved in converting a single instance database to Oracle 11g, 12c RAC databases.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using AWR, ADDM and ASH.
• Troubleshoot Database performance issues with use of ORACHK, Cluster health monitor and Other Oracle support suggested utilities.
• Configuring both physical and logical standby databases to ensure high availability, data protection and disaster recovery for enterprise data.
• Developed RMAN Cold Backup Script to take backups automatically every week for about 200 databases, also scripts to monitor blocking sessions, databases health-check, tablespaces threshold… and automated the process through crontab or DBMS SCHEDULER.
• Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.1.0.7 to 11.2.0.3.
• 24 X 7 Production & Development database support and administration.
• Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).
• Applied security patches (Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using runInstaller and Opatch to improve security and functionality of databases.
• Implemented Flashback technology for 11g, 10g databases to ensure a faster databases and database objects recovery.
• Upgraded the Databases from Oracle 10g/11g to 11g/12c and applied patches according to the client requirement in RAC and NON RAC environments with ASM and Non ASM storage.
• Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.

Confidential

Network Analyst

• Customer services, personal assistance, planning and consulting.
• Manage internal technical inventory, tool kits and equipment in them, including documentation.
• Work with clients to determine equipment and software needs.
• I identify problems within the business and then identify a suitable technical solution.
• I plan, design, analyses, and provide technical support for data communications network or group of networks in the company.
• I work closely with the IT team of programmers, designers and IT managers to design systems.
• Analyzed operations, business and staff performance, and workflow processes; conceived and initiated new management and operational systems that improved communications, performance measurements and job satisfaction.
• Configured and Secured networking equipment’s.