Consulting Services

Database consulting

DBCON offers unmatched consulting services in different Oracle® technologies. Our people are certified professionals with highest level of certifications having exhaustive real time industry experience. Rather than focusing on many different areas, we have selected a few technologies to focus on and provide the best services in those technologies. We love what we do and are passionate about it. We currently offer consulting services in the following technologies.

  1. Oracle Database
  2. Oracle eBusiness Suite
  3. Oracle Grid Control
  4. Oracle Internet Directory
  5. Oracle Application Express

We drive ourselves hard to create real value for you and exceed your expectations.

Services Offered

Oracle Database  


  • Planning for Oracle database installation which includes :-
    • Suggest right architecture based on the requirement.
    • Suggest on hardware.
    • Do capacity planning.
    • Come up with naming convention standards, document templates, periodic report templates.
    • Consider Oracle's OFA (Optimal Flexible Architecture) recommendations for file system layout for software & database
    • Prepare disaster recovery plan.
  • Setup prototype as proof-of-concept to implement any new product, technology or feature.
  • Installation & Configuration of Oracle Software & Database including features like Real Application Cluster, Data Guard, Data Vault, Audit Vault, Recover Manager (RMAN), Partitioning, Label Security, Automatic Storage Management (ASM) etc.
  • Cloning & refresh of database (full or partial).
  • Automation of routine DBA tasks.
  • Setup automated monitoring of databases & integrate with e-mail & SMS notifications depending on the alert level.
  • Review of existing Oracle Infrastructure to suggest on up gradation to newer versions, consolidation (of databases & servers) & standardization.
  • Review and suggest latest patches including Critical Patch Updates (CPUs) periodically released by Oracle.
  • Database audit, health check & review. Coming up with routine database maintenance activity list and checklist to keep the database in a healthy state and identify the symptoms of potential issues at an early stage.
  • Identifying performance bottleneck areas & tuning those areas.
  • Moving database across the platforms.
  • Moving from non-Oracle databases to Oracle.
  • Evaluating disaster recovery strategy & periodic testing of these strategies.
  • Troubleshooting & coordinating with Oracle support for bugs and unresolved issues.
  • Provide on-the-job training on Oracle Database.
  • Documentation of the infrastructure.
  • Analyze usage/growth of database and provide capacity planning report.
  • Evaluate the features of the product and train development team to use those features.
  • Coming up with step-by-step instructions for periodic regular work like cloning/refreshing.

Oracle eBusiness Suite


  • Upgradation from Oracle Applications 11i to R12.
  • Planning for Oracle Application installation which includes :-
    • Suggest the right architecture (Single-node, multi-node, shared technology stack , appl_top etc. ) depending on the requirement.
    • Suggest on hardware.
    • Do capacity Planning.
    • Come up with naming convention standards, document templates, periodic report templates.
    • Define guidelines for customization in Oracle Applications to ensure standardization, flexibility & strict control.
    • Consider Oracle's OFA (Optimal Flexible Architecture) recommendations.
    • Prepare disaster recovery plan.
  • Installation, configuration, patching, cloning & up gradation of Oracle Applications.
  • Troubleshooting & stabilizing Oracle Applications by simulating and resolving functional & technical issues. Coordinating with Oracle support where ever required.
  • Securing Oracle Applications to protect the sensitive data from unauthorized access which includes securing APPS Password, changing password frequently, setting up auditing to provide report on unauthorized access of database and the sensitive information.
  • Use tools & utilities like DATALOAD & FNDLOAD to transfer Oracle Applications 11i Setups (Users, Responsibilities, Menus, Customizations, Values Sets etc.) across the instances during implementation phase; thereby considerably reducing manual effort & time.
  • System   Administration tasks in Oracle Applications 11i including   but   not   limited   to   maintenance of Users, Responsibilities, Menus, Customizations, Printers and Concurrent Managers & Requests etc.
  • Automation of routine DBA tasks (e.g. move customizations across the environments).
  • Review and suggest latest database & application patches including Critical Patch Updates (CPUs) periodically released by Oracle.
  • Database audit, health check, review. Coming up with routine database maintenance activity list and checklist to keep the database & applications in a healthy state and identify the symptoms of potential issues at an early stage.
  • Identifying the areas responsible for performance bottleneck & tuning those areas.
  • Evaluating disaster recovery strategy & periodic testing of these strategies
  • Setup automated monitoring of databases and applications & integrate with e-mail & SMS notifications.
  • Provide on-the-job training to Oracle Apps DBA.
  • Documentation of the infrastructure.
  • Analyze usage/growth of database and provide capacity planning report.
  • Evaluate new features of the product and train development team to use those features.
  • Coming up with step-by-step instructions for periodic regular work like cloning/refreshing, patching etc.

Oracle Enterprise Manager Grid Control


OEM Grid control is a power tool and a great choice to monitor the Oracle infrastructure 24x7. Our services in this technology include :-

  • Setup prototype as proof-of-concept for OEM Grid control.
  • Installation & Configuration of Oracle Grid control to monitor Oracle infrastructure like Oracle databases, applications, middle tier and other products.
  • Install OEM Agent (Enterprise Management Agent) on targets and configure with OEM Grid Control.
  • Define the monitoring rules & policies and setup e-mail & SMS notifications depending on the alert level.
  • Automate the running of ad hoc or periodic tasks against individual systems or groups of systems, which includes use any of the predefined database job tasks (e.g. backup, export, import) or custom scripts.

Oracle Internet Directory


For Organizations having many Oracle databases, DBAs, developers & users maintaining tnsnames.ora on each client and propagating changes when the connection string changes is a challenging & daunting task. Oracle Internet Directory (OID) is the product from Oracle's stable which resolves a database service name, net service name, or net service alias stored in a centralized LDAP-compliant directory server. Our services in OID includes  

  • Installation & configuration of Oracle Internet Directory as Directory Naming Services for centralized storage management and administration of database connect identifiers
  • Configure clients to use Directory Naming Services instead of tnsnames.ora