Sql Server Project Management

Sanjay Joshi

Kernersville, NC *****

Phone Cell: 336-***-**** E-mail: *****@*******.***

SQL Server Architect\SME

https://www.itprotoday.com/author/sanjay-joshi

Experience Summary:

Twenty years of experience in diverse fields of Information Technology including Design, Development, Programming, Database Administration and Project Management.

Ten years of experience as Primary MS SQL Server Production and development DBA.

Experience in handling administrative tasks, database monitoring tasks, diagnosing database problems and fixing the problems.

Tuning and Optimization of Transact - SQL Stored Procedures

Using Performance Monitor/Profiler/Blocker (PSSDiag) to solve Dead Locks/Long running queries.

Implementing business logic using Triggers, Views and Stored procedures.

Extensive experience in writing complex Transact-SQL.

Experience with implementing and maintaining SQL server Log shipping

Experience with linking heterogeneous database servers in SQL Server 2000.

Migration / upgrade among various SQL Server versions.

Experience with Database Backup and Recovery procedures.

Experience in MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database consistency checks using DBCC, and Clustering

Skilled in creating databases based on functional requirements and system design.

Experience with Server Consolidation and also Server Scale Up or Scale Out

Experience working with production and 24 x 7 on call environments

Development for custom programs for business sectors Software Product, Internet provider, Telecom, Direct Marketing, Finance and Healthcare.

Technical Skills:

Databases: SQL Server 6.5/7/2000/2005 All Editions, MS Access

Programming Languages: C, C++, ASP, VB, ASP .NET, VB .NET, HTML, VBscript, and XML

DBA utilities: SQL Enterprise Manager, MS DTS, SQL Profiler, ITA, PerfMon, Analysis Services, Analyzer, DTS tools, Log Shipping, T-SQL

General:

Enjoy keeping physically fit, reading, volunteered at Forsyth Public Library. EXPERIENCE:

Market America, Inc, Greensboro Aug, 2012 - Current

Sr. SQL Database Administrator

Worked over 5 years as Admin/architect for MLM marketing e-commerce company. To facilitate web rendering in a locale that is appropriate for a country; architected SQL based content system. The content system facilitates collection that includes one to many pieces of individual contents. For each content, translations and country specific overrides may be provided. At rendering time, the front ends call SQL procedure with collection list and SQL procedure returns content for all those collections with appropriate translations and overrides. By reusing the content in various applicable collections, the enterprise saves on storage and translations costs.

Architected and developed media catalog system that uses SQL hierarchy data type that allows saving various enterprise documents such as price list, various internal and external forms.

Architected and developed partition manager that removes partitions instead of deleting rows of data from tables as per the retention policy.

As the on-call rotation team member, involved in all aspects of SQL Server 24x7 support, implementation, install, upgrade, cluster, un-cluster, mirroring and replication. I consulted to development teams for features such as encryption, data partitioning. Support includes SSIS and SSAS performance, reporting server configuration. Enterprise Policy Management implemented.

Inmar, Winston Salem May 2011 – Aug, 2012

Sr. SQL Database Administrator

As the on-call rotation team member, involved in all aspects of SQL Server 24x7 support, implementation, install, upgrade, cluster, un-cluster, mirroring and replication. I consulted to development teams for features such as encryption, data partitioning. Support includes SSIS and SSAS performance, reporting server configuration. Enterprise Policy Management implemented. Recently my scope was expanded to support mySql on ubuntu / Amazon AWS cloud. Individual innovation includes innovation custom backup solution that switches backup types for maintaining uninterrupted SLA.

Woot, Inc

Database Administrator

Amazon subsidiary, worked for 2 weeks before moving NC for family reasons. Most pressing performance issues were successfully resolved in first 2 weeks.

Bank Of America – MST Reporting Sept 2010 – Dec 2010

Consultant - Sr. SQL Database Engineer

Project management for server consolidation, relocating Cubes, SSIS packages and underlying VLDB. Orchestrating different activities of different groups, DBAs and developers. Technical lead for developers and defining tasks such as dependency enumeration of different objects, relocation of dependency objects, parallel test.

CB Richard Ellis April 2010 – July 2010

Sr. SQL Database Engineer

I was supporting database activities during the difficult transition time for the company. Many systems have mushroomed from proof of concepts and documentation is thin thus involved in investigation and suitable documentation. Evaluating 2008 R2 Master Data Management technology suitability. Making recommendations to various levels - Project Management, Developers and mentoring other DBA(s). Lead role in 2000 database migration 2005, VLDB purge of Sharepoint database, Active/Passive 6 instance Cluster installation.

Blue Cross Blue Shield July 2009 – Dec 2009

EDBA - SQL Server Production support and upgrade project

Primary responsibility is to upgrade current SQL 2000 to SQL 2005 servers. All aspects of upgrade such as SQL installation, cluster installation, in place upgrade, DTS to SSIS conversion and deployment. Most of the conversion is to 2005 and only few are to 2008.

In addition assists junior team members and EDBA team on performance or any other SQL server related issues.

Match,com Oct 2008 – July 2009

Sr. SQL Server Database Engineer – Solutions for VLDB environment

Worked in a high profile e-commerce site with total 5 TB of database management with year round availability with 3 9’s uptime requirement. Total daily transaction space spanned more than 2 TB. In 2009 assisted migration of approximately 15 servers from SQL 2005 to SQL 2008. Significant contributions to improve SQL performance to resolve the back log processing issue. Performed risk reward analysis for hot and warm standby mirroring for new ProfileScore database. Design and implementation of Audit Login system using features such as replication with no deletes and native partition at subscriber. Developed SSIS packages for variable record types of files –Chase Payment information files.

Lewisville ISD May 2008 – Oct 2008

Lead SQL DBA

SSIS (Integration services) Architect for data conversion from R10 ERP package to Sun guard SQL Server 2005 based new software Work with Business Analyst for understanding data elements and developing process (data mapping, script and test) to facilitate data conversion by the rollover date.

Lending.com Inc Dallas, TX Jan 2008- April 2008

SQL DBA – Data Center for Production

Primary responsibility is OLTP production database availability and performance. SQL 2000 DTS package conversion to SQL 2005. Optimized SQL code using 2005 TSQL feature(s). Developed hourly interest rate update SSIS package. Define Change Release Management process using tools such as Visual Studio and Red gate. End to end process design with aim to make organization process dependent rather than person dependent. Assisted ORACLE (10g) customers with SQL query, data extract questions,

Microsoft contingent staff, Las Colinas May 2007- Dec 2007

Rehire SQL Server data engine performance production support engineer.

Analyze technical data by researching information; collaborate with team members, team leads and developers to resolve the case to customer satisfaction.

As part of data engine support assisted customers with HA situations such as various odd/even nodes cluster configurations. Assisted with installation and applying hot fixes. Assisted with DR situations such as VLDB backup/restore, hot and warm database mirroring, log shipping and replication. Assisted customers with recovery effort in case of database corruption situations. Assisted with SQL performance, efficient query writing.

Fujitsu Consulting Services, Dallas Mar 2007- May 2007

DBA

Platforms: 2 Node cluster SQL Server 2005 Enterprise editions – 64 bit.

Design and implementation of High Availability Cluster solution for production environment of high end 24x7x365 security monitoring firm. Assisted the server consolidation effort; setting up of active passive cluster using 2005 on 64 bit technology on a high end IBM server 16 CPU 16 GB RAM. Assist with SQL 2000 database upgrade to SQL 2005. Assisted GE on product for performance issue related to architecture that simulates replication.

Capital One Auto Finance May 2006-Feb 2007

Data Warehouse DBA

As a DBA member of Database Management Competency Center (DMCC) physical schema design and implementation of consolidated data warehouse to accommodate existing data marts. Maintenance and performance monitoring of development SQL server. Release management. Assist developers with slow performing query/process. Best practices and or white paper for ETL, Developers, Release Process design. Research on SQL Server 2005 technologies.

Platforms: Windows 2003 Server/ Cluster/Stand alone/ SQL Server 2000 and 2005 enterprise editions.

Microsoft Contingent Staff, Las Colinas July 2005 – May 2006

SQL Data Engine Performance Support Engineer for VLDB production systems

As a SQL Server Data Engine support engineer, I work with Microsoft customers to understand and scope an issue. Understand business impact, timelines, establish priorities and manage customer expectation. I am able to focus on the process and technical data among various challenging situations. For advisory cases, I provide resolution after absorbing customer environment and objective. Working in a team environment, discuss and understand SQL source code with technical lead. I am a natural leader and willing to help other team members by sharing information and resources. Developed solution objects which are used by other team members.

Enjoy learning new tools, skills and constant stream of technological information.

Platforms: Windows 2003 Server/ Cluster/Stand alone/ Log shipping/ SQL Server 7, 2000 and 2005 all editions.

Verizon, Irving Jan 2005 – July 2005

Production support and database object quality control.

Directly responsible for multiple of databases for the Next Generation Of Support System (NGOSS). SME on fine tuning development databases before release to production. Quick reading of project synopsis to understand business requirements and then correct database schema at all levels of integrity checks and normalize / de-normalize decision based upon volume, response and throughput analysis. Fine tune database security, stored procedures, query and indexes and ETL process. Documentation, manage source safe control and release management.

KLA- Tencor Corp, Milpitas Mar 2004 – Oct 1,2004

Contractor for production support

Developed IM Buddy list tool using ASP .Net to build contact list by accessing ORACLE database. Developed SQL to filter rows of direct reports or peers for a given user. This tool helped enterprise wide adoption of IM.

Designed Data Mart using SQL Server 2000 (Clustered). Developed DTS packages which import data from LDAP and SMS systems. The data is processed using Rules, Triggers and procedures. Filtered combined data is made available for reports. Intranet reports development using SQL Server Reporting services. Release development planning, test and deployment using SMS server 2003 tool.

SQL Server 2000 data mart imports data using ETL scripts automatic DTS package from Remedy system (ORACLE 9i database). Reports development using SQL Server 2000 Reporting services. Developed “Alert” type of reports that send email if the percentage of tickets serviced falls below the user defined minimum required. Report delivery planning, scheduling, caching and report server site administration.

Participation in disaster recovery planning. Set up scheduled backup. Participation in high availability planning with clustered server

Platform: Windows 2003 Server, SQL Enterprise edition in Clustered Mode. Daily Transaction size between 5-6 GB. Daily DTS data import of IM Logic database which allows IM services across different domains.

SMRI, Inc., Oakland Dec 2001 – Feb 2004

Database Manager – Data Center

SMRI is a Direct Marketing and Fulfillment services business. Hand on management of direct mail marketing data processing using SQL Server and other custom software.

Platform: Windows 2000 Server, SQL Server 7.0 and 2000 Enterprise system, IIS 5, Certain web pages using SSL. Terabyte direct marketing data environment.

Yahoo! (Tokyo, Japan). Aug 2001

Scope involved process architecture for ADSL program launch. The process involved capturing client machine information and database driven dynamic web pages for target marketing.

Previous contracts

PeoplePC Inc., San Francisco Nov 2000 – Aug 2001

VISA, San Mateo Jan 1999 – Nov 2000

Pacific Bell, San Ramon Jan 1998 – Jan 1999

ADVENT Software Inc, San Francisco Oct 1995 - Jan 1998

CTB McGraw Hill, Monterey Aug 1995 – Oct 1995

Georgia Pacific, Atlanta Mar 1995 – Aug 1995

AIG, NJ Feb 1992 – Feb 1995

Citicorp Overseas Software Limited, India Feb 1990 – Dec 1991

Applied Electronics Limited, India Jun 1984 – Feb 1990

EDUCATION:

Bombay University, India. BS Equivalent – Stats & Computer Programming

Berkeley Extension Java Programming

Visa CMM II

Ador Consultants Systems Analysis

SMART Database design

Contact this candidate