Over the past 20 years we have versatile experience on multiple databases in the area of administration, designing of new application and development. We did design commercial application for textiles, solvent, auto, commodity exchange and pulp industries.
Database administration and development on SQL/PLSQL
1. Database Installation, Configuration, Tuning, Backup & Recovery
2. Monitoring the locks, the processes running on to the server, Data transfer
3. Creation of users, Tablespaces, Additional data file creation and maintenance
4. Define the user roles & Snapshot creation and management according to security need
5. Designing schema, indexes and objects, tuning of database objects
6. Creation of procedure, triggers, functions and packages.
7. Physical Database Designing, creation of Database, creation of Redo Logs, creation of Procedure, creation of Cursors, creation of Schema and management.
8. Defining Constraints, Views, Stored Procedure Optimization, Analyzing Query Plans.
9. Migrating database from Sybase SQL Anywhere to Oracle and vice versa.
10. Security and User Administration, Normalization, De-normalizing, Database Objects Placement.