EXPERIENCE SUMMARY:

An experienced SQL Server DBA long with Sql Azure Architect with detail oriented, analytical and troubleshooting having more than 13+ years of professional experience in different Microsoft products as a SQL Server DBA. As a DBA professional and troubleshooting experience include SQL Server database administration, data modeling, gathering and analyzing business requirement and Operating Systems. Solid working experience in managing large databases, backup/recovery, configuring and managing HA solutions, managing reports using SQL Reporting Services (SSRS), Monitoring, Performance Tuning, stored procedures, triggers, functions, constraints and views etc. Working experience entails strong knowledge on ETL tools Azure Data Factory V2, Informatica, SSIS & DTS.

PROFESSIONAL SUMMARY:

• Migration of current data center customer environments to Azure and develop appropriate processes such as change management for the Cloud.
• Sql server upgrade /Migration from Sql server 2000/2005 to Sql server 2008/R2/2012/2014/2016& MS Azure Sql (PaaS) .
• Designing, developing and managing critical applications in Microsoft Azure platform (IaaS & PaaS) as per industry proven cloud computing and application design patterns.
• Implement warehouse model in snowflake or star schema and physical model from logical model in AZURE SQL (DB & warehouse).
• Knowledge of Azure Database Migration Service: Migration of on - premises SQL Server database with Microsoft Data Migration.
• Experience in Azure Data Factory(ADF2 ), API Management service, Storage account, Resource group, Index advisor ,Query Store, Geo-Replication, Elastic Database pool,In-Memory support & PowerShell script.
• Knowledge of Sql azure security features-Azure Active Directory Authentication, Row-level security, Dynamic data masking.
• Database servers monitoring via Microsoft Operations Management suits (OMS)
• Implementing high availability with AlwaysOn Availability Groups and failover clustering in Sql server 2014.
• Database Encryption -TDE.
• Oracle 12C Installation, Administration and maintenance.
• Involve in database implementation life cycle from sizing, capacity planning, design, and implementation
• Performance Tuning - Query and Server Level.
• Experience in ODI designer, Topology, Operator and ODI Tools .
• Building DR sites for existing Production environments and synchronizing them by configuring Log shipping, Transactional Replication and Mirroring.
• Implementing ITIL processes - Incident management, Problem management, Change and Release management, Request Fulfillment and Continuous service improvement.

TECHNICAL SKILLS:

Database Expertise: SQL Server 2014, 2012, 2008 R2, 2005, 2000, MS Access

Database Migration: SQL Server to SQL Server, Oracle to SQL Server, MySQL to SQL Server, and MS Access/Excel to SQL Server

Operating System: Windows Server 2012, 2008 R2, 2003 R2, 2000, VMware

Languages: SQL, T - SQL, HTML, DHTML, XML, D3GS,JavaScript, ASP, ASP.net

Cloud/Azure: Azure Services, PaaS, IaaS, Migrated on premises databases and Legacy products on Azure, deployed products on Azure, Setup development and test environment on Azure

ETL/Data Warehouse Tools: Azure Data Factory, Informatic,SSIS/DTS, BCP

Reporting: SSRS (SQL Server Reporting Services) - Enterprise Reporting & MS BI tool.

Data Modeling Tools: ERWin, Toad Data Modeler, Visio, SSDD (SQL Server Database Diagram)

Domain/AD: Active Directory, DNS

Hardware/Storage: SAN, RAID, iSCSI

Ticketing Tools: SSCM,SCOM, Confidential Remady, ServiceNow, JIRA.

SSMS: SQL server 2008 R2,2012,2014

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Create Solution Architecture based upon Microsoft Azure PaaS Services
• Design solution for various system components using Microsoft Azure
• Implement warehouse model in snowflake or star schema and physical model from logical model in AZURE SQL (DB & warehouse).
• Designing, developing and managing critical applications in Microsoft Azure platform ( PaaS).
• Designing, developing and managing Fact and Dim tables.
• Designing, developing, deploying automated process to ETL (Extract, transform and Load ) data from Flat files,CRM XML Query and SQL to Azure Sql DB using using Azure Data factory (ADF2) and Informatica Cloud. Platform (ICS).
• Co-ordination with external team members and other stake holders to understand the impact of their changes to complete release work with comfort. That helps a lot to avoid any integration issues in Explore.MS application

Confidential

Microsoft Azure Solutions Architect - Cloud and Data Platform\Azure SQL DBA

Responsibilities:

• Performing capacity planning and costing of applications considered for Microsoft Azure .
• Designing, developing and managing critical applications in Microsoft Azure platform ( PaaS) as per industry proven cloud computing and application design patterns.
• Install, configure and maintain Storage account, Azure File Sync, Resource group, Azure Data factory (ADf2), Azure Sql DB server, Database, SQL elastic pools,, Index advisor, Query Store, Geo-Replication.
• Migrate on-premises SQL Server database with Microsoft Data Migration Assistant: Install Database migration Assistant, Create migration, configure Source and target, Create script and migrate data.
• Designing, developing, deploying automated process to ETL (Extract, transform and Load ) data from Flat files residing at Azure File Sync to Azure Sql DB.
• Configure Integration Runtime Setup, Schedule SSIS, create Triger, maintain and monitor Sql jobs (Store proc & SSIS) using Azure Data factory (ADF2).
• Create pipeline,DataSets,Copy Data, Linked services using Azure Data Factory (ADF2) and PowerShell scripts.
• Create Azure Active Directory and maintain Sql login, role and permission using Azure Active Directory.
• Create and maintain Users and their permissions using Microsoft Azure portal.
• Prod Database servers monitoring via Microsoft Operations Management suits (OMS)
• Improve warehouse and DB performance using Partitioning, Sharding and other DB concepts.
• Implement & manage warehouse model and ensure data synchronizations across multiple geo locations
• Work with infrastructure team to handle security and firewall and ensure data availability to applications.

Confidential

Sr Oracle DBA

Responsibilities:

• Installed and upgraded the Oracle server 12C and Master Tax application tool.
• Migrate\upgrade current Empower Oracle DB from Oracle 10g to Db server Oracle 12C.
• Design and build Oracle Database migration strategy, present and approve from SEI Stakeholders.
• Worked with server team for capacity planning and build and open required firewall.
• Develop and automate Script to Refresh Archive DB from current DB as business requirement.
• Allocating system storage and planning future storage requirements for the database system.
• Modify the database structure, as necessary, from information given by application developer.
• Enrolling users and maintaining system security and controlling and monitoring user access to the database.
• Monitoring and optimizing the performance of the database.
• Planning and impregnation for backup and recovery of database.
• Contacting Oracle Corporation and ADP for technical support.

Confidential

Responsibilities:

• Architecting, planning & Migrate the on premise SAP Sql Server 2008 DB size around 1.5TB to MS Azure Sql server (IaaS).
• Designing, developing and managing critical applications in Microsoft Azure platform (IaaS and PaaS) as per industry proven cloud computing and application design patterns.
• Support Development, Testing, QA and Production environments on Azure.
• Support & Maintain the SAP environment on Azure with Managed Shared Services.
• Refresh lower environments with production DB back as needed.

Confidential

Responsibilities:

• Design and build Database migration strategy, present and approve from SEI Stakeholders.
• Involve in Database Servers capacity planning.
• Prepare Cutover plan and L3 Plan and execute during Go live.
• SQL Server Installations, Administration v 2008 R2,2012 .
• Implement SQL 201 4 AlwaysOn Availability Groups and Failover Clustering
• Implement Database Encryption TDE
• Migrate DB server from Sql server 2000 to Sql server 2014
• Migrate DTS to SSIS
• Performance Tuning - Query and Server Level
• Database Deployments per Change Management .
• Developing database object - Stored procedure,Table,View.
• Develop, build and install Sql server report RDL.
• Work with other 7-Eleven vendors to get their product install and manage in 7-Eleven environments.
• Prepare weekly status report-Complete, Ongoing and future work estimation and present with 7-Elevn IT team.
• Prepare KT document and Handover to Database Support Team.
• Prepare HLE, effort estimation for onshore-offshore for other up-coming database migration/upgrade projects.

Confidential

Responsibilities:

• SQL Server Installations, Administration v 2000,2005,2008,2008 R2,2012 ,2014
• High Availability Solutions - Clustering, Replication, Log Shipping, Database Mirroring
• SQL 2012 AlwaysOn Availability Groups and Failover Clustering
• Handle emergency bridge
• Deploy and maintain SSRS, SSAS, SSIS, DTS
• Performance Tuning - Query and Server Level
• Production Issues Troubleshooting
• Database Deployments per Change Management -ITG Proess.
• 24X7 Tier II support
• Incident Management

Confidential

Responsibilities:

• Handling production On-Call Support
• Installation & configuration of SQL Server 2000, SQL Server 2005 and SQL Server 2008 in Standalone as well as Clustered environment.
• Building DR sites for existing Production environments and synchronizing them by configuring Log shipping, Transactional Replication and Mirroring in SQL Server 2000/ 2005/2008.
• Troubleshooting Jobs \ DTS \ SSIS packages which are failing frequently and fixing them
• Data Collection and analysis for SQL Server Consolidation and Decommissioning
• Handling Daily Incident Tickets and Day to Day SQL Issues.
• Working on Disk Space monitoring and troubleshooting for Data files and log files.
• Working on high CPU & memory consumption alerts and troubleshooting
• Pre and post work for rebooting servers for patch release.
• Handling Emergency Bridges to resolve the issues
• Monitoring Physical Server, SQL Instances and Databases SCOM
• Performance Tuning.
• Database server migration from Windows server 2000 to Window server 2008 to cross data center.
• Sql server upgrade /Migration from Sql server 2000 to Sql server 2008/R2.
• Upgrade DTS to SSIS package
• Sql server 2008 SP3 upgrade
• Monitoring and resolving Incident/change request Tickets
• Working on Standard/Emergency/Bundle releases including deployment of DTS,SSIS and SSRS to servers.
• Preparing Daily Dashboard, Weekly incident report to present in client meeting.

Confidential

Responsibilities:

• Data center migration.
• Database server migration from Windows server 2000 to Window server 2008.
• Sql server upgrade /Migration from Sql server 2000 to Sql server 2005/2008/R2
• Involved in disaster recovery.
• Updating the patches released.
• Giving support to customers, when they face any application related issues.
• Performance Tuning - Tune, analyze and optimize costly queries to reduce logical disk I/O for effective performance.

Confidential

Responsibilities:

• Design and implement databases process to support company business need, using SQL Server 2000/05 & 2008.
• Fragmentation, Shrink and Index re-organization in query tuning.
• Production database support on using Help Desk ticket assigning.
• Backup, Restore and recover of SQL Server databases.
• Implementing effective Indexes, stored procedures and triggers to maintain the integrity and consistency of databases.
• Managing SQL Server Login, Database user, Role and Schemas and cluster SQL Servers.
• Creation of Report Server and Deployment of rdl file to Report Server.
• Creation of SSIS packages FOR transfer data from live to Reporting server.
• Involved in disaster recovery.
• Performance Tuning - Tune, analyze and optimize costly queries to reduce logical disk I/O for effective performance.
• Monitoring of server performance by profiler during peak periods of server utilization.
• Tripwire File integrity tool implementation.
• Involved in PCI DSS and SAS 70 Audit