SUMMARY:

• Having 10+ years of IT experience (8+ years in DBA (SQL Server, IIS Administration, 3+ years in Azure Administration, Cosmos administration) and 2+ years of experience in application development & maintenance). I am having a very good expertise in Database Administration, SQL Programming (T - SQL), IIS Administration (Service Engineer), Azure Administration, and coding in application development.
• Experience in designing, optimizing and maintaining SQL Server Database Server Infrastructure in 24X7 environment.
• Experience in building database servers in multiple environments both clustered and standalone of SQL 2005, 2008 R2, 2012 & 2014.
• Experience in creating\modifying TSQL scripting, Batch\PowerShell scripting to keep in place maintenance jobs, activities and to automate some of the repetitive tasks to reduce manual effort.
• SQL Server upgrades, Server Audits and Quarterly refreshes, Annual BCDR exercises, Regular monthly patching activities are some of the regular activities out of the various major DBA activities I do.
• Experience in dealing with SQL Server performance issues using needful SQL traces\Activity monitors\Counters\SQL Profiler\SQL Server Execution Plans to identify bottlenecks and resolving them in a timely manner and having them utilized to capture SQL activities for better performance tuning and optimization.
• Experienced and having knowledge of high availability and Disaster Recovery SQL Server solutions with SQL Server Failover Clustering, Database Snapshot, Log shipping and Database Mirroring Implement data archival and purging.
• Experienced in migration for windows servers from On-Premises to Azure IAAS.
• Experience in big data HD Insight Cluster and Cosmos administration. Good experience at Cosmos data queries, streams and Cosmos jobs.
• Experience on implementing Azure Application Insights and OMS for monitoring applications and servers.
• Good experience in working Analytics queries and creating azure dashboards for monitoring.
• Experience in creating Power BI reports for Business users and team and SSRS reports.
• Supported in deployment of all the types of release cycles for production changes in coordination with Engineering & Release Management Teams.
• Working experience in SCRUM and Agile models.

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, WA

Database Administrator, Azure Administrator & Service Engineer

Responsibilities:

• Worked on Server migration of On Premises servers, including Partners Servers to azure IAAS.
• Worked on Cosmos Scripts to analyze data from Upstream.
• Troubleshoot Cosmos jobs, failures and data stream issues.
• Creating alerts from azure application insights for operations team.
• Create azure dashboards using analytics queries.
• Troubleshooting the Application errors using application insights logs and create alerts based on the app insights.
• Deploying and Managing Azure Services- Cloud services, web apps, service bus, key vault, application insights, azure dashboards, data analytics, HD Insight cluster, SQL Azure, resource groups, Storage accounts, Virtual networks, Load balancers.
• Created Power BI reports, dashboard for Business users and team to monitor application health and exceptions. creating\modifying TSQL scripting, Batch\PowerShell scripting to keep in place maintenance jobs, activities and to automate some of the repetitive tasks to reduce manual effort.
• Conduct periodic review of live site and collect feedback from Client & Internal Management on operational efficiency and alignment with customer’s strategic roadmap.
• Setting up alters which monitor system health like Disk Space Usage, CPU Usage, Memory Usage of the servers based on threshold, so that action can be taken care well in advance to avoid any unexpected issues.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS). Used SSRS to create reports, customized Reports, on- demand reports, ad-hoc reports and involved in analysing multi-dimensional reports in SSRS.
• Worked on configuring SQL Server Replications, Always ON, Log Shipping and Database Mirroring between servers from Production Server to Bay Servers (Disaster Recovery Servers) in our space.
• Designed and implemented Stored Procedures and Triggers for automating tasks. Configured product meta-data tables to support client data reporting needs. Incremental and full database recovery with experience of complex recovery scenarios.
• Analyzed database performance with SQL query manager and Optimized indexes to significantly improve queries. Worked on creating reports performance of all indexes on a weekly basis to make sure team can understand the unused objects details to determine the impact analysis which may help in improving job run times etc.,
• Implementing monitoring using azure App insights and analyzing the production issues and configuring alerts.
• Creating azure dashboards using analytics queries out of Application insights to show health of application.
• Performing FEMEA and coming up with monitoring requirement for applications.
• Install and Configure SSL certificates to ensure security for the web sites deployed on IIS.

Confidential, Redmond WA

Database Administrator & Service Engineer

Responsibilities:

• Working on all content related bugs and making sure to content goes to online seamlessly.
• Worked on Content Override and Redirect in case of broken pages on live site.
• Created automated reports using SSRS to improve the process to make it seamless.
• Take up issues escalated to L3\L4 and fix them at the earliest there by improving CPE (Customer Partner Experience) and reduce impact to Confidential ’s revenue.
• Worked as Service Design engineer for identifying improvement scope in existing or new project space. Work on the new scope right from planning, design, and UAT and production implementation.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs. Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.
• Extensive use of website monitoring portal systems to continuously monitor customer facing websites and production servers for tracking performance and availability issues.
• Setting alerts for all the performance counter such as CPU Usage, Disk space, Mission critical event ids, IIS Reset, Recycle application pool and database size.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server. Designing and building data load procedures using MS SQL Server.
• Worked on configuring SQL Server Replications, Always ON, Log Shipping and Database Mirroring between servers from Production Server to Bay Servers (Disaster Recovery Servers) in our space.
• Analyzed database performance with SQL query manager and Optimized indexes to significantly improve queries. Worked on creating reports performance of all indexes on a weekly basis to make sure team can understand the unused objects details to determine the impact analysis which may help in improving job run times etc.,

Confidential, Redmond WA

Database Administrator & Service Engineer

Responsibilities:

• Monitoring the status of Office. Confidential .com live sites across en-us and intl markets.
• Created automated reports using SSRS to improve the process to make it seamless.
• Monitoring load on Bulk Operations page and take corrective actions in case of blockages.
• Working closely with ODC and Ops team during patching and Hotfix (QFE) deployments.
• Created SQL Scripts for tables, stored procedures etc., as required to be able to persist and retrieve data from the backend to have the same presented through front end.
• Setting alerts for all the performance counter such as CPU Usage, Disk space, Mission critical event ids, Recycle application pool and database size.
• Created and managed databases for clients as well as systems to provide import of client data, and reporting of finalized data. Created schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity.
• Responsible for creating, deploying and scheduling new SSIS packages. Did Migration of the data from DTS to SSIS packages. Created reports using SSRS. Managed devices and databases,
• Interact with DB Engineers, Network Engineers, Developers and other team members understand the requirements used to develop automation tools thereby enhancing the automations in more effective way.

Confidential, Redmond WA

Database Administrator & Service Engineer

Responsibilities:

• Set up load balancer, creating VIPs, configuring NICs, running Server prerequisites, component prerequisites and monitoring.
• Use of Product Studio, TFS as a bug management system and follow-ups.
• Interact with DB Engineers, Network Engineers, Developers and other team members understand the requirements used to develop automation tools thereby enhancing the automations in more effective way.
• Setting alerts for all the performance counter such as CPU Usage, Disk space, Mission critical event ids, IIS Reset, Recycle application pool and database size.
• Extensive use of website monitoring portal systems like Gomez to continuously monitor customer facing websites and production servers for tracking performance and availability issues.
• Involved in performance tuning of the database and T-SQL queries using Explain Plan. Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal Reports.
• Participated in the installation of SQL Server. Installed SQL Server Enterprise manger tools using SQL Server Setup Program. Configured and monitored database application. Created tables, indexes and constraints.