SUMMARY

• Associate has 13+ years of experience in the Information Technology. As part of his assignments, he has been in Database Administration and Microsoft Azure Solutions Architect - Cloud and Data Platform.
• He has good experience in Installation and Administration of MS SQL Server 2008/2012/2014/2016, Oracle 12C on Windows Server 2003/2008/2012 /2012 R2 on cluster as well non cluster environment . Microsoft Azure platform (PaaS & IaaS).
• 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/R 2/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 Autantication, Row-level security, Dynamic data masking.
• Database servers monitoring via Microsoft Operations Management suits (OMS)
• Implementing high availability withAlwaysOn Availability Groupsand 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

Hardware / Platforms: Windows 2000/ 2003/2008/2012, 2012R2

Databases: SQL Server 2000/2005/2008 / R2/2012,2014,2016, Azure Sql server, Oracle 11g & 12C

Other Utilities: SSMS,Data tool,Hyperbac,Veritas,MS SharePoint,SCOM, BMC Remedy,SVN,VSS,Nessus,MBSA,Card Recon,Tripwire,IIS,MS Azure Portal,visualstudio.com, PowerShell script & Azure Data Factory (ADF2), Microsoft Operations Management suits (OMS),ETL-Informatica (ICS)

PROFESSIONAL EXPERIENCE

Confidential

Solution Architecture

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. dat halps a lot to avoid any integration issues in Explore.MS application

Confidential

Microsoft Azure Solutions Architect

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

Sr Oracle DBA

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

Sr SQL DBA

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 2008R2,2012.
• Implement SQL 2014 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 Confidential vendors to get their product install and manage in Confidential 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

Sr SQL DBA

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

Sr SQL DBA

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.
• 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

Team Member

Responsibilities:

• 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