Mahesh Kumar Sahu

Flat#202 Sai Srinivasa Shine

9th cross Ananta Nagar phase II

Electronic city Bangalore

Email:

Phone: 9620726302

Experience Summary

I have total 12 years of experience asSybase DBA on Sybase ASE, Sybase Replication Server DBA in financial domain to support trading as database developer in investment banking background supporting very critical servers.

Working with a leading Investment Bank on application Sybase DBA and has around 1+ years of experience on Trading application (Murex). I have also gained significant functional knowledge during the course of his experience.

Career Profile

Dates / Organization / Designation
Sept 2011 to Current / ANZ operationtechnologies / Sr. System Analyst
March 2010 to Aug 2011 / Wipro technologies / Consultant
Set 2009 to March 2010 / Bank of America / Analyst
July 2006 to Aug 2009 / HCL Technologies / Lead Engineer
June 2005 to June 2006 / CRIS Mumbai / Asst. Software Engineer

Technology: Below is a list of important software products, tools and methods that I have worked with.

Technologies
SYBASE ASE 12.X, 15.X
Sybase Replication, Sybase development, TSQL
UNIX ,Window XP
Shell Scripting , Control-M

Certificate:

  1. SYBASE ASE 12.5 DBA Professional
  2. SYBASE ASE 12.5 DBA Associate
  3. SYBASE ASE 12.5 Developer Professional
  4. SYBASE ASE 12.5 Developer Associate
  5. ITIL Foundation

Projects: The details of the various assignments that I have handled are listed here, in chronological order.

Achievements:

Re-design purging solution of Control – SA: Optimize and re-design purging solution which was taking around 13 hours and purging data on the date basis and application team was facing multiple issues during execution.

Outcome: Job was taking only 3 hours to purge 1 week data from database. Design has changed to purge data on the day/week/years basis.

Pro-active monitoring: Implement proactive monitoring in MUREX application to take snapshot of the sybase server in respect of load and process. It is also collect statistics of server performance which help DBA and application to troubleshooting of issue.

Data migration: Successful data migration from SQL server to sybase for client Pearson publication.

Sybase ASE:-

•Installation of Sybase ASE on AIX, Sun Solaris.

•Experience on ASE 12.X or ASE 15.X Architecture. ASE server building.

•Handling activities like Disk initialization, disk mirroring, device creation / drop.

•Data migration using BCP utility.

•Configured the DBCC database and set up to run DBCC checkstorage.

•Database maintenance activities - DBCC, Reorg & Update Statistics.

•Working on production issues like tempdb full, logsegment full, server slowness/blocking.

•Backup and Restore for Sybase ASE Databases.

•Troubleshooting ASE and Backup server error logs.

•Creates/Modifies Interfaces file.

•Creating /dropping logins, locking /unlocking logins, adding / dropping users in database.

•Granting Roles and Permissions to users.

•Executing DDL, DML on UAT / PROD dataservers for SYBASE.

•Monitoring & acting on the alerts generated by Tivoli/webgui.

•Writing shell scripts and setting the cronjobs for daily activities.

•Experience in log ticketing tools like Virtual Change, Virtual Ticket and Service Now.

•Joining MIH during major production issues.

•Documenting the process, known errors, resolving techniques.

•Managing High availability environment using VCS.

•Buildup ANZ standards of new Sybase servers as per ANZ standards.

•Build capability of disaster recovery.

•Backup and Create Backup Polices.

Sybase Replication:-

•Installing replication server and setting up Sybase to Sybase replication.

•Replication server installation on UNIX.

•Support Warm standbyMSA Replication server.

•Monitoring and maintenance of Replication Servers.

•Creation and alteration of routes, definitions, publications, subscriptions

•Adding databases to the replication environment using the rs_init utility.

•Maintaining the RSSD database.

•Recovering from stopped replication, primary database and the RSSD database.

•Troubleshooting connection errors.

•Re-sync replication database from primary.

Sybase ASE Development:-

•Work as database developer to create database objects as per application requirement.

•Database query procedure performance issue on application or job/batch.

•Index creation, maintenance and fine-tuning of indexes, updating of statistics..

•Worked on shell scripting to create new job as per requirement.

Murex application Support:

  • Hands on experience on both MX2.11 and MX 3.1 versions of Murex
  • Exposure to MxML Exchange, Datamart Reporting, Datamart extractions
  • Experience with Daily Murex EOD Batch, DAPs
  • OSP and STP

Qualifications

Degree and Date / University / Major and Specialization
  • MCA
/ RGPV Bhopal M.P. / 2004
  • B.Sc.
/ Dr.HSGU Sagar M.P. / 2000
  • 12th
/ M.P. Board / 1997
  • 10th
/ M.P. Board / 1995

Personal Details

Date of Birth / 28-July-1979
Nationality / Indian

Page 1 of 3