Administration SalesLogix CRM by performing system-level tasks including security access rights, set up and maintain LAN and Remote communication for Synchronisation of updates in database and managing teams.
Modify and customise the modules according to user needs.
Implementations support and maintain the file sizes and locations to use the disk space for ERP manufacturing software.
Worked on the installation of oracle and creation of Database.
Automated the export of full database.
Developed performance monitoring scripts using dynamic performance tables.
Changed file sizes and locations to use the disk space efficiently.
Rebuild indexes for better performance.
Recreated several tables with different storage parameters according to the growth rate.
Used Import, Export and SQL*Loader utilities for transferring data.
Use PL/SQL for writing triggers, procedures, packages and functions for performing different kinds of functions.
Responsible to create the SQL scripts to generate the DDL required for the application including objects such as, tables, indexes, constraints, grants, synonyms, stored code.
Responsible for the security implementation using Database roles and menu features.
Involve in the documentation of the system.
Scheduling the Backup of SQL Server Database.
Using the Performance Monitor to view the behaviour of objects, such as processors, memory, cache threads, and processes.
Creating the Scheduled Jobs and Alerts.
Also basic administration on Windows NT 4.0 and Unix AIX Server.
Responsible for the security implementation on NT server and AIX server. And tape backups and restore.
Provides Support to users.
Using Crystal Reports and Info Segate to Designing the Sales, Projection and Telemarketing reports for Remote and LAN users. Scheduled these reports to deliver by using Seagate scheduler and Esender.
Design Reports and developed delivers system for PDA (Personal Digital Assistant) formatted CRM reports.