Arun Kumar Jagarapu

+**-********

acqw59@r.postjobfree.com

Objective

Seeking a challenging position as Sybase and MSSQL Database Administrator

Having rich experience and expertise on complete production database support, which includes Database Administration by handling the tickets, monitoring the scheduled jobs through crontab and giving production support (24x7) with onsite/offshore model for Sybase ASE, RepServer and MS SQL Server databases including HA features.Have been working with Sybase 12.5, 15.0.3, 15.5 and 15.7 versions of Sybase on various OS flavours including Sun Solaris, HP Unix and Linux. Managing deployment, server upgrades, ESD patching, Cross platform dumploads, user management, Migration, Production alerts, Replication setup, Replication alerts and various other Production issues in ASE and Replication for Sybase

Experience Summary

Over 7+ years of experience as a Sybase DBA and 4+ years as MSSQL DBA.

Brain bench Certified DBA in ASE 12.5 Administration.

Solid working experience in Sybase database administration and performance tuning with DBA duties.

Experience with ASE 12, ASE 12.5.x and ASE 15.x installation, configuration, applying EBF and administration.

Experience in backup and disaster recovery procedures.

Good knowledge in Sybase database Architecture

Experience in Creating/Modifying/Locking Logins and Users as part of user management.

A good knowledge of Sybase security management and data integrity.

Good understanding of the database, related utilities and tools and OS.

Proficient in configuring Server to achieve the best Performance.

Proficient with database backup and recovery procedures.

Strong Knowledge in Performance tuning, database tuning techniques.

Expert in performing database consistency checks and planning and scheduling Backup & Recovery and general database refreshes.

Thorough knowledge in ASE 12.5.x and ASE 15.x Administration.

Hands on experience in upgrading ASE 12.0 to ASE 12.5.x and 12.5 to 15.x versions.

A strong team player with ability to learn new skills and adapt quickly, highly motivated with excellent interpersonal, communication and leadership skills.

Good communication skills with management, development teams, vendors and other systems administrators

Experience as MSSQL DBA :

Providing 24/7 On-Call support critical production databases

Refreshes from Production backup to Test and Development environments

Scheduling backups and other maintenance tasks using scheduled jobs

Verifying free space in files and file groups.

Extensive experience in installation and configuration of MS SQL Server 2000/2005/2008/2008R2 versions.

Expert in Database Backup, Recovery and Disaster Recovery procedures.

Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.

Hands on experience in the Migration of SQL Server 2000 databases to SQL Server 2005.And Migration of SQL Server 2005 databases to SQL Server 2008

Experience in Log shipping, Mirroring and Replication.

Experience working with production and 24 x 7 on call environments.

Used Performance Monitor/Profiler and other Monitoring tools.

Administered, maintained and implemented Standard Operating Procedures for ensuring the security and integrity of the company database SQL server authentication, server roles, database roles and permissions.

Languages

C#,ASP.NET,ADO.NET, VB 6.0.Dos Scripting,Shell scripting

Operating Systems

Solaris 9,Windows Enterprise 2003, 2000 Advanced Server, Windows 98/95. AIX 5L, Linux flavors.

Databases

Sybase ASE 15.x,ASE 12.5.x – 12.0, SQL Server 2005-2000,2008,2008R2 and MYSQL 5.0

Tools

SQL Advantage, FTP, Telnet, Sybase central, Dbartisian .

Technical Skills

Education/ Certification

M.Sc. in Computer Sciences Passed out in NOV 2003 from Rajive Institute of Technology & Management Studies, Tanuku. Affiliated to Andhra University with 70.0% First Class.

B.Sc. in Computer Sciences Passed out in 2001 from L.B.College, Visakhapatnam Affiliated to Andhra University. 63.0% First class.

Advanced Mainframe Training Course from Computer Maintenance Corporation (CMC) at IBM Mainframes Training center, Hyderabad

Professional Experiences

Project Name : Production DBA Support(24*7) Sybase & MSSQL DBA

Duration : September 2012 to till date.

Client : UBS AG Singapore.

Organization : Cognizant Technologies Solutions

Position : Technology Specialist (Sybase & MSSQL DBA)

Scope:

UBS AG Database Support project is for Swiss bank which operates 24*7 across the globe with more than 1000 Sybase and SQL servers. We provide database support for Installing, Configuring and Maintaining databases and instances includes backup and recovery, monitoring errors, performance tuning, login/users control, change requests through ServiceNow, NetCool and ITCMs.

Working on production, development and UAT servers, ensure availability of production databases to end-users and development database to developers in a 24x7 environment.

Working on Replication issues mainly including DSI threads down, rep Q getting filled up, Latency in replication, new server installations. Replication versions worked on are 12.6 and 15.6

Working on major server builds, Managing database consistency checks and other scheduled maintainance jobs for the weekend

Trouble shooting the daily development/QA/production problems.

Maintenance of development/QA/production Databases.

Monitoring and fine-tuning systems (It includes OS Tuning, Network Tuning, Database Tuning, ASE Tuning, Memory Tuning and Query Tuning) to support Online (OLTP) Users, Trading and daily reports for better performance.

Managing the jobs running on the various servers.

Vendor management to ensure the support for database related issues.

Writing wrapper scripts on UNIX for ease of various day-to-day tasks.

Installing Adaptive Server and Backup Server

Establishing connectivity between clients and servers

Creating and Maintaining user databases

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 & troubleshooting

Configuring Adaptive Server to achieve the best performance.

Looking after the Production alerts and daily production issues. Liase with Application team, Unix Team, SAN Team and tape restore team for various other project activities and tasks

Project Name : Clinician Sybase & MYSQL DBA

Duration : August 2010 to September 2012

Client : Emdeon Business Services, USA.

Organization : Cognizant Technologies Solutions (Aug 2010 to till Date)

Position : Techinical Lead (Sybase DBA)

Scope:

Emdeon Business services is a health care project. In this environment we support Production,Test and development servers for their critical applications which are running on ASE12.5 and ASE15.5 servers on AIX platform. We follow change management process in resolving issues with the help of ER tool. Whenever user faces any issues or any implementation, client creates a ticket and will be assigned to the DBA team. This will be picked up by us and closed according to SLA.

Responsibilities

Database Space Monitoring.

Database creation.

Installing Sybase on AIX Platforms.

Installed EBF’s inline with production servers.

Provide 24 X 7 support for Production Servers.

Binding hot tables to named caches.

Handling DBCC output and troubleshooting

Performance Tuning and Query Optimization.

Ability to work with named segments.

Configuring 12.5 ASE and 15.5 ASE Server level configurations.

Database Refresh (Using backup and restore technique).

Planning for table partitions for improving performance.

Monitoring and troubleshooting backups.

Monitoring the error log and trouble shooting.

Granting Roles and Permissions to Users.

Creation of monitoring scripts for proactive database Monitoring

Handling Day to day database alerts

Plan growth and changes (capacity planning).

Write user and technical document.

Start UP and Shut Down the System.

Database tuning and memory configuration.

Database optimization using defragmentation and re-building indexes and updating statistics.

Index planning.

Account Management and File System maintenance.

Planning to Backup Database and Recovery.

General health checkup

Project Name : MOFT Sybase DBA

Duration : November 2007 to July2010

Client : British Petroleum & Oil London, UK

Organization : Infosys Technologies Limited (Nov 2007 to July 2010)

Position : Technology Lead (Sybase DBA)

Scope:

We support Test and development servers for their various critical applications which are running on ASE12.5 servers on Solaris platform. We have a REMEDY ticketing tool for ticketing purpose. Whenever user faces any issues or any implementation, client creates a ticket and will be assigned to the DBA team. This will be picked up by us and closed according to SLA.

Responsibilities

Database Space Monitoring.

Database creation.

Installing Sybase on Solaris Servers.

QL Server service pack installation.

Installed EBF’s inline with production servers.

Configuring and altering service accounts

Performance Tuning and Query Optimization.

Database Refresh (Using backup and restore technique).

Monitoring and troubleshooting backups.

Granting Roles and Permissions to Users.

Creation of monitoring scripts for proactive database Monitoring

Handling Day to day database alerts

Plan growth and changes (capacity planning).

Write user and technical document.

Start UP and Shut Down the System.

Database tuning and memory configuration.

Database optimization using defragmentation and re-building indexes and updating statistics.

Index planning.

Account Management and File System maintenance.

Planning to Backup Database and Recovery.

General health checkup

Project Name : Sybase DBA Production support

Duration : January 2007 to November 2007

Client : Reliance,UTI,LIC

Organization : Karvy Computershare Pvt.Ltd. (Hyderabad)

Position : Assistant Manager(Sybase DBA)

Scope:

We support production servers for their various client databases which are running on Sybase servers on both Solaris and Windows platforms.

Responsibilities

Creation of monitoring scripts for proactive database Monitoring

Handling Day to day database alerts

Database tuning and memory configuration.

Database optimization using defragmentation and re-building indexes and updating statistics

Configuring and altering service accounts

Database Refresh (Using backup and restore technique).

Monitoring and troubleshooting backups.

Installation, configuration and upgrading of ASE server software and related products.

Maintaining ASE Servers, Critical Databases, Scripts and Backups.

Evaluate ASE features and ASE related products

Establish and maintain sound backup and recovery policies and procedures.

Take care of the Database design and implementation.

Implement and maintain database security (create and maintain users and roles, assign privileges).

Perform database tuning and performance monitoring.

Setup and maintain documentation and standards.

Plan growth and changes (capacity planning).

Work as part of a team and provide 7x24 support when required.

Perform general technical trouble shooting and give consultation to development teams.

Contact this candidate