SUMMARY

• A Microsoft certified SQL server (DBA) with 8+ 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. Offers 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 teh SQL Server in AWS Relational Database Management system and in EC2.
• Extensive Experience in Upgrading SQL Server (In place Up and Side by side Upgrade) based on application compatibility and fixing teh orphan users.
• Experienced 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 in 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 teh 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 teh backup and disaster recovery strategies as per RPO and RTO values.
• Experience in configuring and maintaining full backup, Transactional log backup, Differential backup and creating teh 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 teh automated processes for teh activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job

TECHNICAL SKILLS

• Windows R2
• SQL Server
• T-SQL
• AWS-RDS
• AWS-EC2
• IDERA SQL diagnostic Manager
• SQL safe 6.0
• Red-gate SQL Compare 10
• Data Compare 10
• DataEdo
• ERWIN
• SSDT
• Azure
• SSIS
• SSRS
• SSMS
• DTA
• JIRA
• RAID
• MYSQL
• LiteSpeed
• AZURE VM
• Azure managed instance
• Salesforce
• API

PROFESSIONAL EXPERIENCE

Confidential, Virginia

Senior 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 AWS.
• Experience in setting up database transactional replication for reporting servers, Using Backup and restore methods.
• Expert in Database refresh from prod to lower environment as per teh business requirements and 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.
• Created Database Maintenance jobsto perform full & transaction log Backups and scheduled them with teh SQL Server agent job scheduler.
• Monitor database growth activities & 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 teh 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, Oracle database
• 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 teh 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 teh Execution plans and recommend/implement a better execution plan.
• Experience in Monitoring and Tuning system resources associated with teh database performance, hit ratios, me/O, lock, and latch contention.
• Experience supporting AWS DB in production and Development environment

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

Confidential, New Jersey

SQL Server Database 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 2012, 2016 & 2017.
• Applied service packs, hotfixes and cumulative updates
• Upgraded SQL Server 2005, 2008 and 2008 R2 Database into SQL Server 2017 and 2019
• Created and maintained logins, Users, Roles and managed security of teh 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 teh 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 teh 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, Bentonville, Arkansas

SQL DBA

Responsibilities:

• Installed and configured SQL server 2008/R2, 2012 and 2014.
• Installed and configured window server 2008 and 2012R2
• Created and updated databases, tables, stored procedures, triggers, functions, and views.
• Configured, administered, and troubleshoot multiple databases in production and staging environments in clustered and standalone environments.
• Prepared documentation for disaster recovery plan.
• Involved in installing failover clustering on multiple nodes.
• Implemented database mirroring and log shipping
• Planned backup strategies, scheduled backups, and performed restore operations.
• Managed security of SQL server databases by creating logins, creating database users, creating roles, assigning proper permissions, creating server and database audits.
• Worked on creating, reorganizing, and rebuilding indexes.
• Worked on database space management, performance monitoring, and alert management.
• Planned teh location of files and increased teh size and number of files.
• Performed tasks of query optimization, troubleshooting client/server connectivity issues, and performance tuning.
• Monitored and troubleshoot database and server performance at system-wide scale and effectively identify network, databases, Memory, CPU, Disk Space, and me/O related bottlenecks.
• Transferred data between several servers using BCP and DTS.
• Generated reports extensively using SSRS.
• Providing resolution to assigned tickets (JIRA, Team Track and Service Desk) as per their severity and meet teh deadline before SLA is due.

Environment: Windows R2, SQL Server R2, SQL Server 2012 SSMS, Profiler, Extended Events, Perfmon, RAID