Sql Server Manager

Name : Avinash Kothare

Address : **** ******* ******

West Lafayette, IN, 47906

Telephone : 1-765-***-**** (cell)

E mails : abl2c9@r.postjobfree.com; abl2c9@r.postjobfree.com

Summary

A professional Database Administrator / Developer (Sybase/MS SQL Server)

with more than 12 years of experience in Banking, Finance, Health &

Manufacturing. Has experience and expertise in databases with all layers

of IT infrastructure.

As a DBA / Developer has successfully

- managed full life cycle of database systems and ERP systems

- supported business critical operations as a DBA on-call

- done change management (internal and external vendor driven

changes/releases)

- monitored database health, capacity utilization for 24 x 7 availability

- planned for and implemented database disaster recovery & business

continuity

- provided critical inputs on projects to increase uptime, improve system

performance

- implemented best practices for standardization, documentation

- reduced Total Cost of Ownership (TCO) by consolidation of servers

Professional Experience Summary

USA

1. TDSecurities, IL, Sr. DBA Jan 2009 -

Jul 2010

2. dBProfessionals, IL, Sr. Tech. Consultant Sep 2004 - Dec

2008

Consulted to the following USA companies on site

1.

2.

1. JPMorgan Chase, Columbus, OH

2. Bank of America, Chicago, IL

3. Mayo Clinic, Rochester, MN

4. State Street Global Advisors, Boston, MA

5. DG Systems, Dallas, TX

6. ACNielsen, Syosset, NY

7. dBProfessionals, Chicago, IL

3. Harman/Becker Automotive Systems, IN, USA Oct 2001 -

Jun 2004

Systems Specialist

OVERSEAS

4. Dubai Drydocks, UAE, Computer Services Manager Dec 1996 -

Aug 2001

Professional Experience details in reverse chronological order:

1. TDSecurities Chicago, IL ( Senior DBA Jan 2009

- Jul 2010

TDSecurities is a part of global organization TD Bank Financial Group.

Chicago office specializes in options trading. Company has homegrown

applications for near real-time options trading with data feeds from

vendors and interactions with CBOE as well as with all major exchanges. I

am part of the DBA team supporting all databases end to end.

Environment / Infrastructure : Sybase ASE 12.5 /15.0, Sybase Replication

12.6, Sybase IQ 12.6, MSSQL Server 2005/2008 for PROD, QA/UAT and DEV

based on LAN. Hosts are mostly Sun/Solaris. Storage is SAN. Oracle 8i is

used as a backend for support desk application. CA AutoSys and MS SQL

Server agent are used for job automation. Proactive DBA is for monitoring

Sybase ASE servers.

Desktop tools: Sybase Central, MS Office Suite, Clear Case and SharePoint

for Change Management, Security Management and Inventory Management. CAST

for SQL debugging, Proactive DBA for monitoring.

Role and Responsibilities: Provide critical DBA on call production support,

change management into production for releases and streamlining

applications and cleaning up unused components of database, replication,

scripts, jobs, etc. SQL stored procedure development and developer support.

Accomplishments

- Started on-call support after quickly absorbing details about the

infrastructure layout

- Managed Sybase ASE, IQ, Replication, MS SQL Servers in all environments

DEV, QA/UAT, PROD

- Restructured the Sybase security controls to use proper "groups".

- This removed one of the major red flags raised in previous yearly audit

- Implemented production server failover to standby and back after a

thorough testing. Note : All Servers are heavily involved in complex

replication

- Upgraded from ASE 12.5.3 to ASE 15.0.3 (a major upgrade) with no

server/database down time

- Implemented timely internal releases/changes into production

- Provided important inputs to SQL developers for interfacing with

databases

- Supported ad hoc refresh/restore requests from developers

- Completed security/access control requests from end users

- Coordinated with vendors (Sybase/White Sands/Thompson/iVolatility) for

case management, licensing, patches/upgrades, etc

- Cleaned up replication system as London operations were disengaged

- Overhauled (with a hard deadline) set of customer facing reports to run

off from a new set of objects

- (Excel spreadsheet/macros, MS SQL Server, DTS that pulled data from

Sybase, populating tables with new alternative. Had to start with excel

report tracing a long chain back to source data and then replace with new

objects Net effect to the user was new reports with same steps /

operation she was used to earlier)

- Monitored object usage with auditing and then to dropped the unused ones

without side effects

- Did troubleshooting of production problems with Proactive DBA - a tool

from White Sands

2. dBProfessionals Chicago, IL ( Sr Technical Consultant Sep 2004

- Dec 2008

Part of Global Tech and Resources, dBProfessionals specializes in out

tasking as well as providing IT professionals on-site for consulting

assignments

Responsibility : Provided total support on site to

- JP Morgan Chase

- Bank of America

- Mayo Clinic

- State Street Global Advisors

- DG Systems

- AC Nielsen

- dBProfessionals

Environment / Infrastructure for customers:

PROD, UAT, QA and DEV based on LAN/WAN.

DB Servers: Sybase ASE 12.5 / 15.0, Replication 12.6, IQ 12.6, ECDA

12.6/15.0

MSSQL Server 2000/2005/2008

OS's: Sun/Solaris, IBM / Aix, HP / HP-UX, Windows NT/2000/2003

Storage: SAN, NAS, DAS

Job schedulers: AutoSys, cron and MS SQL Server agent

Monitoring /Alerting: Foglight, ProActive DBA, Hawk and homegrown scripts

Change Management: PVCS, Peregrine Service Center,

Embarcadero Change Manager and

homegrown scripts

Mail: MS Exchange, LotusNotes

Desktop tools: Sybase Central, MS Office Suite, Clear Case, SharePoint,

CAST (SQL debugging), Proactive DBA, dBArtisan,

MS SQL Studio

Role and Responsibilities:

End to End database life cycle administration

DBA on call support for business critical applications

Change / release management from DEV->QA->UAT->PROD

Server Upgrades (test, configure, plan and implement)

Implementing best practices and standardization

Streamline applications, database, replication, scripts, jobs, etc.

SQL stored procedure development and developer support.

Security and access control

End user support

Vendor liaison

Accomplishments

- Every assignment hit the ground running for the production team by

learning about the complete set-up, change management and operations.

- Streamlined/developed/modified scripts for in-house applications, data

distribution.

- Installed, configured and commissioned Replication

Sybase <-> Sybase, Sybase <-> Oracle, SQL Server <-> SQL Server

- Server upgrades from Sybase 12.5 to 15.0, Replication 12.6 to 15.0

- Supported scores of data servers, replication servers and gateways in all

environments

- Ensured continuous availability / least downtime for the complex set-ups

- Performance and resources monitoring with latest tools

- Root cause analysis of problems related to performance, resource usage,

replication, data synchronization, etc.

- Excellent developer support

- Change management into production with no side effects.

- Fast turnaround for end user access control requests

- On call support with a pager/phone by rotation

- Liaison with vendors for technical cases till problem resolution or work

around

3. Harman/Becker Automotive Systems, IN ( System Specialist Oct 2001-Jun

2004

Harman uses Trans4m, an ERP package for specially geared for automotive

OEMs and repetitive manufacturing. Trans4m is available on major UNIX's and

NT

Environment / Infrastructure: HP 9000, HP-UX 11/11i, Glance Plus,

MirrorDisk, Sybase 12.x, Unidata 5.2.x, Tran4m 7.10/8.05/8.16, Oracle 8i,

FAST c/s, MS Exchange 2000, Merkur Fax, BrainEX (for EDI), LAN and WAN

ERP System Routine Support

(HP-UX 10/11i, Sybase 12.x, Unidata 5.1/5.2, Trans4m 7.10/8.05 /8.16

. Data transfers between Sybase and Unidata

. Administered entire Trans4m ERP on servers in Indiana, California and

Michigan. Production and Test and Development were on separate servers.

. Applied latest patches for the production ERP version

. Followed up with ERP software supplier for bugs/problems to provided

fixes and workarounds. Used phone support, their web based electronic

ticketing system and also tools like secure Webex session, VNC and Double

Vision.

. Created user database profiles for users based on access required

. Solved day-to-day user issues like locks & program run time errors

reported.

. Resolved user logged calls with electronic tickets by HEAT system.

. Did the periodic tasks like daylight savings change required by EDI and

shipping modules during April and October.

. Supported finance department for month ends and year end procedures

ERP System Strategic Project Support

Planned, tested - in a sandboxed test area - and went live with add-on

products like

o Jetforms for printing Purchase Orders., Bill of Materials, Invoices,

etc.

o Merkur fax for sending out releases to Harman material suppliers

o Brain-ex as middle tier for business critical EDI communications from

and to Harman customers and suppliers

. Trained site administrators at different locations on first level of

Trans4m ERP support

. Upgraded ERP Trans4m (7.10 to 8.00 and 8.05, tested 8.16). For this

project planned, tested and executed. This involved study of system

requirements, analysis of program customizations done in-house, testing

new version logic with production data, systematically sorting out all

issues during IT level testing and user level testing. Planning, training

and coordination of actual cut-over to next version, verification of

business critical data before and after the upgrade to meet audit

requirements.

HP-UX (UNIX) Administration (Routine Tasks)

Managed HP-UX (10.20/11i) servers (HP9000: D, H, K and rp5470/L3000) at

multiple sites. Separate servers are used for production, testing and

development. Installed new versions of OS and add-on modules, applied OS

patches. Maintained support contract details and liaised with HP support on

problems related to hardware and bundled as well as add-on software

packages.

. Automated routine chores with cron scheduler and UNIX shell scripts.

. Introduced e-mail alerts for critical events in EDI, printing, etc.

. Administered disk & partition organization using LVM and Mirror disk.

. Routine backups and as needed data restores

. Streamlined purging and archiving of old data.

. Monitored servers performance for bottlenecks, hung users, lost

connections, locks, space, runaway processes, etc. Used tools like Glance,

sar, top FAST c/s,

HP-UX (UNIX) Projects - System & Database Administration

Standardization

Analyzed current practices, designed and standardized following

. Printing sub-system for 150+ networked printers using Openspool (from HP

OpenView family). Printers: HP laser jets, OKI impact and Intermec

label.

. Security and User access control on "need" basis

. Password change policy as required by internal auditing and (and now by

Sarbanes Oxley)

. Policy of Users names and numbering User Ids

. All cron batch jobs with self auditing, generous comments and

standardized look and feel of job, commands executed, audit log generated

and e-mail alert about failure if any.

. Standardized unattended backup to tapes with minimal human intervention.

Procedure for marking mile stone back-ups and policy for retention based

on inputs from Finance, Planning, Manufacturing, etc.

. Policy on schedule and scope of purging and archiving of old data

Server consolidation

Performed server consolidation (HP 9000 K100 server at California was

eliminated as a result of this move). Analyzed the requirements of

combined load, planned server architecture, analyzed, formulated and tested

methods of data, logic and sub-systems merger. Plan in detail and executed

the merger/consolidation step-by-step.

. Planned server architecture for OS and DB upgrade, with 3 to 4 years

requirement. Replaced servers by rp5470 HP-UX from 10.20 to 11i (64 bit).

Also consolidated servers at Indiana with disaster recovery server in

Michigan. Server upgrades were done with detailed planning, testing and

training to minimize business interruption.

MISC

Participated in an OLAP/DW departmental project using PILOT as OLAP tool.

. Provided technical inputs to other team members in the Trans4m IT team.

. Transfer ed knowledge to the client and support personnel.

DBA and development

Administered Unidata 5.1/5.2 and Sybase 12.x Installed software and

patches as needed. Tuned kernel parameters related to shared memory, files,

inodes, locks, memory per user, etc as well as setting up specific DB

options.

. Upgraded Unidata from 5.1 (32 bit) on HP-UX 10.20 on D380 to Unidata 5.2

(64) bit on HP-UX rp5470 server. Ensured that OS, database AND ERP are 64

bit versions for correct working.

. Managed the tables (called static and dynamic files), indexes and data

dictionaries. Used FAST c/s tool for table resizing.

. Developed Unibasic programs for specific purposes of statistics, testing,

monitoring, etc.

. Debugged programs for run time errors reported for diagnosing and

deciding corrective action.

. Provided technical inputs on Unidata/Sybase to other team members in the

Trans4m and BI/Query IT team.

OVERSEAS

4. Dubai Drydocks

IT Manager, Dec 1996 -

Aug 2001

Dubai Drydocks is the largest ship repair yard in Dubai, UAE and Middle

East. Ship repair contracts are won by a competing globally. A ship repair

is monitored as a project with tight cost controls. Difference between

overall costs (labor, material, contract, overheads, services, etc) and

quoted repair price reflects the profits.

Environment:

HP-9000 (H60, L2000), Compaq Proliants, Winntel (Compaq & HP) Desktops, HP

CAD stations and fiber optic fast Ethernet LAN with gigabit backbone plus

WAN connection to branch 25KMs away. HP-UX 9.x/10.x, Sybase 10.x/11x,

Oracle 8i, PI/Open 3.6,x/3.7.x, NT 4/W2K, SCO 3.x, MS Exchange 4, Right

Fax, Norton Antivirus, AutoCAD 14/2000

Computer Services Management

Managed all computer data center day to day operations to support project

based ship repair business. This was focused on controlling costs (labor,

contract, material, and overheads) on a daily basis.

. Managed IT departmental budget and expenses.

. Managed IT capital budgets and expenditure on assets keeping track of

relevant depreciation.

. Conducted Vendor negotiations for IT purchased and liaison

. Completed a 18 month Major infrastructure project ($1 M) for

o switched fiber optic LAN with Cisco switched and firewall,

o Wintel desktop & CAD stations,

o HP & Compaq server upgrade and

o Data base (PI/Open + Sybase) upgrade path to Oracle.

Project involved preparing specifications, inviting and evaluation of

sealed quotes, and follow through with the selected vendors for desktops,

database and servers.

. Architected, planned, procured and commissioned MS Exchange electronic

mail and RightFax with unified in-box.

. Oversaw Y2k compliance (31 Dec 1999 to 01 Jan 2000) as required by

Customers, Suppliers, Banks and Government agencies,

. Provided inputs to directors and CEO for the IT technology direction

. Managed a technical staff of analysts/programmers, system and mail

operators and network and hardware engineers.

DBA/Developer

Sybase 10.x, T-SQL, PowerBuilder 5.x, PI/open 3.6/7.x, InfoBasic

. Developed guidelines for naming, and creating Sybase objects (tables,

stored procedures, triggers, etc.) for multiple use, ease of maintenance,

etc.

. Designed and led development of PowerBuilder libraries and programs for

code reuse and ease of network based deployment.

. Led development of Customer Enquiry, Tenders/Quotation system, Dock

availability/occupancy, etc. using Sybase as backend and PowerBuilder as a

front end in client server architecture.

. Formulated and implemented Sybase backup strategy for providing up to

recovery up to last hour.

. Scripted Sybase health checks by running diagnostics and integrity checks

(dbcc, checkdb, etc) overnight..

. Developed server side stored procedures in T-SQL.

. Managed table spaces, performance, locks etc. using built in stored

procedures

. Led the development of in-house ERP using PI/Open (nested table database)

for routine modules like G/L, A/P, A/R, Payroll, Cost, Materials Control,

HR, etc.

. Integrated PI/Open applications and Sybase databases using program

developed in PowerBuilder as a common gateway. (InterCALL DLLs were

used to connect to PI/Open and Sybase simultaneously)

Technical Summary

. 15 years of experience in Information Technology and over 10 years of

database specialization with multiple roles such as Technical Architect,

Designing, Architecture of databases, DBA, Developer of interfaces with

ERP/MRP etc.

. Specialized and adept knowledge in databases like

o Sybase 10.x/12.x/15.x- 8 yrs.

o Sybase Replication server (4 years)

o Sybase IQ (1+ year)

o MS SQL Server 2005 (2 years)

o Unidata 5.1/5.2 & PI/Open (nested-table DBMSs from IBM) - 10 plus yrs.

. Strong Administration skills in the operating systems/ Environments

like

o Solaris 2.8/9/10, IBM Aix 3.x HP-UX 10.20/ 11i, SCO UNIX, Linux

2.x/3.x

o Windows NT/2000/XP

. Business solutions with industry best practices

Overview

. Over 15 years of experience as an IT professional with good understanding

of the technicalities of IT as all three software layers of

o OS : Unix (HP-UX/Solaris/Red Hat Linux/SCO/AIX) operating systems

o Database Administration : Sybase with Replication, SQL Server,

Oracle, Unidata

o ERP applications

. Very good grasp of business critical operations and application

development life cycle

. Extensive applications development experience for customization.

. Change Management experience using matrix approach with an eye for detail

(Unix-OS, DBMS, Applications and Hardware)

. Experience in database performance tuning, administration, backup &

recovery of large database systems.

. Project Management for infrastructure as well as software development

. Strong Communication and leadership skills

. Excellent business user interaction skills

Certification

. Sybase ASE Administrator 15.0

. Sybase ASE Administrator 12.5

. Sybase ASE Developer 12.5

. Sybase Replication Server Administrator 12.6

Education/Training

. Bachelor of Technology in Electrical Engineering.

. Sybase active/standby replication from Sybase USA (at ACNielsen)

. Sybase Fast Track from Sybase ME

. PowerBuilder from Synergy Systems

. Oracle database 8/8i administration training from Oracle ME.

. Oracle Forms/Reports training from Oracle ME

. Oracle RAC training from Global Institute

. Introduction to SAP Basis from Cybertech

. Self Study/Training/Update of Industry trends and technology especially

on desktops, Databases, Operating Systems and networks, etc.

Hardware

HP 9000, Sun Mid and high end servers, Sun Clusters, Digital/Compaq, IBM

Virtual servers, Wintel Desktops (Compaq, HP, Dell), Notebooks/Laptops

(IBM, Dell)

Operating Systems

Solaris 8,9,10, HP -UX 11/11i, Linux AS 2.x/3.x, SCO 3.2.x, True64, AIX 3.x

Windows NT W2K/2K3, XP

Databases/Replication

Sybase 10.x/12.5.x /15.x ASE, with monitor and historical servers

Sybase Replication server 12.5/12.6/15.0

Sybase IQ 12.6

MS SQL Server 2000/2005

DirectConnect for Oracle (Sybase to Oracle replication)

DirectConnect (Sybase to DB2 replication)

Unidata 5.1/5.2,

ERP

Trans4m 7.10/8.05/8.16 for Automotive Manufacturing

In-house ERP for Ship repair yard

Languages

T-SQL (Sybase/SQLServer), UNIX shell and Perl scripts, UniBasic (Unidata),

Performance Tools

Fog Light for Sybase and Sybase replication, PDBA (White Sands)

Glance Plus, FAST c/s for Unidata table resizing

GUI Tools

Embarcadero DBArtisan 8.1.x and Change Manager, Sybase Central, CAST,

SQLDOC CDE (for Unix System admin), UniAdmin (Unidata), Merant PVCS, PDBA

HEAT (for electronic ticketing), Erwin, MS Office 97/2000/2003, Clear Case,

Lotus Notes, Service Center (Peregrine)

[pic]

Contact this candidate