SUMMARY

• 6+ Years of solid experience in Database Administration, System Analysis, Design, Development and Support of MS SQL Server 2019/2016/2014/2012 , 2008 R2 and 2005 in Production, Test, Development, Replication and Cluster Server Environments.
• Highly experienced experience in managing, upgrading, and migrating systems in Microsoft Azure and cloud - based environments
• Extensive experience in 24x7 Production support and On-Call rotation with Ticketing and Change Management.
• 5+ Years’ Experience in Upgrading and Migrating SQL Server from lower versions to SQL 2019/2016/2014/2012
• 4+ Years’ experience in SQL Server 2019/2014/2012 and setting up AlwaysON Availability groups
• 5+ Years’ experience in Database design, warehouse, modeling, relationship using ERWIN and VISIO
• Expert in MS SQL Server Installations and updating and Patching servers with Hot Fixes.
• Experience in Planning and Implementing DR strategy.
• Expert in installation, upgrade, and configuration of 64-bit MS SQL Server databases in clustered (active/active, active/passive) and non-clustered environments in SQL 2008 R2/2005.
• Expert in Log shipping with SQL Server 2019/2016/2012/20008 R2.
• Expert in setting up Snapshot and Transactional Replication
• Expert in implementing SQL Server 2019/ Database Mirroring.
• Good Knowledge in NetApp, LiteSpeed, Diagnostic Manager and Foglight
• 2+ Years’ experience in Powershell Scripting.
• Expert in capacity planning, performance tuning, troubleshooting, and finding bottlenecks
• Strong experience in designing databases, creating tables, views, stored procedures, and Triggers.
• Documented disaster recovery plans and participated in disaster recovery drills.
• Developed backup and recovery strategies for production environment.
• 4+ Years ‘experience in SQL Server Integration Services (SSIS).
• 2+ Years experience in SSRS and SSAS
• T-SQL coding and testing: indexes, views, triggers, functions, cursors, stored procedures, etc.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities.
• Excellent in system tables, DMV’s and stored procedures using T-SQL
• Experience in Extracting, Transforming and Loading of Data from Excel, Flat file, Sybase, Oracle to MS SQL Server by using BCP and DTS Import/Export utility, SQL Server Integration Services (SSIS).
• Expert in T-SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and Data Transform Services (DTS).
• Extensive experience in data Extraction Transformation and Loading (ETL) between homogenous and heterogeneous systems using SQL SSIS tools, Data Transformation Services (DTS), bulk insert/delete(BCP), and XML operations.
• Used AGILE methodology in Software Development process.
• Excellent problem solving, analytical, technical, interpersonal and communication skills with strong leadership abilities.
• Extremely diligent strong team player with an ability to take new roles.
• Manage and support of Delphix Virtual Database and Masking Engine.

TECHNICAL SKILLS

• Windows Server 2016, 2012, 2008 R2/2003
• MS SQL Server 2016, 2014/2012/2008 R2/2008
• Management Studio
• Query Analyzer
• SSIS
• SSRS
• SSAS
• Clustering
• Mirroring
• AlwaysON
• Log Shipping
• Replication
• Oracle 10g/11i
• MS SQL Profiler
• ASP.Net
• PL/SQL
• Visual Studio
• T-SQL
• ERWIN
• Database Modeling
• Microsoft VISIO
• NetApp
• IDERA SQL Diagnostic Manager
• SQL Litespeed
• VMware
• Net Backup
• Microsoft Azure
• Amazon EC2
• Amazon RDS

PROFESSIONAL EXPERIENCE

Confidential, IL

Senior MS SQL Server DBA

RESPONSIBILTIES:

• Worked as a Production Support DBA giving 24/7 support and On-call support for OLTP and DSS
• Supported SQL Server systems by working on Ticketing and Change management applications
• Migrated SQL Server from SQL Server 2008 R2 to SQL Server 2012/2014/2016/2019
• Worked on Microsoft Azure (IAAS) implementation of SQL Server environments
• Migrated databases and servers to Microsoft Azure IAAS
• Planned and documented in-place and side-side SQL Migrations
• Actively Involved in Setting up Always ON availability groups and Clustered environments
• Did heavy duty Migration / Upgrades from lower version of SQL Server to SQL Server 2016
• Installed / configured SQL Server in Virtual Environments using VMWare.
• Installed SQL Server 2019/2016/2012 on windows Server 2019/ , applied service packs and security fix.
• Exclusive Knowledge of Database security including creation of roles/login/user accounts and having good Knowledge of authentication modes, types of roles, how to manage security accounts, grant /revoke permission to access data and how to make a security plan matching your business needs
• Implemented SQL Failover clustering for ACTIVE/ACTIVE and Active/Passive SQL Server 64 bit/32 bits environment and SQL Server 2005/2008/2014/2016/2019
• Implemented Database Mirroring on SQL Server 2008 environments and experience in configured and maintained Log shipping on primary and secondary server with or without witness server on MS SQL 2005/2008.
• Installed SQL 2012/2014/ 2016/2019 SQL servers in Development and Production environment.
• Worked on VMware and Virtual Instances of SQL Server databases.
• Responsible for managing SQL Data warehouse and updates related to it.
• Migrated SQL Codes with RedGate tool.
• Performance tuning, and optimization of procedures and queries.
• Responsible for managing Offshore QL servers and offshore resources.
• Involved in monitoring the backup jobs and fixed the failed jobs.
• Manage and support of Delphix Virtual Database.
• Configured\Monitored\Supported Delphix VDB Engines. Apply patches or upgrade engines to higher version.
• Coordinate with app team for VDBs and Masking Engine outages during upgrade.
• Manage/Granting access to users in Delphix Engines.
• Setting up dSources and VDBs and managing environments in Delphix engines.
• Monitoring and troubleshooting VDBs backups and supporting self-services templates in Delphix.
• Configure and Adding storage to Delphix Engines.
• Managed cubes processing for production OLAP servers.
• Involved in creating ETL Flows and SSIS packages

Tools: SQL Server 2016,2012, 2008 R2, Delphix, Active/Active, Active/Passive Clustering, Mirroring, Log Shipping, Replication, Physical, Virtual, SSIS, SSAS, SSRS, SQL Sentry, Lite-speed, VISIO, Windows Server 2019, 2016,2012, 2008 R2, SAN, VMWare, T-SQL.

Confidential, Herndon, VA

Senior MS SQL Server DBA

RESPONSIBILTIES:

• Managed MS SQL Server 2016, 2012, 2008 R2 and 2005 in Production, Development and QA environment
• Migrated databases from physical and Virtual instance to Microsoft Azure cloud.
• Managed Databases in Physical and Virtual environment
• Worked extensively on VMware and Virtual Instances of SQL Server databases
• Installed SQL Servers for Active/Active and Active/Passive Clustering
• Migrated major SQL Servers from SQL 2005/2008 R2 to SQL SQL Server 2012/2016
• Planned Migration of SQL Servers from Lower Version to Higher Version
• Installed and configured Always ON availability groups for SQL Server 2012/2016
• Implemented Mirroring and Log Shipping for Disaster Recovery
• Created SQL backups and scheduled for Production, Test, UAT and Development servers.
• Worked with SQL server Profiler for creating Audit log of SQL users.
• Created SQL users in Development, Test, UAT and Prod Environments. Removed orphan users from SQL servers for all Environments.
• Created SSIS packages to Extract and Load data from flat files of various source.
• SQL Server 2019/ set up in Development, Test and Prod Environments.
• Reporting services' set up in Development, Test, Prod and DR (Installed BIDS for SSIS, SSRS and SSAS)
• Removed errors from previously set up SQL jobs on Development servers.
• Database mail set up on SQL Servers in all environments.
• Set up operators for all SQL job notifications.
• Worked on configuring third party tools like NetApp and Foglight.
• Applied TDE for mission critical databases.
• Created Transactional Replication for Test and Prod databases.
• Publishes in all Environments with SQL Scripts and Red Gate tool.
• Created local windows accounts for report users, included them in groups and added those groups on Report manager to have access on Report server for users.
• Created linked servers for Open Query statements.

Tools: SQL Server 2016,2012, 2008 R2/2008/2005, Always On availability groups, Microsoft Azure, Active/Active, Active/Passive Clustering, Mirroring, Log Shipping, Replication, Physical, Virtual, SSIS, SSAS, SSRS, SQL Sentry, Double Take, Tidal, VISIO, Windows Server 2008 R2, SAN, VMWare, T-SQL

Confidential, Hoboken, NJ

MS SQL Server DBA

RESPONSIBILTIES:

• Installed and administered clustered and virtual SQL server 2014/2012/2008 and 2005.
• Installed Service Packs/Hot fixes and created documentation for tracking and SQL server installation purposes.
• Established and Scheduled Database Backup and Other Maintenance plans for User and System databases right after SQL server Installation process is done.
• Recovered the databases from backup in disasters. Implemented Point-In-Time Recovery solutions.
• Performed migration from 2005/2008-R2 SQL server databases version to SQL Server 2012 and SQL Server database consolidation.
• Managed SQL server high availability and disaster recovery strategies including Mirroring, Log shipping, Clustering and Always on availability groups.
• Implemented and Maintained Transactional and Snapshot Replication for reporting purposes.
• Administered SQL Server/Database level Security and utilized Auditing and Data Encryption (TDE) according to requirements and Integrity with HIPAA requirements.
• Created logins and database users, roles and provided permissions to users and roles according to the requirement and security policy.
• Implemented Data Masking and Database Security Hardening.
• Scheduled jobs and monitored and troubleshooting them. Task automation using power shell script and SQL agents.
• Write, test and maintaining T-SQL and stored procedures as they relate to DBA support.
• Performed data partitioning for efficient management of database tables and indexes.
• Evaluated CPU, Disk I/O and Memory related bottlenecks using Performance Monitor and improve the SQL server performance.
• Fine tune slow running T-SQL queries using Execution Plan and Database engine tuning advisor.
• Monitor, troubleshoot, Optimize and fine-tune databases' Performance issues using DBCC, DMVs SQL server Profiler and third-party tools like Tivoli.
• Resolved blocking and deadlock issues using activity monitor and system stored procedures.
• Worked with developers to develop and optimize SQL code for database scripts, triggers and stored procedures to implement database logic and maintenance.
• Responsible for reviewing, optimizing and deploying database scripts requested by Application Development Team.
• Worked with the application team on the planning, testing and implementing production database software upgrade cycles.
• Moved/Copied of Databases from one server to another server using Backup-restore, Attach and detach methods and refreshing databases in development, QA and stage environments using production backup.
• Developed MS SQL Server SSIS packages to implement ETL requirements.
• Created SSIS package to fulfill the SQL server maintenance tasks including rebuilding index, backing up database and updating statistics.

Tools: SQL Server 2012,2008 R2/2008/2005, Always On availability groups Active/Active, Active/Passive Clustering, Mirroring, Log Shipping, Replication, Physical, Virtual, SSIS, SSAS, Linux, Oracle 11g R2, 11g R1, 10g R2, Diagnostic Manager, Double Take, Tidal, VISIO, Windows Server 2008 R2, SAN, VMWare, T-SQL

Confidential, Dallas, TX

MS SQL Server DBA

RESPONSIBILTIES:

• As a Production and development support DBA responsible for maintaining 150 SQL Servers out of which 170 servers are production servers in which 100 were mission critical and 70 were business critical servers, remaining test and development servers.
• Installed SQL Server 2008 R2 and SQL Server 2005 on windows 2008 R2 and 2003servers, applied service packs and security fix for all servers.
• Implemented Failover clustering for ACTIVE/ACTIVE and Active/Passive SQL Server 64-bit environment
• Managed SQL Servers in 32/64-bitClustered environments
• Implemented Database Mirroring on SQL Server 2008 environments.
• Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.
• Implemented transactional replication for data refresh
• Managed all Publisher, Distributor and Subscriber database environments for the replication
• Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries
• Upgraded server from MS SQL Server 2005 to MS SQL Server 2008 R2
• Planned database sizing and capacity planning for production servers.
• Created the standard documents for Disaster recovery testing and implemented them.
• Created the backup schedule for production, test and development servers.
• 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)
• Installed, configured and maintained MS SQL Fail over clustering to provide server high availability solution for 6 different environments.
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Created logical and physical database design for development projects.
• Improved SQL Server query performance and traced problem queries.
• 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.

Tools: SQL Server 2008 R2/2008/2005, Active/Active, Active/Passive Clustering, Mirroring, Log Shipping, Replication, Physical, Virtual, SSIS, SSAS, Diagnostic Manager, Double Take, Tidal, VISIO, Windows Server 2008 R2, SAN, VMWare, T-SQL