Monitor database with exa data machinePerformance monitoring & Query tuning

Performance monitoring Oracle Cloud em 13c,Awrreport,Assh,Addm
DB Security :
Oracle Database Audit Vault & Database FirwallMonitor database with exa data machine Performance monitoring & Query tuning Performance monitoring Oracle Cloud em 13c,Awrreport,Assh,Addm DB Security : Oracle Database Audit Vault & Database Firwall
Skills: RMAN · Oracle Database

Managing SQL server Database Administrator & Oracle Database Administrator, replication,merge replication snapshot and performance tuning, backups provide privileges server level and user levelInvolved month end & transition activity

Responsible to improve the performance by using the Hints, Index, Explain Plan
Performance tuning of SQL statements using STATSPACK, TKPROF, Explain Plan and SQL Trace
Table space management including, adding/resize data files, allocated quotas to user and managed disk space
Export and Import of User, Tables and Database using exp/imp and Data Pump
Used exp/imp, data pump and dblinks to move the data
Worked on standard and enterprise edition of the Oracle RDBMS.
Worked on database backup using RMAN for HOT backup and scripts written for COLD backup.
Performed Database Refreshes and Database Copies for Development, Test and Production databases
Installed, Migrated, configured and tested Oracle 9i databases in various environments
Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.
Applications on varied platforms like Solaris, Windows and Linux Servers

Implemented procedures and practices regarding database design, development, monitoring, access, and upkeep.
Developed and implemented backup and recovery strategies.
Developed policies and procedures for system operations to better serve clients.
Worked on SQL Server 2005 and 2008 instances.
Schedule daily and weekly maintenance jobs in SQL server
Setup the log shipping to create standby database in DR data center.Powered by
Database Backup, Database Restore and Database Recovery using various tools.
Database Reorganizations for better space management.
Performed Database Refreshes and Database Copies for Development, Test and Production
Extensively used data moving utilities like export/import, Data pump, Migrated flat files from different sources into Oracle
Database using SQL*Loader and Performed DB cloning.
Performed Online/Offline database backups.
Built and configured RMAN Recovery Catalog for Backup and Recovery strategy

Installs, configures and maintains database instances, create various database objects, create user with appropriate roles and level of security.
Daily monitoring and analysis of systems to ensure 24/7 stable operations
Troubleshoot day-to-day database issues system stability and through put
Responsible for Oracle logical and physical database design, implementation and maintenance on Aix, linux , solaris
Installed upgraded and patched Oracle software, set up brand new machine including oracle software installation, oracle side configuration, troubleshooting and backup testing
Moved database schema changes to stage or production
Migrated and upgraded databases from version from version 9i, 10g to 11g
Performs Oracle database performance analysis, capacity planning, system sizing and ongoing maintenance/tuning to ensure maximum performance
Moved database Schema change to stage or production
Created materialized views
Developed some Unix Shell scripts to automate database operation and database monitoring.
Implemented database refresh with the hot backup using Duplicate or full export Used EXPORT/IMPORT to do table level and full database fragmentation.
Performed database tuning using sql developer Toad, client tools, and Enterprise Manager
Tested and documented some Oracle11g new features, such as duplicate database using RMAN from both disk and tape
Backing up and restoring databases, maintaining archived data

  Perform database re-organizations as required to assist performance and ensure maximum uptime of the databases
  Puts standards in place to ensure that all application design and code is produced with proper integrity, security and performance
   Enforces and maintains database constraints to ensure integrity of the databases
 Administers all database objects, including tables,  indexes, views, sequences, packages and procedures
  Troubleshoots with problems regarding the databases, applications and development tools
 Create new database users, assigns privileges as required
 Maintenance of online rental application developed in asp.net running at different locations.
   Troubleshoot day-to-day database issues system stability and throughput
    Plans and implements backup and recovery of the Oracle databases