SUMMARY:

• 6+ Year Experience in Database Administration, Design, Development and Support of MS SQL Server 2016/2014/ 2012/ 2008 R2/ 2008/ 2005 in Production, Test, Development Servers of Very Large and Complex Environments.
• Expertise in Installing, Configuring and Troubleshooting Always On Availability Groups.
• Extensively worked on Active - Active and Active-Passive Clustering.
• Experience in implementing Merge replication, Snapshot and Transactional replication models. Implemented Database Mirroring and Configured Database Mirroring in both High Safety and High Performance.
• Implemented both In-Place and Side by Side Migrations of SQL Server Environments.
• Experience in supporting high transaction OLTP Databases in Production Environments. Experience in Setting up Log-Shipping.
• Expertise in Capacity Planning, MS SQL Server installation, configuration and installation of Service Packs, Hotfixes for SQL Server.
• Expertise in Creating and Managing User Permissions, Logins and Configuring Security According to Organizational Standards.
• Experience in Installation, Configuration and Maintenance of SQL Servers in BIZTalk, MicroStrategy and Sharepoint Server Environments.
• Extensive Knowledge of SOX Compliant and HIPAA Compliant Database Environments and Experience in Working with Change Management Process.
• Expertise of Various Backups, Recovery Methods of SQL Server.
• Hands on Experience in Using Third Party Tools such as Idera SQL Diagnostic Manager, New Relic, Apex SQLDIFF.
• Expert Knowledge in Usage of Open Source Maintenance and Support Solutions Such as Ola Hallengren, Brent Ozar, Adam Machnic's Who is Active and Active in Various SQL Server Communities and PASS.
• Extensive Knowledge in Performance Tuning and Analyzing Locks and Deadlocks in SQL Server Hands on Experience in Using SQL Server Native Tools and Options Such as Extended Events, SQL Server Profiler, Activity Monitor for Performance Analysis and Tuning.
• Expertise in Analyzing Index Usage, Fragmentation and Reorganize/Rebuild Indexes, Update Statistics for Better Performance.
• Expertise in Analysis of Query Execution Plans for Low Cost Execution Options and Providing Suggestions on the same.
• Experience in Database Consistency Checks using DBCC Utilities.
• Implemented Change Data Capture (CDC) in SQL Server.
• Extensive Knowledge of Installing SSIS, SSRS and SSAS in Various SQL Server Environments. Expertise in Installation and Configuration of Multiple Instances of SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Extensive Knowledge of Development, Troubleshooting and Deployment of SSIS Packages. Created Various Useful Reports using SSRS regarding Database Administration.
• Knowledge of Development and Deployment of OLAP Cubes in SSAS.
• Experience in Developing Basic PowerShell Scripts, VB Scripts for Automation.
• Expertise in Disaster recovery planning and participated in disaster recovery drills.
• Highly Committed, Motivated Individual and a team player with Strong Ability.

PROFESSIONAL EXPERIENCE:

Confidential, Miami, FL

Sr. Database Administrator

Responsibilities:

• Created and maintained various databases on Production, Staging and development environments with SQL Server 2014/ 2012/2008 R2/ 2008.
• Managed Overall 32 Instances of SQL Servers being in Part of the Team of 2 DBA's.
• Migrated Various SQL Servers from SQL Server 2012 to SQL Server 2014 and Some Legacy Servers to SQL Server 2012.
• Created, Configured and Maintained AlwaysOn AG with 3 Node as A (Primary), B (Secondary Sync Commit) and C (Secondary ASync Commit).
• Created and Maintained Windows Server Failover Clustering.
• Implemented Log Shipping and Transactional Replication.
• Implemented Ola Hallengren's SQL Server Backup, Integrity Check, and Index and Statistics Maintenance
• Created database Maintenance Plans, SQL Server Jobs and deployed custom maintenance scripts to schedule regular DBA tasks for enhancing the performance of SQL Server including Database Integrity checks and Re-Indexing, Updating Statistics, Full, Differential and Transactional Log Backups and DBCC Cleanup.
• Created and Managed User Permissions, Logins and Configuring Security Per Organizational Standards.
• Closely worked with the Data Warehouse Team in suggestions about the ETL Processes and Deployed Various SSIS Packages for Various ETL Processes.
• Deployed Various RDL's across our Report Servers and Maintained Various Report Servers, Configured Data Sources and Configured the Security on the Report Servers.
• Involved in Deployment of various Jobs, Stored Procedures, and T-SQL Queries across Development, Staging, Pre-Production and Production Environments.
• Experience in Installation, Configuration and Maintenance of SQL Servers in BIZTalk, MicroStrategy and SharePoint Server Environments.
• Implemented Change Data Capture (CDC) in SQL Server.
• Involved in Migration of Various SQL Servers to New Domain.
• Involved in the Migration of SharePoint Database Server to a new domain.
• Analyzed and Created Various Reports on Server Performance and Preventive measures to ensure High Availability.
• Created Various Reports on SQL Server Job History for Various Teams.
• Provided Audit Reports for HIPPA Compliance using ApexAudit.
• Involved in Tuning of Various Stored Procedures and SSIS Packages by providing valuable performance related reports and suggestions to the development team.
• Provided 24*7 Production Support for the database and application issues.

Confidential, Port Jeff Station, NY

Database Administrator

Responsibilities:

• Created and maintained various databases on Production, Development and Test environments using SQL Server 2012/2008 R2/2008.
• Migrated MS SQL Server 2008 to MS SQL Server 2012.
• Implemented Database Mirroring and Configured Database Mirroring in both High Safety and High Performance.
• Installed necessary Service Packs and Patches for SQL server 2012/2008 R2/ 2008.
• Configured replication methods like snapshot, transactional and merge replications.
• Performance Tuning with regards to Indexing on the Databases by Re-Build and Re-Organized Indexes.
• Monitoring and scheduled jobs on production and staging environment.
• Implemented Ola Hallengren's SQL Server Backup, Integrity Check, and Index and Statistics Maintenance
• Created database Maintenance Plans, SQL Server Jobs and deployed custom maintenance scripts to schedule regular DBA tasks for enhancing the performance of SQL Server including Database Integrity checks and Re-Indexing, Updating Statistics, Full, Differential and Transactional Log Backups and DBCC Cleanup.
• Created and Managed User Permissions, Logins and Configuring Security Per Organizational Standards.
• Used the Execution Plan to improve the optimization of the T-SQL code.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Expert in Performance Tuning of the Stored Procedures.
• Developed, Optimized complex stored procedures, triggers, views to handle complex business rules, history data and audit analysis.
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach.
• Provided 24 x 7 Production support for the database and application issues.
• Handled user's permissions and Group Policy Management on Production, Development, Test Servers and Managed security on them.
• Resolving performance related issues to Blocking, Deadlocks and long running queries
• Scheduling SSIS packages by creating the corresponding job tasks for updating the synchronizing of data between two databases.
• Involved in Source Data Analysis, and designing mappings for data extraction.
• Responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.

Confidential, New York, NY

Database Administrator

Responsibilities:

• Created and maintained various databases on Production and development environments using SQL Server 2012/2008 R2.
• Installed necessary Service Packs for SQL server 2012/2008 R2.
• As a Part of Disaster Recovery Implemented Active-Active and Active-Passive Clustering.
• Tuned databases for better performance.
• Monitored and configured the complete environment for resource utilizations and to avoid any bottlenecks.
• Installed and configured SSRS.
• Created Various SQL Server Extended Event Sessions as a part of Monitoring SQL Servers.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Implemented Ola Hallengren's SQL Server Backup, Integrity Check, and Index and Statistics Maintenance
• Created database Maintenance Plans, SQL Server Jobs and deployed custom maintenance scripts to schedule regular DBA tasks for enhancing the performance of SQL Server including Database Integrity checks and Re-Indexing, Updating Statistics, Full, Differential and Transactional Log Backups and DBCC Cleanup.
• Created and Managed User Permissions, Logins and Configuring Security Per Organizational Standards.
• Loaded the data into another data sources (Oracle, SQL Server) using SSIS.
• Created various SSIS packages based upon the requirement.
• Created various reports using SSRS.
• Analyzed the Performance of a Cube by partitioning it and creating Perspective Cubes.
• Scripted the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures).
• Data migration using DTS services across different databases like Oracle, MS access & flat files.
• Analyzed various backup compression tools available and made the recommendations.

Confidential, New York, NY

Database Analyst

Responsibilities:

• Created and maintained various Databases of which contains information of Tutors and Student Information, Schedules, Practice Tests using SQL Server 2012/2008 R2
• Actively participated in gathering of User Requirement and System Specification.
• F iltered bad data using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistency Data entry into the database.
• Created reports from database onto excel spread sheet using DTS.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity
• Checks, Update Database Statistics, Re-indexing and Created Users and Roles, and managed security and permission of database.
• Completed High Number of service requests from the internal ticketing system.
• Oversaw the daily performance and maintenance of 10 servers and over 15 SQL Server instances.
• Performed system imaging using Norton Ghost 12.0.
• Analyzed long running slow queries and tuned same to optimize system performance.
• Set up SQL Server configuration settings.
• Monitored database servers using Idera SQL Diagnostic Manager.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Data Analysis and Data Profiling as required
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Migrated SQL Server 2005 data bases into SQL Server 2008.

Confidential

Jr. Database Administrator

Responsibilities:

• Created Database Maintenance Plans for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Planned the Complete Backing up of Database and restoring the Database from Disaster Recovery.
• Planned and modified the permission issues in the server.
• Designed a report on the monitoring of SQL Server Performance.
• Fine-tuned the Database Settings as well as the Server Settings.
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed and Maintained SQL Script for creation of Database Objects.
• Creating, maintaining the users, roles and granting privileges.
• Logical and Physical Data Modeling using AllFusion ERWIN.
• Performed Database backups (operating system, flat file backups & export/import).
• Maintained various databases for Production and Testing using SQL Server 2008.
• Planning the location of data, index and Transaction log files on the disk.
• Performance tuning and optimization of procedures and queries.

Confidential

SQL Developer

Responsibilities:

• Gathered functional requirements and Business requirements and written the technical specifications.
• Created database objects like tables, indexed views, indexes, stored-procedures, triggers and cursors using DDL, DML statements.
• Developed stored procedures and views for managing efficient data retrieval and application development.
• Wrote stored procedures for querying the data dynamically by defining parameters.
• Extensively used reporting tool (Web focus) to create reports as per user requirements.
• Created reports out of the views and developed OLAP cubes.
• Optimized queries using SQL Profiler and performance monitors to enhance the performance of database servers.
• Used DTS Packages for data import and export data from SQL Server to MS Access, Flat files and EXCEL files.
• Performed some DBA Tasks like checking the jobs, data consistency and troubleshooting the issues.
• Worked closely with developers, end users and Administrator in designing and developing database.
• Worked with Implementation team and closely moved with end users to implement manufacturing solutions.
• Responsible for enhancements and Maintenance of the product.
• Optimized SQL statements for customer summary reports.