Sybase DBA

RESUME

Name : Yasmin Gurumayum Valencia

Email : **********@*****.***

Mobile Number : +1-678-***-****

Skills : Sybase ASE, Sybase Replication, Sybase IQ, Golden Gate replication Experience Summary

My objective is to contribute to organization’s success through the use of my existing skill set. I am looking forward to acquire additional skills which will help in seeking a challenging position and will boost my career graph.

Extensive experience on Production, Development and supporting high availability databases configured in Sybase. These include very high Transactional (24X7) OLTP instances (10000+ users) and huge volume of data.

Experience in Sybase upgrade from 12.5 to 16.x

Experience in cross-platform database migration.

Experience in 2k to 8k page migration

Understanding of Sybase Replication (Table level) and Sybase IQ.

Migration from Golden gate replication to Sybase Replication. Technical Skills Summary:

Platforms : Unix Sun/AIX, Linux, Windows OS.

Databases Administration Skills : Sybase 12.5, 15.x, 16.x, Sybase Upgrade from 12.5 to 15.x and 16.x, Understanding of Sybase Replication and Sybase IQ.

Tools : Control-M (Job Scheduler)

Work Experience

Company Name:- HCL Technologies Limited, India Duration: March 2008 to November 2017 HCL Technologies is an Innovative Technology & Outsourcing Company that provides technical consulting, it solutions & software development to global firms.

Project 1: E Trade Financial Corporation (USA)

Responsibility:

Sybase ASE (12.x, 15.x, 16x)

Worked on Sybase ASE 16.x, 12.5 to 15.7 upgrade. Involved in Pre and Post upgrade plans and implementing the plans for each Production, UAT, and performance environment.

Worked on cross-platform (Solaris to Linux) server migration.

Worked on Sybmigrate to migrate data server from 2k to 8k page.

Applying ESD patch on Prduction, UAT and development environmnts.

Maintaining the integrity and consistency of databases using DBCC commands.

Running rebuild index and update statistics as weekend activity.

Dealing with the tempdb and user log issues.

Replication (15.0) (MSA Level)

Setting up warm standby replication (Heterogeneous and Homogeneous) using replication definitions and subscriptions.

Checking for latency of replicated tables.

Starting and shutting down the replication Server.

Monitoring the Replication server error log and trying to fix the issues.

Working on replication issues like thread down, disk space monitoring. Sybase IQ (15.0)

Creating logins.

Refreshing IQ DEV servers from PROD dumps.

Monitoring servers for versioning and dbspaces.

Project 2: JLT Financial Instituition (UK)

Responsibilities

Sybase ASE (12.x, 15.x)

Installation of Sybase ASE in linux, Solaris.

Apply ESD patch.

Configuring server parameter for performance.

Creating Devices and databases.

Taking regular database and transaction log backup.

Transferring the data using BCP.

Creating logins, adding users to respective database and managing the logins by granting and revoking permissions.

Maintaining the integrity and consistency of databases using DBCC commands.

Running rebuild index and update statistics as weekend activity.

Dealing with the tempdb and user log issues.

Refreshing databases in DEV server from PROD dumps. Educational Qualifications

Bachelor Degree :-Bachelor of Technology in Computer Science from Uttar Pradesh Technical University with 65% in 2006.

H.S.C from Manipur Board with 70.4% in 2002.

S.S.C from Manipur Board with 58.8% in 2000.

Trainings

HCL India internal training

o Sybase DBA training

o Sybase Replication training

o UNIX

Self Training

o Basic SYBASE IQ.

o Basic Shell Scripting

Personal Information

DOB : 21st December 1984

Present Address : 3010 Highland Pass Alpharetta GA- 30004 Marital status : Married

Contact this candidate