Vivek Chandra

720-***-****(h)

SUMMARY

. Over 11 years experience as a DBA/Developer specializing in MySQL,

MS SQL 7.0/2000/2005/2008 R2/2012.

. Expert knowledge in query tuning, writing T-SQL code and stored

procedures and other database objects.

. Extensive knowledge in modeling, database design, development and

administration. Expert level skill in installation, configuration

and performance tuning of SQL Servers and MySQL.

. Strong skills in replication, data mirroring, log shipping, data

migration, DTS, SSIS, clustering and data warehousing concepts.

. Worked in machine critical and high volume Terabyte database

environments.

SKILLS SUMMARY

Operating Systems: Windows Vista, XP, Windows 95/98, Windows NT 4.0,

Windows 2000/2003/2008, Dos, UNIX, AIX, Solaris 2.x/7,

LINUX and Cisco IOS.

Database: MySQL, MSSQL 2000/2005/2008, MS Access, MySQL 5.1, Oracle,

DB2, OLAP and Data warehousing.

Tools: MS SQL Server Management Studio (SSMS), Business Intelligence

development Studio (BIDS), SQL Profiler, PostgreSQL,

VISIO, Enterprise Manager, SSMS, i3-Precise, Idera admin

toolset, SQL Doctor, SSIS, SSAS.

Languages: C#, Perl, VBScript, UNIX Shell scripting, ASP.Net, HTML,

.Net

Hardware: Compaq, Dell and HP servers/desktops, laptops, Cisco routers,

SUNSPARC

EDUCATION

B.Sc. (Civil Engineering), National Institute Of Technology, PATNA,

INDIA.

SQL Server Administration, UNITEK College, Fremont, California

Oracle Administration Course I and II, Oracle University, Pleasanton,

California

Certification: Scrum Master Accredited Certification

PROFESSIONAL EXPERIENCE

AirMethods, Centennial, CO

June 2012 - December 2012

DBA

Supported Ramco System (Aviation Module) running on SQL Server 2005/2008

R2 . Also support flight operation system. Maintained replication and setup

database maintenance plans on MySQL. Upgraded 2008 R2 SQL databases to

MSSQL 2012.

Maintained MySQL clusters.

Supported monthly release on production and training environment for Ramco

Systems. Document the process and raise tickets with Ramco Systems

Technical Team.

Write stored procedure for Journey Log Integration.

Installed hotfixes supplied by Ramco Systems.

Utilized SSIS to create packages for loading data in SQL server from

external sources.

Created Fact and Dimension tables. Created cubes using SSAS.

Applied Patches to SQL Server and perform Backup and Restore of training

and Pre-Production environment.

Evaluateted EtQ software for Safety department.

Mercury Payment Systems, Denver, CO

April 2012 - June 2012

DBA

Worked on SQL Server and MySQL databases. Migrated database from MySQL on

Linux to MySQL 5.1 on Windows.

Participated in daily scrum meetings.

Installed MySQL 5.1 on boxes and configured them for Master/Slave/Slave

configuration.

Created Users and grant permissions.

Participated in daily scrum meetings and planning meeting.

.

First Data, Greenwood Village, CO

Feb 2011 - Feb 2012

Project Lead/Database Administrator

Supported located on various datacenters in Chandler, Cincinnati,

Sacramento and Charlotte running on MySQL, SQL 2005, SQL 2008 and SQL 2008

R2.

Performance tuned queries on MySQL databases.

Utilized MySQL for database creation, import, security and load activity.

Led and managed the development effort for creating reports using BIDS in

SSRS.

Verified the Source Code before deployment in QA and Production

environment.

Created Triggers, Objects, Views, Stored Procedures, databases using T-SQL

and PowerShell.

Utilized SSIS to create packages for loading data in SQL server from

external sources.

Created and deployed Cubes using SSAS.

Install Service Packs and Patches and upgraded SQL Server 2005 to SQL 2008

and SQL 2008 to SQL 2008 R2.Updated global master database inventory.

Monitor SQL Server by creating and evaluating policies using Policy Based

Management.

Utilize MySQL for database creation, import, security and load activity.

Managed and lead the Disaster Recovery for CMS Worldlink databases servers

for TASQ application.

Evaluated and install Idera products namely SQL Doctor, SQL admin toolset

for TASQ and Worldlink Server.

Manage the data center consolidation project. Migrated databases from

legacy servers to better hardware.

Monitor Replication and Mirroring installed on the servers.

Monitor Oracle Databases and administer them using TOAD for Oracle.

Utilize i3-precise to monitor servers across all the data centers.

Utilize CA Service Desk for managing the change.

Evaluate servers and harden them for security purpose.

Performance tuning for end user running applications like TASQ, MTOS,

Government Of Alabama/Puerto Rico tax

Perform index rebuilds and maintain database partitions.

FedEx, Milwaukee, WI

Jan 2011 - Feb 2011

Database Advisor

Created star schema using fact and dimension tables. Led projects on

Oracle, MySQL and Business Objects. Transported objects from DEV to QA

instance. Developed cubes. Created reports using SSRS. Participated in

SDLC change process meeting with developers and project managers.

OnTargetJobs Inc, Englewood, CO

May 2010 - Nov 2010

Database Developer/Administrator

Supported Medhunter, Baybio, Regional Help Wanted and Hcareeers.com Job

Boards.

Performed On Call Support for SQL Server, MySQL and Oracle databases.

Using Scrum, worked with development, product manager and project manager

to create databases upgrade scripts.

Deployed Database objects across QA and production environment.

Utilized RedGate SQL Compare and Data Compare tools to create

synchronization reports across different databases.

Maintain regular contact with the product manager throughout the

development cycle to ensure each step of implementation meets the business

requirement.

Led and managed the unit and system testing to ensure design is still

relevant and implementation is producing a useful, maintainable, and

reliable product

Resolved production tickets after daily triage call with the management.

Supported websites running on SQL Server and MySQL.

Installed pgAdminIII and supported Hcareers.com job site running on

PostgreSQL.

Utilized Erwin to create logical database diagram.

Developed Stored Procedures for contract based feed jobs.

Performed backup on datadomain using datadomain's deduplication technology.

Created gold standards for Virtualization project.

Created fact tables, dimension tables and cubes. Utilize SSRS and SSAS for

analyzing data.

Maintained centralized repository for enterprise level instance/schema

information.

Created Microsoft's SCOM alerts on all production boxes.

Maintained Database Versions on Development, QA and Production Environment

using TortoiseSVN tools.

Developed, deployed and monitored SSIS Packages.

Worked on Database Partitioning and Snapshot Isolation in SQL Server 2005

and SQL 2008.

Implemented SQL Logins, Roles and Authentication Modes as a part of

Security Policies for various categories of users.

Wells Fargo, San Leandro, CA

November 2009 - March 2010

Database Administrator

1. Performed backup of MySQL databases. Optimized queries on MySQL

databases.

2. Utilize Eclipse IDE for product development and upgrade script

preparation.

3. Deploy application in QA environment.

. Created SSIS packages using SQL 2008.

. Ran daily and monthly Jobs to support Wells Fargo reporting needs.

. Developed, deployed and monitored SSIS Packages including upgrading

DTS to SSIS.

Williams Sonoma Inc, San Francisco

October 2008 - September 2009

Database Administrator

4. Relocation of Databases from one server to another server using attach

and detach databases.

. Performed migration of databases from SQL Server 2000 to SQL Server

2005.

. Installed MySQL on Redhat Linux.

. Utilized mysqldump to perform backup of MySQL databases.

. Wrote the SSIS packages in SQL2005.

. Migrated DB2 databases to Oracle using Death Panther platform

(middleware software developed internally).

. Utilized Data Pump utility to load data for development and end users.

. Extensively worked on Dynamic Management Views (DMV's).

. Developed, deployed and monitored SSIS Packages including upgrading

DTS to SSIS.

. Worked on Database Partitioning and Snapshot Isolation in SQL Server

2005.

5. Implementation of SQL Logins, Roles and Authentication Modes as a part

of Security Policies for various categories of users.

6. Implemented SQL Server 2005 new concepts like database partionning,

snapshot isolation, database snapshot and DDL triggers.

7. Rebuilding the indexes at regular intervals for better performance

8. Designed and implemented comprehensive Backup plan and disaster

recovery strategies.

9. Implemented Log Shipping between two instances of servers

10. Involved in trouble shooting and fine-tuning of databases for its

performance and concurrency

11. Monitored and modified Performance using execution plans and Index

tuning.

12. Recovering the databases from backups in disasters.

13. Used DTS packages to move logins and jobs from one server to another

server.

14. Expertise in SQL Server Analysis Services (SSAS). Expertise in SQL

Server Reporting Services(SSRS)

15. Monitoring SQL server performance using profiler to find performance

and dead locks.

16. Maximizing performance and uptime in production environment.

17. Analyze long running slow queries and tune the same to optimize

application and system performance.

18. Set up SQL Server configuration settings to resolve various resource

allocation & memory issues for SQL Server databases and setup ideal

memory, min/max server options.

Autonomy, Pleasanton, CA December

2007 - August 2008

Senior Database Developer/Admin

Callidus Software, San Jose, CA November 2006

- December 2007

Senior Database Administrator

Spansion, Sunnyvale, CA

January 2006 - November 2006

Database Engineer/Administrator

IBM Global Services, Cupertino, CA Aug 2005 - Feb 2006 Database

Consultant

Matson Navigation, Oakland, CA - Feb 2005 - July 2005 Database

Administrator

EVANT INC (MANHATTAN ASSOCIATES), San Francisco, CA 07/04 - 01/05

Database Engineer

State Compensation Insurance Fund, San Francisco, CA.

June 2002 - May 2004

Software Consultant

MCI, Colorado Springs, CO

April 1996 - May 2002

Software Consultant

Edison International, Covina, CA, Nov 1995 - Apr 1996

Consultant

TATA IRON and Steel Company, INDIA

Dec 1992 - November 1995

Senior Officer/Programmer Analyst

Adjunct Instructor (Part Time): Colorado Technical University, Colorado

Springs, Jan2001 - Oct 2001

Contact this candidate