Database and application support project

• Maintenance of Production and Development Servers, ensure the availability of the production databases to end-users and development databases to developers. • Helped on migration of ASE servers from 12.5 to 15 in DEV/QA and Test Environment. • Establishing and maintaining sound backup and recovery policies and procedures. • Troubleshooting database related problems as and when required. And working closely with Dell Perot Team in Sev II/I call. • Evaluated 3rd party tools that could be used for database administration purpose like DBA Artesian, SQL Back Track, MKS integrity etc. • Installing, configuring, designing, creating, operating, maintaining and troubleshooting of Sybase and Replication Server and Ms SQL Server databases. • Backup using scripts and ftp, setup cronjobs. Worked, configure Vmware for virtual environment. Interact with customer in Level II and Level III support for problem resolution as and when required. • Monitoring replication queue and provide resolution based on KEDB. • Interfacing with multiple vendors to diagnose and resolve system, application and network issues. • Act as the last point escalation for different problems and resolve them within predefined SLA. • Configuring and Monitoring Database Backups with Maintenance plans. Restoring Databases in case of crash and emergencies. • Setting of the auditing. Monitoring the tempdb and database log full. • Users database creation/deletion/alter, setting up the database options, creation and dropping the dump devices. • Data backup and Restore management Monitoring various database load and dump jobs, copy db jobs, Control M jobs, db refresh jobs, DBCC jobs and trouble shoot. • Setting up the crontab for the daily backups, reindex,reorg, updatestats, database syncing etc. Managing Permissions and Access. Planning and implementation of Backup Schedule. • Database syncing from Production to Stage and Development servers. Creation of Logins/Users/Aliases. ASE Dataserver EBF upgrades. Migration of data between Servers using [login to view URL] up cronjobs at the operating system level for performing database consistency checks (DBCC). • Maintenance of Production and Development Servers, ensure the availability of the production databases to end-users and development databases to developers in a 24x7 environment. • Extensive Experience in Database Optimization and Performance Tuning • SQL, Database, Server tuning, Index Design, Restructuring, Optimization, Tempdb optimization, Cache partitioning. • Capacity planning, Handling large databases, Data cleansing. • Database Design / Modeling / Migration. • Extensively developed Stored Procedures and Triggers, data feeds to downstream systems. • Automated Backend process through Shell / Perl Scripting, extensively optimized Batch Processes. • System Analysis, Data Modeling and Volume test. • Establishing and maintaining sound backup and recovery policies and procedures. • Data backup and Restore management Monitoring various database load and dump jobs, copy db jobs, Control M jobs, db refresh jobs, DBCC jobs and trouble shoot. • Checking the consistency of databases and stored procedures. • Troubleshooting database related problems as and when required. • Evaluated 3rd party tools that could be used for database administration purpose like DBA