Database and application support project

Cancelled Posted Dec 23, 2013 Paid on delivery
Cancelled

• 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 [url removed, login to view] 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

Database Administration SAP SQL

Project ID: #5254583

About the project

Remote project Active Dec 23, 2013