Senior Database Administrator
Salam Technology
مجموع سنوات الخبرة :16 years, 8 أشهر
•Area of Expertise mainly includes Database support & maintenance, installation, configuration, administration, security management, memory management, backup, recovery, cloning, up-gradation, database design in RAC and Non RAC environments.
• Installed 4 Node Oracle 12cR1 and 11gr2 RAC Cluster on Linux, Operating System, Migrated existing databases, performance tuning, setup Oracle Grid for Databases, provisioning, application management and alerts.
• Extensive experience on database design and modeling. • Prepare and design the enterprise database and document standards for systems development. • Prepare and maintain change management procedures for systems utilizing the databases.
• Proficient in Relational Database Management Systems (RDBMS).
• Concurrent Manager Setup and trouble shooting.
• Prepare and maintain change management procedures for systems utilizing the databases.
• Experience in Installation of Oracle Audit Vault and Database Firewall Server 12.1.2.3.0 AVDF.
• Database Firewall Activity Monitoring using DAM Mode.
• Oracle Database Vault 11gr2 integrating with 2 node RAC Database.
• Installed and configured 2 node RAC 12c (12.0.1.2) Database on RHEL 6.5
• Installed latest JAN 2016 PSU patch on 12.1.0.2 database and standby database with 2 nodes RAC.
• Upgraded the production database from 11.2.0.4 to 12.0.1.2 (12c) database.
• Resizing Online Redo Logs and Standby Redo Logs on Primary and Physical Standby in Data guard & RAC Environment.
• Hands of experience in 12c OEM with monitoring the database and more than 250 database host machines.
• Deploying agents from hosts to target in 12c OEM.
• Hands of experience in to Blackouts the targets when in maintenance on 12c OEM
• Integrating Oracle Database Vault with Oracle Label Security.
• Upgraded Oracle E-Business Suite from 11.5.10.2 to 12.0.4 and from 12.1.3 to 12.2.5.
• Performance tuning using new EM grid control, database control, AWR, ADDM, SQL tuning/access advisors, Toad
• Installation and configuration of Oracle Enterprise Manager Cloud Control 12c.
• Installation and Configuration of Red Hat Enterprise Linux on Oracle Virtual Machine (OVM).
•Installation and Configuration of Oracle Application Server on Linux on Oracle Virtual Machine (OVM).
• Performed Database server Tuning - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA Tuning, Shared Pool Tuning, Buffers and Disk I/O tuning using Oracle’s regular performance tuning tools like Explain Plan, SQL*Trace, TKPROF, DBMS_STATS, Data Dictionary Views etc.
• Installation and configuration of Oracle Enterprise Manager Cloud Control 12c.
• Installation and Configuration of RedHat Enterprise Linux on Oracle Virtual Machine (OVM).
• Auditing and database health checkup on regular basis. • Good experience in Transportable Table spaces, SQL Tuning Advisor, Data Pump, Table space Management and Virtual Private Database.
Design and Normalization of the database tables.
•Experience in implementing business logic using Triggers, Indexes, Views and Stored procedures.
•Extensive Knowledge of advance query concepts (e.g. group by, having clause, union so on).
•Experience with tools like SQL Server management studio and SQL Server 2008/2012/2016 integration (SSIS) and reporting services (SSRS).
•Proficient in Tuning T-SQL queries to improve the database performance and availability.
•Experienced hands in Query tuning and performance tuning.
•Experience in monitoring SQL Server Performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
•Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Configuring Data Guard for Oracle databases and Database Mirroring for MSSQL Server databases.
• Hands on Production experience on Standby database/Data Guard, RAC, ASM and RMAN.
• Experience with 3 nodes RAC with ASM on Linux/Solaris/AIX/Windows.
• Installation of oracle 10g and 11g on Windows, Linux/Solaris.
Area of Expertise mainly includes Database support & maintenance, installation, configuration,
administration, security management, memory management, backup, recovery, cloning, up-gradation,
database design in RAC and Non RAC environments.
• Installed 2 Node Oracle 11gr2 RAC Cluster on Linux, Operating System, Migrated existing databases,
performance tuning, setup Oracle Grid for Databases, provisioning, application management and alerts.
• Extensive experience on database design and modeling.
• Prepare and design the enterprise database and document standards for systems development.
• Prepare and maintain change management procedures for systems utilizing the databases.
• Well versed in adutilities (adadmin, adctrl, adrelink, adpatch, etc. for Oracle Applications Managing
Oracle E-Business suit profile’s option.
• Applied Application patches for bugs and upgrades
• Worked on Sysadmin activities and workflow.
• Configuring Data Guard for Oracle databases and Database Mirroring for MSSQL Server databases.
• Hands on Production experience on Standby database/Data Guard, RAC, ASM and RMAN.
• Experience with 3 nodes RAC with ASM on Linux/Solaris/AIX/Windows.
• Installation of oracle 10g and 11g on Windows, Linux/Solaris.
• Implement and administer data guard in 10g and 11gR2.
• Solid command over various Database tools like EXPDP/IMPDP, RMAN, SQL* Plus.
• Performed backup and recovery using RMAN.
• Coordinated with Oracle support for SR to resolve Oracle bugs and ORA-errors.
• Prepared knowledge documents including Standard Operating Procedures, Daily activity reports, base
line documents, GAP analysis etc.
• Working as part of a team and providing 24x7 support when required.
Expertise also includes Oracle Installation, Upgrades, Migrations, Patches and creation of Production databases, Backup, recovery, and Performance tuning.
Installed the Oracle Clusterware, RDBMS, ASM, RAC and CPU patches on Oracle 10gr2/11gr2 RAC on Unix Enviornment.
Database health checks for 2Node RAC.
Installed and configured Oracle 11gr2 RAC high availability
Experienced with SRVCTL, OCR and Voting Disk of 10g/11g RAC
Implemented Disaster Recovery (DR) Plan.
Implemented DATAGUARD (Standby) for high availability/disaster recovery purpose
Monitoring the Hit Ratios and tuning the System Global Area (SGA) accordingly
Monitoring the operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like SAR, VMSTAT, ISOSTAT and TOP.
Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports.
Implementation of OEM 12c has done on both Production and UAT servers for Oracle 11.2.0.3 databases.
Experience in MS SQL Server 2005/2008 Installation and configuration as well as applying service packs.
Experience in Microsoft SQL Server Database Administration including planning, implementing Backup and Recovery strategies
Implementing Database Security at Server level by giving specific permission to the different logins.
Monitoring RAC databases through SRVCTL.
Maintaining and Monitoring ASM instances.
Checking for locked instances of the db's and clearing.
Monitoring User sessions through toad, OEM 11g grid and OEM 12c.
Creation and Maintenance of Data Guard.
Creation of database maintenance plans, rebuild indexes and integrity checks
Implemented RMAN Backups, Creation of catalog database
Creation of database maintenance plans, rebuild indexes and integrity checks
Implemented RMAN Backups, Creation of catalog database
Database Management - Backup, & Recovery, Performance Tuning, Configuration of Database, Table space administration, User management, Index management
Performed and scheduled re-orgs
Provided support on performance issues during project development resulting in improved response times and reduced contention
Intensively involved in the area of installations of Oracle Software, Configuration for database and day-to-day routine works for database administration.
Writing UNIX shell scripts for backup and recovery, Import and export procedures.
Monitoring Growth of tables and undertaking necessary re-organization of tables and indexes as and when required.
Expertise in Oracle Enterprise Manager (OEM) grid control and TOAD
Schema Refresh using Export & Import.
Regular Monitoring Alert log Files and trace files on Day-to-Day Basis.
Extensively using DATAPUMP and Export /Import utilities for logical backups.
Experience of transporting tablespaces using Transportable Tablespace feature of export/import dump utility across different platform.
Clearing the lock sessions when query is running slow.
Installed Standby Database Server as precautionary for Implementing Disaster recovery strategies using Standby Database.
Creating oracle related jobs like gathering stats for schema through toad.
Analyzing the SQL Query using Explain plan.
Expertise in Oracle Enterprise Manager (OEM), TOAD.
Performing daily health checkups.
All of my experience & knowledge has been gained across the different Oracle database versions (10g and11g)) and a wide range of operating systems (UNIX/Linux, Sun Solaris, MS-Windows 2000, 2003, NT Server). I have been exposed to a wide range of technologies and developed a broad set of technical skills and a very strong background in Oracle Database & flavors of UNIX operating system.
Expertise also includes Oracle Installation, Upgrades, Migrations, Patches, Database modeling, and creation of Production databases, Backup and recovery and Performance tuning.
Designed and implemented the High-Availability (Real Application Clusters) solution.
Successfully performed installations and configurations of Oracle 10g&11gr2 RAC with ASM on two-nodes across different platforms (Solaris, RHEL 5/Win-2003) with HP EVA SAN Storage.
Applied the Oracle Clusterware, RDBMS, ASM, RAC bundle, and CPU patches on Oracle 10g/11gr2 RAC systems.
Troubleshoot and resolved the RAC Node evictions & Clusterware issues.
Worked as a dedicated project resource for new server builds and created number of production seed databases and migrated the databases (on different Oracle versions) to newly build servers with vendor specifications on different UNIX & Windows platforms.
Prepared and placed the backup policies for the databases including RMAN integrated with Data protector (formerly HP OMNI backup), COLD & HOT Backups, and logical backups using exp/imp.
Widely cloned and refreshed the test and development databases with production data using RMAN, Cold and Hot backups for Application Support Unit/Team environments.
Installed and configured Oracle 11g R2 on Oracle Enterprise Linux 5.5.
Responsible for 24x7 support of large 10g &11g databases for mission critical online applications.
Administration in Real Application Cluster (RAC).
Database Refresh for UAT / Test region with production.
Ensuring Database synchronization of production with standby server.
Ensure the completion of backups on all the production servers.
Checking all production Database Servers and ensuring their health.
Checking Alert Logs and trace files for any errors on all Prod Db.
Periodically check and purging Dump destinations.
Writing scripts for automated database backup, planning and monitoring regular Backups.
Prepared knowledge documents including SOPs, Daily activity reports, base line documents, GAP analysis etc.
Installed and configured Oracle 11gR2 RAC (Real Application Clusters) on Two Nodes - Red Hat Linux 5.5.
Implemented and configured a Physical Standby Database and Data Guard Protection Modes.
Effective in managing multiple projects simultaneously, troubleshooting, finding solutions to the most challenging technical problems and meeting the deadlines.
Lead and managed Oracle Database upgrade project from 10g to 11g for DB servers.
Responsible for 24x7 support of large 10g &11g databases for mission critical online applications.
Periodically check and purging Dump destinations.
Provided Oracle DBA support, backup and restore, performance monitoring and tuning; Experience of using Oracle Enterprise Manager (OEM), Grid Control, and Data Guard
• Installation and Configuration of Oracle on Linux and Windows platform
• Involved in installation and configuration of Oracle 10g Real Application Clusters.
• Converted single instance database to cluster database.
• Managing the oracle clusterware using: crsctl, crs_stat, ocrconfig, ocrdump utilities.
• Managing RAC instances using srvctl.
• Performing daily health checkups.
• Performed cloning of RAC and non RAC databases.
• Applied the interim and patchset patches for RAC and non RAC Databases.
• Implemented Oracle Dataguard (Physical) standby databases with Dataguard modes maximum (Protection, Availability and Performance). And make use of Standby Database for Reporting Purpose.
• Creation and maintenance of tablespaces.
• Creation and maintenance of control files, redo log files, Table-Spaces and data files.
• Creation and management of user, profiles, roles and privileges.
• Planning and performing ONLINE (HOT BACKUP) as well as OFFLINE (COLD BACKUP) backup.
• Installed Standby Database Server as precautionary for Implementing Disaster recovery strategies using Standby Database.
• Performing Backup and Recoveries using RMAN
• Analyzing the SQL Query using Explain plan
• Generating & interpreting Database statistics using AWR Report.
• Using Tkprof for Diagnosing SQL query performances
• Checking the Datafiles consistency using DBVerify Utility
• Maintenance and support of 10g RAC instances
• Configure ASM and Migrating non ASM database to ASM
• Migration and Patches Installation
• Managing DATAGUARD for Disaster Recovery familiar with failover and switchover scenarios for RAC Database
• Database Cloning using RMAN and User managed Backup.
• Installation of Oracle 9i &10g on Linux and Windows platform.
• Performing Backup and Recovery Using RMAN
• Administration in Real Application Cluster.
• Administration in Automatic Storage Management.
• Migration and Patches Installation.
• Creation and Maintenance of Data Guard.
• Checking the Datafiles consistency using DBVerify Utility.
• Schema Refresh using Export & Import.
• Maintaining all the objects of the database.
• Creation of oracle users, oracle roles, granting privileges and profiles etc.
• Checking alert log for errors and rectify them.
• Performing logical backups
• Importing data from old files using export/import utility
• Checking user’s tablespace growth.
• Creating User with Quota Maintenance.
• Proficiency with backup and recovery including Cold backup and Hot backup
• Frequent analysis of objects or schemas to improve the speed of the database
• Configured and performed RMAN backup.
• Checking the Data Files Consistency using DBVerify utility
• Monitoring CPU resource utilization and database growth.