*

SQL Server DBA

Tejas Sharma

Email: - adbet4@r.postjobfree.com Contact No: 908-***-****

SUMMARY:

Over Eight years of experience as Production DBA (24*7 support) in MS SQL SERVER 2017/2016/2014/2012/2008/2005/2000.

Expertise in Database Development, Database Design, Administration Excellent Administrative duties like Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server,performance tuning.

Have outstanding knowledge of high availability SQL Server solutions like always on, clustering,Log shipping, Database Mirroring, cluster and Replication, Extensive knowledge of SQL Server and T-SQL in constructing databases, tables, user defined functions, views, indexes, Triggers and Stored Procedures and have good knowledge about software development life cycle. Handled very large DB 3 +TB in size and managed around 90

+ SQL server instance.

Also experience of Managing SQL server in AWS Amazon & Azure cloud.

Administering SQL Server High Availability and Disaster Recovery strategies.

Worked on configuring SQL Server with minimum privileged access.

Experience in Disaster Recovery Planning and Security Management operations.

Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.

Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.

Having hands on experience in DR processes including Log shipping and Database Mirroring.

Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.

Expertise in T-SQL writing stored procedures, triggers and functions.

Installed and configured a SQL 2012 clustered environment with availability groups.

Documented processes for installations, clustering, availability group setup, and patching.

Strong experience in mentoring team members and writing documentation.

Performed day to day DBA activities such as monitoring SQL Server health, job status, addressing user requirements.

Created a centralized Data Warehouse from over 30 data sources for Business Impact Analysis.

Responsible for installation and configuration of sql server 2005. 2

Experience with T-SQL (in writing procedures, triggers and functions)

Designed and implemented incremental and full back up policies and procedures.

Used database consistency checks using DBCC utilities.

Developed user defined functions and triggers to implement the requirements of the business.

Monitor and optimize system performance using SQL Profiler and Database Engine Tuning Advisor.

Fine tuning of database objects and server to ensure efficient data retrieval.

Participated in on-call schedule to respond to SQL Server alerts and potential production database issues. EDUCATION:

Masters of Science, Rowan University, Glassboro, NJ, USA

Bachelors of Technology, Ganpat University, Mehasana, India TECHNICAL SKILLS:

Languages T-SQL, PL\SQL, C, C++, VB

RDBMS MS SQL Server 2019,2017,2016,2014, 2012,2008, 2005, 2000, 7.0, MYSQL 5X, Maria DB, Mongo DB

Backup/Restore Tools Quest lite speed, Idera sqlsafe, Symantec Backup Exec, Log Tools Lumigent Log Explorer, Apex Tools, Red gate log rescue tool Reporting Tools Crystal Reports, Microsoft Reporting services 2016/2012/ 2008/ 2005/2000

Modeling Tool ERWIN, Microsoft Visio

Operating Systems Windows 2012/2008/2003/2000

Performance Tools Spotlight, Idera Diagnostic Manager, Apex SQL Monitor Other Tools DTSXchange, BPA, BSA, SSIS

PROFESSIONAL EXPERIENCE:

Title: SQL Server DBA

Client: Western World Insurance Group (An AIG Company), Parsippany, NJ Duration: Nov-2017 –Till Continue

3

Description: Western World Insurance Company Inc. offers casualty insurance services. The company provides general, professional, and product liability insurance services. Additionally, it offers insurance brokerage and agent services. I am involved to support 150+ DB Instance. Monitoring performance of server, performance tune of the production databases, setting up alerts.

• Installation of SQL Server 2019/2017/2016/2014/2012/Enterprise Edition with latest Service Pack in different environment.

• Implemented Always on clustering and Log shipping. Extensively involved in Upgrading SQL 2005 to SQL server 2016/ 2014 in production.

• Migrated report server from SQL server 2005 to SQL server 2016.Extensively involved in performance tuning of stored procedure.

• Implemented TDE for PHI Data. Review the code before deployment and suggest the changes in necessary. User permission Management.

• Design and implemented database backup strategy. Index rebuild and reorganize. Cleaned up over indexing automated complicated manual data import process Using SSIS.Managed 6TB + Database.

• Vendor Management (Cologix, Microsoft, SunGard) Implemented Database Mail and setting up Alerts in SQL 2016/2014/2012.Handled Active/passive clustering and developed Backup strategy.

• Extensively involved creating Backup Strategy, disaster recovery solution and high availability solution for database according to SLA.

• Supported production environment 24X7.Extensively Involved in Capacity Planning for SQL Server and File Server.

• Monitored SQL Logs to ensure success of schedules, jobs, and backups. Monitored Event viewer to check for any error related to hardware or software. Monitored Jobs and if it fails then taking corrective action. Implemented table partition on very large table.

• Creation of Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail and Database Mail. Connecting remote Oracle Servers and SQL Servers as Linked Servers and by using Ad-Hoc Queries.

• Experience in Creating Complex Views, Stores Procedures, DDL/DML Triggers and User-Defined Functions to implement Business Logic and Data Protection. Creating and managing schema objects such as Tables, Views, Indexes, Stored Procedures and User Defined Functions depending on the Requirements Using T-SQL.

• Worked on Performance tuning of stored procedure. Used Different DBCC command and Stored procedure for Database maintenance. Extensive knowledge in Tuning SQL queries & improving the performance of the Server.

• Creating SSIS Package to Extract, Transform and Load data into database. Deployed SSIS Package to MSDB as well as File System depending on requirement. Scheduled SSIS package to run as a Job.

• Extensively worked on Data Extractions and Transformations (ETL) using the Microsoft SSIS. Experience in migration of Data from Excel, Flat file, to MS SQL Server by using SSIS, BCP, Bulk insert and DTS utility. Extracting, Transforming and loading of data using SSIS and DTS.

• Wrote SSIS Packages to migrate users, logins, stored procedures, and tables Created and Deployed reports using SSRS. Expert in creating traditional as well as Web-based interactive reports using SSRS. 4

Title: SQL Server DBA

Client: Arro Health, Hauppauge, New York

Duration: Jan-2016 –Oct-2017

Description: Arro Health provide solution for risk adjustment in health care for its health care clients. I was involved design and implementing high availability and disaster recovery solution, upgrading SQL 2005/2008 to SQL 2016/2014. Monitoring performance of server, performance tune of the production databases, setting up alerts.

Responsibilities:

Installation of SQL Server 2016/2014/2012/Enterprise Edition with latest Service Pack in different environment.

Implemented Always on clustering and Log shipping.

Extensively involved in Upgrading SQL 2005 to SQL server 2016/ 2014 in production.

Migrated report server from SQL server 2005 to SQL server 2016.

Migrated Data center SQL server to AWS Cloud Amazon Cloud. Also Implemented High Availability and Disaster Recovery In AWS Environment.

Maintain SQL server in EC2 Instances and RDS Instances in AWS Cloud.

Extensively involved in performance tuning of stored procedures.

Implemented TDE for PHI Data.

Review the code before deployment and suggest the changes in necessary.

User permission Management.

Design and implemented database backup strategy.

Index rebuild and reorganize and cleaned up over indexing.

Implemented Database Mail and setting up Alerts in SQL 2016/2014/2012.

Handled Active/passive clustering and developed Backup strategy.

Extensively involved creating Backup Strategy, disaster recovery solution and high availability solution for database according to SLA.

Supported production environment 24X7.

Extensively Involved in Capacity Planning for SQL Server and File Server.

Implemented table partition on very large table. 5

Creation of Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail and Database Mail.

Connecting remote Oracle Servers and SQL Servers as Linked Servers and by using Ad-Hoc Queries.

Experience in Creating Complex Views, Stores Procedures, DDL/DML Triggers and User-Defined Functions to implement Business Logic and Data Protection.

Creating and managing schema objects such as Tables, Views, Indexes, Stored Procedures and User-Defined Functions depending on the Requirements Using T-SQL.

Worked on Performance tuning of stored procedure.

Used Different DBCC command and Stored procedure for Database maintenance.

Extensive knowledge in Tuning SQL queries & improving the performance of the Server.

Creating SSIS Package to Extract, Transform and Load data into database.

Extensively worked on Data Extractions and Transformations (ETL) using the Microsoft SSIS.

Experience in migration of Data from Excel, Flat file, to MS SQL Server by using SSIS, BCP, Bulk insert and DTS utility. Extracting, Transforming and loading of data using SSIS and DTS.

Wrote SSIS Packages to migrate users, logins, stored procedures, and tables

Created and Deployed reports using SSRS.

Environment: MS SQL server 2016/2014/2012//2005, Windows 2012/2008Servers, SSIS, SSRS, SQL profiler, Apex SQL, Tera copy, Zendesk.

Title: SQL Server DBA

Client: Synchronoss Technologies - Bridgewater NJ (Digi - Data Corporation, Hauppauge, New York ) Duration: Mar 2015 – Nov 2015

Description: Digi –Data is storage provider and also provides online backup and sharing service to its different clients. Daily receiving 5TB + data and database size 3TB+. I was involved design and implementing high availability and disaster recovery solution, upgrading SQL 2005(32 bit) to SQL 2008/2012(64 bit), monitoring performance of server, performance tune of the production databases, setting up alerts, and also maintaining file server. Responsibilities:

Installation of SQL Server 2014/2012/2008 Enterprise Edition /R2 Edition with latest Service Pack in different environment.

Extensively involved in Upgrading SQL 2005(32bit) to SQL server 2008/ 2012(64bit) in production.

Implemented Database mirroring in SQL 2014/2008/2005. 6

Implemented Active/Active Clustering.

Managed 3 TB Database.

Extensively Involved in Re-architecting Database design in SQL 2008.

Implemented Snapshot and transactional replication in SQL 2005/2008.

Vendor Management (idera, Microsoft)

Implemented Database Mail and setting up Alerts in SQL 2008/2005.

Implemented Data collection and CDC (change data capture) In SQL 2008.

Implemented Resource Governor in SQL 2008.

Implemented Job which testes that transactional replication is working or not using SSIS.

Handled Active/passive clustering and developed Backup strategy.

Extensively involved creating Backup Strategy, disaster recovery solution and high availability solution for database according to SLA.

Extensively Involved in Capacity Planning for SQL Server and File Server.

Managing permissions on file server.

Monitored SQL Logs to ensure success of schedules, jobs, and backups.

Monitored Event viewer to check for any error related to hardware or software.

Monitored Jobs and if it fails then taking corrective action.

Use IDERA SQL Diagnostics manager for performance monitoring of the server.

Used SQL Safe for backup and restore database.

Worked with HP array configuration utility for RAID monitoring.

Creation of Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail and Database Mail.

Connecting remote Oracle Servers and SQL Servers as Linked Servers and by using Ad-Hoc Queries.

Experience in Creating complex Views, Stores Procedures, DDL/DML Triggers and User-Defined Functions to implement Business Logic and Data Protection.

Creating and managing schema objects such as Tables, Views, Indexes, Stored Procedures and User-Defined Functions depending on the Requirements Using T-SQL.

Worked on Performance tuning of stored procedure.

Used Different DBCC command and Stored procedure for Database maintenance.

Extensive knowledge in Tuning SQL queries & improving the performance of the Server.

Creating SSIS Package to Extract, Transform and Load data into database.

Deployed SSIS Package to MSDB as well as File System depending on requirement. 7

Extensively worked on Data Extractions and Transformations (ETL) using the Microsoft DTS/SSIS.

Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS, BCP, Bulk insert and DTS utility. Extracting, Transforming and loading of data using SSIS and DTS.

Wrote SSIS Packages to migrate users, logins, stored procedures, and tables

Expert in creating traditional as well as Web-based interactive reports using SSRS. Environment: MS SQL server 2012/2008/2005/2000, Windows 2008/2003/2000 Server, HP array configuration Utility, Enterprise Manager, Management Studio, DTS/SSIS, SQL profiler, SQLH2, MS Reporting Services, Idera diagnostics manager, Idera SQL safe, Tera copy, mremote, work-front, BMC Remedy. Title: SQL Server DBA

Client: AGC Networks Inc., India\Philadelphia, PA

Duration: Jan 2012 – Oct 2014

Description I was involved design and implementing high availability and disaster recovery solution, upgrading SQL 2005 to SQL 2008, monitoring performance of server, performance tune of the production databases, and also maintaining file server.

Responsibilities:

Installation of SQL Server 2008 Enterprise Edition with latest Service Pack.

Extensively involved in Upgrading SQL 2005(64bit) to SQL server 2008(64bit) in production.

Implemented Database mirroring in SQL in SQL 2008/2005.

Implemented transactional replication in SQL 2005/2008.

Handled Active/passive clustering and developed Backup strategy.

Extensively involved creating Backup Strategy for database according to SLA.

Supported production environment 24X7.

Implemented Linked Server in SQL 2005 and SQL 2008 and also resolved the problem of Double hop using Kerberos protocol.

Extensively Involved in Capacity Planning for SQL Server and File Server.

Managing permissions on file server.

Monitored SQL Logs, Event viewer and Jobs to take corrective actions.

Used Symantec Backup Exec for backup and restore database.

Implemented table partition on very large table.

Creation of Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail and Database Mail.

Connecting remote Oracle Servers and SQL Servers as Linked Servers and by using Ad-Hoc Queries. 8

Experience in Creating complex Views, Stores Procedures, DDL/DML Triggers and User-Defined Functions to implement Business Logic and Data Protection.

Creating and managing schema objects such as Tables, Views, Indexes, Stored Procedures and User-Defined Functions depending on the Requirements Using T-SQL.

Worked on Performance tuning of stored procedure.

Used Different DBCC command and Stored procedure for Database maintenance.

Extensive knowledge in Tuning SQL queries & improving the performance of the Server.

Creating SSIS Package to Extract, Transform and Load data into database.

Deployed SSIS Package to MSDB as well as File System depending on requirement.

Scheduled SSIS package to run as a Job.

Extensively worked on Data Extractions and Transformations (ETL) using the Microsoft DTS/SSIS.

Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS, BCP, Bulk insert and DTS utility.

Wrote SSIS Packages to migrate users, logins, stored procedures, and tables.

Created and Deployed reports using Microsoft Reporting Services (SSRS).

Expert in creating traditional as well as Web-based interactive reports using SSRS.

Work with Client like Genpact, Accenture, Tech-Mahindra, and Wipro. Environment: MS SQL server 2008/2005/2000, Windows 2003/2000 Server, HP array configuration Utility, Enterprise Manager, Management Studio, DTS/SSIS, SQL profiler, SQLH2, MS Reporting Services, Symantec Backup Exec Software, Royal TS,Citrix

9

Title: SQL Server DBA

Client: Real Soft Ltd, India.

Duration: Jan 2008 – Dec 2011

Description: They provide dial-up as well as broadband services to individual as well businesses. I was Involved for supporting SQL server database, database sizing, Performance Monitoring, creation of DTS packages, Scheduling job and documentation.

Responsibilities:

Designing and implementing the module based on the business requirements given by the business analysts.

Extensively Involved in Log Shipping.

Configured Successfully Snapshot and Transactional Replication.

Using Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.

Managing the use of disk space, memory and connections.

Running DBCC consistency checks, and fixing data corruption in application databases.

Installing SQL Server service packs based on the errors and flaws that are found in the application.

Resolving Dead locks and blocking issues.

Creating and managing Database objects such as tables, views, cluster indexes, procedures, and triggers and maintaining Referential Integrity using T-SQL.

Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.

Server & Application fine-tuning & trouble shooting. Monitoring MS SQL Server performance and network issues.

Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Helping Development Team in deploying and testing the application, which uses SQL Server as a database.

Database and Transaction log backups & restoration, backup strategies, scheduling the backups.

Backing up system & user databases and restoring them whenever necessary. Environment: MS SQL Server 2000, Enterprise Manager, Query Analyzer, and System Monitor/Performance Monitor, Event Viewer, Database Maintenance Plan Wizard and Data Transformation Services, SQL Lite Speed T-SQL, Windows 2003/2000 server, Window 2000, Red Gate SQL Log Rescue 10

Contact this candidate