Dibatalkan

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 [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

Keahlian Administrasi Basis Data, SAP, SQL

Lihat lebih lanjut: working for dell, working at vmware, working at dell, virtual devices, virtual administration jobs, systems analysis and design, systems administration jobs, sybase dba jobs, sql server dba jobs, sound jobs, sound designing jobs, sound designing, shoot management, shell jobs, server monitoring jobs, scripting jobs, qa jobs, planning problem, party planning jobs, optimization jobs, ms project test, ms project server developers, ms project jobs, ms access jobs, ms access developers

Tentang Pemberi kerja:
( 0 ulasan ) Kolkata, United States

ID Proyek: #5254583