Sql Manager

Ashish Sheth ********@*****.***

*** ****** **. *** #** Mobile: 347-***-****

Hoboken, NJ 07030

OBJECTIVE:

To apply my strong Database Architectural / Administration / Development skills in a challenging environment for professional

advancement. Worth noting are excellent communication skills and more than 10 years of solid experience as a Database

Administrator on MySQL 5.1 / 5.5 + SQL 2008 / 2012 platforms across financial/wireless/retail/payroll/Radio environments.

Possess strong skills in logical/physical database design and modeling, performance tuning, supporting large datawarehouses for

BI, programming high-level SQL queries, supporting 24x7 production databases, managing backup strategies, and all database

architecture/infrastructure responsibilities

TECHNICAL SKILLS:

RDBMS Utilities: MySQL 5.1 / 5.5 on CentOS/Ubuntu, GitHub, Percona 5.5, MongoDB, SQL Server 2008 / 2012, SSIS,

SSRS, ER/Studio 8.0, IDERA SQLSafe, IDERA Diagnostic Manager, Oracle 8i Enterprise Manager (OEM), SQL Compare,

DBA Studio,, SQL*LOADER, SVRMGR, SQL Profiler, FTP,DTS, BCP, JDBC, ODBC, OLEDB, ADO

Languages: SQL, T-SQL, PL/SQL, INNODB, DTS, DDL, DML, .NET, ASP, JavaScript, VBScript, HTML, TCL,

EXPERIENCE:

CBS Radio / CBS Interactive Music Group New York, NY Oct 2010 - Present

Lead DBA/Data Architect

Responsible for all Properties of CBS Radio including AOL Music/Yahoo Music/Radio.com/Last.fm/150 Radio Stations in 29

US Cities spinning over 30 million songs per day. Environment needs to be available 24x7 and is close to 3TB in size with a

team of 20 developers, and over 10 million writes per hour during peak times.

Major accomplishments

• Designed and administer Multi-Master Replication for Local HA in MySQL for high traffic

• Designed and administer Multi-Datacenter Clustering for Geo-Redundancy (DR) using Tungsten in MySQL

• Performance tuning INNODB and XtradDB using table partitioning, data sharding, improving query response times, and

consistently optimizing stored procedures for efficiency, using Percona and MySQL Native tools

• Responsible for all MySQL Production deployments and ensure all MySQL DB Objects meet performance standards

• Administer and Configure the SQL 2008 3+1 Active/Passive Production Database Cluster

• Lead Development Team on all Data modeling tasks and assist in all database development needs

• Write custom bash scripts to monitor various MySQL Replication Systems in Production

• Upgraded all MySQL 5.1 INNODB systems in DEV/QA/PROD to Percona 5.5 XtraDB

• Designed and maintain the 2TB DataWarehouse with several ETL jobs for critical royalty and listenership reports

THEMARKETS.COM New York, NY Aug 2009 – Sep 2010

Lead SQL DBA

Lead DBA administrating a Production SQL 2005 Equity/Fixed Income Research Platform with extensive SQL replication.

Environment requires 24x7 uptime availability and is close to 2TB in overall data size, with a team of 25 Developers.

Major accomplishments

• Maintain the Peer to Peer Replication/Log Shipping/DB Mirroring Configuration for the Disaster Recovery Environment

• Primary DBA to solve all replication issues in production

• Primary DBA on all production deployments including off-hour support

• Wrote several SSIS Jobs to gather filings, estimates data, and ratings changes daily

• Designed custom deployment tools for ensuring DB patches and SSRS builds are successfully deployed

• Use IDERA Diagnostic Manger to monitor all critical DB servers.

• Performance tuned several DB Objects which utilized less CPU and I/O for immediate firm/brokerage data

• Responsible for all DB Schema/Model changes which developer request.

• Wrote several stored procedures which custom SSRS reports called

Long Island North Shore Hospital New Hyde Park, NY May 2009 - Aug 2009

Senior Productions DBA

\ Mission Critical Patient Related SQL Database which served 15 Hospitals in Long Island. SQL 2005 Clustering used for High

Availability and EMC (SAN) Snapshot Snapview for primary backup methodology

Major accomplishments

• Lead DBA on all SQL Clustering administrative tasks for the production environment including setup and configuration

• Designed several DB maintenance tasks which included Online Index rebuilding and Backup Methodologies

• Implemented SQL 2005 Snapshot Technology for reporting requirements

• Ensured all developers T-SQL follows performance guidelines, tuning several stored procedures

Ashish Sheth ********@*****.***

300 Newark St. Apt #4L Mobile: 347-***-****

Hoboken, NJ 07030

EXPERIENCE:

Axis Capital New York, NY Oct 2006 – Sep 2008

Senior Database Administrator

Lead DBA with concentration in database monitoring and 24x7 uptime availability in the re-insurance industry. Responsible for

mission critical VLDB’s involving clustering, replication, log-shipping, mirroring and disaster recovery support around the globe.

Major accomplishments

• Responsible for 36 Production Database Servers which require 99.999% Uptime

• Conducted several upgrades from SQL 2000 to SQL 2005 in production environments. This included re-writing legacy DTS

packages into SSIS. Functions/Procedures were rebuilt ensuring SQL 2005 compliance.

• Built a Production SQL Disaster Recovery site for several production databases using database mirroring and log-shipping.

• Supported several transactional Replication environments that fed data warehouse systems

• Created scripts within IDERA SQLSafe for custom backup/restore procedures

• Optimized several developer stored procedures/functions for speed and efficiency.

• Assisted a team of 17 developers in all DB modeling/design and tuning efforts.

ADP (Automatic Data Processing Inc.) Roseland, NJ Jun 2003 – Sep 2006

Senior Database Administrator

Primary DBA in building scripts for client related issues, working alongside developers/analysts/support team for future DB

Designs, and ensuring high availability for multiple production environment databases. Effectively led a group of 20 developers

in daily database production & development requests on large databases for the .NET Application

Major accomplishments

• Designed data models (ERD) via ER/Studio and communicated data models to developers as version updates occur from

development to staging

• Wrote database scripts to achieve daily DBA tasks such as installation, configuration, tuning, backup, and recovery

• Liaise with client and middle tier support to resolve production client issues

• Wrote complex SQL Scripts to fix data issues to allow clients to finish year end tax filings

• Performance tune existing stored procedures resulting in a 100% to 1600% increase in performance

• Ran Several Trace files via SQL Profiler to determine slowest queries and poor performing stored procedures.

• Exported and imported large amounts of data between different environments using DTS and BCP utilities

• Built close to 60-70 stored procedures utilizing complex transactions, joins, cursors, and various high level T-SQL

• Used SQL Performance Monitor to troubleshoot the hardware and diagnose CPU related bottlenecks, I/O related issues (disk

drives), poor network connectivity areas, and memory management

• Responsible in properly securing all SQL Servers utilizing roles, table encryption schemes, restricting access to views

assigning permissions to objects, auditing users via Profiler, and assigning NT/SQL authentication

Antenna Software Inc. New York, NY Feb 2002 – Mar 2003

Lead DBA

Designed, administered, and responsible for all web-driven database systems in a wireless mobile enterprise software firm which

ran on 2 Major CRM’s (Siebel 7.0 and ClarifyCRM) containing instances of SQL 7.0/2000 and Oracle 8i on NT/2000 Platforms.

Major accomplishments

• Designed and maintained multiple schemas in ER/STUDIO for various applications assisting developer needs

• Wrote several automated backup plans on SQL Server 2000 and ORACLE to minimize data loss Worked very closely with

SQL Profiler to diagnose potential DB performance bottlenecks, recommend more efficient usage of clustered/non-clustered

indexes, determine schema design flaws, and deadlock/contention areas

• Wrote highly transactional DTS packages to push large amounts of data from tables to ASCII files for reports

• Created advanced installer DB scripts to easily create databases from any version going from dev to production builds

• Used Veritas Backup for SQL to properly dump online SQL Databases to nightly tape along with custom SQL scripts

ePresence Inc. Red Bank, NJ Jun 2000 – Nov 2001

Senior Database Administrator

Lead DBA on an Oracle 8i/Java/Vignette Personalization Portal system for Cingular Inc running on UNIX Sun Solaris Server.

Developed and supported a 200 gig SQL Server 2000 Database containing critical financial investment data for ARGUS

Investment Research Inc. (www.argusresearchgroup.com)

EDUCATION:

Rutgers University College of Engineering Piscataway, New Jersey Sept 1994 – May 1999

• Bachelor of Science, Industrial Engineering

• 3.172 Overall GPA

Contact this candidate