Sql Server Dba

KOTHAN JAYAGOPAL

Austin, TX

Contact# 646-***-**** (M)

abkhkq@r.postjobfree.com

SUMMARY

Highly accomplished and result-oriented Senior SQL Server Database

Administrator with 11+ years of expertise in Data System Architecture, Data

Modeling, High Availability, Disaster Recovery, and Troubleshooting SQL

Databases. Mid level ORACLE Database Administration with expertise in RAC

and Dataguard technology. Team player with a proven ability to provide

excellent deliverables within time limits without compromising quality,

while working on multiple high priority tasks.

TECHNICAL SKILLS

Databases Microsoft SQL Server including 2008 (POC), 2005,

2000 11+ years

ORACLE including 10g, 9i, 8i 4+ years

Database Database Mirroring, Replication (Transactional,

Technologies Merge), Log Shipping, SQL Clustering, Service

Broker, SAN, Netapps, ASM, Dataguard, Grid

Control

Operating Systems Windows servers including Windows 2003, Linux

(SuSe, Red Hat), UNIX

Computer Languages T-SQL, PL/SQL, ASP, ADO, XML, HTML, VC++, Visual

Basic, C, C++

Other Tools ERWIN, Power Designer, Microsoft Internet

Information (IIS), SQL Suite (Testing tool),

Legato Backup, Lite Speed, VERITAS Backup, Remedy,

MOM, Ignite PI

PROFESSIONAL EXPERIENCE

Gerson Lehrman Group, Austin, TX Oct 2007 - Present

Senior SQL Server DBA

. Implemented Merge Replication as a scale out architecture. Performance

improved significantly.

. Implemented NetApp disk mirroring as enterprise-wide Disaster Recovery

Solution.

. Completed proof of concept to adept to SQL Server 2008.

. Evaluated Lumigent Audit Software and Ignite PI for SQL Server

performance monitoring.

Environment: 50 SQL Servers 2005, Merge and Transactional Replication,

Service Broker, NetApp, MOM

Dell Inc, Austin, TX March 2004 - Aug

2007

Senior SQL Server DBA/ORACLE DBA

. Led SQL Server 2005 migration process by delegating work to six DBAs,

evaluating new database features, integrating with enterprise backup

and other external systems/processes, defining Standards. Minimized

downtime (less than 30 minutes) for enterprise wide 1200 production

SQL Servers.

. Designed and implemented enterprise-wide High Availability solution,

using Data Mirroring technology; reduced incidents by 85%

. Defined and Automated the global installation process for 1200

production SQL Servers, reducing installation time by 90%

. Standardized and automated a global decommissioning process for all

production database servers using Six Sigma based Dell BPI; achieved

cost savings of $150,000 per annum

. Oracle database administrator in production (24X7), development, QA,

and training environments. Responsible for administration of mission

critical databases. Administer more than 1000 databases with a DBA

group

. Proficient in Oracle installations, migrations, upgrades, patches, and

configuration. Create and manage database structure, schema, and

objects. Administer users and privileges. Performance monitoring,

tuning and troubleshooting. Backup and recovery using RMAN. Capacity

planning

. Migrated ORACLE databases from 9i on Windows to 10g on Linux.

Databases ranging 50 gigabytes to 100 gigabytes

Environment: 1200 SQL Servers (2005 & 2000), Database Mirroring,

Replication, Log Shipping, DTS, EMC SAN, Remedy, Legato Backup, ORACLE

(10G, 9i), RAC, Dataguard

VERIZON Communications, Dallas, TX March 2002 - March

2004

Senior SQL Server DBA/ORACLE DBA

. Defined and implemented merge replication architecture between

geographically dispersed sites achieving load balancing; increased

data-system availability from 95% to 99.9%

. Assessed and standardized SQL Server installation process across

enterprise, reducing 15% of troubleshooting time

. Consolidated database servers and data environment by migrating

heterogeneous ORACLE databases to SQL Server using DTS technology;

completed the project within time and in budget

. Implemented Microsoft security lock-down procedure for all production

SQL Servers

. 24/7 support to the production datacenter with over 500 SQL Servers

Environment: Transactional and Merge replication, DTS, SQL Server 2000 &

7.0, Erwin

QUILL Corporation, Lincolnshire, IL April 2000 -

Feb 2002

Senior SQL Server DBA

. Defined and upgraded SQL Server 6.5 to 7.0 for 50+ database servers

. Led a team of seven system administrators, network engineers, and DBAs

for a Disaster recovery project by setting up a standby recovery

environment at a remote site

. Analyzed SQL Server incidents, developed a mitigation plan, automated

report generation and delivery, and reduced incidents by 90%

Environment: Replication, Log Shipping, DTS, SQL Server 2000, 7.0 & 6.5,

Erwin

HARRIS INTERACTIVE, NY Jan 00 - April 00

SQL Server DBA

. Designed and Implemented maintenance plan and automated the reports

via email for DBA's to proactively look and fix for potential issues

. Architected Backup and recovery procedures

. Designed and Implemented end users reporting database using

replication technology

Environment: Replication, SQL Server 7.0

UWSI, Milwaukee, WI Aug 99 - Jan 00

SQL Server DBA

. Designed, developed and implemented Maintenance plan

. Setting up Server logons, users and groups

. Data Migration

. Wrote Stored Procedures and Views using T-SQL

. Recovered point in time recovery

. Installed SQL Servers 6.5, 7.0

Environment: SQL Server 7.0 & 6.5

ABACUS DISTRIBUTION PTE LTD, SINGAPORE Dec 97 - July 99

SQL Server DBA

RAMCO SYSTEMS, INDIA April 93 - Nov 97

. SQL Server DBA, Nov 96 - Nov 97

. Developer, Dec 94 - Nov 96

. Backup Administrator, Feb 94 - Nov 94

. Product Tester, Aug 93 - Feb 94

Environment: SQL 6.0, Visual C++, Visual Basic

EDUCATION

B.S. Math, University of Madras, India - Year 1993

TRAINING

SQL Server 2005 Administration

BPI (Dell's Business Process Improvement - Sixsigma)

ORACLE 10g Architecture

UNIX and C

Conflict resolution, Effective delegation

Contact this candidate