SUMMARY:

Over 11+ years of IT experience of experience in Database Administration and Business Intelligence tools. Microsoft SQL Server (2005, 2008R2, 2012, 2014 & 2016) and in MSBI - SQL Server Integration Services (SSIS) and SQL Server Reporting Service (SSRS) and AWS (Amazon Web Services).

• Experience with AWS components such as EC2, RDS, S3, EBS, and Security Groups.
• Designed and Developed the Backup and Archiving, Disaster Recovery in AWS Cloud.
• Experience in maintaining MS SQL Servers in Production, Development and Testing in Clustered and Stand-alone server Environment.
• Expertise in Upgrade and Migration of SQL Server in clustered and non-clustered environments.
• Perform database administration activities including configuration, monitoring, space management, database backup & restore, disaster recovery and database server maintenance for clustered database servers.
• Worked on failover cluster and load balancing and moving services & applications from one node to another. 
• Implemented Mirroring for DR solutions.
• Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic. •Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional.
• Performed performance tuning using Dynamic Management Views (DMVs), System Catalog Views, Profiler, Server-side Traces, Windows Performance Monitor, DBCC commands and in-built SQL tools like SQL Profiler, DTA (Database Engine Tuning Advisor)
• Worked on database creation, refresh, decommission and instance or server builds, decommissions
• Experience in MS SQL Server Reporting Services (SSRS), SQL Server Integration Services.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation and transformations.
• Experience in importing/exporting data between different sources like Oracle/Excel etc. using SSIS/DTS.

RDBMS: MS-SQL Server 2000, 2005/ 2008/ 2008 R2/ 2012, 2014,2016 &MS Access

Programming Languages: Transact-SQL, SQL, ASP.Net, PHP and Visual Basic

Operating Systems: Windows Server 2003/2008/2008 R2,2012 & 2016

Database Tools: SQL Server Management Studio, SQL Server Business Intelligence Studio, SQL Profiler, Database Tuning Advisor, and Upgrade Advisor

ETL Tools: SSIS 2008/2008 R2/2012/2014,2000 DTS

Reporting Tools: SSRS 2005/2008/2012 ,2014,Reports, MS-Excel

Third Party tools: Red Gate, Lite-Speed, IDERA PROFESSIONAL EXPERIENCE:

SQL DBA  

Confidential, Dallas, TX

Environment: SQL Server 2008R2, 2012, 2014 & 2016 Windows Server 2016, VS 2010, AWS, T-SQL, SSIS

Responsibilities: 

• Preparing the plan for the Server Migration and installing, configuring, managing, monitoring and setting up AG in SQL Server 2016 Servers. 
• Involved in building Always on SQL Server instance utilizing almost all of the AWS stack (Including EC2, S3, RDS, IAM, Snowball, Glacier) focusing on high-availability. 
• Migrating Databases from SQL Server 2008 R2 and 2012 to SQL Server 2016. 
• Used Cloudberry drive with S3 for backups and moved objects to Amazon Glacier for archiving. 
• Created users and groups using IAM and assigned individual policies to each group. 
• Experience with monitoring tools such as Cloud Watch and SCOM. 
• Involved in maintenance and performance of Amazon EC2 instances. 
• Implemented data compression, online indexing, Contained Databases, security principals and AAG (Always on Availability Group). 
• Responsible routine DBA jobs like Backups and Restores. 
• Worked on SSIS Packages changes.
• Regular database capacity planning related to database growth and system utilization, trend analysis, predictive future database resource requirements, and the structured organized reporting of the same. 
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

SQL DBA

Confidential, Houston 

Environment: SQL Server 2008, 2012, 2014 SQL Server, SSIS, SSRS, Windows Server2003, 2008.

Responsibilities:  

• Preparing the plan for the Dedicated/Shared Server Migration 
• Ordering and Preparing the Servers for the Migration in new Data centre 
• Installed the SQL Clusters for New Data Centre. 
• SSRS Scale-out Configuration. 
• Coordinating with the Systems Administration team, install and maintain application software and systems that integrate with database systems. 
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs. 
• Working with development and systems teams to perform application and database tuning. 
• Migrating Databases from SQL Server 2005 to SQL Server 2008 and 2008 to 2012 and 2014. 
• Setup test and maintain business continuity/disaster recovery infrastructure database and applications. Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing. 
• Security issues related to logins database users and application roles and linked Servers. 
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers. 
• Responsible to Monitor and troubleshooting Log Shipping. 
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment. 
• Worked in Active, Active Passive Cluster environment as a High availability solution. 
• 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. 
• Checking Database Health by using DBCC Commands and DMVS 
•  Monitored and modified Performance using execution plans and Index tuning. 
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Non-Production Servers and handling maintenance Jobs. 
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.

SQL DBA

Confidential

Environment : SQL Server 2008, 2012, 2014 SQL Server, SSIS, SSRS, Windows Server2003, 2008.

Responsibilities:  

• Experience in installing, configuring, managing and monitoring SQL Server 2008 to 2014 Servers. 
• Experience in SQL server daily health check to ensure all the servers and database are up and running. 
• New SQL Server builds on Standalone and Cluster servers along with the pre-and post-steps. 
• Monitoring the regular backup job failures and incidents from BMC Remedy tool and troubleshooting. 
• Backup and Restoration: Scheduling different database backups of full, differential and log backups, and the complete responsible for restoring the databases at the critical time zone of round the clock support. 
• Experience in creating operators, alerts, and implementing jobs through the quest lite speed tool. 
• Worked on log-shipping, failover clustering management, database mirroring. 
• Worked on database creation, refresh, decommission, upgrade and migration from lower to higher. 
• Plan and implement the backup strategy by analysing the disk and NAS space upon the requirement. 
• Experience in SQL server patching on standalone servers. 
• Installation, implementation and maintenance of Windows 2003 and 2008 Servers. 
• Assist in planning upgrades and patch management for various systems including Windows and SQL 2008. 
• Involved in the service accounts change and verification for SQL Services based upon the requirement. 
• Monitoring of logical disk space, log files growth and performing the shrinking accordingly. 
•  Involved in disaster recovery in terms of DR drill, DR verification, DR setup and DR database removals. 
• Involved in different database backup setups in configuring the backups to Local disk and NAS locations. 
• Monitoring SQL server incidents, change requests, and mission critical databases and providing 24x7 supports. Creating outage notifications to ensure the accurate downtime of server and same will be notified to PDBA's. 
• Worked on failover cluster and load balancing and moving services & applications from one node to another. 
• Performing the IP compliance Audit remediation on all the servers and remediating the reports. 
• Worked on SQL server Reporting services SSRS, and SSIS 
• Worked on Performance Tuning, and Troubleshooting issues, Blocking, Profiler. 
•  Involved in NAS free check verification and ordering the new NAS volume depends on database growth. 
• Experience in supporting the production environment round the clock. 

SQL DBA and BI Support  

Confidential 

Environment : SQL Server 2012, T-SQL, Excel, SSIS, and SSRS.

Responsibilities : 

• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SSIS Packages. 
• Created SQL Jobs for scheduling and executing the packages. 
• Designed and developing SSIS packages using different transformations like Conditional Split, Multicast, Union-All, Merge, Merge Join and Derived Column. 
• Plan, analyse and develop Ad-hoc Reports using SQL Server Reporting Services (SSRS) and Report Manager to support various user requirements. 
• Experience in configuring database mail and creating alerts and operators for smooth flow of the operations on production servers. 
• Creating and Monitoring the Maintenance plans - scheduling tasks to run daily and/or on weekends (tasks like rebuilding indexes, defragmenting Databases, Shrink Database, Database backup and delete the history backups). 
• Scheduled Full and Differential Database backups to disks, tapes or remote servers, using batch scripts, T-SQL Script and Maintenance Plan Wizard 
• Worked closely with application development users on database solutions to business problems and modify existing databases, for better performance of database.