Meg M Email & Phone Number

Redmond, Washington, Us

•Support to professional and premier customers on all issues related to performance, product support, advisory and deep knowledge of SQL Server products.•Gathering of information, analysis, documentation, troubleshooting, resolution of cases and problems, with specialization in performance and core of SQL Server.•Investigate root cause for database-related application errors (SQL timeouts, Deadlocks, unexpected data condition, etc. •Used Event Viewer, SQL Error logs, and Log File Viewer for Software and hardware related errors. •Extensively worked on troubleshooting and fine-tuning of databases for performance. •Performed health checks and gave recommendations to Business units.•Query optimization and improving overall performance. •Communicate with customers to gather information in a fast-paced environment.

•Install, Manage, and administer SQL server 2008R2/2012/2014 SQL servers.•Implemented side by side and In-place upgrade of MSSQL server 2008R2 to 2016.•Applied Patches and Service packs, hot fixes to update different versions of MS SQL server.•Implemented and configured Always on High Availability solutions, replication, disaster recovery solutions on MSSQL Server 2012-2016.•Experience in implementing HADR solutions like Clustering, Replication, and Log shipping, and always on.•Help the application team identify the blocking process by collecting information on blocked processes. •Developed automated database refresh for production backups, development, and testing.•Hands on experience working with and troubleshooting databases in SQL Server 2012, 2014 and 2016 Always-On Environment.•Conduct system tests, troubleshoot performance issues, and correct database defects.•Tested and implemented SQL backup strategy based on the business needs. Utilized the combination of full, differential, and transactional log backup to ensure all necessary business data is properly backed up.•Setup Transactional Replication to synchronize a subset of tables to multiple subscribers in real-time for reporting purposes which separates the readers and writers to avoid blocking issues.•Define SQL profiler templates to capture different types of SQL activities, such as long running queries and deadlocking.

•Installation, upgrade, configuration, and migration of SQL Server 2016, 2017 that includes memory, file initialization, lock pages in memory, storage, data and log files.•SQL Server in clustered and non-clustered production environments. •Setting up the Transactional Replication in between SQL Server databases.•Responsible for performance tuning and optimization of databases using tools like SQL Profiler, Query Analyzer, and Database Engine Tuning Advisor.•Created maintenance plans and jobs to achieve maximum performance.•Performance Tuning on SQL queries and stored procedures using execution plan and Query store.•Used Performance Monitor to track the size of SQL Server database transaction logs and set up alerts using SQL server agent to notify the server before the transaction log files.

New York, Ny, Us

•Install and configure SQL server 2012, 2014 and 2016. •Analyze results of upgrade advisor and perform database server upgrades from 2012 to 2014/2016. •Plan, test and apply SQL patches on SQL servers to make sure we are up to date. •Used performance Monitor to track the size of SQL Server database transaction logs and set up alerts using SQL server agent to notify the server before the transaction log fills.•Configured Transparent Data Encryption (TDE).•Modified Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for SQL servers. •Created maintenance jobs by using PowerShell script. Help the application team identify the blocking process by collecting information on blocked processes.