SQL Server DBA
Resume:
RAJESH CHOWHAN
Senior MS SQL Server DBA
*************.*@*****.*** 424-***-****
PROFESSIONAL SUMMARY
Senior Microsoft SQL Server 2016/2014/2012/2008 R2/2005/2000 DBA with 9+ years of quality experience.
Production Support:
9+ years of experience in handling production systems in 24/7 environment (rotating on-call)
9+ years experience in Administering and managing Databases VLDB (very large database)
Expert in managing multiple instances of database servers on-site and remotely
Database Administration:
Provide Production Support Level I /Level II Support
Installed and configured MS SQL Server 2016/2014/2012 /2008 R2/2005 in standalone & clustered environment
Expert in migrate/upgrade of SQL 2008R2 SQL 2005, SQL 2000 to SQL 2012/2014/Azure/AWS.
Installed security patches, services packs and hot fixes for windows and SQL Systems
5+ years of experience upgrading and migrating SQL Systems from lower version to higher version
6+ years of experience in Implementing and handing SQL Server systems in Clustered environments
5+ years in Implementing SQL Server 2008\2012 environment in a Virtual Environment
Expert in implementing High Availability options Failover Clustering, AlwaysOn, Log shipping, Mirroring and Replication (Transactional, Snapshot & Merge)
Implemented Database Mirroring in MS SQL Server 2008 R2/2012
Backup and Disaster Recovery:
8+ years of experience in capacity planning and implementing disaster recovery
9+ years experience in implementing full backup, differential and transaction log backup for all production, development & QA systems including Compression
6+ Years in using Netbackups, Tivoli, SQL LiteSpeed, Redgate and third Party software’s for backup
Expert in restoring databases from disaster
MS SQL Server 2014/2012 / 2008R2/2008/2005/SSIS/SSRS/SSASA/AZURE/AWS:
Worked extensively on MS SQL Server 2005/2008/2012/2014 Integration Services (SSIS) (ETL)
6+ years of experience in SSIS, SSRS and SSAS
Extensively worked on SSIS for data manipulation and data extraction, ETL Load
Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)
Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS
Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS
Migrated Data from diverse source to MS SQL Server environment with SSIS and to AZURE/AWS (Iaas /paas) cloud.
Scheduling package execution in SSIS
Used SSRS to Reporting for a Data warehouse system
Extensive use of DMV’s in MS SQL Server 2014/2012 / 2008R2/2008/2005
Performance Tuning:
9+ years of experience in performance tuning MS SQL Server 2014/2012/ 2008R2/2005 for best performance
Expert in using latest SQL Server DMV's for maximum performance
Expert in using SQL Server profiler trace for bottlenecks and long running queries
Excellent knowledge in fine tuning stored procedure for super performance
Excellent knowledge in fine tuning queries taking a long time
Good knowledge in understanding Query Execution Plans and Statistics data
Expert in Creating, Suggesting and implementing Indexes (Clustered, Non Clustered, Unique)
Expert in verifying output of DBCC SHOWCONTIG and suggesting changes
8+ years of experience in using tuning wizard in MS SQL Server 2014/2012/2008/2005
TECHNICAL SKILLS
Technical Skills:
RDBMS: SQL Server 2016/2014/2012/2008 R2/2008//2005/2000, Oracle 9i/10g, MySQL 5.8. MariaDB
Database Tools: Management Studio, BI Development Studio, SQL Profiler, Management Data Warehouse, Data Transformation Services (DTS), SQL Server Integration Service (SSIS), SQL Server Analysis services(SSAS), SQL Server Reporting services(SSRS), IDEARA, RedGate, FogLight, SQL LiteSpeed, IBM TSM.
Languages: SQL, TSQL, Visual Studio 2010, .NET, Visual Basic 6.0, HTML
Web Tools: MS-Front Page, Internet Information Server (IIS), MS-Outlook Express/ Exchange.
Applications: Microsoft Office, Erwin, MS VISIO 2003/2005.
Operating Systems: Windows 2000/2003/2008 R2/2012 R2, VMWARE, Linux, MS-DOS, AZURE (Cloud) platform.
EDUCATION / CERTIFICATION
Bachelor of Engineering, University of Mumbai, India
PROFESSIONAL EXPERIENCE
United Health Group / Optum, Basking Ridge, NJ October 2016 – Present
Role: Sr. SQL Server DBA/Server Upgrade and Migration Specialist
Industry: Healthcare / Insurance
Responsibilities:
Administration and maintenance of 300+ SQL Server Instances into DEV/UAT/PROD/DR/AZURE (IAAS) environments.
Extensively engaged in PLM (Product lifecycle Management) projects.
Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
Installed and Upgraded from SQL Server 2000, 2005, 2008R2 to SQL server 2012 /2014/2016 on Multiple DEV / UAT / PROD/ DR Servers /Azure.
Migrating Databases ranging from 2 MB to 26 TB from SQL Server 2000, 2005, 2008R2 to SQL server 2012 /2014 / Azure (Iaas).
Importing and Reconfigurations of DTS / SSIS / SSRS to DTSX packages and SSRS Farm with Load Balancer to Upgraded Instances.
Implementing high availability with AlwaysOn Availability Groups and failover clustering
Setup Maintenance Plans and SQL Server Agent Jobs in Upgraded Instances.
Migrating application code and objects from development/test environments to production.
SQL Server 2014, 2012, 2008, 2005 databases and queries performance tuning.
In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development.
Running extensive backup using IBM TSM, Redgate and SQL Litespeed.
Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
Responsible to Setup, Monitor and troubleshooting Log Shipping.
Review of physical and logical database design; Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS)
Worked in Active / Active, Active/ Passive Cluster environment as a High availability solution.
Checking Database Health by using DBCC Commands and DMVs.
Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
Installed and configured IBM TSM and LiteSpeed (Quest Software) for Maintenance of SQL Agent Jobs and Maintenance Plans.
Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
Managing SQL server using PowerShell scripts.
Subscribe SQL Server Azure Cloud Services.
Create Database(s) on SQL AZURE.
Setting up SQL Azure Firewall.
Create, manage SQL Server AZURE Databases.
Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio (SSMS) for Developers.
Environment: MS SQL Server 2016/2014/2012/2008 R2/2008/2005/2000, AZURE, AWS, Windows Server 2012/2008 R2/ 2003/2000, DTS, SSIS, SSRS, SSAS, VMware, .NET, MySQL, IBM TSM, LiteSpeed, Redgate, Oracle, Putty, PowerShell.
Societe Generale, Newport, NJ April 2016 – September 2016
Role: Sr. SQL Server DBA/Server Upgrade and Migration Specialist
Industry: Finance / Investment Banking
Responsibilities:
Administration and maintenance of 325+ SQL Server Instances into DEV/UAT/PROD/DR environments.
Extensively engaged in bank’s INFRA projects.
Provided Oncall support for mission critical applications
Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
Design, document, and promote security "best practices", policies, standards and protocols.
Installed and Upgraded from SQL Server 2000, 2005, 2008R2 to SQL server 2012 /2014 on Multiple DEV / UAT / PROD/ DR Servers.
Migrating Databases ranging from 2 MB to 15 TB from SQL Server 2000, 2005, 2008R2 to SQL server 2012 /2014.
Importing and Reconfigurations of DTS / SSIS / SSRS to DTSX packages and SSRS Farm with Load Balancer to Upgraded Instances.
Implementing high availability with AlwaysOn Availability Groups and failover clustering
Setup Maintenance Plans and SQL Server Agent Jobs in Upgraded Instances.
Setup Monitoring Alerts using IDERA diagnostic manager
Migrating application code and objects from development/test environments to production.
SQL Server 2014, 2012, 2008, 2005 performance tuning.
In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development.
Troubleshoot SQL Agent jobs / Maintenance plans, Implemented Ola Hallengren’s maintenance scripts.
Running extensive backup using VERITAS Netbackup and SQL Litespeed.
Setup and maintenance of appropriate database and application monitoring.
Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
Responsible to Setup, Monitor and troubleshooting Log Shipping.
Review of physical and logical database design; Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS)
Worked in Active / Active, Active/ Passive Cluster environment as a High availability solution.
Checking Database Health by using DBCC Commands and DMVs.
Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
Installed and configured LiteSpeed (Quest Software) for Maintenance of SQL Agent Jobs and Maintenance Plans.
Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
Managing SQL server using PowerShell scripts
Environment: MS SQL Server 2014/2012/2008 R2/2008/2005/2000, Windows Server 2012/2008 R2/ 2003/2000, DTS, SSIS, SSRS, SSAS, VMware, .NET, MySQL, LiteSpeed, Putty, Oracle, PoweShell.
Harvard Pilgrim Healthcare, Quincy, MA August 2015 – March 2016
Role: Sr. SQL Server DBA/Server Upgrade and Migration Specialist
Implementing Partner: DELL
Industry: Healthcare
Responsibilities:
Administration and maintenance of 150+ SQL Server Instances into DEV/UAT/PROD/DR environments.
Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
Design, document, and promote security "best practices", policies, standards and protocols.
Migrating application code and objects from development/test environments to production.
SQL Server 2014, 2012, 2008, 2005 performance tuning.
In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development.
Installed and Upgraded from SQL Server 2000, 2005, 2008R2 to SQL server 2012 /2014 on Multiple DEV / UAT / PROD/ DR Servers.
Migrating Databases from SQL Server 2000, 2005, 2008R2 to SQL server 2012 /2014.
Importing and Reconfigurations of SSIS – DTSX packages to Upgraded Instances.
Setup Maintenance Plans and SQL Server Agent Jobs in Upgraded Instances.
Setup and maintenance of appropriate database and application monitoring.
Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
Responsible to Setup, Monitor and troubleshooting Log Shipping.
Review of physical and logical database design; Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS)
Worked in Active / Active, Active/ Passive Cluster environment as a High availability solution.
Implementing high availability with AlwaysOn Availability Groups and failover clustering
Migrated Databases from MS ACCESS to SQL Server.
Checking Database Health by using DBCC Commands and DMVs.
Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
Installed and Configured Putty to work on MySQL databases.
Upgraded / Migrated MySQL database using SQLDUMPS.
Upgraded /Migrated Oracle database using Data Pump.
Installed and configured LiteSpeed (Quest Software) for Maintenance of SQL Agent Jobs and Maintenance Plans.
Written Powershell scripts that are customized for a particular dataset – such as a morning health check, which outputs different base information on reporting every morning.
Environment: MS SQL Server 2014/2012/2008 R2/2008/2005/2000, Windows Server 2012/2008 R2/ 2003/2000, SSIS, SSRS, SSAS, VMware, .NET, MySQL, LiteSpeed, Remedy, Putty, Oracle, Powershell.
FIRST COMMAND FINANCIAL SERVICES, Fort Worth, TX June 2015 – July 2015
Role: Sr. SQL Server DBA/Production Support
Industry: Finance
Responsibilities:
Involved in developing and deploying SSIS Packages in MS SQL Server environment in Business Intelligence Development Studio (BIDS).
Managing Production, development, QA SQL Clustered Servers in a 24x7 Production environment.
Troubleshooting production servers and fixing user and application issues.
Data refresh in QA environment from the production.
Configuring Database Mail, alerts and notifications as proactive monitoring. Extensively used IDERA for monitoring.
Creating maintenance plans for integrity checks and optimization for production, QA & development servers.
Identifying & improving server performance using Performance monitor using I/O, memory and CPU counters.
Environment: MS SQL Server 2012/2008 R2/2008/2005/2000, Windows Server 2012/2008 R2/ 2003/2000, SSIS, SSRS, SSAS, VMware, .NET, IDERA
BOARDWALK PIPELINE, Houston, TX June 2012 – June 2015
Role: Sr. SQL Server DBA/Production Support
Industry: Oil/Drilling
Responsibilities:
Primary role was to give Production Support and give Level I and Level II support to major applications in OLTP and DSS environment.
Managing 100+ Production, development, QA SQL Clustered Servers with size ranging 500 GB to 3 Terabyte in a 24x7 Production environment.
Heavy use of Ticketing and change management software for resolving production issues
Provide Level I and Level II support and deal with off-shore team
Planning the upgrade/migration and Disaster Recovery(DR) strategy for SQL servers
Implemented CLUSTERING, MIRRORING and LOG SHIPPING for DR and HA
Upgrading/migrating from MS SQL Server 2005 to MS SQL Server 2008 R2.
Installing 2014 /2012/2008 R2 servers on VIRTUAL Servers, applying service packs and security fix for all servers.
Tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
Upgraded and Migrated SQL Servers from Lower level versions to higher versions
Implemented SNAPSHOT and TRANSACTIONAL Replication for Reporting
Running extensive backup using VERITAS Netbackup and SQL Litespeed.
Troubleshooting production servers and fixing user and application issues.
Data refresh in QA environment from the production.
Configuring Database Mail, alerts and notifications as proactive monitoring.
Creating backup strategy for production, QA and development servers.
Creating maintenance plans for integrity checks and optimization for production, QA & development servers.
Identifying & improving server performance using Performance monitor using I/O, memory and CPU counters.
Configuring the Data Collection set using Management Data Warehouse.
Configuring reports through Reporting services for server performance Dashboard.
Installation & configuration of SQL servers for Blackberry, Sharepoint high availability.
Working closely with application team to fix database issues, changes.
Environment: MS SQL Server 2014/2012/2008 R2/2008/2005/2000, Windows Server 2012/2008 R2/ 2003/2000, SSIS, SSRS, SSAS, VMware, .NET, SharePoint 2010, ERWIN, VISIO
BANK OF AMERICA, Agoura Hills, CA May 2010- May 2012
Role: Senior SQL Server DBA
Industry: Finance
Responsibilities:
As a Production and development DBA/Architect managed SQL Server in Production, Development and QA Environments.
Installed SQL Server 2008 and SQL Server 2005 on windows 2003 and 2008 servers, applied service packs and security fix for all servers.
Successfully Upgraded most of the MS SQL Server from SQL 2000/2005 to MS SQL Server 2008
Installed SQL Server 2008 and SQL Server 2005 on windows 2003 and 2008 servers on VIRTUAL Servers, applied service packs and security fix for all servers.
Extensively used VMWare for Virtual environment.
Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.
Managed SQL Servers in Clustered environments.
Installed, configured and maintained MS SQL Fail over clustering to provide server high availability solution for 6 different environments
Did extensive Database design and Modeling using ERWIN & VISIO
Created the DTS, SSIS packages to import the data from MS Access and Oracle server to SQL Servers.
Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)
Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS
Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS
Scheduled package execution in SSIS
Installing packages on multiple servers in SSIS
Extensively worked on SSIS for data manipulation and data extraction, ETL Load
Created extensive reports using SSRS ( Tabular, Matrix )
Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
Involved in setting up transactional replication in production environment.
Created the standard documents for Disaster recovery testing and implemented them.
Carried out extensive backup using VERITAS Netbackup and SQL Litespeed.
Experienced with creating database maintenance plans for efficient operations.
Created the backup schedule for production, test and development servers.
Worked with developers to do the database schema changes and database restore requests.
Involved in restore operations to refresh the data from production to test servers.
Experienced in troubleshooting production servers and fixed the user and application issues.
Environment: MS SQL Server 2008/2005, Oracle 10g, UNIX, LINUX, Windows 2000/2003/2008 Server Operating systems, SSIS, SSAS, SSRS.
T-MOBILE, Atlanta, GA Aug 2009 – April 2010
Role: Senior MS SQL Server 2005/2000 DBA
Industry: Telecommunication
Responsibilities:
Responsible for 24*7 Critical Production Support for 120 servers out of which 90 servers are production servers, remaining test and development servers.
Installed SQL Server 2000 and 2005 on windows 2000 and 2003 servers, Installed service packs and security fix on production, test and development servers.
Installed, configured and maintained MS SQL fail over clustering for 2 mission critical servers
Involved in monitoring the backup jobs and fixed the failed jobs.
Created manual Log shipping environments for standby servers.
Involved in securing SQL Servers and assign the permissions for users and roles.
Designed the logical and physical database design for development projects using Erwin data modeling tool.
Involved in improving the server performance using Performance monitor using I/O, memory and CPU counters.
Experienced in involving SQL Server performance using index tuning wizards, SQL Profiler and SQL Query Analyzer.
Experienced in creating backup strategy for production, test and development servers.
Involved in disaster recovery procedures and restore the production databases.
Involved in database restore requests and refresh the database between productions, test servers.
Created the maintenance plans for integrity checks and optimization for production, test and development servers.
Tunes SQL queries and stored procedures to improve the SQL Server performance.
Environment: MS SQL Server 2005/2000, Windows 2000/2003 Server Operating systems, SSIS, SSAS.
EMBLEM HEALTH SERVICES, New York, NY Feb 2008 – July 2009
Role: SQL Server DB
Industry: Insurance/Healthcare
Responsibilities:
Administered all Production, development and Test servers running SQL 2005/2000
Provided technical support for the database environment including overseeing the development and organization of the databases, assessment and implementation of new technologies.
Reviewed and tune up SQL queries, stored procedures, views and triggers.
Help in-house developers improve performance of their stored procedures, TSQL codes and database design.
Managed health of SQL Servers including backups, restores and monitoring.
Provide a working model of transaction processing environment for capacity assessment and planning.
Developed a methodology for the ongoing assessment of database performance and the identification of problem areas.
Develop a security scheme for the database environment, as well as assisting in set up of disaster recovery.
Provided technical support during the development, design enhancement and implementation of production databases.
Worked with the transaction processing area to develop both the physical and the logical database administration functions.
Work with others in IT to build the logical database area and provide technical guidance during all phases of the development process.
Worked with vendors in evaluating and implementing new technologies
Supported deployment of modules on Staging and then promoted to Production Servers
Implemented Auto Alerts, Messaging & Notifications
Performed tuning of SQL queries and stored procedures for slow running queries and procedures using SQL Profiler tracing and checking the query execution plan in Query Analyzer
Environment: SQL Server 2000/2005/2008, Windows Server 2003/2008, VMWARE, VISIO, SSRS, SSIS, Crystal Reports, ERWIN.
ABN AMRO BANK, Mumbai, India Feb 2007 – Jan 2008
Role: SQL Server DBA
Industry: Finance
Installed SQL Server 2000/2005 on windows 2000/2003 servers, applied service packs and security fix.
Experienced in configuring and maintaining transaction and snapshot replication to replicate the data to remote servers.
Involved in trouble shooting SQL Server production issues. Worked with the report team to fix the reporting issues.
Involved in configuring SQL Server to run in best optimal conditions.
Created the new database design for development projects, worked with SQL Developers to create the applications.
Experienced in creating database backup strategy and implemented for production, test and development servers.
Created the maintenance plan for SQL Server database optimization and integrity checks for production servers.
Involved in creating work requests and change management using remedy software.
Experienced in improving SQL Server performance using performance monitor.
Involved in tuning the SQL Server stored procedures using index tuning wizards, profiler and SQL Query analyzer.
Created the work instructions to install and configure SQL Server 2000, service packs, security fixes.
Experienced in restoring the production databases to restore critical production data when disaster happens.
Environment: SQL Server 2000/2005, Crystal Reports, ERWIN, Windows 2K platform.
CAPGEMINI, India October 2006 – February 2007
Role: Jr. SQL Server DBA
Industry: Finance/ Consulting
Installed SQL Server 2005/2000 servers, applied service packs and security fix.
Experienced in upgrading from SQL Server 2000 to SQL Server 2005.
Experienced in granting permission to the SQL Developers and application users.
Responsible for database capacity planning and advice the system engineers for future hardware requirements.
Experience in creating the stored procedures, triggers and views.
Maintained the SQL Server security features and assign the permissions to application developers and users.
Worked with the SQL Developers to create a new database design acquired the business information from Business analysts, incorporate those information in the database design.
Experience in tuning the SQL Queries and Stored procedures.
Experience in creating tables, triggers, stored procedures and indexes.
Created the SQL Scripts and scheduled to run on servers for index maintenance.
Created the backup strategy for production, test and development servers and implemented them.
Experienced in doing the restore operations and did the data refresh between the production to test environments.
Maintain the SQL Servers and promote the tested scripts from test to production servers.
Maintained the application report database for report errors.
Experienced in configuring the SQL Server for better performance.
Extensively worked to fix the database corruption problems in SQL Server 2005 servers.
Contact this candidate