SUMMARY

• Technology professional with around 7 years of experience in database Administration on SQL Server, SharePoint Administration, Cloud Technologies like Azure, Windows Administration, Configuration Management, Continuous Integration, Continuous Deployment System analysis, Development, Testing and implementation using Microsoft technologies.
• Expertise in the fields of Software development,CloudComputing including comprehensive knowledge in the analysis, design, development, and testing of the Software development life cycle using the ADO.NET, VB.NET, Web Services, Object Oriented Design and Windows Applications.
• Experience in Automating, Configuring and Deploying Instances on Azure environments and in Datacenters.
• Knowledge over automation components, processes and implementation to support Agile development, DevOps, and Continuous Integration (CI)/Continuous Deployment (CD).
• Expertise in migrating the existing v1 (Classic) Azure infrastructure into v2 (ARM), scripting and templating the whole end to end process as much as possible so that it is customizable for each area being migrated.
• Developed strategies forcloudmigration, implemented best practices and helped to develop backup and recovery strategies for applications and databases on virtualization platforms.
• Expertise in configuring Always - On High Availability solution withAvailability Groups in SQL Servers 2012/2014 with combination of Synchronous & Asynchronous modes and HA/DR Troubleshooting.
• Disaster Recovery planning by configuring Clustering (Active-Active and Active-Passive), Log-shipping, and Mirroring
• Experience in Installing, configuring and maintaining SQL Server 2012, 2016 in both Standalone and Cluster Environments.
• Designed and implemented High Availability solutions like Always on Availability Groups, Clustering, Database Mirroring in SQL 2016/2018/2014 R2 and SQL 2005 for databases more than 10 TB in size
• Interacted with Architect & implementedCloud/ Azure based systems as a part of POC in the pitching process.
• A qualified Network and SecurityEngineer, excellent knowledge of Client/Server architecture, OSI layers, TCP/IP networks and good understanding of Network Topology (LAN/WAN/Subnets/VPN/Firewalls).
• Responsible for technical design using requirement specifications and use cases/stories by collaborating with the product management and business on product requirements. Providing SaaS hosting and integration expertise across Cloud,vendor and Client platforms.
• Expertise in RDBMS including MS SQL Server, MS Access with thorough knowledge in writing SQL queries, Stored Procedures, Views, Functions, Packages, Triggers, Testing exception handlers, Cursors & tables and objects types.
• Good knowledge in handling messaging services using Apache Kafka.
• Experience in query optimization by using SQL Profiler, analyzing Execution Plans, using DMVs, Perfmon tool, DB engine Tuning Advisor and Activity Monitor.
• Experience in Data Partitioning, creating partition schemes & functions. Database Backup, Recovery and Disaster Recovery procedures for restoring databases using FULL, Differential and Transaction Log backups.
• Designed and developed standalone data migration applications to retrieve and populate data from Azure Table / BLOB storage to Python, HDInsight and Power BI.
• Strong knowledge and working experience in software Development Life Cycle (SDLC) methodologies such as Agile, Scrum and Waterfall models.
• Detail-oriented energetic team player, motivated with multi-tasking capabilities, problem solver, and hands-on leader with exceptional presentation and client/customer relation skills.
• Strong communication and interpersonal skills with ability to work well in a dynamic team environment.

TECHNICAL SKILLS

Cloud Computing: MS-Azure

Operating System: Windows Server 2012/2014/2016 , UNIX, Sun Solaris 8.0/10.0

Language/Technology: Microsoft.Net Framework 2.0, 3.5,4.0,4.5, SQL, PL/SQL, Scala, Hive, and Python.

Packages: Delphix, Attunity, Vormetric, Netezza, Power BI

Big data Technologies: Hdfs, Hive Hbase, sqoop

Scripting Language: VB.Net, Shell Scripting, Power Script.

Programming Languages: C, C++, C#. Net, Core

Database Tools: Manager, SQL Server Query Analyzer, Import and Export Utility of SQL Server, Client and Server Network Utility, Performance Monitor and SQL Server Profiler, DTS, SSIS, Always ON

Networking Protocols: TCP/IP, UDP, IP and SMTP

Databases: MS SQL Server 2005, 2008, 2008R2, 2012, 2014, 2016

PROFESSIONAL EXPERIENCE

Confidential, Berlin, CT

Azure Cloud Engineer/SQL DBA

Responsibilities:

• Providing operations support and meeting the business requirements expectations for projects pertaining to azure cloud (PAAS & IAAS) infrastructure with all project teams and client services groups for deployment and hosting the environment.
• Migration of Databases by creating a data factory pipeline, data lake store to transfer data from on-premises toAzureCloud. Create Guidelines and escalation protocols for the DBA team.
• Create an Operational handbook with Procedures and commands to identify the problem.
• Collaborate with different organizational teams, including escalation teams and R&D Teams, and 3rd party support partners (Open Source).
• Providing Support, Guidance and Implementation in respect to Azure Provisioning and Application Deployment Automation for IAAS and PAAS.
• Maintain Geico's Azure Cloud Infrastructure with Optimal Configuration from both technical and budgetary perspectives.
• Support the infrastructure to enable strategic and effective use of tools by using the optimal configurations.
• Providing support on Build Release management using TFS and deploying to cloud services.
• Providing operations support involving certificate management, application insight, Resource Groups, IP Management, Networking, Cloud Service, Redis Cache and BLOB storage account.
• Work with Security team for verifying connectivity within the workload subscriptions and also between other on-prem domains and Azure cloud.
• Worked on resolving the blockings and deadlocks, monitored the performance of SQL server by using SQL perfmon tool, DBCC commands.
• Created clustered index, non-clustered index, column store indexes and managed them based on fragmentation levels.
• Improved the performance of the server rebuilding and reorganizing indexes.
• Refreshing the databases from Production environment to Test Environment.
• Responsible for supporting the server issues on Dev, Test, pre-Prod environments.
• Created PowerShell scripts for automating Audit process regarding storage, DNS and IP address quota limits for workload subscriptions.
• Used Azure PowerShell (ASM and ARM) to find out the servers provisioned via Azure portal ; for auditing groups added in local administrator and the OU groups in which the server resides on the domain. Also verified the status of the patches installed for compliance.
• Created several SQL scripts as part of bug fixes to provide immediate solutions for some of the common issues.
• Involved in production support and available 24X7 for any issues on Prod.
• Created SQL Stored procedure for automating data on boarding to the catalog.
• Troubleshoot azure related issues pertaining to quota management, networking, load balancer and provisioning issues using Azure PowerShell.
• Created Azure runbook Automation using PowerShell to automate QC checks on IAAS machines.

Environment: Azure cloud, Cloud service, BLOB storage, Azure Power shell, SQL, IP management, Redis Cache.

Confidential, Redmond, WA

SQL Server DBA

Responsibilities:

• Installed and Configured Microsoft SQL Server 2008 R2 and 2012 on development, Test and pre-production servers.
• Managed Security using SQLLogins, Permission, Roles and Security Modes as a part of Security Policies for various categories of users.
• Implemented Backup and Recovery Strategies based on Business requirements.
• Implemented Disaster recovery strategy using Clustering and setting up AlwaysOn availability groups with failover clusters.
• Analyzed Perfmon counters, tuning the SQL server, tracking database health, Optimizing Indexes.
• Involved in resolving the blockings and deadlocks, monitored the performance of SQL server by using SQL perfmon tool, DBCC commands and also by analysing SQL wait types.
• Monitored Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Analyzed slow running queries and fine-tuned them to optimize application and improved overall system’s performance.
• Worked on resolving the blockings and deadlocks, monitored the performance of SQL server by using SQL perfmon tool, DBCC commands.
• Created clustered index, non-clustered index, column store indexes and managed them based on fragmentation levels.
• Improved the performance of the server rebuilding and reorganising indexes.
• Refreshing the databases from Production environment to Test Environment.
• Responsible for supporting the server issues on Dev, Test, pre-Prod environments.
• Worked closely with developers to ensure that the database environment optimally supports the requirement all the time and implemented the changes, if any.
• Applying Service Packs, Security Patches and Hotfixes through maintenance windows.
• Created, altered, maintained system roles and permissions for users on various database objects.
• Created alerts for database startup failures, drive space issues, & created notifications for system errors, insufficient resources, fatal database errors, hardware errors.
• Documented all the issues faced during the installation process, upgrades and code deployment with quick turnaround and resolutions in a shared OneNote document.
• Documented the environments topology using Microsoft Visio and updated them when changes were made.
• Designed the front-end applications, user interactive (UI) web pages using web technologies like XML, HTML, XHTML, and CSS.
• Designed and developed intranet web applications using JavaScript and CSS.
• Actively Participated in meetings, recommended the necessary changes required in the present database.

Confidential

Database Administrator

Responsibilities:

• Installed, managed and administered the MS SQL Server 2005\2008\2012\2014\2016 Production and Non-Production Servers.
• Involved in Upgrading and Migration of Production databases from SQL Server 2008 to SQL Server 2012 and from SQL Server 2012 R2 to 2014.
• Configured and worked on Always-On High Availability concept withAvailability Groups in SQL 2012/2014 with combination of Synchronous and Asynchronous Mirroring.
• Configured and Monitored Database Mirroring/Log shipping/Transactional, snapshot and Merge Replications and troubleshooting of errors.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Setup clustering both Active/Active and Active/passive on 2012\2014 servers.
• Worked on Maintaining SQL Server Security including the creation of logins and users, configuring permissions and assigning roles to users as required.
• Performed Database Integrity Checks (DBCC), Database Maintenance plans, updated Database Statistics and performed Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
• Worked on Profiler, Perform Counters, DMVs, DMFs and DTA to tune the databases, servers, and query tuning.
• Monitor the bottlenecks of Blocking, Deadlocks, CPU, Memory, Network, Disk Space alerts and Disk IO on SQL Server Instances using DPA Tool, Splunk, Perfmon and Idera Diagnostic manager.
• Implemented new features in SQL Server 2012 like Policy based Management, Table Compression & backup compression, SQL Server Auditing, Resource Governor and Transparent Data Encryption.
• New features are implemented in SQL Server 2012\2014 like Always on Enhancements, Buffer Pool Extension, In-Memory OLTP Engine, Backup Encryption and SQL Server Data Tools for Business Intelligence.
• Worked extensively on Data Refreshes from Production to Non Prod environments (DEV, SIT and UAT), automated the whole data refresh process at database level using Delphix Tool, Attunity Replicate tool, PowerShell scripts, stored procedures, Backups, and SQL Agent jobs without having any performance impact on Production servers.
• Used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas.
• Worked on Attunity Replicate to refresh data through CDC, Full Load and Change tracking from SQL Production to Target environments such as Cloudera, SQL Reporting, Netezza and Hadoop.
• Worked on multiple third-party tools such as Delphix for very large database restore, Vormetric Encryption for Data Security at folder level and Lite Speed and Iderafor Database backups.
• Developed SSIS and SSAS packages in SQL Server using Business Intelligence Studio and created jobs to schedule the SSIS and SSAS packages in SQL Scheduler.
• Recognize and identify potential areas where existing policies and procedures require change, or where new ones need to be developed, especially regarding future business expansion.
• Provide leadership during the development and enhancement of the enterprise production applications including working the applications, technical support and operations during the design.
• Attend the weekly change management meetings to review and approve all the requests.

Confidential

Windows Administrator

Responsibilities:

• Performing application deployment/installation and troubleshooting for Windows 2012/2014/2016 , Red Hat Linux 5.4/5.5 and Sun Solaris 8.0/10.0 based products in both QA and production environments.
• Provide support to the application deployment and release processes, and provide first-line, incident response coverage and triage of services, systems and applications
• Coordinated promotion of product releases through the various development and production environments using versions to identify, record and track all application components
• Install, configure and manage WebSphere Application Server, WebSphere Commerce Server and JBoss
• Running the change meeting and representing the group changes in all the meetings with the authority to accept or reject the changes if the conditions were not satisfied.
• Supporting the tickets assigned through IT Service Management (ITSM) based on ITIL best Support areas of Incident, Problem, Change, Release, Configuration Management and Service Desk.
• Responsible for 7x24 technical support for any QA or Production issue and Weekend coverage for changes Actively worked on the Perl script for automation of the script, by getting the data from the script and loading it on the database.
• Managing the source code from the development organization including receiving, compiling, and securing source so it can be tracked and so that applications are reproducible.
• Worked on the upgrade of the script which is required to get the data from the source code to the server.
• Managed the source control software (PVCS) by adding the auditing and journaling option to the various databases, user access and license.
• Managed users and groups in the Windows 2012/2014 server and Unix environment on SunSolaris 8.0Administered and configured websites using IIS version 7.0 and 6.0
• Managing the disk space and troubleshooting the alerts caused due to the patches/upgrade.Developed and troubleshoot deployment scripts using Perl.
• Created batch scripts for auto back up of Log files and Performance logs from QA and PROD servers to the log server which was available for the developers to troubleshoot the application.
• Worked on installing the patches/upgrades on the windows 2014 R2 (64 bit) / Windows bit) server.
• Worked on the ANT script and updated the script for getting the mail after any deployment has been completed.
• Worked on the Automation of the nightly backup on the SQL Server by running the Batch file.
• Worked closely with various teams, by solving the server space issues, permission issues and troubleshooting their Production deployment issues.

Environment: -Windows 2012/2014 server, Unix environment on SunSolaris 8.0,ANT script,SQL Server.