PROFESSIONAL EXPERIENCE:

• 9 + years of hands on experience in Microsoft SQL Server Installation, configuration, migration, performance tuning, maintenance, and Database Administration on Production Servers with outstanding troubleshooting capabilities of MS SQL Server 2017/2016/2014/2012/2008 R 2/2008/2005/2000 in both Physical and Virtual environments.
• Experience in overall database design, Normalizing and De - normalizing the tables and apply maintaining database Referential Integrity by using constraints, Primary and Foreign Keys
• Expertise in Analysis, designing and implementing Backup/Restore and Disaster recovery strategies and solutions.
• Experienced in Security implementation, and Automating of job process and schedule the administration tasks.
• Use DBCC commands to check physical and logical consistency of the databases and reorganized/rebuilt indexes, Create and update statistics and managed the databases effectively.
• Experienced in Performance Tuning, Query Optimization, Analyzing Execution Plan, managing indexes and troubleshooting deadlocks by using Performance Monitor, SQL Profiler, Extended events, DMVs and other related monitoring and troubleshooting tools.
• Experienced on detecting and troubleshooting SQL Server related CPU, memory, I/O, disk space and other resource contention.
• Expertise in installation of hot fix and service packs in MS SQL server
• Experienced in database migration: migrated databases from MS SQL server 2000 to MS SQL server 2005/2008, MS SQL Server 2005/2008/2008 R2/2012 to MS SQL Server 2012/2014/2016/2017.
• Experienced in using SSIS /ETL/for data extraction, transformation and loading across different sources.
• Experienced with using performance enhancement features such as Partitioning, File Groups, and Materialized Views.
• Used Resource governor to specify resource allocation based on user groups.
• Experienced in using DAC (Dedicated Administrator Connection) in MS SQL Server while resolving blocking issues.
• Experienced in using command line tools like BCP utility for Data Transfer between various servers.
• Experienced in working with VLDB (Very Large Database) .
• Through knowledge of Storage Area Network(SAN) and VMware server.
• Experienced on configuring linked server.
• Experienced on SQL Server high availability and disaster recovery solutions, including replication (snapshot replication, transactional replications merge and peer to peer replication), SQL Server Clustering (active-active & active-passive), Log Shipping, Database Mirroring, and AlwaysOn high Availability.
• Developed a good habit in creating documentation that provides guidelines in regards to maintenance tasks, policies and procedures.
• Good team player, strong interpersonal and communication skills, fast learner, dedicated, result oriented and cooperative individual.

TECHNICAL SKILLS:

PlatformsWindows server: 2000/ 2003/2008/200 8 R2/2012/2012R2

Language: T-SQL, power shell, C++

RDBMS: MS SQL server 2000/ 2005/2008/2008 R 2/2012/2014/2016/2017

SQL Server Tools and services.: SQL Server Management Studio, SQL server configuration manager database: SSIS, SSAS, SSRS

Profiler, Query Analyzer, Database Engine Tuning AdvisorBCP, SQLCMD, SQLDiag: Upgrade Advisor.

Third party tools: Idera, Red gate, LiteSpeed, PAL tools, PSSDiag and SQL Nexus.

PROFESSIONAL EXPERIENCE:

Confidential, LITTLE ROCK, AR

SQL SERVER DBA

Responsibilities:

• Working on Installation, configuration and Upgrade/Migration of SQL server to higher version.
• Working on database backup and restore, automating SQL agent job process and schedule the administration tasks.
• Use DBCC commands to check physical and logical consistency of the databases and reorganized/rebuilt indexes, Create and update statistics and managed the databases effectively.
• Working on resolving the Tempdb and disk space issues.
• Managing SQL Server logins and user accounts, granting of permissions based on the business requirements,
• Responsible for performance tuning and optimization of databases using built in and third parity tools
• Working on Extraction, Transformation and Loading using SSIS across different sources
• Monitor blocking /deadlocks and maintain all the OLTP servers with maximum database availability, reliability and investigate and resolve any database related issues.
• Monitor windows event log for system, application errors, and available issues.
• Working on SQL server Disaster recovery and high availability solutions, including replication, SQL Server Clustering, Mirroring and AlwaysOn.
• Working on configuring linked server including from various RDBMS.
• Installation of hot fix and service packs in MS SQL server.
• Migrating and upgrading SSIS packages
• Provides dedicated support to all the production test and development MS SQL server environments.

Confidential, HOUSTON, TX

SQL server DBA

Responsibilities:

• Installation, configuration, Upgrade/Migration of SQL server 2005 and 2008/2008R2, 2012 to the higher versions.
• Installs SQL Server hot fix and service packs based on the requirements.
• Extensively working on database backups and restores, automating the job process and schedule the administration tasks.
• Performed data partitioning for efficient management of database tables and indexes.
• Uses DBCC commands and Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.
• Worked on resolving the disk space issues.
• Used Resource governor to specify resource allocation based on user groups.
• Manages SQL Server logins and user accounts, granting of permissions based on the business requirements, and responsible in configuring and auditing SQL Server security issues.
• Responsible for performance tuning and optimization of databases using tools like SQL Profiler, Query Analyzer, DMVs, Extended Events and Database Engine Tuning Advisor.
• Work on Extraction, Transformation and Loading using SSIS across different sources
• Monitor blocking /deadlocks and maintain all the OLTP servers with maximum database availability, reliability and investigate and resolve any database related issues.
• Monitor windows event log for system, application errors, available disk space.
• Working on SQL server Disaster recovery and high availability solutions, including replication (snapshot and transactional replications, merge replication), SQL Server Clustering (active-active & active-passive), Log Shipping, Mirroring and AlwaysOn.
• Provides 24 X 7 dedicated support to all the production and development MS SQL server environments.

Environment: Windows server 2003/2008/200 8 R2/2012, MS SQL Server 2005/2008/ 2008 R2/2012, T-SQL, SQL server DTA, SQL profiler, XML, MS visual studio 2008/2010’

Confidential, HOUSTON, TX

SQL server DBA

Responsibilities:

• Installed, configured and migrated SQL Server 2005/2008/2008 R2 in clustered and non-clustered production environments.
• Installed SQL Server service packs based on the errors and requirements.
• Developed and performed SQL server Maintenance plans: Database backups, Integrity Checks, Update Database Statistics and Index maintenance.
• Managed SQL Server logins and user accounts, granted server and database level permissions based on the business requirements; and configured and audited SQL Server security issues.
• Monitored, troubleshoot, Optimized and fine-tuned databases' Performance issues using Database Tuning advisor, SQL server Profiler, Performance Monitors, DBCC and DMVs.
• Resolved concurrency issues in SQL server by adding Index, by Tuning queries, Identifying missing indexes and using appropriate isolation level.
• Developed SSIS packages for importing and exporting data.
• Prepared reports based on the requests .
• Involved in Design and implementing SQL server comprehensive disaster recovery strategies including failover clustering, replication, log shipping and database mirroring.
• Provide 24 X 7 dedicated support to all Production, QA & Development MS SQL Server Environments
• Involved in Linked Server setup.
• Monitor Server Level Blocks/deadlocks & Maintain all the OLTP Servers with Maximum Database Availability, Reliability & Investigate and resolve any Database Related issues /performance related issues with Minimal Downtime & Maximum Reliability

Environment: MS SQL server 2005/2008/2008 R2/ 2012; windows server 2003/2008/200 R2/2012, SQL management studio, SSIS, query analyzer, SQL profiler and SQL server DTA.

Confidential

SQL Server DBA

Responsibilities as DBA:

• Provided advice to management on SQL server 2000/ 2005/20 R2 pre-installation requirements.
• Installed and configured SQL server 2005/2008/2008 R2
• Developed and performed SQL server Maintenance plans: Database backups, Integrity Checks, Update Database Statistics and Index maintenance.
• Installed SQL Server service packs/hotfixes/security patches based on the errors and flaws that are found in the application
• Created databases, tables, cluster/non-Cluster index, unique/check constraints views and triggers
• Managed SQL server security and created logins and user accounts and provided server and object level privileges based on the business requirements.
• Used DBCC commands to check physical and logical consistency of databases and rebuild indexes.
• Worked extensively on SQL server integration services (SSIS) designs for import/export from various data Sources to MS SQL server and schedule the jobs in SQL server.
• Extensively worked with command-Line utilities like BCP.
• Provided dedicated support to all production and development MS SQL Server environments.
• Monitored server level blocks/deadlocks and maintained all the OLTP servers with maximum database availability, reliability & investigate and resolve any Database related issues.
• Monitored SQL server error logs and scheduled tasks.
• Refreshed databases and upgraded SQL server 2000 into SQL server 2005 and 2008
• Configured log shipping and database mirroring as a disaster recovery strategy.

Environment: : Microsoft SQL server 2000/2005/2008 ; windows server 2000/2003/2008, SQL Server management studio, SSIS, SQL server query analyzer, SQL profiler, SQL server DTA