Ramesh Mogadala

Database Administrator (Sybase / SQL Server)

Summary:

. Sybase DBA with about 8 years of experience with Sybase Adaptive

Server Enterprise 12.5x to Sybase Adaptive Server Enterprises 15.0.3

on UNIX and Windows NT platforms. Having 3 years of experience as a

SQL Server DBA, having working knowledge on SQL Server 2000 and SQL

Server 2005 as my secondary skills. Working on Oracle Databases now as

an Application DBA.

. Experience with Sybase Replication Technologies (Sybase Replication

Server 12.6).

. Experience includes Administration activities such as Production

Support, Installation, Configuration, Database Creation, Performance

Tuning, and Unix Shell Scripting for Automation.

. Very capable in database recovery techniques and implementation of

those recovery techniques to ensure business continuity.

. Knowledge of Sun UNIX/Solaris platforms and Windows platforms.

. Ability to work effectively in a team environment and collaborate with

others focused on business priorities.

. Successful track record as a Sybase DBA at financial services and

insurance institutions including Merrill Lynch, ING North America

Insurance and First Data Corp.

Sybase Adaptive Server Enterprise capabilities (up to version 15):

Installation, configuration, setup on Sun Solaris platform. Support and

maintenance. Backup and recovery. Failover strategy & disaster planning.

Security and permissions. Performance tuning. Utilized bulk copy utility.

Sybase Replication Server capabilities (up to version 12.6):

Installation (on Sun Solaris).

Configuration including changes to default parameter settings.

Warm Standby setup.

Creating subscriptions and publications.

SQL Server capabilities (SQL Server 2005 and SQL Server 2008):

Installation, configuration, setup on Windows 2003 Server. Support and

maintenance. Backup and recovery. HA / DR planning. Knowledge on Database

Mirror, Replication Setup. Security and permissions.

Performance Tuning:

Analyzed query plans including cache strategy. Utilized showplan,

forceplan, statistics io, and statistics time to optimize code. Decided

which tables/indexes of a database to place in memory based on usage.

Experience:

Name of the Company : First Data Corp.

Location : Wilmington, DE

Designation : Senior Database Administrator

Role : Sybase and SQL Server DBA

Period : 09/2014 to Till Date

Design, install, maintain and upgrade Sybase Adaptive Server Enterprise and

SQL Server production databases. Automate database maintenance using T-SQL

and Unix Shell Scripting. Setup high availability using Replication,

mirroring and clustering configurations. Working closely with clients,

business analyst and application developers to define, debug, resolve and

implement application code. Monitor and analyze performance metrics using

MDA Tables, Performance monitor. Allocate database resources to achieve

optimum database performance. Support multiple servers and multiple

databases of real time production environment with multiple concurrent

users. Taking up migration projects from Sybase Adaptive Server Enterprise

to SQL Server.

Checking Error log and monitoring Issues. Creating Logins, Users and

Monitoring Roles. Taking Database backups and load as per the user's

requirement. Performance tuning using sp_configure, table partition and

indexes creation. Setting Database options using sp_dboption. Creating i.e.

initializing required resources like Disks, Segments etc. Backups

scheduling. Trouble shooting the daily development/ production problems.

Maintenance of development/ production Databases. Running DBCC to check the

Database consistency. Utilities like BCP, defncopy, ddlgen etc. Working

production releases. Documenting critical issues and communicating with

Technical Support Team. Raise a Technical case with Sybase Technical

Support Team. Using MON Tables. Having knowledge of Replication server.

Setting up WARM STANDBY replication. Installation ASE 12.5.x. and ASE 15.x.

Migration from ASE 12.5.x to ASE 15.x (cross platform). Trouble shooting

ASE and Replication server. Provide training across team. Taking training

for SQL Server 2012 from Database Training Academy. Handling incident

ticket, change record and problem management ticket as per ITIL procedures.

Name of the Company : Tech Mahindra Limited

Name of the Client : AT&T Services

Location : Middletown, NJ

Designation : Lead DBA

Role : Sybase and Oracle Application DBA

Period : 04/2014 to 09/2014

Working Export / imports of schemas, granting access to application users,

participating in Deployment review meetings and Executing Deployments,

trouble shooing Golden Gate issues. Working on various versions of Oracle

9i, 10g and 11g. Using tools like SQLPLUS and TOAD for executing various

SQLs.

Also working on Sybase ASE databases which are using with GCP (Global

Computing Process) applications.

Name of the Company : Cognizant Technology Solutions

Name of the Client : First Data Corp.

Location : Omaha, NE

Designation : Manager - Operations

Role : Sybase DBA

Period : 09/2011 to 04/2014

Checking Error log and monitoring Issues. Creating Logins, Users and

Monitoring Roles. Taking Database backups and load as per the user's

requirement. Performance tuning using sp_configure, table partition and

indexes creation. Setting Database options using sp_dboption. Creating i.e.

initializing required resources like Disks, Segments etc. Backups

scheduling. Trouble shooting the daily development/ production problems.

Maintenance of development/ production Databases. Running DBCC to check the

Database consistency. Utilities like BCP, defncopy, ddlgen etc. Working

production releases. Documenting critical issues and communicating with

Technical Support Team. Raise a Technical case with Sybase Technical

Support Team. Using MON Tables. Having knowledge of Replication server.

Setting up WARM STANDBY replication. Installation ASE 12.5.x. and ASE 15.x.

Migration from ASE 12.5.x to ASE 15.x (cross platform). Trouble shooting

ASE and Replication server. Provide training across team. Taking training

for SQL Server 2012 from Database Training Academy. Handling incident

ticket, change record and problem management ticket as per ITIL procedures.

Creating Shift Schedules for the Team. Participating in Weekly meetings

with Client. Conducting Weekly meetings with Team. Preparing Work load

analysis. Attending operation Maturity (OM) auditing and clearing NC (non-

compliances) if any. Preparing Metrics, daily dash boards, met book

Preparing KEDB (Known error database) for future reference in the team.

Preparing and implement SIP (Service improvement plans). Preparing MoM

(weekly minutes of meeting)

Name of the Company : Cognizant Technology Solutions

Name of the Client : Zenith Media

Location : Hyderabad, India

Designation : Associate Operations Manager

Role : Sybase DBA

Period : 05/2011 to 08/2011

Migration from ASE 12.5.x to ASE 15.x (cross platform) Sun Solaris to

Linux. Installation ASE 15.5. Create table partitions. Install Replication

15.0 and Warm Standby replication setup. Setup maintenance jobs like

backups, update stats, DBCC Checks, Reorg Rebuild.

Name of the Company : Cognizant Technology Solutions

Name of the Client : ING North America Insurance

Location : Chennai, India

Designation : Associate Operations Manager

Role : Sybase DBA

Period : 03/2009 to 04/2011

Production Support DBA (24/7) to enable the smooth operation of the day-to-

day activities. Checking Error log and monitoring Issues. Creating Logins,

Users and Monitoring Roles. Taking Database backups and load as per the

user's requirement. Performance tuning using sp_configure, table partition

and indexes creation. Setting Database options using sp_dboption. Creating

i.e. initializing required resources like Disks, Segments etc. Backups

scheduling. Trouble shooting the daily development/ production problems.

Maintenance of development/ production Databases. Running DBCC to check the

Database consistency. Utilities like BCP, defncopy, ddlgen etc. Working

production releases. Documenting critical issues and communicating with

Technical Support Team. Raise a Technical case with Sybase Technical

Support Team. Having knowledge of Replication server. Installation ASE

12.5.x. and ASE 15.x. Migration from ASE 12.5.x to ASE 15.x (cross

platform). SQL Server 2005 is a secondary skill for me with ING.

Name of the Company : Satyam Computers Limited

Name of the Client : Merrill Lynch

Location : Hyderabad, India

Designation : Project Lead

Role : Sybase DBA

Period : 01/2008 to 02/2009

Production Support DBA (24/7) to enable the smooth operation of the day-to-

day activities. Checking Error log and monitoring Issues. Creating Logins,

Users and Monitoring Roles. Taking Database backups and load as per the

user's requirement. Performance tuning using sp_configure, table partition

and indexes creation. Setting Database options using sp_dboption. Creating

i.e. initializing required resources like Disks, Segments etc. Backups

scheduling. Trouble shooting the daily development/ production problems.

Maintenance of development/ production Databases. Running DBCC to check the

Database consistency. Utilities like BCP, defncopy, ddlgen etc. Working

production releases. Documenting critical issues and communicating with

Technical Support Team. Raise a Technical case with Sybase Technical

Support Team. Having knowledge of Replication server. Installation ASE

12.5.x. and ASE 15.x. Migration from ASE 12.5.x to ASE 15.x (cross

platform). Working on SQL Server 2000 and SQL Server 2005 databases as

secondary skills.

Name of the Company : Syntel Limited

Name of the Client : Trizetto Health Care

Location : Pune, India

Designation : Project Lead

Role : Sybase DBA

Period : 08/2007 to 12/2007

Production Support DBA (24/7) to enable the smooth operation of the day-to-

day activities. Checking Error log and monitoring Issues. Creating Logins,

Users and Monitoring Roles. Taking Database backups and load as per the

user's requirement. Performance tuning using sp_configure, table partition

and indexes creation. Setting Database options using sp_dboption. Creating

i.e. initializing required resources like Disks, Segments etc. Backups

scheduling. Trouble shooting the daily development/ production problems.

Maintenance of development/ production Databases. Running DBCC to check the

Database consistency. Utilities like BCP, defncopy, ddlgen etc. Working

production releases. Documenting critical issues and communicating with

Technical Support Team. Raise a Technical case with Sybase Technical

Support Team. Having basic knowledge of Replication server. Installation

ASE 12.5.x. and ASE 15.x.

Name of the Company : iGate Global Solutions Limited

Name of the Client : Mellon Capital Management / Bank of New

York

Location : Bangalore, India

Designation : Senior Software Engineer

Role : Sybase DBA / SQL Server DBA

Period : 10/2006 to 08/2007

Checking Error log and monitoring Issues. Creating Logins, Users and

Monitoring Roles. Taking Database backups and load as per the user's

requirement. Performance tuning using sp_configure, table partition and

indexes creation. Setting Database options using sp_dboption. Creating i.e.

initializing required resources like Disks, Segments etc. Backups

scheduling. Trouble shooting the daily development/ production problems.

Maintenance of development/ production Databases. Running DBCC to check the

Database consistency. Utilities like BCP, defncopy, ddlgen etc. Working

production releases. Documenting critical issues. Installation ASE 12.5.x.

Working on SQL Server 2000 databases.

Name of the Company : Sigachi Industries Private Limited

Location : Hyderabad, India

Designation : Database Administrator

Period : 09/2003 to 10/2006

Checking Error log and monitoring Issues. Creating Logins, Users and

Monitoring Roles. Taking Database backups and load as per the user's

requirement. Performance tuning using sp_configure, table partition and

indexes creation. Setting Database options using sp_dboption. Creating i.e.

initializing required resources like Disks, Segments etc. Backups

scheduling. Trouble shooting the daily development/ production problems.

Maintenance of development/ production Databases. Running DBCC to check the

Database consistency. Utilities like BCP, defncopy, ddlgen etc.

Installation ASE 12.5.x. Working on SQL Server 2000 databases.

Name of the Company : Sigachi Industries Private Limited

Location : Hyderabad, India

Designation : Computer Operator

Period : 08/1996 to 08/2003

Operating accounting packages like Tally, Focus to record all sales,

purchases, expenses. Preparing Trail Balance, Profit & Loss Account on

monthly basis, preparing Accounts receivable and Account payable on monthly

basis, preparing MIS reports to submit to Financial institutions, preparing

Balance sheet and preparing Income tax returns for Company and Individuals.

Summary of activities:

Database administration, error processing and trouble shooting,

installation support for production system, post-installation modifications

for production system.

Replication:

Assisted with work associated with creation of replication definitions and

subscriptions, re-started data queues on Replication Server which had

stopped due to errors. Monitored Replication Server.

Database Administration:

Used the bulk copy utility (bcp) to load the database with large amounts of

data. Set permissions for accessing data. Utilized showplan, forceplan,

statistics io, and statistics time to optimize code. Table partitioning,

cache configurations, fix DBCC errors etc. Participate in DR testing.

UNIX Shell Scripting:

Korn, Bourne and C shells used to create different scripts to automate

database administrator's maintenance tasks like backups, restores, update

stats, DBCC checks etc. Using editor VI, utilities like sed, awk, find etc.

Contact this candidate