SUMMARY

• Over 8 years of experience in Database Administration of Microsoft SQL Server OLTP & DWH databases in On - premise and Cloud environment across all editions of versions of SQL Server 2000/2005/2008/ R 2/2012/2014/2016.
• Microsoft Certified Professional (MCP) in SQL Server 2008 and SQL Server 2012 and ITIL V3 foundation certified.
• Production Support (24x7) experience in the areas of Database Management, Disaster Recovery Management, Design, Development, Maintenance and Migration of databases in Automotive, Health, Finance and Insurance environments.
• Expert in SQL Database Disaster Recovery Techniques like Log-Shipping, Mirroring, Replication (Snapshot, Transactional and Merge) and DB Snapshots in Cluster and Non-Cluster in environments.
• Expert in Database High Availability Techniques like SQL Clustering and Always-ON (HADR) in On-premise/Azure VMs .
• Experienced in Microsoft Windows and SQL Azure (in IaaS/PaaS Environments) and configured Geo-Replication.
• Migrated VMs from Classic Subscription/On-Premise to Azure Resource Manager (ARM) V6 Subscription with Azure Site Recovery (ASR) Tool.
• Worked on On-premise and Cloud environments and managed security, Storage, and performance.
• Hands on AWS cloud technologies such as RDS, EC2, S3 Storage, EBS Volumes and cloud watch.
• Expert in analysis and resolution of performance bottlenecks involving CPU, I/O and memory usage.
• Expert with Performance Monitor, SQL profiler, activity monitor and query execution plans.
• Generating Weekly/Monthly analysis reports for the Database Growth and Performance Statistics and capacity planning.
• Good experience in designing, creating, debugging and tuning of stored procedures, triggers, and functions.
• Possess good knowledge of algorithms and design patterns in T-SQL and Power shell scripting.
• Database security implemented as per STIG standards with SSL Administration and security s and used Transparent Data Encryption (TDE).
• Experienced in Designing, Creating and modifying SSRS reports and SSIS/DTS/ETL packages with Microsoft Visual Studio.
• Worked on SSAS cubes processing, security, maintenance and troubleshooting and resolving the issues occurred while processing cubes in the jobs.
• Expert in implementation and supporting MSSQL replication (Snapshot, Transactional, Peer to Peer and Merge) between MSSQL and/or Non-MSSQL Database systems.
• Expert in Build and Deployment analysis on UAT and deploying it in Prod environments.
• Experience with Create and Maintain enterprise databases, Integrity, Backup & Recovery, Security, Capacity planning, Performance monitoring and tuning and Data archiving and compression techniques.
• Experienced in working with SSL Administration & securitys and Active Directory and OS Tools.
• Experienced in Monitoring Tools like Delta, SCOM, IDERA, SQL Sentry, Fog light, spotlight and Ticketing Tools like BMC Remedy, Jira, Service-Now, and ITSM.
• Experienced using Red-Gate, Lite-speed, CommVault, and other backup tools and TFS, visual Studio Online Release management tools.
• Excellent communication and technical writing skills in developing and implementing SOPs and documentation for ensuring the security and integrity of the databases and maintained SLA/OLA with ITIL standards.

TECHNICAL SKILLS

• Databases: Microsoft SQL Server 2000/2005/2008/ R 2/2012/2014/2016 and BI (SSIS, SSRS, SSAS) Tools and SQL Azure, MS Access and Excel, Sybase ASE Server 15.7 databases.
• OS: Windows server 2000/2003/2008 R2/2012R2/2016 and Linux.
• Clouds: Windows Azure and AWS Cloud.
• Languages: C, C++, T-SQL, PowerShell and HTML, XML.
• Tools: TOAD, SQL Compare, Visual Studio, PowerBI and IIS Manager,
• Backup tools: Azure backup Server, DPM, Idera, Red gate, CommVault and SQL Lite Speed.
• Monitoring tools: Delta, OMS, SCOM, SQL Sentry & Confio, Ignite and IDERA SQL DM.
• Ticketing tools: Service Now, JIRA, BMC Remedy and ITSM.

PROFESSIONAL EXPERIENCE

Confidential, Redmond,

Responsibilities:

• Maintaining High availability of Application and Database servers and databases with HADR Techniques.
• Configured, migrated and maintaining of SQL Database Always-On in On-premise and Azure Cloud environment.
• Migrated VMs from Classic Subscription/On-Premise to Azure Resource Manager (ARM) V6 Subscription with Azure Site Recovery (ASR) Tool.
• Controlling ETL flows with METaL framework for dynamic on demand package creation and execution, and maintaining Cube processing and reporting.
• Responsible for Query Optimization, Performance Tuning, and resolving CPU, Memory and IO related bottlenecks.
• Capacity planning and determining sku size for servers based on performance tests.
• Working on Process Automation using T-SQL and PowerShell scripting.
• Database security implemented as per STIG standards with SSL Administration and security s and used Transparent Data Encryption (TDE).
• Build and Releases automation through Visual Studio Online with Octopus Tool and Release Deployment analysis in UAT and planning deployments accordingly in Prod environments.
• Worked with Operations Management suite (OMS) for configuring and Monitoring alerts and Service Now ticketing tool.

Confidential, Broomfield, Colorado

Responsibilities:

• Worked on High Business Impact (HBI) environments and configured/Supported log-shipping, Mirroring, Replication (Snapshot and Transactional, Merge), Clustering and Always-On High availability (HADR).
• Responsible for Query Optimization, Performance Tuning, and the IO related bottlenecks.
• Responsible for creating, configure and maintain the Cloud Databases in Microsoft Azure and AWS Cloud and configured Geo-Replication.
• Migrated SQL Databases on to Cloud using SQL Server Azure. Worked on Azure Resource Manager (ARM), IaaS and PaaS.
• Worked on AWS Cloud environment and managed security, Storage, and performance.
• Worked on cross-platform database migrations from Sybase ASE Server to SQL server and replication, DB tasks.
• Databases upgraded, downgraded and migrated across different Versions and editions of SQL server.
• Responsible for creating and modifying the SSIS packages and SSRS reports in visual studio.
• Worked on PowerBI Reporting tools for automation and robust report generation.
• Creating and Tuning the queries, procedures, triggers and reports for enhanced and quick response time, by using concepts of Indexes with INCLUDE columns, CTE’s, Data and Table Partitioning Techniques to allow the SQL Server engine to escalate locks to the partition level in the table.
• Documenting issues and resolutions of SQL Server and Applications logged in event viewer and error-logs.
• Implemented SOPs as per business flow with ITIL standards in the project.

Confidential,

Responsibilities:

• Performed all the Database Administrative tasks, in all High availability and disaster recovery (HADR) solutions like log-shipping, Mirroring, Replication in clustered and non-clustered environments and Always-ON.
• Responsible for the security, Performance improvements and Query analyzing using profiler and execution plans and also required Patches were implemented on both DB and OS level.
• Experience using Policy Based Management, Data Compression, Resource Governor, Data Collector and Transparent Data Encryption (TDE), BCP, Import and Export, Activity Monitor, Extended Events, SQL Profiler and OS Tools.
• Performing Database backups and refreshes and maintain database security as per business requests.
• Creating, debugging and tuning stored procedures, triggers, functions, views, indexes and used Error & Event handlers.
• Utilized DDL, DML, DCL commands for manipulation of data within the database.
• Monitor and resolving alerts on database status including CPU, memory, I/O, Disk and DB free Space and capacity planning, job failures and blocking and deadlocks using SQL Server Utilities and DMVs.
• Generating Weekly/Monthly analysis reports for the Database Growth and Performance Statistics.
• Responsible for creating & modifying SSIS packages, SSRS reports as per the requirements.
• Responsible for Migrating the SQL databases and documenting the issues and resolutions.

Confidential,

Responsibilities:

• Working on Standard Database Maintenance tasks, Backups and Recovery Plans and Log-shipping.
• Database Refreshes from Production to Stage and Development environments as per the requirement.
• Security Administration by creating user/group Logins with appropriate roles, granting and denying login/user privileges, database and application roles to users and groups and monitor the user accounts.
• Periodic checking of databases consistency and integrity and indexes fragmentation with update statistics.
• Monitoring and maintaining free space over threshold values for Disk and database data and log file and CPU, memory, blocking and deadlock.
• Constantly checking the functionality of the environment and taking necessary action when an alert is thrown from alerting mechanism by taking a prompt action based on its severity, prioritize the resolution of the issues.
• Creating jobs, verifying and troubleshooting jobs and alerts.
• Working as part of a team and provide 24x7 technical database support.