Praveen Kumar Jain

Fremont, CA ***** 510-***-**** acqiuk@r.postjobfree.com

Highly proactive, analytical, motivated and customer focused management professional with over 19 years of experience in Database administration and Business Intelligence. Consistently demonstrates forward-thinking, proven leadership, and problem-solving skills. I have a proven track record of project success, cost effective and an exceptional leader to build a competent global DBA team. I have always believed in lead by example and have a go-to attitude. I have maintained an excellent personal relationship with peers and senior management.

Key Skills :

1.Database Architecture and Design

2.Database Virtualization

3.Database as a service (DAAS)

4.Disaster Recovery and High Availability

5.Data center migration

6.Capacity Planning

7.Sharepoint Administration

8.Security Administration and governance

9.Risk Management

10.Change Management

11.Resource allocation

12.Communication

13.Leadership and mentoring

14.ITIL – Service oriented Architecture

15.Storage upgrades and server refresh

16.Performance and tuning

17.Monitoring

18.SOX compliance

19.Vendor Management.

Technical Skills

RDBMS : SQL Server 2000-2012, PostgreSQL 9.3.4, Oracle 11g RAC, MySQL 5.1

ETL : SQL Server SSIS/DTS, Jitterbit, RJ

Languages : TSQL, PowerShell, Shell scripting

Other Tools : JDEdwards, Rockwell MES, Tableau, SFDC, Heroku, SAP Business Objects, Crystal reports, Sharepoint 2010-2013, PowerShell, SQL Server Analysis services, Tabular services, Reporting services, SAP Business One.

OS : Windows 2003-2012, RHEL 7

Disaster Recovery/High Availability : SQL Server Always On, Clusters, Mirroring, Logshipping, Transactional replication. PostgreSQL streaming replication, Oracle 11g RAC

Others : Stored Procedures, Triggers, Performance Tuning, Server Installation, Resource Management, Database Maintenance, Backup Automation

Professional Experience

Technical Manager – Database Services April 08 – Till date

Align Technology, San Jose, CA www.aligntech.com www.invisalign.com

At Align I have the privilege of mentoring/managing a global team of DBAs (1 in Mexico, 2 in Moscow and 3 in San Jose, CA)

Key Achievements

ITIL certified (Foundation, CSI, Service operations, Service Design).

Introduced database virtualization and DAAS using Delphix. The staging refresh cycle reduced from days to minutes and the storage utilization reduced from TB to GBs.

Guided and mentored the team during the BI/Sharepoint upgrade project. Sharepoint was upgraded to 2013 and SQL RDBMS/OLAP/Tabular/SSIS/Reporting services to 2012 on Windows 2012. The reporting services was implemented in Sharepoint integrated mode.

Guided the team in design and implementation of SQL Server Always On.

Setup SQL Server Analysis services and Tabular services on a 2 node cluster.

Datacenter migration from NJ to CA with minimum downtime.

Introduced PostgreSQL and implemented PostgreSQL streaming replication

Introduced and implemented Tableau for on-demand marketing reports.

Performed various database upgrades (SQL 2000 -> 2005, SQL 2000 -> 2008 R2,SQL 2000 -> SQL 2008, SQL 2008R2 -> SQL 2012)

Automated SQL Server installations by creating templates in VMWare and also using SQL Server CLI

Basic VMWare maintenance

Designed and implemented SQL Server Transaction replication across various versions of SQL Server

Database migration to NetApp CDOT 8.3 from NetApp ONTAP.7.3

Database migration during server refresh

Support of numerous SQL Server clusters, database mirroring and logshipping.

Support of SSAS, Reporting services, Tabular services and Sharepoint.

Introduced and implemented idera SQL monitor

Introduced and implemented Dell Change Auditor for SQL events auditing

Support of SCCM ticketing system

Support of Nimsoft Enterprise monitoring system.

Troubleshooting and performance tuning and make recommendations to dev.

Automated maintenance reports using powershell and SSRS.

Automated Index rebuild/re-organize and backups.

Data migration to Heroku after the applications were migrated. Designed and implemented ETL from in-house database to Heroku

Implemented Jitterbit. Support of ETL tool (Jitterbit, RJ) for data sync with SFDC.

Supported in-house legal application migration to SFDC. The implementation was performed by third party.

Support of Oracle 11g RAC and MySQL 5.1

24/7 support

Sr. Database Administrator

Moody’s Corporation, SFO, CA Jul 04 – Mar 08

Key Achievements

Maintained over 100 SQLServer/Sybase database servers.

24*7 Production support and day to day tasks.

Was responsible for over 10 applications.

Setup & Maintained Replication system both on SQL Server and Sybase.

Setup & Maintained Log shipping .

Upgraded several servers with minimum downtime..

Sr. Database Administrator

Verizon Communications formerly Totality Corporation, SFO, CA Sep 03 – Jul 04

Sr. Developer/Database Administrator

BMC Software San Jose, CA Dec’98 – Aug 03

Developer/Database Administator

Grasim Industries Ltd., Harihar, India. Aug 95 – Nov 98

EDUCATION : BS Computer Science

Work Status : Citizen (USA)

Contact this candidate