Senior database administrator.
Sonatrach petroleum corporation –Production division
Total years of experience :18 years, 3 Months
Supporting multiple databases for production, development, and test staging purposes on SUN Solaris, HPUX, AIX,
Oracle Linux.
Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and
Oracle 12.2. RAC databases.
Applying upgrade patch, maintenance and interim patches on all the databases using opatch, migration of
Databases from 11.2.0.4 to 12.1 and 12.2.
Oracle Fusion Middleware 11g Products installation/configuration.
Responsible for maintenance of all the SQL Server and Oracle servers.
Proficiency in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
Manage SQL Server databases and Configure failover cluster.
Setup and maintain Replication for Production servers to provide high availability and monitor using Replication
Monitor.
Setup Alerts, Notifications, Jobs, Job steps with automated Response solution schedules.
Frequently Monitor Connections, Locks and Sql Server Database performance.
Involved in SQL security and planning; administrating and creating user accounts for proper access, SQL/Server
system databases and tables, SQL Profiler and Enterprise Manager/Management Studio, and Server monitoring and
capacity planning to ensure adequate CPU, disk space, and memory on all SQL servers.
Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks
and performance of SQL server.
Gathered, analyzed, and normalized relevant information related to, and from business processes.
Successfully implemented physical standby database using Oracle Data Guard feature for High availability
configuration.
Implemented and managed optimum physical database design (table space, data files, extents, redo logs, archive
logs) and assessed database capacity by monitoring online storage, growth and file system space.
Maintenance of Oracle 12cR2 Real Application Cluster (RAC) Database for High Availability, Scalability and
Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle
RAC.
Worked on disaster recovery, Database backup concepts and options such as user-managed backup, RMANmanaged backup with or without catalog, operating system backup, Cold and Hot backup, Full backup, Incremental,
Cumulative backup and implementing backup and recovery strategies, and Successfully Implemented key RMAN 11g
and 12c new features such as block change tracking, use of flashback recovery area and taking incrementally
updated backup to meet backup and recovery goals.
Monitored Day-Day Backups, Log's & recovering them as per the requirement.
Monitored health of database by keep an eye on all Alert log and trace files and if any error comes find out the root
cause & analysis for resolution.
Developed UNIX / Windows scripts for Primary / Standby switchover and failover, RMAN, recovery, Data pump
export, import, purging archive log files, old backup files etc.
Tuning of SQL queries using AWR, ASH, SQL Tuning Advisor, ADDM, Explain Plan, Stats gathering etc.
Assist in SQL tuning and providing consultation such as creating materialized views, adding indexes, dropping
unnecessary indexes, using hints wherever possible, amongst others.
Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database
design, database tables, indexes, Instance, memory, operating system and java calls.
Regular maintenance activities like cloning, patching and custom code migration provide by developer and working
with their issues.
Implemented and monitored all databases using Oracle Enterprise Manager (OEM) for maximum uptime and
optimal performance. Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell
scripts.
Developed compliance reports and performed auditing at higher levels.
Responsible for Installing, cloning, patching and upgrading ORACLE E-Business Suite .
Standardized and created solid processes for using Rapid Clone processes to create Oracle E-Business instance
clones and additional nodes.
Managed and maintained Oracle E-Business instances and databased on HP UX and Linux environments
Successful upgrade of E-Business Suite Production Instance.
Advised and assisted functional users to set up inventory end Financials modules.
Installation, Configuration, Administration of Oracle Business Intelligence Enterprise (OBIE 11g).
Install Oracle Grid Infrastructure consisting on 3 nodes of an Oracle 11gR2 database in Real application Cluster and
Oracle Data Guard mode.
Upgrade Oracle Databases 10g Rac to and 11g Rac servers ( Real application cluster)
Application of Patches (Interim Patches, Diagnostic Patches, Patch Set Updates, Security Patch, Updates) on Oracle
11g Rac databases.
Tuning Oracle 11g production database performance based on changes in database storage structures due to
application change requirements.
Configure database settings for optimal performance.
Automated maintenance tasks to assist with overall database and environment performance.
Monitoring I/O conflicts, resource conflicts to resolve database fragmentation issues.
Monitoring node status in Rac, alert message, cluster cache coherency statistics of Oracle 11g database servers in
Real application cluster.
Configuration of backup and recovery scenarios using RMAN, RMAN scripts and shell scripts.
Periodic monitoring of backup statuses and regular interval recovery test to ensure the validity of backups.
Import and Export execution.
Researches and analyzes emerging database technologies and makes recommendations to hierarchy.
Regularly collaborated with team and management to discuss new opportunities. Examples include introduction of
Enterprise Manager monitoring, database version upgrades, new statistics gathering methods, important
preventative application and tech stack patching. Developed and delivered complete documentation of the installation and configuration procedures.
Administration of Oracle e-Business Suite 11i/R12 (Concurrent Managers - configuration, setup, optimization,
performance, tuning, monitoring and troubleshooting.
Customizations, concurrent programs, responsibilities Concurrent managers set using Oracle Enterprise Manager
(OEM).
Multiple cloning of Oracle Applications 11i via Adclone to test and pre-production environments.
ADI 7.2 installation on Windows XP Professional Client Computers.
Installing oracle servers under Sun Solaris 5.
Involved in writing Korn Shell scripts for daily RMAN backups.
Development of shell scripts and PL/SQL procedures and planned CRON and DBMS_JOBS jobs to monitor database
performance and user management.
Involved in Backup and Recovery Strategy Development and testing multiple recovery scenarios.
Monitoring of night jobs and scripts for backup automation and other jobs.
Verify validity of backups using recovery options on a separate database configuration
Oracle 10g databases configuration and administration with Oracle Enterprise manger.
Administration of an Oracle 10g database in Real Application Cluster mode.
Oracle Enterprise Manager configuration for Activity Monitoring and Database Evolution and Storage Space
Administration.
Monitoring alert logs for database issues.
Implementation of automatic database monitoring alert systems via the Oracle Grid Control console.
Creation of database objects such as tables, tablespaces, views, indexs, synonyms, materialized views and
multiplexing of control files, data files, logging files.
Export and import database objects using the Data Pump EXPDP and IMPDP utilities.
URL removed due to policy violation. Please contact support for further information.