SUMMARY:

• Positioned to deliver quality service and provide rare value to clients in intensely - competitive industries
• Broad experience in design, administration, support and performance tuning of Azure and OnPrem SQL databases.
• Expertise in administering Azure SQL (PaaS databases), maintaining logins, security, dealing with performance issues, troubleshooting and fixing issues with Azure sql features, migrating OnPrem databases to Azure, mentoring new hires, help them to ramp up to the process etc.
• Expertise in creating different datasets, pipelines to copy data from OnPrem to Azure, from Blob Storage to Azure using Data Factory. Good working knowledge and litle experience of Azure Data Lake store, Data lake analytics.
• Expertise in setting up maintenance activities for PaaS databases using Azure automation via runbooks and troubleshooting issues using OMS Log analytics, setting up alerts etc.
• Expertise in dealing critical situations, working on priority incidents, find root causes and drive them until they fixed.
• Experience with T-SQL, Powershell automation, SQL BI (SSIS, SSRS), Power BI tools and using GIT, VSTF, TFS for repository and extensive experience with Kusto for BigData querying.
• Experience in debugging Application, Network, Infrastructure issues where required, perform maintenance activities and managing Tier I, II teams, documentation.
• Working knowledge of Hadoop administration on Linux.
• Confidential Certified Solutions Associate (MCSA) in Administering SQL Server 2012/2014 and Implementing Azure Infrastructure Solutions.

CORE SKILLS AND EXPERTISE:

• SQL Administration
• Azure SQL. Data Factory. Data Lake Store
• Performance Optimization
• Databases Troubleshooting
• Azure SQL Support
• T-SQL, Powershell Programming
• SQL BI (SSIS, SSRS), Power BI
• Database Migrations
• Capacity Planning recommendation
• Hadoop
• Kusto
• Process Improvement

TECHNICAL SKILLS:

Operating Systems: Windows 2008/2008R2/2012 Servers

Data Bases: SQL Server 2014/2012/2008 R2/2008

Web/App Servers: IIS 7/7.5/8.0

Scripting: Batch, Powershell, T-SQL, KQL

Tools: Perfmon, Netmon, Debug DIAG, Fiddler2, SQL Profiler, Confidential Deployment Tools (Octopus and Sequence Manager), Log parser, SCOM, SCVMM, Hyper-V, Power BI, Confidential Office, SSIS, SSRS

Languages: C#, JAVA, .NET

Cloud Technologies: Azure, SQL Azure, ADF, ADLS

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, WA

Azure SQL/ADF/SQL DBA

Responsibilities:

• Experience with creating and managing logins and security, firewall rules, contained users, auditing, threat detection, setting up alerting for various issues, analysing and fixing them.
• Troubleshooting performance issues and set up automation to take care of auto scaling databases during peak hours. Expertise in managing databases in elastic pools.
• Setup, troubleshoot and fix issues for PaaS database features like Data Sync, dealing with Geo Secondary databases, Cross database functionality, Elastic pools, Data masking, Transparent Data Encryption, LTR etc.
• Migrating databases, exporting bacpac files between OnPrem and Azure. Fixing any issues encountered during the activity.
• Creating multiple pipelines, different datasets to copy data and performing bulk inserts from OnPrem to Azure Database/Across Azure using Data Factory and Blob Storage securely using Access Keys, SAS Tokens.
• Creating automation runbooks for auto scale, restores, applying database properties from one environment to other during database copy using powershell script and database maintenance using t-sql SPROC.

Confidential, Redmond, WA

SQL DBA/Azure SQL

Responsibilities:

• Managing complex system configurations, development and implementation of process and T-SQL automation.
• As a member of data team, (6 members team who supports ~2000 SQL servers with huge number of customers) solely worked on many priority incidents, found root causes and bugs, driven them until they fixed.
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end for SQL server. Refined regular processes and performed alert tuning which reduced 60% of noise alerts to team’s queue.
• Done migrating hundreds of databases to Azure and managing them, setting up security, creating Data Sync, maintenance jobs using Azure automation via runbooks and troubleshooting failed jobs.
• Done with designing and implementing backup strategy for MSIT farms, developed SPROCs and databases when required. Worked in SQL Azure environment
• Optimized performance of Content databases in Production by capturing queries using SQL Profiler and Database Tuning Advisor and tuned them for multiple tables
• Fixed issues with SiteCollection and SQL upgrade processes, automated them which reduced Log Shipping failures by 90% in all env.s

Confidential, Redmond, WA

SQL DBA

Responsibilities:

• Developed MSES2 databases and did fine-tuning in the later process, maintained and secured them. Deployed new databases for new Escalation Service, setup/troubleshoot AlwaysOn for it
• Troubleshooted application and databases issues, drive the root causes until bugs gets fixed.
• Developed dashboards incorporating SCOM alerts and incidents, sub reports and parameterized reports using Power BI for Ticketing and Escalation Service tools which uses by Tier-1 team to track and escalate them. Managed Tier I, II and off-shore teams
• Addressed questions and diagnosed issues that arise through the usage of our software in both production and development environments. Performed BCP failovers, created and BCP failover procedures
• Created automation using Powershell for SQL jobs which optimized ES service health and communicate with team

Confidential, Redmond, WA

SQL DBA and Service Engineer

Responsibilities:

• Provided support in Application/Infrastructure/Databases troubleshooting to improve performance, find root causes and fix them.
• Expertise in using tools like Debug DIAG, Netmon, Perfmon, Fiddler, SQL Profiler etc for troubleshooting.
• Provided technical expertise in the use of SQL database technology and done with slow response SQL queries tuning when required. Experienced with SQL security.
• Configured Windows/SQL 2008R2 in all env.s, performed OS and SQL upgrades and migrations for BDM and OMS services in all env.s
• Supported huge server Infrastructure and dealt with hardware issues. Developed automation using Powershell to hinder service passwords in deployment logs.