Prashant Mehra Email & Phone Number

Abu Dhabi, United Arab Emirates

Qatar

United Arab Emirates

Singapore

Responsible for database administration/maintenance including database servers installation, logical/physical data modeling, Granting roles and permissions to Adaptive Server users, Managing and monitoring the use of disk space, memory and connections, Backing up and restoring databases, Diagnosing system problems, Configuring Adaptive Server to achieve the best performance ,tuning, monitoring the server activity, Replication & scheduling activities and all other database activities.

Mumbai Area, India

Responsible for administering the database maintenance including Sybase SQL server and backup server installation, logical/physical data modeling, Creating and managing Adaptive Server login accounts, Granting roles and permissions to Adaptive Server users, Managing and monitoring the use of disk space, memory and connections, Backing up and restoring databases, Diagnosing system problems, Configuring Adaptive Server to achieve the best performance ,tuning, monitoring the server activity, Replication & scheduling activities and all other database activities.Writing CRON job scripts for data loading, migration, processing etc., by using shell script

Mumbai Area, India

Team Size : 2OS : AIX 5.3, RHEL 5.3.Software : Sybase ASE 12.0 upto 15.7 Sybase Replication 12.0 & 15 Relational database : T-SQLEnvironments : Production, Test, DevelopmentTools : Sybase central, DBArtisan.Other Utilities : Autosys – Automated Job SchedulerService Now– Incident, Request & Change Management tool; Provided 8X5 administration support & Priority 1 On-Call Support for Sybase ASE applications and attended Hotline calls from the users, related to Performance issues. Handled approximately 13 Production,6 Test and 4 Development servers.Performing Sybase ASE Cross Platform Migration from ASE 12.0 to ASE 15.7.Responsibilities:Performed Sybase Cross Platform Upgrade/Migration from ASE 12.0.X to ASE 15.7.Performed successful Recovery of Master Database.Migrating existing Scripts from AIX to Linux environment.Address day-to-day Data server and Database issues in a production environment which includes log segment getting filled up, Tempdb log segment filled up, Blocking of processes, Deadlock.Attend Database issues related calls.Help Setting up the jobs (Using Autosys) for the daily backups, reindex, reorg, updatestats etc.Handling user requests through Service Now and maintaining it.Resolve database outage/performance issues & ensure communication of the same to affected users on time. Participate in the areas of server builds, database design, performance and management, User creation, syncing etc.Participate on scheduled Maintenance activities over the weekends like Reorg/reindex, update stats, DBCC checks.Achievements:Achieved Capgemini – Project Star Award in July’2011.

Mumbai Area, India

Team Size : 3OS : AIX 5.3Software : Sybase ASE 12.0 and above, Environments : Production, development, backup.Tools : Sybase central, DBArtisan.Other Utilities : Remedy – Incident, Request & Change Management Tool; Address day-to-day Data server and Database issues in a production environment which includes log segment getting filled up, Tempdb log segment filled up, Blocking of processes, Deadlock.Attend Database issues related calls.Help Setting up the jobs for the daily backups, reindex, reorg, updatestats etc.Handling user requests through Remedy and maintaining it.Resolve database outage/performance issues & ensure communication of the same to affected users on time. Participate in the areas of server builds, database design, performance and management, User creation, syncing etc.Participate on scheduled Maintenance activities over the weekends like Reorg/reindex, update stats, DBCC checks.

Bachelor Of Science, Information Technology

Activities and Societies: Voluntered in Cultural Activities

Ssc, First Calss