Database and application support project
$15-25 USD / hour
• 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
Project ID: #5254583