SUMMARY

• Over ten (10) years of experience as a SQL Server DBA with detail oriented, analytical and troubleshooting experience in different aspect of SQL Server including installation and configurations of SQL Server, Database High Availability Solutions, SQL Server Reporting Services (SSRS), data modeling, DR (Disaster Recovery) Solution, backup/recovery, performance tuning, stored procedures, triggers, functions, constraints, SQL Cloud Azure, AWS etc.
• Solid working experience in managing large databases in 24/7 data processing environment including, developing and managing reports using SQL Reporting Services (SSRS), and Monitoring. Working experience entails strong knowledge on using database third party tools (Spotlight, Fog light, Red Gate, Erwin Data Modeler, Toad Data Modeler, Microsoft Visio)for Database Administration, Data Modeling, and Performance Tuning using different Tools like Profiler, Execution Plan, Perfmon, Database Tuning Advisor, DMV, and Activity Monitor.
• Having working experience in a fast - paced environment as a Database Administrator for VLDBs in SQL Server 2008R 2/ 2012/2014/2016 over the Windows 2000/2003/2008 R 2/2012/2016/2017
• Proficiency in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery planning and Security Management. Configured Service Broker and Table partitioning
• Implemented the new SQL Server 2014/2016 concepts like Data partitioning, Snapshot isolation, database mirroring, DDL triggers, Online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA, SQLCMD, dedicated admin connection, MERGE statement
• Worked on High Availability atmosphere (Active-Active/Active-Passive Cluster, Transactional Replication). Mirroring, Log Shipping and Replication. Evicting (dropping) nodes and adding node in cluster 2008/2012/2014 /2016. Documentation and Inventory maintenance for various SQL Servers
• Used Perfmon, profiler, DTA (Database Engine Tuning Advisor), DMV’s and DMF’s for troubleshoot performance problems, fine-tuning of databases, for finding long running queries and index analysis. Worked on 32- and 64-bit SQL Server and MSCS Configurations
• Extensively Worked on Transactional Replication, Snapshot Replication and Merge Replication
• Handled multiple SQL Instances on Cluster for Server Consolidation projects built on SAN using RAID levels. Worked on SQL Server 2016 migration from SQL Server 2008/2012/2014
• Worked on configuring SQL Server in Single user mode and Minimal Configuration Mode
• Data modeling experience in Physical and logical data modeling by using Erwin Data Modeler, Toad Data Modeler and Microsoft Visio
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support. Extensive usage of Proactive Monitoring tools of SQL Server
• Handling Memory configurations, SQL Server 2008/2012/2014 /2016 on Windows 2008/2012/2016
• Sound knowledge stored procedures, Indexed views, User Data Link (UDL), Triggers, Distributed Queries and Common Table Expressions, UDFs
• Experience in Batch processes, SSIS, DTS, BCP (bulk copy), Bulk Insert, Import, Export, Backup, Database Monitoring tools and Application support
• Have experience on other tools like SharePoint, VPN, AD (Active Directory), Portals, Bulleting Board, Visio
• Third party tools used Red Gate, Idera, Erwin, Toad Data Modeler, Spotlight, Fog Light
• Reporting tools - BI (Business Intelligence), Report builders, Crystal Reports, BRIO Query, SSRS (SQL Server Reporting Services)

TECHNICAL SKILLS

Databases: SQL SERVER 2017,2016, 2014/2012/2008 R 2/2008/2005/2000 , MySQL,MS-Access, DB2,Oracle Database 10g/11g/12c,SQL Azure

Programming Languages: TSQL, PL/SQL, Power Shell, C, C#, VBScript, HTML, XML

SQL Tools: SQL Server Management Studio, SQL Navigator, Microsoft Visual Studio 2008/2010/2012 , SQL Server Enterprise Manager, BIDS, SQL Profiler, SQL Networking, Activity Monitor, DTA, PerfMon, SQL Configuration Manager, IIS.

Cloud Environments: Microsoft Cloud(Azure), Amazon Web Services (AWS), Google Cloud Platform

Third Party Tools: Lite speed, Erwin, Redgate, Fog lite, Spot Light, Splunk, Idera Diagnostic Manager, Autosys.

Networks and Protocol: TCP/IP, IPv4, IPv6, SSL, HTTP, SMTP, DNS, RDP.

Environment: Windows Server 2003 / Server 2008 / Server 2008R2/ Server 2012, Server 2012R2/2016,Unix, Linux.

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

MS SQL DBA/Database Administrator with Azure

Responsibilities:

• Installing, configuring, managing, monitoring and troubleshooting SQL Server.
• Implementation of SQL Logins, Roles and Authentication modes as a part of security policies for various categories of user support
• Upgrading SQL Server software to new versions and applying service packs and hot fixes
• Working on Database Backup and Recovery procedures
• Scheduled and maintained routine Jobs, Tasks, Alerts and Maintenance Plans
• Using Performance Monitor/Profiler to solve Dead Locks/Long running queries
• Migration of databases from SQL server 2008 R2 to SQL server 2012/2014/2016/2017
• Meeting the Service level agreements for the various customers.
• Disaster recovery and Log shipping of SQL Servers
• Configure and maintain SQL Mirroring, Log shipping, Replication and Clustering, Always on
• Providing 24x7 technical database support for SQL Database systems
• Supporting and managing multiple Production, Staging & Development instances
• Creating T-SQL, stored procedures, tables, views, functions, triggers and indexes.
• Involve in creating Logical & Physical Database Design using Toad Data Modeler.
• Using native tool ensuring all the databases are backed up on the regular basis and restoring databases as requested.
• Improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.
• Working with installation, configuration and creation of SSRS
• Working with SSIS and DTS package to import & export operations in and out of the SQL Servers.
• Configure Analysis service
• Configuring Azure Services PaaS, IaaS and Migrated databases from on-premises to Azure
• Configured development and test environment on Azure
• Creating and monitoring Azure SQL Server databases
• Configured and Maintained Elastic DB pools
• Configuring and monitoring Geo Replication
• Configured failover groups to provide high availability for PAAS SQL Server
• Working with Database Synchronizations using HUB-MEMBER Topologies
• Configuring backups and restoring database from recovery vault
• Configuring Server level and database auditing for SQL server
• Configuring CPU, Disk, DTU usage alerts and Monitoring for Azure SQL servers
• Ability to select correct tier for Azure SQL Databases working with Performance Metrics and Plan Management
• Configured server level and database level firewalls as per security compliance
• Implementing TDE (Transparent Data Encryption) and DDM (Dynamic Data Masking) Feature
• Deployed Azure IaaS virtual machines (VMs) and Cloud services (PaaS role instances) into secure VNets and subnets
• Configured Always on Availability groups using Cloud VMs
• Experience in using the tools AZ copy and storage explorer to migrate the databases from on premise to Cloud VM and PAAS SQL servers
• Provided high availability for IaaS VMs and PaaS role instances for access from other services in the VNet with Azure Internal Load Balancer
• Migrating the on premise database to Cloud and from cloud to on premise using multiple methods
• Used Database Migration Assistant tool to migrate the large databases to PAAS Server and VM

Confidential, Alpharetta, GA

MS SQL DBA/Database Administrator

Responsibilities:

• Providing 24x7 dedicated On-Call production supports for SQL Server problem resolution and server outages.
• Making ready build requirement for any new build server, new technology, DR and High Availability solution
• Strong experience on making build requirement & implement SQL Always On, Failover cluster, Log Shipping, Mirroring, Replication
• Configure and Maintain Always On HA on SQL Server 2012/2014/2016 for Prod and Non Prod
• Install and configure MSSQL 2017 in Non Prod environment
• Configure and Maintain Failover Cluster on SQL Server 2008R 2/ 2012/2014/2016 for Prod/DR/Non Prod
• Support on SQL Log Shipping, SQL Failover Cluster, Always on AG, Mirroring and DR Situation
• Support on Prod, DR, Staging, QA, Dev and Lab servers
• Installed and configured SQL server 2008R2/ 2012/2014/2016 on Windows Server 2008/2012/2016 , applied service packs and security fixes.
• Strong skill on performance tuning, troubleshooting, High availability, Disaster Recovery,Migration,upgrade
• Responsible for a large scale of database migration from SQL server 2008R2/2012 to SQL server 2012/2014/2016.
• Support on Database Migration Side by side and in place as application requirement.
• Responsible for configuring and maintaining transactional, snapshot and merge replication in production environments.
• Setup HPA Audit, Qualys trace, Splunk logs
• Creating T-SQL, stored procedures, tables, views, functions, triggers and indexes.
• Involve in creating Logical & Physical Database Design using Toad Data Modeler.
• Using DDBoost & native tool ensuring all the databases are backed up on the regular basis and restoring databases as requested.
• Strong knowledge and working experience in Database Backup and Disaster Recovery.
• Improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.
• Experiences on storage system and mount point configuration
• Using Idera SQL Diagnostic Manager to monitor all agents, Alarms, Databases, Domains, Hosts, the servers and their jobs in a single Management Console, to run and manage reports as required and as schedule
• Using Idera SQL Diagnostic Manager to analyze workload in Instance view and Business Views
• Working with installation, configuration and creation of SSRS
• Strong experience on user management, assigning permissions & roles
• Working with SSIS and DTS package to import & export operations in and out of the SQL Servers.
• Working with Central Management Server and ServiceNow Ticketing tool
• Working on MS Visual Studio 2013 Team Web Access for file transfer
• Working on TDE (Transparent Data Encryption) and Vormetic encryption
• Working on Maintenance plan to configure jobs, alerts, SMTP, Operator
• Working on SSMA to migrate Database from MySQL to MSSQL
• Working on RP (Replicated Storage) for DR Solution
• Part Time support on MySQL and Oracle Database in build side and run side
• Configure Analysis service
• Support on SQL Cloud Azure, AWS
• Ability to manage multiple projects

Confidential, Stamford, CT

MS SQL DBA/Database Administrator

Responsibilities:

• Installed, Configured, and Managed SQL Server 2014,2012,2008R2, 2008, 2005 in development, test, and production environment
• Installed and Configured SQL Server 2012,2014 in test and development environment
• Strong knowledge and working experience in Database Backup and Disaster Recovery
• Experienced with Point-in-Time Recovery
• Restored Database from backup
• Installed, Configured and Maintained Database Mirroring including automatic fail-over option in SQL Server 2008R2,2012,2014
• Configured Log Shipping as Standby database from Production database for Reporting purposes
• Clustering using SQL Server 2008R2/2012/2014
• Configured and Maintained Replications
• Used DBCC to check database conditions, fix database corruption, rebuild indexes and other database Maintenance purposes as well
• Installed, Configured, and administered SQL Server Reporting Services (SSRS)
• Developed Reports for different purposes like DBA Reports, user reports using SSRS and Report Builder 3.0 & 2.0
• Deployed Reports and managed security of report server including folder levelSSIS Package create, deploy and manage
• Moved data from flat file, Excel, Oracle, MySQL, MS Access, OLEDB Data Sources to SQL Server

Confidential, Washington DC

Database Administrator - SQL Server

Responsibilities:

• Installed, Configured, and Managed SQL Server 2005, 2008, 2008 R2,2012 in development, test, and production environment
• Configure and Maintain Failover Cluster on SQL Server 2012 and 2008R2 for Prod and Non-Prod
• Configured and Managed Database Replications (Snapshot/Transactional/Merge)
• Installed and Configured SQL Server Reporting Services (SSRS)
• Responsible for developing and implementing SSIS Solutions and Configuring, Deploying, and Maintaining SSIS
• Managed Backup/Restore, Point-in-Time Recovery
• Managed SQL Server Error Logs, space usage, growth pattern
• Upgraded MS Access 2000 databases into MS SQL Server 2005 and 2008
• Expertise in database Performance tuning
• ETL Tools: Used ETL tools like DTS, SSIS, Import/Export, BCP (Bulk Copy), to import & export data from flat files, and excel to MS SQL Server databases
• Security Management: Created and Managed users, roles, security at object level, data encryption
• Created and managed Index, Constraints, Keys (PK, FK)
• Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2008 for High availability solutions.
• Worked on different Data Modeling projects including creating scripts, E-R Diagram, backward/forward engineering
• Installed, Configured, Developed and Managed Report in SSRS (SQL Server Reporting Services) including managing securities
• Export & Import data from Oracle, Excel, Flat file, CSV file to SQL Server Database using EXP/Imp and DTS tools
• Have experience on other tools like Share point, VPN, AD (Active Directory), Portals, Bulletin Board, Visio
• Migrated MySQL 4.1.0, Oracle 10g/11g databases to SQL Server 2008 R2
• Installed, Configured, and Managed SQL Server 2012 in Development and Test environment.

Confidential, Jacksonville, Florida

Database Administrator - SQL Server

Responsibilities:

• Installed, Configured, and Managed SQL Server 2000, 2005, 2008,2008R2 in development, test, and production environment
• Installed and Configured SQL Server Reporting Services (SSRS)
• Developed and Managed Report in SSRS (SQL Server Reporting Services)
• Created and Managed Securities for Reports
• Maintained VLDBs
• Configured and Maintained Database Replications
• Configured and Managed Log Shipping including Standby database for reporting purposes
• Administered Fail-Over Clustering in SQL Server 2008R2
• Managed Backup/Restore, Point-in-Time Recovery including backup verification
• Managed Server, Database Roles and Security for different users and user groups
• Upgraded databases from SQL Server 2000/2005 to SQL Server 2008/2008 R2in Test and Production Environment
• Upgraded MS Access 2003/2000 databases into MS SQL Server 2000, and 2008
• Applied SP (Service Pack) on SQL Server 2000, 2005, and 2008
• Applied Patch SP2 on Windows Server 2003/2008 Enterprise Edition
• Expertise in database Performance tuning
• T-SQL, Stored-Procedures, Triggers
• Created and managed Index, Constraints, Keys (PK, FK)
• Worked on different Data Modeling projects including creating scripts, E-R Diagram, backward/forward engineering
• Processed data dump and Exported& Imported data from Flat file, CSV file, Oracle, My-SQL, and Access to/from SQL Server Database using DTS, SSIS, and EXP/IMP tool
• Setup automated jobs for different purposes including backup, monitoring database health, disk space, backup verification, moving databases from environment to environment including creating test environment
• Developed Different Maintenance Plans such as backups, index management, fragmentation management, cleaning history, deleting old files
• Monitored Server Activity, Error Log, space usage, and solving problem as needed