ORACLE DBA SUPPORT

Wise Men provides administration, maintenance and support for the following:

Core Oracle DBA Services

Oracle Apps DBA Services

 

Monitoring and Support

  • 365x24x7 Support
  • Flexi-Support Models (8×5, 16×5, 24×5, 24×6, 24×7)
  • Daily database health checks
  • Monitoring Dashboard / Alerts
  • Regular Housekeeping activities
  • Coordinate with Oracle Support for Service Requests / Technical Assistance Requests
  • Monitoring database backups and archives logs
  • Provide Root Cause Analysis(RCA) and implement solutions to prevent further occurrences
  • WiseDesk support for service management
  • Project management activities (Project planning, Weekly / Daily meetings, Status reports)
  • Center of Excellence (Knowledge Management & Database)

 

Development Activities

  • Cloning of database from PROD to DEV / TEST / UAT
  • Periodic Service Updates (PSU) Patches
  • Shell/Perl scripts for database monitoring
  • Automation scripting for cloning and other activities
  • DB Installation & upgrades (10g to 11g, 11g to 12c, Non-RAC to RAC, Non-ASM to ASM)
  • DB Migrations (Windows to Unix / Linux, Unix to Linux, 32bit to 64bit)
  • Amalgamation of Databases
  • Homogeneous / Heterogeneous Databases Integration
  • Enabling NLS (National Language Support)

 

Database Installation and Deployment

  • Detailed planning, Activity break-down, scheduling
  • Capacity Planning-Storage, Processors, RAM, Swap
  • Backup & disaster recovery strategy-RMAN, Snapshot, Active-Standby Replication, manual (Hot & Cold)
  • Unix and Windows environment including virtual machines PR / SM (VMWare and lPAR)
  • Storage environments VERITAS, EMC and NetApp (ASM & Non-ASM)
  • Clustering-RAC, VERITAS Cluster Server, IBM HACMP
  • Scripting and script automation
  • Enterprise Manager Cloud Control-Installation, configuration
  • SOX compliance setups and periodic auditing reports generation
  • Performance Tuning-Gather Stats, Explain plan, SQL profiles, In-active sessions, DB Locks, AWR / ADDM reports

 

Database Upgrade and Platform

  • Upgrade strategy & Planning
  • Upgrade Oracle databases-10g-11g, 10g-12c, 11g-12c
  • Move Oracle Databases from Windows-Unix, Unix-Linux
  • Storage migration from non-ASM to ASM
  • Consolidation of Schemas / Database(s)
  • Clustering-RAC and non-RAC
  • Synchronizing user accounts, grants and security
  • Test Plan-To ensure and validate seamless upgrade / migration
  • Re-Install / Re-Configure OEM Agents
  • Enable new version features to reap the benefits of the upgrade

 

Performance Management & Monitoring

  • SQL query analyzer
  • Data file(s) Defragmentation
  • Automatic Workload Repository(AWR) reports and analysis
  • Automatic Database Diagnostic Monitor(ADDM) reports and analyses
  • Periodic execution of Gather Stats
  • Rebuild indexes
  • DB Performance improvement parameters tuning
  • Monitoring Locks
  • Monitoring Wait Events and long running sessions
  • Analyzing Diagnostic Data

 

High Availability Solutions:

Oracle Solutions

  • Real Application Cluster
  • Oracle Clustering
  • Data Guard
  • Grid control
  • Oracle Flashback Technology
  • RMAN Backup & Recovery

 

Other Solutions

  • VERITAS Clustering
  • NETAPP Snap Manager

 

Sizing and Capacity Planning

  • Concurrent Users
  • Application Data
  • Number of Schemas
  • Response time requirement
  • SGA sizing calculations
  • Rollback segments
  • Reporting requirements
  • Backup Strategy & Methodology
  • Resource usage and trend analysis

 

Security

  • SOX compliances
  • Auditing setup
  • Transparent Data Encryption
  • Oracle Data Redaction
  • Secure Socket Layer Certificates filtering
  • Encryption Algorithms (3DES, AES)
  • Database Vault Setup & Configuration
  • Oracle Advanced Security Architecture (Encryption, Authentication, Data Integrity)
  • Controlling and monitoring user access to the database
  • Enrolling users and maintaining system security

center-ride