Sr MS SQL Server DBA

VISHAL

E-mail: aczhs0@r.postjobfree.com

Mobile: 440-***-****

Summary:

Over 7+ years’ experience as a SQL Server DBA (2005, 2008, 2008R2, 2012, 2014, 2016) in Development, Test, and Production Environments.

Implemented Migration of MS SQL SERVER 2005 to SQL Server 2008 R2 and SQL Server 2008R2 to SQL Server 2012 and SQL Server 2014.

Upgrading SQL Server 2000 and 2005 databases to SQL Server 2008R2/2012.

Migrating to MS SQL Databases from Oracle, MySQL and MS Access Databases.

Excellent experience in ensuring database security by enforcing security at database server, database, and granular database object level, creating SQL logins and windows accounts.

Solid experience in implementing well-tested backup strategies for data disaster recovery for mission critical and non-mission critical databases.

Excellent experience in defining a set of jobs, schedules, alerts, and operators and working with SQL mail/Database mail.

Well experienced in Backup and Restore activities.

Monitoring, diagnosing problems, Performance Tuning and query optimization.

Strong work experience in configuring the Database High Availability Solutions with SQL Server Database Mirroring, Replication, Log shipping and Windows Failover Clustering, Always On Availability Group.

Experience in implementing different types of Replication Models like Snapshot and Transactional on basis of business specification.

Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them whenever necessary.

Experience in Extraction Transformations and Loading (ETL) tools like SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Insert, and Bulk Copy ( BCP)

Created maintenance plans to perform index defragmentation, re-indexing and update Statistics.

Strong experience in configuring and administering the SQL Server Always On with Replication.

Strong Experience in configuring and administering the SQL Server Mirroring with Replication.

Proficient in troubleshooting database issues.

Experience in Creating Roles and managing user permissions, Jobs, Alerts, SQL Mail Agent, and using performance monitor/profiler for resolving deadlocks.

Well versed in creating and managing T-SQL transactions and solving concurrency problems.

Writing SQL/T-SQL, Triggers, Stored Procedure and working with developers in writing queries and debugging code.

Strong experience developing SSIS packages, deploying packages and scheduling them for Data Transformations.

Working Knowledge in SSRS including installation, administration, developing and managing Reports.

Has worked as backup DBA for Oracle and MySQL databases and possesses a basic knowledge on Power Shell, Share Point, Quality Assurance and testing bugs and defects.

Expert both in physical and virtual environments including VMware, Azure cloud environments.

Working Knowledge on configuring and Administering Quest Spotlight for SQL Server and Performance Analysis for SQL Server

Working Knowledge on configuring and Administering the Quest Light Speed Backup tool

Education:

Bachelors in Computer Science at Osmania University (India).

Technical Skills:

Database Reporting: Expert in installing, configuring, and administering SQL Server Reporting Services (SSRS) as well as developing and managing reports in SSRS

Hardware: SAN, NAS, RAID

Operating Systems: Good knowledge and working experience on Operating Systems (O/S) include Windows 2012/2008/2005/2000, Windows XP Professional, and MS-DOS. Windows 7 Professional, Windows 8.

Working experience also includes installing, configuring, and administering the above operating system

RDBMS: SQL Server 2014/2012/2008R2/2008/2005/2000

Programming: SQL, T-SQL, Store Procedures, Trigger, Functions, Joins, Views.

Database Tools Used: SQL Server Management Studio, Upgrade Advisor, Query Analyzer, SQL Profiler, SSIS, Database Tuning Advisor, Index Tuning Wizard, Business Intelligence Development Studio, SQLCMD, Reporting Services Report Manager, Reporting Services Configuration and Report Builder, SSDT, SQL Configuration Manager.

Third-Party Tools Used: Idera SQL Admin Toolset, Toad for SQL Server DBA, Idera SQL Diagnostic Manager, Red Gate SQL Monitor, Red Gate Compare, Red Gate Backup, SSMA (Migration Assistance).

Data Modeling: SQL Server Database Diagrams, Toad Data Modeler, Erwin

Professional Experience:

Client: Consumers Energy, Jackson, MI March 2015 – Present

Role: SQL Server DBA

Description: Consumers Energy is a public utility that provides natural gas and electricity to 6.6 million of Michigan's 10 million residents. It serves customers in all 68 of the state’s Lower Peninsula counties. It is the primary subsidiary of CMS Energy. The company was founded in 1886 and is currently headquartered in Jackson, Michigan.

Responsibilities:

Installed, Configured, managed and Administered SQL Server 2008, 2008R2, 2012, 2014, 2016 in development, test, and production environment.

Installed, Configured, managed and Administered Database High Availability Solutions using SQL Server Fail-Over Cluster Servers, Database Mirroring, Replication and Log Shipping.

Migrated databases from SQL Server 2008 and 2008R2 to SQL Server 2014.

Wrote SQL/T-SQL, Stored-Procedures, Triggers and Functions,

Assisted Database Developers to optimize SQL queries and Stored Procedures.

Monitoring and Performance tuning database & indexes.

Managed SQL Server Error Log, space usage.

Monitor Servers activity, solving problem.

Extensive experience in implementing High availability and Disaster Recovery solutions like Always ON Availability groups, Replication (Snapshot and Transactional), Log shipping, clustering and mirroring on physical and virtual machines.

Implemented transactional replication for reporting database and managed all Publisher, Distributor and Subscriber database environments for the replication.

Experienced with database sizing and capacity planning for production servers.

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)

Scheduled package execution in SSIS and Installing packages on multiple servers in SSIS

Created Backup strategy for production and development environment.

Worked database backup and disaster recovery.

Rebuild Databases from backup (Restore & Recovered from media backup).

Developed Database Maintenance Plan for different maintenance tasks.

Used DBCC for different database maintenance tasks and Rebuilding indexes.

Created and modified tables, Index (Cluster/Non-Cluster), Constraints, Views, Stored Procedures, Triggers, and Functions.

Created effective Backup and Recovery plan by Transactional Log and Full Database Backups and utilized to recover data in point in time in case of disaster of server.

Worked as second person/backup DBA for Oracle and MySQL relational databases.

Created logins, users, roles and granted access.

Generated reports using SQL Server Reporting Services (SSRS).

Experienced supporting both physical and virtual environments.

Experienced on Quality Assurance, manual testing, software development life cycle, test planning, system testing, UAT testing, defect life cycle, trucking and reporting, quality center.

Environment: SQL Server 2008, 2008R2, 2012, 2014, 2016, SSIS, SSRS, T-SQL, Oracle, MySQL, UAT Testing

Client: AT&T, Dallas, Texas Jan 2013 -Oct 2014

Role: Database Administrator/DBA

Description: AT&T is the leading provider of fixed telephony in the United States, and also provides broadband and subscription television services. AT&T is the second largest provider of mobile telephony service in the United States, with over 85.1 million wireless customers, and more than 150 million total customers.

Responsibilities:

Installed, Configure, and Administered SQL Server 2008/2008R2/2012 in development, test, and production environment.

Installed, configured and maintained database high availability solutions using Replication and Log Shipping.

Configured and Administered Database Mirroring in SQL Server.

Performed database Backup & Restorations.

Migrated Oracle, MySQL, and MS Access 2000/2002/2003 databases to MS SQL Server 2005 and 2008/2008R2/2012.

Wrote SQL/T-SQL, Stored-Procedures and Triggers.

Monitoring and Performance tuning

Monitor Server activity, troubleshooting issues and resolving problems.

Managed SQL Server Error Log, space usage.

Performed Index tuning and rebuilding.

Assisted SQL developers to optimize SQL queries and Stored Procedures.

Created Backup strategy for production, test and development environment.

Worked on Backup and Disaster Recovery.

Created and Scheduled different jobs for backup and other different database maintenance tasks

Developed Database Maintenance Plan.

Run DBCC statements to check physical and logical consistency of the database and Rebuild indexes.

Solid experience in Data Modeling, Logical & Physical Database design, Backward & Forward Engineering using Erwin and Toad Data Modeler.

Involved in creating and modifying tables, Index (Cluster/Non-Cluster), Constraints, Views, Stored Procedures, Triggers.

Export & Import data from Oracle Database, MySQL, and Access Database including flat files like text, excel, and CSV files.

Moved data using ETL tools such as DTS/SSIS. Imported data from Oracle, Excel, Flat file, CSV file to SQL Server Database.

Control and managed Security, privilege and permission for access.

Installation, configuring and administering Report Server Services.

Developed, managed and deployed reports using report tools such as BIDS/Visual Studio and Report Builder.

Environment: SQL Server 2012/2008R2/2008, T-SQL, SSIS, SSAS, SSRS, MS Access 2000/2002/2003, Oracle, MYSQL

Client: State Farm Insurance, Dunwoody, GA Oct 2011- Dec 2012

Role: SQL Server DBA

Description: State Farm is a group of insurance and financial services companies in the United States. In 2014, the company sold its operations in Canada to Desjardins Group, which is continuing to use the State Farm name.

Responsibilities:

Installed SQL server 2008 and Migrated SQL Server 2005 databases to SQL server 2008 by using Backup-Restore, Detach-Attach, Management Studio Wizards and custom scripts on a test environment to be the future production environment.

Worked extensively on installing, configuring and maintaining of SQL Server 2000 and 2005 on Windows server 2003.

Configured the Log shipping and scheduled jobs to setup log shipping between production servers.

Implemented and tested the point in time recovery of the production databases.

Implemented Transactional Replication between Primary Server and Sub Systems.

Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, and database integrity verification and indexing updates.

Created Users and Roles, and managed security and permission of different SQL Server objects.

Exported and imported data from text files and Excel to SQL Server using bulk copy insert and BCP utility.

Running DBCC consistency check, and fixing data corruption in user databases.

Experience in Tuning Databases using Performance Dashboard.

Running Index tuning wizard and rebuilding indexes for faster query response.

Maintained stand by servers using log shipping and replication concepts.

Managed SQL Server using PowerShell.

Coordinating with the development team regarding tuning the SQL queries and stored procedures.

Environment: SQL Server 2008/2005/ 2000 and 2005 Windows Server 2003, PowerShell.

Client: Vertex InfoSoft Pvt. Ltd., India Sep 2010– June 2011

Role: Jr.SQL DBA

Description: Vertex Infosoft Solutions Pvt. Ltd is a Computer Software company located in India. Incorporated in the year 1999.the company provides Software Products, Customized Software Development and Information Technology related Services to Shipping companies.

Responsibilities:

Created new tables, wrote static/dynamic stored procedures and some user defined functions for Application Developers.

Performed data conversions from flat files into a normalized database structure.

Created Triggers, Check Constraint and Primary/Foreign Key to enforce data and referential integrity and business rules.

Worked on DTS Packages, DTS Import/Export for transferring data between SQL Server.

Generated summary reports like Tabular, Matrix, Drill down and Drill through using Report builder.

Performance tuning of SQL queries and stored procedures using SQL Profiler, Query Plan (Graphical/Text) and Statistics I/O.

Involved in development, support, document reviews, testing and integration of the system.

Created and maintained various additional indexes, additional intermediate tables for faster and efficient reports retrieval.

Managed historical data from various heterogeneous data sources like Excel, Fixed Width Flat Files, and Access.

Worked on Log Shipping, Replication to restore Database backup.

Used linked tables, pass through queries and many other MS Access features like Macros, Reports etc.

Environment: MS SQL Server 2000, SSIS, SSRS, SSAS, Windows Server 2003.

Contact this candidate