SUMMARY

• A Microsoft SQL server (DBA) with 9+ years IT experience: designing, coding, testing, and supporting next - generation database solutions in SQL Server environment.
• Possess strong communication and problem-solving skills developed through a variety of projects. Offer proven ability in team work and proactive system support.
• Experience in Installing, configuring, administration and Maintenance of mission critical client databases in SQL server 2008, 2008R2, 2012, 2014, 2016, 2017 and 2019 versions.
• Good experience in configuring the SQL Server in Azure Cloud Environment.
• Extensive Experience in Upgrading SQL Server (In place Up and Side by side Upgrade) based on application compatibility and fixing the orphan users.
• Experience in implementing SQL Server security and Object permissions like creation of users, granting permissions and assigning roles to users.
• Deployment, administration and operational support of production, development and test environments utilizing proper change management and other ITIL best practices using ticketing tools.
• Good experience implementing and troubleshooting High Availability of database servers using Replication, Log Shipping, Database Mirroring, failover clustering and Always ON AG.
• Strong experience on understanding and creating the server level and database level roles as per business requirement.
• Experience in Configuring and Scheduling SQL Server agent Jobs, Alerts, operators, Maintenance plans, Database Mail Configuration, facets and Transparent Data Encryption.
• Extensive experience with Monitoring, Performance Tuning and analyzing DB performance issues.
• Strong experience on designing and implementing the backup and disaster recovery strategies as per RPO and RTO values.
• Experience on configuring and maintaining Full backup, Transactional log backup, Differential backup and creating the maintenance plans for index rebuild, index reorganize based on fragmentation.
• Strong experience on identifying and troubleshooting database health, integrity checks and fixing them.
• Experience in Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Created reports, sub reports, charts, Tablix, Matrix, Hyperlink reports.
• Created jobs, alerts to run SSAS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job

TECHNICAL SKILLS

• Windows
• SQL Server
• T-SQL
• IDERA SQL diagnostic Manager
• SQL safe 6.0
• Red-gate SQL Compare 10 and Data Compare 10
• DataEdo
• ERWIN
• Profiler
• Extended Events
• Perfmon
• RAID
• SSDT
• Azure
• SSIS
• SSRS
• AWS
• SSMS
• DTA
• JIRA
• RAID
• MYSQL
• LiteSpeed
• AZURE VM
• Azure managed instance
• Salesforce.

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

SQL DBA Administrator

Responsibilities:

• Installing, configuring, administering and securing production and non-production servers (clustered and non-clustered).
• Upgrading SQL server 2012 to SQL Server 2016 and 2017.
• Experience in implementing windows cluster across multiple availability zones and Implemented SQL Server 2016 Always On availability group in Azure.
• Experience in setting up database transactional replication for reporting servers, Using Backup and restore methods.
• Experts in Database refresh from prod to lower environment as per the business requirements. Automated quarterly/monthly database refresh.
• Managed and Involved in SQL performance Tuning, identifying locking and blocking issues using Native and Third-party tools to enhance and boost performance of SQL Dbs.
• Managed and Implemented Ola Hallengren's Industries best SQL server maintenance plan and created schedule for all environments.
• ManagedSQL server Logins, Database users & rolesand involved in Daily User Maintenance.
• CreatedDatabase Maintenance jobsto perform full & transaction log Backups and scheduled them with the SQL Server agent job scheduler.
• Monitor databasegrowthactivities & Troubleshoot Transaction Log Issue.
• Created and configured mirroring for Disaster Recovery.
• Providing weekly status information on all projects to Project Manager.
• Wrote and debugged Stored Procedures and (DDL /DML) Triggers, Functions as per client requirements.
• Logical and Physical design of database for projects on basis of user requirements using ERWIN
• Reporting on a weekly basis to the project manager.
• Extensively worked on troubleshooting and fine-tuning of databases for optimal performance.
• Worked withPerformance Tuning/Query tuning,execution plans, trace flags and SQL Profiler
• Installation ofService packsto all environments.
• Used log shipping for synchronization of databases.
• Designed and developed ETL process using SSISto load data from various sources like MS Access and SQL Server 2014, Azure Databases
• Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS)
• Experience in migrating SQL Server 2012 and 2014 to SQL Server 2016 with AlwaysOn Availability
• Good understanding in database and data warehousing concepts (OLTP & OLAP).
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases
• Worked on BCP for data uploading module and created SSIS packages for data transfer & transform across locations and multiple data sources as per requirement.
• Created new tables, stored procedures and triggers using T-SQL.
• Refactored and Fine-tuned the queries and Stored procedures in T-SQL.
• Performing DB backups, DB refresh, DB restores, clean-up, statistics update
• Installed and configured MS SQL Servers in Virtual Environments using VMWARE.
• Analyze the Execution plans and recommend/implement a better execution plan.
• Experience in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• Experience supporting AWS DB in production and Development environment

Environment: Windows R2, SQL Server, IDERA SQL diagnostic Manager, SQL safe 6.0, Red-gate SQL Compare 10 and Data Compare 10, Visio 2010, DataEdo, ERWIN.

Confidential, Arlington, VA

SQL Server Administrator

Responsibilities:

• Installed and configured various editions and versions of SQL Server in standalone, and clustered nodes.
• Installed, and Configured SQL Server Fail-Over Cluster for SQL Server 2008, 2008 R2 & 2012.
• Applied service packs, hotfixes and cumulative updates.
• Upgraded SQL Server 2005, 2008 and 2008 R2 Database into SQL Server 2012 and 2014.
• Created and maintained logins, Users, Roles and managed security of the database.
• Implemented Disaster recovery plan by performing routine backups and restore
• Taking Full, Differential and Transactional log backups and setting automated jobs.
• Migrated data using Import/Export, bulk, backup-restore, DTS, SSIS, Detach/Attach
• Performed data Extracting, Transforming and Loading (ETL) from different data sources.
• Rebuilding /reorganize indexes to reduce fragmentation and enhance SQL server performance
• Created triggers, views and stored procedures,
• Implemented database Maintenance plans, scheduled automated SQL Server jobs, Created Alerts, Operators, Notifications and configured database Mail.
• Hands on experience monitoring and performance tuning using Tuning Advisor, SQL server Profiler, Activity monitor, Windows performance monitor, DBCC, DMVs, Stored procedures
• Working with Resource Governor to control and allocate CPU and memory resources depending on the priority of applications.
• Configured and Managed Database High Availability: Replication, Database Mirroring, Log Shipping, Failover Clustering and Always On availability group.
• Scheduled reports using SSRS to generate daily, weekly, monthly, quarterly reports
• Worked in a team with integrated Developers, CAB (Change Approval Board) and Disaster Recovery Planning team.
• Experience in contacting Microsoft and other vendors for product and technical support.
• Providing resolution to assigned tickets (JIRA, Team Track and Service Desk) as per their severity and meet the deadline before SLA is due.
• Experience in Agile projects with a solid foundation in Software Development Lifecycle (SDLC).

Environment: Windows R2, SQL Server, IDERA SQL diagnostic Manager, Red-gate SQL Compare 10 and Data Compare 10, Visio 2010, SSDT.

Confidential, Silver Spring MD

SQL Server Administrator

Responsibilities:

• Database High Availability: Installed, Configured and Maintained AlwaysOn High Availability Groups using SQL Server 2012. Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2008. Installed, Configured and Maintained Database Mirroring using automatic fail-over option in SQL Server 2008. Configured Log Shipping as Standby database from Production database for Reporting purposes. Configured and Maintained Replications.
• Database Upgrade: SQL Server SQL Server 2005 and 2008 R2 to SQL Server 2012
• Database Migration: Migrated MS Access 2003/2005/2008 R2 databases into MS SQL Server. Migrated Oracle 10g, MySQL into MS SQL Server 2012.
• Data Modeling: Worked on more than 10 data modeling projects and generated E-R Diagrams. Data modeling tools used using SQL Server Data Diagram.
• Database Monitoring/Performance Tuning: Strong on database Monitoring and Performance tuning. Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification. Monitor SQL Server Error Log, space usage.
• Database Programming: Wrote T-SQL, Trigger, and Stored-Procedures. Assisted Database Developers to optimize SQL queries and Stored Procedures.
• 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.
• Export & Import: Data from Oracle and SQL Server Excel and setup and performed ETL data load from Oracle and other flat files like text, Excel, and CSV files
• Backup/Recovery: Proficient in Database Backup and Disaster Recovery. Experienced with Point-in-Time Recovery. Restored Database from backup.
• Report Development: Installed, Configured, and administered SQL Server Reporting Services. Developed Reports using SSRS, developed Ad-hoc Reports using Report Builder 3.0, 2.0.