Resume 10

Experienced Certified Sybase DBA with over 7.5 years of experience in Sybase SQL Server, MS SQL Server and Replication Server Administration. Expert level skills using Sybase 11.0.x, 11.5.1, 11.9.x - 12.0.0.x 32 - 64 bit installations on Solaris / HP-UX / AIX / Linux installations , Sybase System - Database Administration, Sybase Replication Server 11.5.1 -12, Sybase Performance - Tuning strategies and issues, MS SQL Server Database Administration, Sybase Disaster Management - Recovery, Database design and UNIX System Administration skills.

Worked on databases from 40 GB to 2.5 TB in size, and upgraded over 80 servers from 11.x to 12.x. Evaluated and made recommendations on multiple disaster recovery solutions, storage solutions as well as hardware / software choices to clients in the Banking, Energy and Telecommunications industry. Designed and implemented logical and physical database models. I have a solid techno-commercial background that allows me to make better decisions for my employer / clients on the basis of cost-effectiveness of different solutions.

• Strong decision making - management skills and team player attitude with the ability to get things done.
• SYBASE Certified Professional. Certified on SYBASE 11 - 11.5.1.
• Expert in Dataserver Design - Configuration, Disk Layout - machine configuration and Performance optimization and Tuning.
• Sybase Replication Server Design and Implementation for disaster management and recovery.

HP-UX 11.0 / 10.20 K / V / N Class boxes , AIX 4.3.x S 80 / S70 / H Class Boxes , Solaris 2.5.1 / 2.6 / 7 / 8 sparc 5 / sparc 10 / E250 / E 450 / E3500 / E 4500/ E 6500 / E 10000 class servers using Veritas Quick IO , NT 4.0 Compaq Proliant and HP Servers , Linux - Windows 95.

EMC Symmetric 5740, MTI, EMC Clarion, T3, A5200, D1000, A1000 and IBM Shark arrays with SSA controllers.

Sybase Adaptive Server Enterprise 11.0, 11.5.1, 11.9.2 - 12.0, Sybase Replication Server 11.5.1 and 12.0, SQL Backtrack, Sybase IQ Server 12.4.2, DB Artisan, MS SQL Server 6.5 - 7.0, isql, bcp, Sybase Monitor Server, Sybase Historical Server, Component Integration Services CIS , SQL Remote for Sybase Replication to SQL Anywhere and T-SQL, Mercury Load Runner.

• MBA in progress - Keller Graduate School of Management 2000-02 www.keller.edu
• Bachelors Degree in Accounting from University of Bombay.
• 2 year Post Graduate Diploma in Information Systems Management from NIIT
• Sybase Certified Professional - Adaptive Server Administrator version 11.5.1
• Certified SYBASE DBA - version 11.0
• System and Database Administration: Adaptive Server Enterprise 12.0
• Replication Server Disaster Recovery version 12.0
• Fast Track to Replication Server Administration 12.0
• Fast Track to Replication Server Administration 11.5.1
• Fast Track to Sybase Adaptive Server Enterprise11.5.1
• System Administration of SYBASE Adaptive Server Enterprise 11.5.1
• Advanced System Administration of SYBASE Adaptive Server Enterprise 11.5.1
• Performance and Tuning of SYBASE Adaptive Server Enterprise 11.5.1
• Advanced Sybase SQL Server System Administration 11.0
• Certified UNIX System Administrator
• Microsoft Certified Product Specialist.

Provided Technical Support to system analysts and end users on technical issues. Database sizes ranged from 40 GB to 2.5 TB. I installed, tuned, upgraded, maintained and trouble shot Sybase Adaptive Servers v. 11.5.1 / 11.9.2 / 12.x on Solaris using Veritas file System / HP-UX / AIX / NT platforms, and Replication Servers 11.5.1 and 12.0. Additional duties included stress testing database servers using TPC and Mercury Load Runner, designing and implementing disaster management and recovery plans; automation of routine database maintenance tasks using shell scripts. Tuned database servers as needed on the physical and / or the logical query tuning level, as well as Replication and SQL Remote servers for using parallel dsi and memory allocation as needed. Supported both OLTP and DSS environments in development, production and QA environments. Designed and implemented physical database models.

Provided Production Support to the client, and did performance tuning on the Test and Production Servers. Tuned and rewrote some stored procedures to do index scans, partitioned big tables across devices on a segment to reduce disk i/o contention, and wrote korn shell scripts to automate DB maintenance tasks such as update stats, sp_recompile - dbcc s. Installed, configured and upgraded Sybase dataservers 11.5.1 / 11.9.x, and Replication Server 11.5.1 on Solaris, AIX, Linux and NT. Also supported MS SQL Server 6.5 on NT 4.0

Provided Technical Support to clients database administrators on technical issues. SPME caters to a majority of banks, government organizations, commercial houses - financial institutions on behalf of Sybase Inc. Duties include installation, remote trouble shooting using dial up networking, installing SYBASE on Sun Solaris Clusters for high availability.

• Installed SYBASE in various client locations on multiple platforms.
• Implemented Disaster recovery - management strategies.
• Automation of Routine Maintenance tasks.
• Physical Database design and implementation.
• Set-up - configuration of SYBASE ASE 11.0.3.x, 11.5.1 and 11.9.2 on UNIX and NT platforms.
• Performance tuning - troubleshooting of SYBASE ASE - Replication Servers.
• Replication Server installation, configuration and administration.
• Installed and configured Sybase Dataservers used for running GEAC solutions.
• Installed and configured Sybase Dataservers and Replication Servers used for running LOGICA solutions used by banks and credit card issuers.

• Installation and configuration of the databases and dataservers on SCO UNIX and Solaris with VFS.
• Set-up user groups and accounts to facilitate system administration.
• Set-up a comprehensive Disaster Management and Recovery plan to ensure full and rapid recovery from any disasters.
• Database Design - Performance Tuning:
• Placed the database devices on different hard disks to reduce disk I/O contention and speed up performance.
• Created indexes to help optimize queries and improve performance.
• Arranged database devices on raw partitions to reduce disk I/O contention - speed up performance
• Fine tuned SQL queries to improve performance
• Implemented Stored Procedures - created indexes improving performance
• Distributed tables on different devices to reduce disk I/O contention

Languages spoken: English, Hindi, Urdu, Marathi, Gujrati.