Database : Oracle 9i/8i/7.X, MS SQL Server and MSAccess, Sybase, DB2
Database Tools : OEM, BMC Patrol, RMAN, SQL Backtrack,DBARTISAN Smart DB, Space Manager,
Shareplex, Discoverer |
*Installation, Upgrade, patching and managing Oracle
Applications 10.7NC & Smart client and 11.0.3
*Tuning Concurrent Managers, Defining Work Shifts, etc.
*Installation, Upgrade and Configuration of Oracle
(7.1.6, 7.3.4, 8.0.5, 8i).
*Extensive Performance Tuning, Memory (SGA) Tuning,
Tuning Concurrent Managers, etc
*Applying Patches both Server side and Client side.
*Used Designer 2000 for database design
*Cloning databases.
*Setting up new environments (Development, Testing,
Conference Room Pilot, Production etc)
*Upgrading to Oracle Server 7.3.4 and then to 8i.
*Setting up advanced replication.
*Setting up Oracle Parallel server.
*Installed and configured Oracle Web Server 3.0
*Taking Hot and Cold Backups, Exports etc.
*Setting up and Installing Oracle Web Application Server
*Setting and Installing Oracle Enterprise Manager and
Enterprise Backup Utility.
*Creating the database, tables, tablespaces, data
objects, setting privileges, indexes, user logins,
passwords (security).
*Data Warehousing
*Database Sizing, Tablespace Management and Rollback
Tablespace Management, Transaction Management, Security
Administration.
*Setting up Citrix 1.7
*Defragmentation of database using export import.
*Removing row chaining fot better performance.
*Data Modelling, Database Design and Creation
*Deciding the naming conventions of datafile, redo log
files, tablespaces, segments.
*Writing scripts for backup and recovery, Import and
export procedure.
*Unix Shell scripting in csh, ksh for automating
startup/shutdown of databases.
|