SUMMARY

• A Microsoft certified SQL server (DBA) with almost 7+ 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 teamwork 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 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 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 R2
• SQL Server
• T-SQL
• AWS-RDS
• AWS-EC2
• IDERA SQL diagnostic Manager
• SQL safe 6.0
• Red-gate SQL Compare 10 and Data Compare 10
• DataEdo
• ERWINSSDT
• Azure
• SSIS
• SSRS
• SSMS
• DTA
• JIRA
• RAID
• MYSQL
• LiteSpeed
• AZURE VM
• Azure managed instance
• MuleSoft
• Salesforce
• API
• Windows R2
• SQL Server R2
• SQL Server 2012 SSMS
• Profiler
• Extended Events
• Perfmon
• RAID

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, Ohio

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.
• 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, 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 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, 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, Miami, Florida

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.