Professional Summary
SQL DBA PROFESSIONAL SUMMARY 6+ years of experience in SQL server Database Administration using MS SQL Server versions 2012, 2014, 2016, 2017 and 2019. 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. Experienced in setting up high availability and DR options like log shipping, mirroring, replication (Transactional or Snapshot) and Always on Availability Groups. Proficient with SQL Server Disaster Recovery, Backup/Restore and creating Business Continuity Planning. Experience in Database Migration, Migrated SQL Server 2008R2 to 2012 and to 2016. Proven experience in creating implementing Database objects like Stored Procedures, Triggers, Views, User Defined Functions. Well experienced in Query Optimization, Client/Server connectivity, Performance Tuning, Database Consistency Checks using DBCC utilities, DMV's. Hands on experience in creating Maintenance plans, scheduling SQL Server Jobs, Automated administrative tasks and Configuring Database Mail. Experienced in using Joins and Subqueries for the simplification of complex queries including more than one tables. Experience in implementing SQL Server security and managing permission to the Database through Database roles, Creating Users and Logins. Experience in writing and tuning T-SQL (Transact-SQL) (DML/DDL/DCL) Queries. Hands-on experience in maintaining SQL Server Clustering (Active- Active/Active-Passive). Experience in ETL (Extract, Transform and Load) using SSIS (SQL Server Integration Services) in SQL Server 2012 with Import/Export Data, Bulk Insert. Solid experience in troubleshooting and performance tuning by using activity monitor, performance monitor, DBCC, DMVs, DMFs and third-party tools such as Spotlight, Idera monitoring. Experienced on working with production Servers and 24 x 7 On-Call environments. Applied Service Packs and security updates for SQL server instances. Azure API Management, Security, Cloud- to-Cloud Integration (Public, Private) Created a migration plan for moving on-premises data to the cloud, including identifying security and compliance risks in Azure. Designed an Azure Active Directory integration with on-premises directories using AAD Connect and DirSync Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills as well as flexibility to learn advancements in the IT industry. - CORE TECHNICAL SKILLS